UpDateTime

display:block; width:75px;

DD-MON-YYYY"
" HH:MIPM

TO_CHAR(SYSDATE, 'DD-MON-YYYY');

Depending LOV’s in a generic way

LOV 102

Andy

1. Application item named: Get_Rooms
2. block to construct a list of item
3. JavaScript in HTML Header
4. HTML Form Element Attributes

********* Begin Get_Rooms : On Demand **********

select ROOM,ROOR_ID
from SVR_ROOMS_RF
where sitr_sitr_id = :TEMPORARY_ITEM)
…. rec.ROOR_id '">' rec.ROOM '');
********* End Get_Rooms : On Demand **********
********* Begin JavaScript in HTML Header**********

…..
htmldb_Get(null,$x('pFlowId').value,'APPLICATION_PROCESS=Get_Rooms',0);
get.add('TEMPORARY_ITEM',pThis.value);
gReturn = get.get('XML');
if(gReturn && l_Select){
…..

********* End JavaScript in HTML Header**********

*********** Begin HTML Form Element Attributes **********
onchange="get_AJAX_SELECT_XML(this,'P4_ROOM')"
*********** End HTML Form Element Attributes **********
ONCHANGE
Apex Cascading LOV's

Handling Depending LOV’s in a generic way

http://forums.oracle.com/forums/thread.jspa?threadID=400026
http://forums.oracle.com/forums/thread.jspa?messageID=1371958
http://htmldb.oracle.com/pls/otn/f?p=31517:42:1201664623903907:::::
http://htmldb.oracle.com/pls/otn/f?p=31517:1:1201664623903907::NO:::
http://forums.oracle.com/forums/thread.jspa?messageID=3416455&#3416455

Multiple Validations

for each button


Up Date Button2


Up Date Button1
#########################


************** CREATE ************
declare
icount number;
inum number;
begin
select count (SVR_EQUIPMENT.serial_number) into icount from SVR_EQUIPMENT
where serial_number = :p2_serial_number;
if
icount >0 then return 'Duplicate Number';
elsif
:p2_serial_number is null then return 'Serial Number cannot be Null';
end if;
inum:= to_number(:p2_serial_number);
exception
when others then return 'Must be numeric';
end;

************** UPDATE ************
declare
icount number;
inum number;
begin
select count (SVR_EQUIPMENT.serial_number) into icount from SVR_EQUIPMENT
where serial_number = :p2_serial_number
and equipment_id <> :p2_equipment_id;
if
icount >0 then return 'Duplicate Number';
elsif
:p2_serial_number is null then return 'Serial Number cannot be Null';
end if;
inum:= to_number(:p2_serial_number);
exception
when others then return 'Must be numeric';
end;
#######################

Before Modified

Informative

Attempts

LOV Plus TextArea