APPS.QLTDACTB dependencies on FND_PROFILE

Line 27: user_id := NVL(FND_PROFILE.VALUE('USER_ID'), 0);

23: X_LAST_UPDATE_LOGIN NUMBER;
24:
25: BEGIN
26:
27: user_id := NVL(FND_PROFILE.VALUE('USER_ID'), 0);
28:
29: if X_CONCURRENT = 1 then -- Online
30:
31: X_REQUEST_ID := FND_PROFILE.VALUE('REQUEST_ID');

Line 31: X_REQUEST_ID := FND_PROFILE.VALUE('REQUEST_ID');

27: user_id := NVL(FND_PROFILE.VALUE('USER_ID'), 0);
28:
29: if X_CONCURRENT = 1 then -- Online
30:
31: X_REQUEST_ID := FND_PROFILE.VALUE('REQUEST_ID');
32: X_PROGRAM_APPLICATION_ID :=
33: FND_PROFILE.VALUE('CONC_PROGRAM_APPLICATION_ID');
34: X_PROGRAM_ID := FND_PROFILE.VALUE('CONC_PROGRAM_ID');
35: X_LAST_UPDATE_LOGIN := FND_PROFILE.VALUE('CONC_LOGIN_ID');

Line 33: FND_PROFILE.VALUE('CONC_PROGRAM_APPLICATION_ID');

29: if X_CONCURRENT = 1 then -- Online
30:
31: X_REQUEST_ID := FND_PROFILE.VALUE('REQUEST_ID');
32: X_PROGRAM_APPLICATION_ID :=
33: FND_PROFILE.VALUE('CONC_PROGRAM_APPLICATION_ID');
34: X_PROGRAM_ID := FND_PROFILE.VALUE('CONC_PROGRAM_ID');
35: X_LAST_UPDATE_LOGIN := FND_PROFILE.VALUE('CONC_LOGIN_ID');
36:
37: insert into qa_action_log (LOG_ID,

Line 34: X_PROGRAM_ID := FND_PROFILE.VALUE('CONC_PROGRAM_ID');

30:
31: X_REQUEST_ID := FND_PROFILE.VALUE('REQUEST_ID');
32: X_PROGRAM_APPLICATION_ID :=
33: FND_PROFILE.VALUE('CONC_PROGRAM_APPLICATION_ID');
34: X_PROGRAM_ID := FND_PROFILE.VALUE('CONC_PROGRAM_ID');
35: X_LAST_UPDATE_LOGIN := FND_PROFILE.VALUE('CONC_LOGIN_ID');
36:
37: insert into qa_action_log (LOG_ID,
38: LAST_UPDATE_DATE,

Line 35: X_LAST_UPDATE_LOGIN := FND_PROFILE.VALUE('CONC_LOGIN_ID');

31: X_REQUEST_ID := FND_PROFILE.VALUE('REQUEST_ID');
32: X_PROGRAM_APPLICATION_ID :=
33: FND_PROFILE.VALUE('CONC_PROGRAM_APPLICATION_ID');
34: X_PROGRAM_ID := FND_PROFILE.VALUE('CONC_PROGRAM_ID');
35: X_LAST_UPDATE_LOGIN := FND_PROFILE.VALUE('CONC_LOGIN_ID');
36:
37: insert into qa_action_log (LOG_ID,
38: LAST_UPDATE_DATE,
39: LAST_UPDATED_BY,

Line 1741: user_id := NVL(FND_PROFILE.VALUE('USER_ID'), 0);

1737:
1738: end if;
1739:
1740: -- get user id
1741: user_id := NVL(FND_PROFILE.VALUE('USER_ID'), 0);
1742:
1743: -- build the message for request_log by concatenating fnd_message and user input text message.
1744:
1745: -- Commented the usage of the cursor get_user_message and added code to use the cursor