DBA Data[Home] [Help]

APPS.IBU_SR_UTIL dependencies on IBU_NUM_TBL_TYPE

Line 91: p_Object_Id IN SYSTEM.ibu_num_tbl_type,

87:
88: -- added the below procedures for isupport porject----------------------------------
89: PROCEDURE call_create_org_contact( p_user_id IN NUMBER,
90: p_Subject_Id IN NUMBER,
91: p_Object_Id IN SYSTEM.ibu_num_tbl_type,
92: p_Subject_Table_name IN VARCHAR2,
93: p_Object_Table_name IN VARCHAR2,
94: p_Subject_Type IN VARCHAR2,
95: p_Object_Type IN VARCHAR2,

Line 127: l_user_id_type SYSTEM.IBU_NUM_TBL_TYPE := SYSTEM.IBU_NUM_TBL_TYPE();

123: l_msg_count NUMBER;
124: l_msg_data VARCHAR2(2000);
125: x_insert_status VARCHAR2(10) ;
126: i NUMBER;
127: l_user_id_type SYSTEM.IBU_NUM_TBL_TYPE := SYSTEM.IBU_NUM_TBL_TYPE();
128: l_party_id_type SYSTEM.IBU_NUM_TBL_TYPE := SYSTEM.IBU_NUM_TBL_TYPE();
129: l_flag_type SYSTEM.IBU_VAR_3_TBL_TYPE := SYSTEM.IBU_VAR_3_TBL_TYPE();
130: l_operation_type SYSTEM.IBU_VAR_3_TBL_TYPE := SYSTEM.IBU_VAR_3_TBL_TYPE();
131: --x_email_status VARCHAR2(10);

Line 128: l_party_id_type SYSTEM.IBU_NUM_TBL_TYPE := SYSTEM.IBU_NUM_TBL_TYPE();

124: l_msg_data VARCHAR2(2000);
125: x_insert_status VARCHAR2(10) ;
126: i NUMBER;
127: l_user_id_type SYSTEM.IBU_NUM_TBL_TYPE := SYSTEM.IBU_NUM_TBL_TYPE();
128: l_party_id_type SYSTEM.IBU_NUM_TBL_TYPE := SYSTEM.IBU_NUM_TBL_TYPE();
129: l_flag_type SYSTEM.IBU_VAR_3_TBL_TYPE := SYSTEM.IBU_VAR_3_TBL_TYPE();
130: l_operation_type SYSTEM.IBU_VAR_3_TBL_TYPE := SYSTEM.IBU_VAR_3_TBL_TYPE();
131: --x_email_status VARCHAR2(10);
132: BEGIN

Line 317: p_party_id IN SYSTEM.IBU_NUM_TBL_TYPE,

313:
314:
315: PROCEDURE update_ibu_multi_parties(p_user_id IN NUMBER,
316: p_loggedin_user_id IN NUMBER,
317: p_party_id IN SYSTEM.IBU_NUM_TBL_TYPE,
318: p_enable_flag IN SYSTEM.IBU_VAR_3_TBL_TYPE,
319: x_update_status OUT NOCOPY VARCHAR2
320: )
321: AS