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 3355: l_last_updated_by NUMBER DEFAULT NVL(FND_GLOBAL.USER_ID, -1);

3351: l_action_code VARCHAR2(2);-- DEFAULT 'N';
3352: --Added the following variables for the Enhancement -Enc Redesign: Enh. Bug 2259310
3353: l_batch_name VARCHAR2(30) DEFAULT 'ENC'||TO_CHAR(TRUNC(SYSDATE));
3354: l_last_update_date DATE DEFAULT SYSDATE;
3355: l_last_updated_by NUMBER DEFAULT NVL(FND_GLOBAL.USER_ID, -1);
3356: l_last_updated_login NUMBER DEFAULT NVL(FND_GLOBAL.LOGIN_ID, -1);
3357: CURSOR get_enc_control_id_cur IS
3358: SELECT enc_control_id
3359: FROM psp_enc_controls

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

3352: --Added the following variables for the Enhancement -Enc Redesign: Enh. Bug 2259310
3353: l_batch_name VARCHAR2(30) DEFAULT 'ENC'||TO_CHAR(TRUNC(SYSDATE));
3354: l_last_update_date DATE DEFAULT SYSDATE;
3355: l_last_updated_by NUMBER DEFAULT NVL(FND_GLOBAL.USER_ID, -1);
3356: l_last_updated_login NUMBER DEFAULT NVL(FND_GLOBAL.LOGIN_ID, -1);
3357: CURSOR get_enc_control_id_cur IS
3358: SELECT enc_control_id
3359: FROM psp_enc_controls
3360: WHERE payroll_action_id = p_payroll_action_id

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

3658: p_enc_line_type IN VARCHAR2,
3659: p_return_status OUT NOCOPY VARCHAR2)
3660: IS
3661: l_last_update_date DATE DEFAULT SYSDATE;
3662: l_last_updated_by NUMBER DEFAULT NVL(FND_GLOBAL.USER_ID, -1);
3663: l_last_update_login NUMBER DEFAULT NVL(FND_GLOBAL.LOGIN_ID, -1);
3664: BEGIN
3665: FORALL i IN 1 .. t_enc_lines_array2.r_enc_element_type_id.COUNT
3666: insert into psp_enc_lines

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

3659: p_return_status OUT NOCOPY VARCHAR2)
3660: IS
3661: l_last_update_date DATE DEFAULT SYSDATE;
3662: l_last_updated_by NUMBER DEFAULT NVL(FND_GLOBAL.USER_ID, -1);
3663: l_last_update_login NUMBER DEFAULT NVL(FND_GLOBAL.LOGIN_ID, -1);
3664: BEGIN
3665: FORALL i IN 1 .. t_enc_lines_array2.r_enc_element_type_id.COUNT
3666: insert into psp_enc_lines
3667: (

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

6386: BEGIN
6387: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_RANGE_CODE pactid: ' || pactid);
6388:
6389: l_last_update_date := SYSDATE;
6390: l_last_updated_by := NVL(FND_GLOBAL.USER_ID, -1);
6391: l_last_updated_login := NVL(FND_GLOBAL.LOGIN_ID, -1);
6392: l_request_id := fnd_global.conc_request_id;
6393: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
6394: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');

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

6387: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_RANGE_CODE pactid: ' || pactid);
6388:
6389: l_last_update_date := SYSDATE;
6390: l_last_updated_by := NVL(FND_GLOBAL.USER_ID, -1);
6391: l_last_updated_login := NVL(FND_GLOBAL.LOGIN_ID, -1);
6392: l_request_id := fnd_global.conc_request_id;
6393: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
6394: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
6395:

Line 6392: l_request_id := fnd_global.conc_request_id;

6388:
6389: l_last_update_date := SYSDATE;
6390: l_last_updated_by := NVL(FND_GLOBAL.USER_ID, -1);
6391: l_last_updated_login := NVL(FND_GLOBAL.LOGIN_ID, -1);
6392: l_request_id := fnd_global.conc_request_id;
6393: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
6394: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
6395:
6396: OPEN action_parameters_cur;

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

7461: AND status_code = 'N';
7462: BEGIN
7463: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_DEINIT payroll_action_id: ' || p_payroll_action_id);
7464: l_last_update_date := SYSDATE;
7465: l_last_updated_by:= NVL(FND_GLOBAL.USER_ID, -1);
7466: l_request_id := fnd_global.conc_request_id;
7467:
7468: OPEN payroll_id_cur;
7469: FETCH payroll_id_cur INTO l_process_mode;

Line 7466: l_request_id := fnd_global.conc_request_id;

7462: BEGIN
7463: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_DEINIT payroll_action_id: ' || p_payroll_action_id);
7464: l_last_update_date := SYSDATE;
7465: l_last_updated_by:= NVL(FND_GLOBAL.USER_ID, -1);
7466: l_request_id := fnd_global.conc_request_id;
7467:
7468: OPEN payroll_id_cur;
7469: FETCH payroll_id_cur INTO l_process_mode;
7470: CLOSE payroll_id_cur;

Line 7494: TO_CHAR(fnd_global.conc_request_id),

7490: '',
7491: '',
7492: FALSE,
7493: TO_CHAR(p_payroll_action_id),
7494: TO_CHAR(fnd_global.conc_request_id),
7495: TO_CHAR(l_business_group_id),
7496: TO_CHAR(l_set_of_books_id));
7497:
7498: IF l_request_id = 0 THEN

