237: , partner_id
238: , null
239: , attr_text
240: , SYSDATE
241: , FND_GLOBAL.user_id
242: , SYSDATE
243: , FND_GLOBAL.user_id
244: , 1.0
245: , FND_GLOBAL.user_id
239: , attr_text
240: , SYSDATE
241: , FND_GLOBAL.user_id
242: , SYSDATE
243: , FND_GLOBAL.user_id
244: , 1.0
245: , FND_GLOBAL.user_id
246: , null
247: , attribute_id
241: , FND_GLOBAL.user_id
242: , SYSDATE
243: , FND_GLOBAL.user_id
244: , 1.0
245: , FND_GLOBAL.user_id
246: , null
247: , attribute_id
248: , null
249: from (
610: , partner_id
611: , null
612: , attr_text
613: , SYSDATE
614: , FND_GLOBAL.user_id
615: , SYSDATE
616: , FND_GLOBAL.user_id
617: , 1.0
618: , FND_GLOBAL.user_id
612: , attr_text
613: , SYSDATE
614: , FND_GLOBAL.user_id
615: , SYSDATE
616: , FND_GLOBAL.user_id
617: , 1.0
618: , FND_GLOBAL.user_id
619: , null
620: , attribute_id
614: , FND_GLOBAL.user_id
615: , SYSDATE
616: , FND_GLOBAL.user_id
617: , 1.0
618: , FND_GLOBAL.user_id
619: , null
620: , attribute_id
621: , null
622: from (
1105: -- Declaration of local variables needed in Create_SalesTeam API call
1106: l_admin_group_id NUMBER;
1107: l_person_id NUMBER;
1108: l_def_cm_id NUMBER;
1109: l_user_id NUMBER := FND_GLOBAL.user_id;
1110: l_chk_access_flag VARCHAR2(1);
1111: l_admin_flag VARCHAR2(1);
1112: l_identity_sales_force_id NUMBER;
1113: l_access_id NUMBER;
1918: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE := p_email_rec;
1919: l_email_cnt_point_id NUMBER;
1920:
1921: -- Some common local variables used by all the API call.
1922: l_application_id NUMBER := 691; -- FND_GLOBAL.application_id;
1923: l_appl_short_name VARCHAR2(5) := 'PV'; -- FND_GLOBAL.APPLICATION_SHORT_NAME;
1924:
1925: -- Local variable declaration for Standard Out variables.
1926: l_return_status VARCHAR2(1);
1919: l_email_cnt_point_id NUMBER;
1920:
1921: -- Some common local variables used by all the API call.
1922: l_application_id NUMBER := 691; -- FND_GLOBAL.application_id;
1923: l_appl_short_name VARCHAR2(5) := 'PV'; -- FND_GLOBAL.APPLICATION_SHORT_NAME;
1924:
1925: -- Local variable declaration for Standard Out variables.
1926: l_return_status VARCHAR2(1);
1927: l_msg_count NUMBER;