DBA Data[Home] [Help]

APPS.AST_UWQ_OLIST_WORK_ACTION dependencies on FND_PROFILE

Line 198: , p_last_updated_by => FND_PROFILE.Value('USER_ID')

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:

Line 200: , p_last_update_login =>FND_PROFILE.Value('LOGIN_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:
203: END LOOP;
204:

Line 229: IF FND_PROFILE.Value('AST_DEBUG') = 'Y' THEN

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;

Line 299: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID');

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

Line 300: l_created_by NUMBER := FND_PROFILE.Value('USER_ID');

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;

Line 301: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID');

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

Line 550: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID');

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:

Line 552: l_created_by NUMBER := FND_PROFILE.Value('USER_ID');

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;

Line 553: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID');

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

Line 904: NVL(FND_PROFILE.Value('AS_COMPETITOR_REQUIRED'), 'N') = 'Y' AND

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:

Line 1101: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID');

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;

Line 1102: l_created_by NUMBER := FND_PROFILE.Value('USER_ID');

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

Line 1103: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID');

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;