eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_ENC_CREATE_LINES dependencies on FND_GLOBAL

Line 3587: l_last_updated_by NUMBER DEFAULT NVL(FND_GLOBAL.USER_ID, -1);

3583: l_action_code VARCHAR2(2);-- DEFAULT 'N';
3584: --Added the following variables for the Enhancement -Enc Redesign: Enh. Bug 2259310
3585: l_batch_name VARCHAR2(30) DEFAULT 'ENC'||TO_CHAR(TRUNC(SYSDATE));
3586: l_last_update_date DATE DEFAULT SYSDATE;
3587: l_last_updated_by NUMBER DEFAULT NVL(FND_GLOBAL.USER_ID, -1);
3588: l_last_updated_login NUMBER DEFAULT NVL(FND_GLOBAL.LOGIN_ID, -1);
3589: CURSOR get_enc_control_id_cur IS
3590: SELECT enc_control_id
3591: FROM psp_enc_controls

Line 3588: l_last_updated_login NUMBER DEFAULT NVL(FND_GLOBAL.LOGIN_ID, -1);

3584: --Added the following variables for the Enhancement -Enc Redesign: Enh. Bug 2259310
3585: l_batch_name VARCHAR2(30) DEFAULT 'ENC'||TO_CHAR(TRUNC(SYSDATE));
3586: l_last_update_date DATE DEFAULT SYSDATE;
3587: l_last_updated_by NUMBER DEFAULT NVL(FND_GLOBAL.USER_ID, -1);
3588: l_last_updated_login NUMBER DEFAULT NVL(FND_GLOBAL.LOGIN_ID, -1);
3589: CURSOR get_enc_control_id_cur IS
3590: SELECT enc_control_id
3591: FROM psp_enc_controls
3592: WHERE payroll_action_id = p_payroll_action_id

Line 3896: l_last_updated_by NUMBER DEFAULT NVL(FND_GLOBAL.USER_ID, -1);

3892: p_enc_line_type IN VARCHAR2,
3893: p_return_status OUT NOCOPY VARCHAR2)
3894: IS
3895: l_last_update_date DATE DEFAULT SYSDATE;
3896: l_last_updated_by NUMBER DEFAULT NVL(FND_GLOBAL.USER_ID, -1);
3897: l_last_update_login NUMBER DEFAULT NVL(FND_GLOBAL.LOGIN_ID, -1);
3898: BEGIN
3899: FORALL i IN 1 .. t_enc_lines_array2.r_enc_element_type_id.COUNT
3900: insert into psp_enc_lines

Line 3897: l_last_update_login NUMBER DEFAULT NVL(FND_GLOBAL.LOGIN_ID, -1);

3893: p_return_status OUT NOCOPY VARCHAR2)
3894: IS
3895: l_last_update_date DATE DEFAULT SYSDATE;
3896: l_last_updated_by NUMBER DEFAULT NVL(FND_GLOBAL.USER_ID, -1);
3897: l_last_update_login NUMBER DEFAULT NVL(FND_GLOBAL.LOGIN_ID, -1);
3898: BEGIN
3899: FORALL i IN 1 .. t_enc_lines_array2.r_enc_element_type_id.COUNT
3900: insert into psp_enc_lines
3901: (

Line 6646: l_last_updated_by := NVL(FND_GLOBAL.USER_ID, -1);

6642: BEGIN
6643: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_RANGE_CODE pactid: ' || pactid);
6644:
6645: l_last_update_date := SYSDATE;
6646: l_last_updated_by := NVL(FND_GLOBAL.USER_ID, -1);
6647: l_last_updated_login := NVL(FND_GLOBAL.LOGIN_ID, -1);
6648: l_request_id := fnd_global.conc_request_id;
6649: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
6650: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');

Line 6647: l_last_updated_login := NVL(FND_GLOBAL.LOGIN_ID, -1);

6643: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_RANGE_CODE pactid: ' || pactid);
6644:
6645: l_last_update_date := SYSDATE;
6646: l_last_updated_by := NVL(FND_GLOBAL.USER_ID, -1);
6647: l_last_updated_login := NVL(FND_GLOBAL.LOGIN_ID, -1);
6648: l_request_id := fnd_global.conc_request_id;
6649: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
6650: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
6651:

Line 6648: l_request_id := fnd_global.conc_request_id;

6644:
6645: l_last_update_date := SYSDATE;
6646: l_last_updated_by := NVL(FND_GLOBAL.USER_ID, -1);
6647: l_last_updated_login := NVL(FND_GLOBAL.LOGIN_ID, -1);
6648: l_request_id := fnd_global.conc_request_id;
6649: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
6650: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
6651:
6652: OPEN action_parameters_cur;

Line 7777: l_last_updated_by:= NVL(FND_GLOBAL.USER_ID, -1);

7773: AND status_code = 'N';
7774: BEGIN
7775: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_DEINIT payroll_action_id: ' || p_payroll_action_id);
7776: l_last_update_date := SYSDATE;
7777: l_last_updated_by:= NVL(FND_GLOBAL.USER_ID, -1);
7778: l_request_id := fnd_global.conc_request_id;
7779:
7780: OPEN payroll_id_cur;
7781: FETCH payroll_id_cur INTO l_process_mode;

Line 7778: l_request_id := fnd_global.conc_request_id;

7774: BEGIN
7775: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_DEINIT payroll_action_id: ' || p_payroll_action_id);
7776: l_last_update_date := SYSDATE;
7777: l_last_updated_by:= NVL(FND_GLOBAL.USER_ID, -1);
7778: l_request_id := fnd_global.conc_request_id;
7779:
7780: OPEN payroll_id_cur;
7781: FETCH payroll_id_cur INTO l_process_mode;
7782: CLOSE payroll_id_cur;

Line 7806: TO_CHAR(fnd_global.conc_request_id),

7802: '',
7803: '',
7804: FALSE,
7805: TO_CHAR(p_payroll_action_id),
7806: TO_CHAR(fnd_global.conc_request_id),
7807: TO_CHAR(l_business_group_id),
7808: TO_CHAR(l_set_of_books_id));
7809:
7810: IF l_request_id = 0 THEN

