DBA Data[Home] [Help]

APPS.IBU_SR_UTIL dependencies on IBU_NUM_TBL_TYPE

Line 90: p_Object_Id IN SYSTEM.ibu_num_tbl_type,

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

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

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

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

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

Line 316: p_party_id IN SYSTEM.IBU_NUM_TBL_TYPE,

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