APPS.IEC_IH_HLPR_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 77

     	select resource_id into l_resource_id
        from jtf_rs_resource_extns
        where user_name = 'IECAOUSER';

Line: 210

     	select resource_id into l_resource_id
        from jtf_rs_resource_extns
        where user_name = 'IECAOUSER';

Line: 268

PROCEDURE UPDATE_CLOSE_MEDIA_ITEM
(
  P_MEDIA_ID      IN  NUMBER,
  P_SUBSET_ID     IN  NUMBER,
  P_SVR_GROUP_ID  IN  NUMBER,
  P_START_TIME	  IN	DATE,
  P_END_TIME		  IN	DATE,
  P_ADDRESS	      IN  VARCHAR2,
  P_ABANDON_FLAG  IN  VARCHAR2,
  P_HARD_CLOSE    IN  VARCHAR2
)
IS
  PRAGMA AUTONOMOUS_TRANSACTION;

Line: 313

    LOG('UPDATE_CLOSE_MEDIA_ITEM', l_msg_data);

Line: 319

END UPDATE_CLOSE_MEDIA_ITEM;