194: , p_note_context_id => CUR_NOTE_REC.NOTE_CONTEXT_ID
195: , p_jtf_note_id => CUR_NOTE_REC.JTF_NOTE_ID
196: , p_note_context_type_id => p_customer_id
197: , p_note_context_type => 'PARTY'
198: , p_last_updated_by => FND_PROFILE.Value('USER_ID')
199: , p_last_update_date => p_last_update_date
200: , p_last_update_login =>FND_PROFILE.Value('LOGIN_ID')
201: );
202:
196: , p_note_context_type_id => p_customer_id
197: , p_note_context_type => 'PARTY'
198: , p_last_updated_by => FND_PROFILE.Value('USER_ID')
199: , p_last_update_date => p_last_update_date
200: , p_last_update_login =>FND_PROFILE.Value('LOGIN_ID')
201: );
202:
203: END LOOP;
204:
225: l_msg_count NUMBER;
226: l_msg_data VARCHAR2(2000);
227: BEGIN
228:
229: IF FND_PROFILE.Value('AST_DEBUG') = 'Y' THEN
230: G_Debug := TRUE;
231: ELSE
232: G_Debug := FALSE;
233: END IF;
295: ) IS
296:
297: l_creation_date DATE := SYSDATE;
298: l_last_update_date DATE := SYSDATE;
299: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID');
300: l_created_by NUMBER := FND_PROFILE.Value('USER_ID');
301: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID');
302:
303: l_task_name VARCHAR2(80);
296:
297: l_creation_date DATE := SYSDATE;
298: l_last_update_date DATE := SYSDATE;
299: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID');
300: l_created_by NUMBER := FND_PROFILE.Value('USER_ID');
301: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID');
302:
303: l_task_name VARCHAR2(80);
304: l_task_type_id NUMBER;
297: l_creation_date DATE := SYSDATE;
298: l_last_update_date DATE := SYSDATE;
299: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID');
300: l_created_by NUMBER := FND_PROFILE.Value('USER_ID');
301: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID');
302:
303: l_task_name VARCHAR2(80);
304: l_task_type_id NUMBER;
305: l_description VARCHAR2(4000);
546:
547: l_creation_date DATE := SYSDATE;
548: l_last_update_date DATE;
549: l_p_last_update_date DATE;
550: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID');
551: --created by used for creating note..
552: l_created_by NUMBER := FND_PROFILE.Value('USER_ID');
553: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID');
554:
548: l_last_update_date DATE;
549: l_p_last_update_date DATE;
550: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID');
551: --created by used for creating note..
552: l_created_by NUMBER := FND_PROFILE.Value('USER_ID');
553: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID');
554:
555: l_lead_number VARCHAR2(30);
556: l_lead_id NUMBER;
549: l_p_last_update_date DATE;
550: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID');
551: --created by used for creating note..
552: l_created_by NUMBER := FND_PROFILE.Value('USER_ID');
553: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID');
554:
555: l_lead_number VARCHAR2(30);
556: l_lead_id NUMBER;
557: l_p_lead_id NUMBER; --added For R12
900: Log_Mesg('Start parameter validation');
901: --code modified for R12 enhancement --Start
902: /*
903: IF l_name = 'CLOSE_COMPETITOR_ID' AND
904: NVL(FND_PROFILE.Value('AS_COMPETITOR_REQUIRED'), 'N') = 'Y' AND
905: l_p_close_competitor_id IS NULL THEN
906: l_return_status := 'E';
907: END IF;
908:
1097: ) IS
1098:
1099: l_creation_date DATE := SYSDATE;
1100: l_last_update_date DATE := SYSDATE;
1101: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID');
1102: l_created_by NUMBER := FND_PROFILE.Value('USER_ID');
1103: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID');
1104:
1105: l_customer_id NUMBER;
1098:
1099: l_creation_date DATE := SYSDATE;
1100: l_last_update_date DATE := SYSDATE;
1101: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID');
1102: l_created_by NUMBER := FND_PROFILE.Value('USER_ID');
1103: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID');
1104:
1105: l_customer_id NUMBER;
1106: l_source_object_type_code VARCHAR2(60);
1099: l_creation_date DATE := SYSDATE;
1100: l_last_update_date DATE := SYSDATE;
1101: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID');
1102: l_created_by NUMBER := FND_PROFILE.Value('USER_ID');
1103: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID');
1104:
1105: l_customer_id NUMBER;
1106: l_source_object_type_code VARCHAR2(60);
1107: l_source_object_id NUMBER;