DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG1 dependencies on FND_GLOBAL

Line 1115: l_request_id NUMBER := fnd_global.conc_request_id();

1111: CURSOR cur_packet IS
1112: SELECT gl_bc_packets_s.nextval
1113: FROM dual;
1114:
1115: l_request_id NUMBER := fnd_global.conc_request_id();
1116: l_program_id NUMBER := fnd_global.conc_program_id();
1117: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
1118: l_update_login NUMBER := FND_GLOBAL.login_id;
1119: l_num_rows NUMBER := 0;

Line 1116: l_program_id NUMBER := fnd_global.conc_program_id();

1112: SELECT gl_bc_packets_s.nextval
1113: FROM dual;
1114:
1115: l_request_id NUMBER := fnd_global.conc_request_id();
1116: l_program_id NUMBER := fnd_global.conc_program_id();
1117: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
1118: l_update_login NUMBER := FND_GLOBAL.login_id;
1119: l_num_rows NUMBER := 0;
1120: l_return_status VARCHAR2(1);

Line 1117: l_program_application_id NUMBER:= fnd_global.prog_appl_id();

1113: FROM dual;
1114:
1115: l_request_id NUMBER := fnd_global.conc_request_id();
1116: l_program_id NUMBER := fnd_global.conc_program_id();
1117: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
1118: l_update_login NUMBER := FND_GLOBAL.login_id;
1119: l_num_rows NUMBER := 0;
1120: l_return_status VARCHAR2(1);
1121: l_debug_mode VARCHAR2(10);

Line 1118: l_update_login NUMBER := FND_GLOBAL.login_id;

1114:
1115: l_request_id NUMBER := fnd_global.conc_request_id();
1116: l_program_id NUMBER := fnd_global.conc_program_id();
1117: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
1118: l_update_login NUMBER := FND_GLOBAL.login_id;
1119: l_num_rows NUMBER := 0;
1120: l_return_status VARCHAR2(1);
1121: l_debug_mode VARCHAR2(10);
1122:

Line 4214: l_request_id NUMBER := fnd_global.conc_request_id();

4210: p_bc_mode IN VARCHAR2,
4211: p_calling_module IN VARCHAR2 DEFAULT NULL) IS
4212:
4213: PRAGMA AUTONOMOUS_TRANSACTION;
4214: l_request_id NUMBER := fnd_global.conc_request_id();
4215: l_program_id NUMBER := fnd_global.conc_program_id();
4216: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
4217: l_update_login NUMBER := FND_GLOBAL.login_id;
4218: l_num_rows NUMBER := 0;

Line 4215: l_program_id NUMBER := fnd_global.conc_program_id();

4211: p_calling_module IN VARCHAR2 DEFAULT NULL) IS
4212:
4213: PRAGMA AUTONOMOUS_TRANSACTION;
4214: l_request_id NUMBER := fnd_global.conc_request_id();
4215: l_program_id NUMBER := fnd_global.conc_program_id();
4216: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
4217: l_update_login NUMBER := FND_GLOBAL.login_id;
4218: l_num_rows NUMBER := 0;
4219: l_return_status VARCHAR2(1);

Line 4216: l_program_application_id NUMBER:= fnd_global.prog_appl_id();

4212:
4213: PRAGMA AUTONOMOUS_TRANSACTION;
4214: l_request_id NUMBER := fnd_global.conc_request_id();
4215: l_program_id NUMBER := fnd_global.conc_program_id();
4216: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
4217: l_update_login NUMBER := FND_GLOBAL.login_id;
4218: l_num_rows NUMBER := 0;
4219: l_return_status VARCHAR2(1);
4220:

Line 4217: l_update_login NUMBER := FND_GLOBAL.login_id;

4213: PRAGMA AUTONOMOUS_TRANSACTION;
4214: l_request_id NUMBER := fnd_global.conc_request_id();
4215: l_program_id NUMBER := fnd_global.conc_program_id();
4216: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
4217: l_update_login NUMBER := FND_GLOBAL.login_id;
4218: l_num_rows NUMBER := 0;
4219: l_return_status VARCHAR2(1);
4220:
4221: BEGIN

Line 4717: l_request_id NUMBER := fnd_global.conc_request_id();

4713: p_mode IN varchar2 default 'R' ) IS
4714:
4715: PRAGMA AUTONOMOUS_TRANSACTION;
4716:
4717: l_request_id NUMBER := fnd_global.conc_request_id();
4718: l_program_id NUMBER := fnd_global.conc_program_id();
4719: l_program_application_id NUMBER := fnd_global.prog_appl_id();
4720: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
4721: l_userid NUMBER := NVL(fnd_global.user_id,-1);