Line 7637: TO_CHAR(fnd_global.conc_request_id),

7633: '',
7634: '',
7635: FALSE,
7636: TO_CHAR(p_payroll_action_id),
7637: TO_CHAR(fnd_global.conc_request_id),
7638: TO_CHAR(l_business_group_id),
7639: TO_CHAR(l_set_of_books_id));
7640:
7641: IF l_request_id = 0 THEN

Line 8164: l_last_updated_by := fnd_global.user_id;

8160: p_return_status OUT NOCOPY VARCHAR2) IS
8161: l_last_updated_by NUMBER(15);
8162: l_last_update_login NUMBER(15);
8163: BEGIN
8164: l_last_updated_by := fnd_global.user_id;
8165: l_last_update_login := fnd_global.login_id;
8166:
8167: INSERT INTO psp_enc_summary_lines
8168: (enc_summary_line_id, business_group_id, set_of_books_id,

Line 8165: l_last_update_login := fnd_global.login_id;

8161: l_last_updated_by NUMBER(15);
8162: l_last_update_login NUMBER(15);
8163: BEGIN
8164: l_last_updated_by := fnd_global.user_id;
8165: l_last_update_login := fnd_global.login_id;
8166:
8167: INSERT INTO psp_enc_summary_lines
8168: (enc_summary_line_id, business_group_id, set_of_books_id,
8169: enc_control_id, time_period_id, person_id,

Line 8342: l_last_updated_by := fnd_global.user_id;

8338: attribute10 t_varchar_150_type,
8339: org_id t_num_15_type);
8340: t_sum_lines sum_lines_rec;
8341: BEGIN
8342: l_last_updated_by := fnd_global.user_id;
8343: l_last_update_login := fnd_global.login_id;
8344:
8345: OPEN sum_lines_cur;
8346: FETCH sum_lines_cur BULK COLLECT INTO t_sum_lines.enc_control_id,

Line 8343: l_last_update_login := fnd_global.login_id;

8339: org_id t_num_15_type);
8340: t_sum_lines sum_lines_rec;
8341: BEGIN
8342: l_last_updated_by := fnd_global.user_id;
8343: l_last_update_login := fnd_global.login_id;
8344:
8345: OPEN sum_lines_cur;
8346: FETCH sum_lines_cur BULK COLLECT INTO t_sum_lines.enc_control_id,
8347: t_sum_lines.time_period_id, t_sum_lines.person_id,

Line 8613: l_request_id := FND_GLOBAL. CONC_REQUEST_ID;

8609: p_payroll_action_id: ' || p_payroll_action_id || '
8610: p_payroll_id: ' || p_payroll_id || '
8611: p_process_mode: ' || p_process_mode);
8612:
8613: l_request_id := FND_GLOBAL. CONC_REQUEST_ID;
8614: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8615: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8616: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_request_id: ' || l_request_id ||'
8617: l_set_of_books_id: ' || l_set_of_books_id || '

Line 9488: l_request_id := fnd_global.conc_request_id;

9484:
9485: l_request_id NUMBER(15);
9486: BEGIN
9487: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
9488: l_request_id := fnd_global.conc_request_id;
9489:
9490: IF (p_person_id1 IS NULL) THEN
9491: OPEN superceded_line_cur(NULL);
9492: FETCH superceded_line_cur BULK COLLECT INTO t_superceded_lines.enc_summary_line_id;