Line 7949: TO_CHAR(fnd_global.conc_request_id),

7945: '',
7946: '',
7947: FALSE,
7948: TO_CHAR(p_payroll_action_id),
7949: TO_CHAR(fnd_global.conc_request_id),
7950: TO_CHAR(l_business_group_id),
7951: TO_CHAR(l_set_of_books_id));
7952:
7953: IF l_request_id = 0 THEN

Line 8485: l_last_updated_by := fnd_global.user_id;

8481: p_return_status OUT NOCOPY VARCHAR2) IS
8482: l_last_updated_by NUMBER(15);
8483: l_last_update_login NUMBER(15);
8484: BEGIN
8485: l_last_updated_by := fnd_global.user_id;
8486: l_last_update_login := fnd_global.login_id;
8487:
8488: INSERT INTO psp_enc_summary_lines
8489: (enc_summary_line_id, business_group_id, set_of_books_id,

Line 8486: l_last_update_login := fnd_global.login_id;

8482: l_last_updated_by NUMBER(15);
8483: l_last_update_login NUMBER(15);
8484: BEGIN
8485: l_last_updated_by := fnd_global.user_id;
8486: l_last_update_login := fnd_global.login_id;
8487:
8488: INSERT INTO psp_enc_summary_lines
8489: (enc_summary_line_id, business_group_id, set_of_books_id,
8490: enc_control_id, time_period_id, person_id,

Line 8664: l_last_updated_by := fnd_global.user_id;

8660: attribute10 t_varchar_150_type,
8661: org_id t_num_15_type);
8662: t_sum_lines sum_lines_rec;
8663: BEGIN
8664: l_last_updated_by := fnd_global.user_id;
8665: l_last_update_login := fnd_global.login_id;
8666:
8667: OPEN sum_lines_cur;
8668: FETCH sum_lines_cur BULK COLLECT INTO t_sum_lines.enc_control_id,

Line 8665: l_last_update_login := fnd_global.login_id;

8661: org_id t_num_15_type);
8662: t_sum_lines sum_lines_rec;
8663: BEGIN
8664: l_last_updated_by := fnd_global.user_id;
8665: l_last_update_login := fnd_global.login_id;
8666:
8667: OPEN sum_lines_cur;
8668: FETCH sum_lines_cur BULK COLLECT INTO t_sum_lines.enc_control_id,
8669: t_sum_lines.time_period_id, t_sum_lines.person_id,

Line 8990: l_request_id := FND_GLOBAL. CONC_REQUEST_ID;

8986: p_payroll_action_id: ' || p_payroll_action_id || '
8987: p_payroll_id: ' || p_payroll_id || '
8988: p_process_mode: ' || p_process_mode);
8989:
8990: l_request_id := FND_GLOBAL. CONC_REQUEST_ID;
8991: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8992: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8993: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_request_id: ' || l_request_id ||'
8994: l_set_of_books_id: ' || l_set_of_books_id || '

Line 10117: l_request_id := fnd_global.conc_request_id;

10113:
10114: l_request_id NUMBER(15);
10115: BEGIN
10116: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
10117: l_request_id := fnd_global.conc_request_id;
10118:
10119: IF (p_person_id1 IS NULL) THEN
10120: OPEN superceded_line_cur(NULL);
10121: FETCH superceded_line_cur BULK COLLECT INTO t_superceded_lines.enc_summary_line_id;