Line 4718: l_program_id NUMBER := fnd_global.conc_program_id();

4714:
4715: PRAGMA AUTONOMOUS_TRANSACTION;
4716:
4717: l_request_id NUMBER := fnd_global.conc_request_id();
4718: l_program_id NUMBER := fnd_global.conc_program_id();
4719: l_program_application_id NUMBER := fnd_global.prog_appl_id();
4720: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
4721: l_userid NUMBER := NVL(fnd_global.user_id,-1);
4722: l_return_status Varchar2(1000);

Line 4719: l_program_application_id NUMBER := fnd_global.prog_appl_id();

4715: PRAGMA AUTONOMOUS_TRANSACTION;
4716:
4717: l_request_id NUMBER := fnd_global.conc_request_id();
4718: l_program_id NUMBER := fnd_global.conc_program_id();
4719: l_program_application_id NUMBER := fnd_global.prog_appl_id();
4720: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
4721: l_userid NUMBER := NVL(fnd_global.user_id,-1);
4722: l_return_status Varchar2(1000);
4723:

Line 4720: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);

4716:
4717: l_request_id NUMBER := fnd_global.conc_request_id();
4718: l_program_id NUMBER := fnd_global.conc_program_id();
4719: l_program_application_id NUMBER := fnd_global.prog_appl_id();
4720: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
4721: l_userid NUMBER := NVL(fnd_global.user_id,-1);
4722: l_return_status Varchar2(1000);
4723:
4724:

Line 4721: l_userid NUMBER := NVL(fnd_global.user_id,-1);

4717: l_request_id NUMBER := fnd_global.conc_request_id();
4718: l_program_id NUMBER := fnd_global.conc_program_id();
4719: l_program_application_id NUMBER := fnd_global.prog_appl_id();
4720: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
4721: l_userid NUMBER := NVL(fnd_global.user_id,-1);
4722: l_return_status Varchar2(1000);
4723:
4724:
4725: BEGIN

Line 5426: l_request_id NUMBER := fnd_global.conc_request_id();

5422: p_compiled_multiplier IN NUMBER
5423: ) RETURN boolean is
5424: PRAGMA AUTONOMOUS_TRANSACTION;
5425:
5426: l_request_id NUMBER := fnd_global.conc_request_id();
5427: l_program_id NUMBER := fnd_global.conc_program_id();
5428: l_program_application_id NUMBER := fnd_global.prog_appl_id();
5429: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
5430: l_userid NUMBER := NVL(fnd_global.user_id,-1);

Line 5427: l_program_id NUMBER := fnd_global.conc_program_id();

5423: ) RETURN boolean is
5424: PRAGMA AUTONOMOUS_TRANSACTION;
5425:
5426: l_request_id NUMBER := fnd_global.conc_request_id();
5427: l_program_id NUMBER := fnd_global.conc_program_id();
5428: l_program_application_id NUMBER := fnd_global.prog_appl_id();
5429: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
5430: l_userid NUMBER := NVL(fnd_global.user_id,-1);
5431: -- bug : 3717214

Line 5428: l_program_application_id NUMBER := fnd_global.prog_appl_id();

5424: PRAGMA AUTONOMOUS_TRANSACTION;
5425:
5426: l_request_id NUMBER := fnd_global.conc_request_id();
5427: l_program_id NUMBER := fnd_global.conc_program_id();
5428: l_program_application_id NUMBER := fnd_global.prog_appl_id();
5429: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
5430: l_userid NUMBER := NVL(fnd_global.user_id,-1);
5431: -- bug : 3717214
5432: -- Declare variables and cursors to determine if existing multipliers should be used

Line 5429: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);

5425:
5426: l_request_id NUMBER := fnd_global.conc_request_id();
5427: l_program_id NUMBER := fnd_global.conc_program_id();
5428: l_program_application_id NUMBER := fnd_global.prog_appl_id();
5429: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
5430: l_userid NUMBER := NVL(fnd_global.user_id,-1);
5431: -- bug : 3717214
5432: -- Declare variables and cursors to determine if existing multipliers should be used
5433: --

Line 5430: l_userid NUMBER := NVL(fnd_global.user_id,-1);

5426: l_request_id NUMBER := fnd_global.conc_request_id();
5427: l_program_id NUMBER := fnd_global.conc_program_id();
5428: l_program_application_id NUMBER := fnd_global.prog_appl_id();
5429: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
5430: l_userid NUMBER := NVL(fnd_global.user_id,-1);
5431: -- bug : 3717214
5432: -- Declare variables and cursors to determine if existing multipliers should be used
5433: --
5434: l_count NUMBER ;

