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,
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);
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
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