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 587: l_user_date_mask VARCHAR2(100) := fnd_profile.value('ICX_DATE_FORMAT_MASK');

583: --
584: -- bug 12605910
585: -- Variable to store the user date format mask
586: --
587: l_user_date_mask VARCHAR2(100) := fnd_profile.value('ICX_DATE_FORMAT_MASK');
588: BEGIN
589:
590: x_progress := 1;
591: --dbms_output.enable(1000000);

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

1783:
1784: end if;
1785:
1786: -- get user id
1787: user_id := NVL(FND_PROFILE.VALUE('USER_ID'), 0);
1788:
1789: -- build the message for request_log by concatenating fnd_message and user input text message.
1790:
1791: -- Commented the usage of the cursor get_user_message and added code to use the cursor

Line 2289: l_user_id := NVL(FND_PROFILE.VALUE('USER_ID'), 0);

2285: aname => 'PCA_ID',
2286: avalue => fnd_number.canonical_to_number(X_PCA_ID));
2287: END IF;
2288:
2289: l_user_id := NVL(FND_PROFILE.VALUE('USER_ID'), 0);
2290:
2291: Open f_user_name(l_user_id);
2292: fetch f_user_name into l_user_name;
2293: close f_user_name;