Line 6476: l_request_id NUMBER := fnd_global.conc_request_id();

6472: l_burden_method VARCHAR2(20) := 'NONE';
6473: l_bc_packet_id NUMBER;
6474: l_parent_bc_packet_id NUMBER;
6475: l_doc_type VARCHAR2(30);
6476: l_request_id NUMBER := fnd_global.conc_request_id();
6477: l_program_id NUMBER := fnd_global.conc_program_id();
6478: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
6479: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
6480: l_num_rows NUMBER := 0;

Line 6477: l_program_id NUMBER := fnd_global.conc_program_id();

6473: l_bc_packet_id NUMBER;
6474: l_parent_bc_packet_id NUMBER;
6475: l_doc_type VARCHAR2(30);
6476: l_request_id NUMBER := fnd_global.conc_request_id();
6477: l_program_id NUMBER := fnd_global.conc_program_id();
6478: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
6479: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
6480: l_num_rows NUMBER := 0;
6481: l_userid NUMBER := NVL(fnd_global.user_id,-1);

Line 6478: l_program_application_id NUMBER:= fnd_global.prog_appl_id();

6474: l_parent_bc_packet_id NUMBER;
6475: l_doc_type VARCHAR2(30);
6476: l_request_id NUMBER := fnd_global.conc_request_id();
6477: l_program_id NUMBER := fnd_global.conc_program_id();
6478: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
6479: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
6480: l_num_rows NUMBER := 0;
6481: l_userid NUMBER := NVL(fnd_global.user_id,-1);
6482: l_exp_type VARCHAR2(100);

Line 6479: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);

6475: l_doc_type VARCHAR2(30);
6476: l_request_id NUMBER := fnd_global.conc_request_id();
6477: l_program_id NUMBER := fnd_global.conc_program_id();
6478: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
6479: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
6480: l_num_rows NUMBER := 0;
6481: l_userid NUMBER := NVL(fnd_global.user_id,-1);
6482: l_exp_type VARCHAR2(100);
6483: l_expenditure_type VARCHAR2(100);

Line 6481: l_userid NUMBER := NVL(fnd_global.user_id,-1);

6477: l_program_id NUMBER := fnd_global.conc_program_id();
6478: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
6479: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
6480: l_num_rows NUMBER := 0;
6481: l_userid NUMBER := NVL(fnd_global.user_id,-1);
6482: l_exp_type VARCHAR2(100);
6483: l_expenditure_type VARCHAR2(100);
6484: l_entered_dr NUMBER;
6485: l_entered_cr NUMBER;

Line 9077: l_request_id NUMBER := fnd_global.conc_request_id();

9073: ,p_reference1 IN varchar2
9074: ,p_reference2 IN varchar2
9075: ,p_mode IN varchar2) IS
9076:
9077: l_request_id NUMBER := fnd_global.conc_request_id();
9078: l_program_id NUMBER := fnd_global.conc_program_id();
9079: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
9080: l_update_login NUMBER := FND_GLOBAL.login_id;
9081: l_num_rows NUMBER := 0;

Line 9078: l_program_id NUMBER := fnd_global.conc_program_id();

9074: ,p_reference2 IN varchar2
9075: ,p_mode IN varchar2) IS
9076:
9077: l_request_id NUMBER := fnd_global.conc_request_id();
9078: l_program_id NUMBER := fnd_global.conc_program_id();
9079: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
9080: l_update_login NUMBER := FND_GLOBAL.login_id;
9081: l_num_rows NUMBER := 0;
9082: l_return_status VARCHAR2(1);

Line 9079: l_program_application_id NUMBER:= fnd_global.prog_appl_id();

9075: ,p_mode IN varchar2) IS
9076:
9077: l_request_id NUMBER := fnd_global.conc_request_id();
9078: l_program_id NUMBER := fnd_global.conc_program_id();
9079: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
9080: l_update_login NUMBER := FND_GLOBAL.login_id;
9081: l_num_rows NUMBER := 0;
9082: l_return_status VARCHAR2(1);
9083: l_debug_mode VARCHAR2(10);

Line 9080: l_update_login NUMBER := FND_GLOBAL.login_id;

9076:
9077: l_request_id NUMBER := fnd_global.conc_request_id();
9078: l_program_id NUMBER := fnd_global.conc_program_id();
9079: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
9080: l_update_login NUMBER := FND_GLOBAL.login_id;
9081: l_num_rows NUMBER := 0;
9082: l_return_status VARCHAR2(1);
9083: l_debug_mode VARCHAR2(10);
9084: