DBA Data[Home] [Help]

APPS.CN_PERIODS_API dependencies on FND_GLOBAL

Line 144: l_user_id NUMBER(15) := fnd_global.user_id;

140: END update_gl_status ;
141:
142: -- Add concurrency to the open periods process
143: PROCEDURE update_error (x_physical_batch_id NUMBER) IS
144: l_user_id NUMBER(15) := fnd_global.user_id;
145: l_resp_id NUMBER(15) := fnd_global.resp_id;
146: l_login_id NUMBER(15) := fnd_global.login_id;
147: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
148: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

Line 145: l_resp_id NUMBER(15) := fnd_global.resp_id;

141:
142: -- Add concurrency to the open periods process
143: PROCEDURE update_error (x_physical_batch_id NUMBER) IS
144: l_user_id NUMBER(15) := fnd_global.user_id;
145: l_resp_id NUMBER(15) := fnd_global.resp_id;
146: l_login_id NUMBER(15) := fnd_global.login_id;
147: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
148: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
149: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

Line 146: l_login_id NUMBER(15) := fnd_global.login_id;

142: -- Add concurrency to the open periods process
143: PROCEDURE update_error (x_physical_batch_id NUMBER) IS
144: l_user_id NUMBER(15) := fnd_global.user_id;
145: l_resp_id NUMBER(15) := fnd_global.resp_id;
146: l_login_id NUMBER(15) := fnd_global.login_id;
147: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
148: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
149: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
150: BEGIN

Line 147: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;

143: PROCEDURE update_error (x_physical_batch_id NUMBER) IS
144: l_user_id NUMBER(15) := fnd_global.user_id;
145: l_resp_id NUMBER(15) := fnd_global.resp_id;
146: l_login_id NUMBER(15) := fnd_global.login_id;
147: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
148: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
149: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
150: BEGIN
151: -- Giving the batch an 'ERROR' status prevents subsequent

Line 148: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

144: l_user_id NUMBER(15) := fnd_global.user_id;
145: l_resp_id NUMBER(15) := fnd_global.resp_id;
146: l_login_id NUMBER(15) := fnd_global.login_id;
147: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
148: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
149: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
150: BEGIN
151: -- Giving the batch an 'ERROR' status prevents subsequent
152: -- physical processes picking it up.

Line 149: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

145: l_resp_id NUMBER(15) := fnd_global.resp_id;
146: l_login_id NUMBER(15) := fnd_global.login_id;
147: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
148: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
149: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
150: BEGIN
151: -- Giving the batch an 'ERROR' status prevents subsequent
152: -- physical processes picking it up.
153: UPDATE cn_process_batches

Line 366: x_request_id => fnd_global.conc_request_id,

362:
363: cn_message_pkg.begin_batch(x_process_type => 'OPEN_PERIODS',
364: x_process_audit_id => l_proc_audit_id,
365: x_parent_proc_audit_id => l_proc_audit_id,
366: x_request_id => fnd_global.conc_request_id,
367: p_org_id => l_org_id);
368:
369: cn_message_pkg.debug('Beginning of open periods process.');
370: ---------------------------------------------------------------

Line 418: fnd_global.user_id,

414: 0,
415: 'IN_USE',
416: 'OPENING_PERIODS',
417: sysdate,
418: fnd_global.user_id,
419: l_org_id
420: from (select distinct s.salesrep_id
421: from jtf_rs_role_relations rr,
422: cn_rs_salesreps s,

Line 495: x_last_update_login => fnd_global.login_id,

491: x_quarter_num => pending_period.quarter_num,
492: x_period_year => pending_period.period_year,
493: x_creation_date => sysdate,
494: x_last_update_date => sysdate,
495: x_last_update_login => fnd_global.login_id,
496: x_last_updated_by => fnd_global.user_id,
497: x_created_by => fnd_global.user_id,
498: x_period_type_code => null, -- not used
499: x_performance_goal => 0

Line 496: x_last_updated_by => fnd_global.user_id,

492: x_period_year => pending_period.period_year,
493: x_creation_date => sysdate,
494: x_last_update_date => sysdate,
495: x_last_update_login => fnd_global.login_id,
496: x_last_updated_by => fnd_global.user_id,
497: x_created_by => fnd_global.user_id,
498: x_period_type_code => null, -- not used
499: x_performance_goal => 0
500: );

Line 497: x_created_by => fnd_global.user_id,

493: x_creation_date => sysdate,
494: x_last_update_date => sysdate,
495: x_last_update_login => fnd_global.login_id,
496: x_last_updated_by => fnd_global.user_id,
497: x_created_by => fnd_global.user_id,
498: x_period_type_code => null, -- not used
499: x_performance_goal => 0
500: );
501: END LOOP;

Line 652: l_user_id NUMBER := fnd_global.user_id;

648:
649: l_err_srp_id number:=0;
650: l_err_quota_id number:=0;
651: l_orig_pd_id NUMBER := -1;
652: l_user_id NUMBER := fnd_global.user_id;
653: l_login_id NUMBER := fnd_global.login_id;
654: l_curr_srp_id NUMBER;
655: l_curr_pd_id NUMBER;
656: l_count NUMBER;

Line 653: l_login_id NUMBER := fnd_global.login_id;

649: l_err_srp_id number:=0;
650: l_err_quota_id number:=0;
651: l_orig_pd_id NUMBER := -1;
652: l_user_id NUMBER := fnd_global.user_id;
653: l_login_id NUMBER := fnd_global.login_id;
654: l_curr_srp_id NUMBER;
655: l_curr_pd_id NUMBER;
656: l_count NUMBER;
657:

Line 673: ,x_request_id => fnd_global.conc_request_id

669: cn_message_pkg.begin_batch
670: (
671: x_parent_proc_audit_id => p_parent_proc_audit_id
672: ,x_process_audit_id => l_proc_audit_id
673: ,x_request_id => fnd_global.conc_request_id
674: ,x_process_type => 'OPEN_PERIODS_RUNNER'
675: ,p_org_id => l_org_id);
676:
677: cn_message_pkg.debug('Populate SRP tables runner');

Line 1118: x_last_updated_by => fnd_global.user_id,

1114: x_cal_period_id => x_period_id,
1115: x_org_id => x_org_id,
1116: x_interval_number => l_interval_number,
1117: x_last_update_date => sysdate,
1118: x_last_updated_by => fnd_global.user_id,
1119: x_creation_date => sysdate,
1120: x_created_by => fnd_global.user_id,
1121: x_last_update_login => fnd_global.login_id
1122: );

Line 1120: x_created_by => fnd_global.user_id,

1116: x_interval_number => l_interval_number,
1117: x_last_update_date => sysdate,
1118: x_last_updated_by => fnd_global.user_id,
1119: x_creation_date => sysdate,
1120: x_created_by => fnd_global.user_id,
1121: x_last_update_login => fnd_global.login_id
1122: );
1123: END IF;
1124: END LOOP;

Line 1121: x_last_update_login => fnd_global.login_id

1117: x_last_update_date => sysdate,
1118: x_last_updated_by => fnd_global.user_id,
1119: x_creation_date => sysdate,
1120: x_created_by => fnd_global.user_id,
1121: x_last_update_login => fnd_global.login_id
1122: );
1123: END IF;
1124: END LOOP;
1125: END IF;