DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG1 dependencies on FND_GLOBAL

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

1096: CURSOR cur_packet IS
1097: SELECT gl_bc_packets_s.nextval
1098: FROM dual;
1099:
1100: l_request_id NUMBER := fnd_global.conc_request_id();
1101: l_program_id NUMBER := fnd_global.conc_program_id();
1102: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
1103: l_update_login NUMBER := FND_GLOBAL.login_id;
1104: l_num_rows NUMBER := 0;

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

1097: SELECT gl_bc_packets_s.nextval
1098: FROM dual;
1099:
1100: l_request_id NUMBER := fnd_global.conc_request_id();
1101: l_program_id NUMBER := fnd_global.conc_program_id();
1102: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
1103: l_update_login NUMBER := FND_GLOBAL.login_id;
1104: l_num_rows NUMBER := 0;
1105: l_return_status VARCHAR2(1);

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

1098: FROM dual;
1099:
1100: l_request_id NUMBER := fnd_global.conc_request_id();
1101: l_program_id NUMBER := fnd_global.conc_program_id();
1102: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
1103: l_update_login NUMBER := FND_GLOBAL.login_id;
1104: l_num_rows NUMBER := 0;
1105: l_return_status VARCHAR2(1);
1106: l_debug_mode VARCHAR2(10);

Line 1103: l_update_login NUMBER := FND_GLOBAL.login_id;

1099:
1100: l_request_id NUMBER := fnd_global.conc_request_id();
1101: l_program_id NUMBER := fnd_global.conc_program_id();
1102: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
1103: l_update_login NUMBER := FND_GLOBAL.login_id;
1104: l_num_rows NUMBER := 0;
1105: l_return_status VARCHAR2(1);
1106: l_debug_mode VARCHAR2(10);
1107:

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

3925: p_bc_mode IN VARCHAR2,
3926: p_calling_module IN VARCHAR2 DEFAULT NULL) IS
3927:
3928: PRAGMA AUTONOMOUS_TRANSACTION;
3929: l_request_id NUMBER := fnd_global.conc_request_id();
3930: l_program_id NUMBER := fnd_global.conc_program_id();
3931: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
3932: l_update_login NUMBER := FND_GLOBAL.login_id;
3933: l_num_rows NUMBER := 0;

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

3926: p_calling_module IN VARCHAR2 DEFAULT NULL) IS
3927:
3928: PRAGMA AUTONOMOUS_TRANSACTION;
3929: l_request_id NUMBER := fnd_global.conc_request_id();
3930: l_program_id NUMBER := fnd_global.conc_program_id();
3931: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
3932: l_update_login NUMBER := FND_GLOBAL.login_id;
3933: l_num_rows NUMBER := 0;
3934: l_return_status VARCHAR2(1);

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

3927:
3928: PRAGMA AUTONOMOUS_TRANSACTION;
3929: l_request_id NUMBER := fnd_global.conc_request_id();
3930: l_program_id NUMBER := fnd_global.conc_program_id();
3931: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
3932: l_update_login NUMBER := FND_GLOBAL.login_id;
3933: l_num_rows NUMBER := 0;
3934: l_return_status VARCHAR2(1);
3935:

Line 3932: l_update_login NUMBER := FND_GLOBAL.login_id;

3928: PRAGMA AUTONOMOUS_TRANSACTION;
3929: l_request_id NUMBER := fnd_global.conc_request_id();
3930: l_program_id NUMBER := fnd_global.conc_program_id();
3931: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
3932: l_update_login NUMBER := FND_GLOBAL.login_id;
3933: l_num_rows NUMBER := 0;
3934: l_return_status VARCHAR2(1);
3935:
3936: BEGIN

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

4421: p_mode IN varchar2 default 'R' ) IS
4422:
4423: PRAGMA AUTONOMOUS_TRANSACTION;
4424:
4425: l_request_id NUMBER := fnd_global.conc_request_id();
4426: l_program_id NUMBER := fnd_global.conc_program_id();
4427: l_program_application_id NUMBER := fnd_global.prog_appl_id();
4428: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
4429: l_userid NUMBER := NVL(fnd_global.user_id,-1);

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

4422:
4423: PRAGMA AUTONOMOUS_TRANSACTION;
4424:
4425: l_request_id NUMBER := fnd_global.conc_request_id();
4426: l_program_id NUMBER := fnd_global.conc_program_id();
4427: l_program_application_id NUMBER := fnd_global.prog_appl_id();
4428: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
4429: l_userid NUMBER := NVL(fnd_global.user_id,-1);
4430: l_return_status Varchar2(1000);

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

4423: PRAGMA AUTONOMOUS_TRANSACTION;
4424:
4425: l_request_id NUMBER := fnd_global.conc_request_id();
4426: l_program_id NUMBER := fnd_global.conc_program_id();
4427: l_program_application_id NUMBER := fnd_global.prog_appl_id();
4428: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
4429: l_userid NUMBER := NVL(fnd_global.user_id,-1);
4430: l_return_status Varchar2(1000);
4431:

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

4424:
4425: l_request_id NUMBER := fnd_global.conc_request_id();
4426: l_program_id NUMBER := fnd_global.conc_program_id();
4427: l_program_application_id NUMBER := fnd_global.prog_appl_id();
4428: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
4429: l_userid NUMBER := NVL(fnd_global.user_id,-1);
4430: l_return_status Varchar2(1000);
4431:
4432:

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

4425: l_request_id NUMBER := fnd_global.conc_request_id();
4426: l_program_id NUMBER := fnd_global.conc_program_id();
4427: l_program_application_id NUMBER := fnd_global.prog_appl_id();
4428: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
4429: l_userid NUMBER := NVL(fnd_global.user_id,-1);
4430: l_return_status Varchar2(1000);
4431:
4432:
4433: BEGIN

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

5110: p_compiled_multiplier IN NUMBER
5111: ) RETURN boolean is
5112: PRAGMA AUTONOMOUS_TRANSACTION;
5113:
5114: l_request_id NUMBER := fnd_global.conc_request_id();
5115: l_program_id NUMBER := fnd_global.conc_program_id();
5116: l_program_application_id NUMBER := fnd_global.prog_appl_id();
5117: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
5118: l_userid NUMBER := NVL(fnd_global.user_id,-1);

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

5111: ) RETURN boolean is
5112: PRAGMA AUTONOMOUS_TRANSACTION;
5113:
5114: l_request_id NUMBER := fnd_global.conc_request_id();
5115: l_program_id NUMBER := fnd_global.conc_program_id();
5116: l_program_application_id NUMBER := fnd_global.prog_appl_id();
5117: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
5118: l_userid NUMBER := NVL(fnd_global.user_id,-1);
5119: -- bug : 3717214

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

5112: PRAGMA AUTONOMOUS_TRANSACTION;
5113:
5114: l_request_id NUMBER := fnd_global.conc_request_id();
5115: l_program_id NUMBER := fnd_global.conc_program_id();
5116: l_program_application_id NUMBER := fnd_global.prog_appl_id();
5117: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
5118: l_userid NUMBER := NVL(fnd_global.user_id,-1);
5119: -- bug : 3717214
5120: -- Declare variables and cursors to determine if existing multipliers should be used

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

5113:
5114: l_request_id NUMBER := fnd_global.conc_request_id();
5115: l_program_id NUMBER := fnd_global.conc_program_id();
5116: l_program_application_id NUMBER := fnd_global.prog_appl_id();
5117: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
5118: l_userid NUMBER := NVL(fnd_global.user_id,-1);
5119: -- bug : 3717214
5120: -- Declare variables and cursors to determine if existing multipliers should be used
5121: --

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

5114: l_request_id NUMBER := fnd_global.conc_request_id();
5115: l_program_id NUMBER := fnd_global.conc_program_id();
5116: l_program_application_id NUMBER := fnd_global.prog_appl_id();
5117: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
5118: l_userid NUMBER := NVL(fnd_global.user_id,-1);
5119: -- bug : 3717214
5120: -- Declare variables and cursors to determine if existing multipliers should be used
5121: --
5122: l_count NUMBER ;

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

6151: l_burden_method VARCHAR2(20) := 'NONE';
6152: l_bc_packet_id NUMBER;
6153: l_parent_bc_packet_id NUMBER;
6154: l_doc_type VARCHAR2(30);
6155: l_request_id NUMBER := fnd_global.conc_request_id();
6156: l_program_id NUMBER := fnd_global.conc_program_id();
6157: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
6158: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
6159: l_num_rows NUMBER := 0;

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

6152: l_bc_packet_id NUMBER;
6153: l_parent_bc_packet_id NUMBER;
6154: l_doc_type VARCHAR2(30);
6155: l_request_id NUMBER := fnd_global.conc_request_id();
6156: l_program_id NUMBER := fnd_global.conc_program_id();
6157: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
6158: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
6159: l_num_rows NUMBER := 0;
6160: l_userid NUMBER := NVL(fnd_global.user_id,-1);

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

6153: l_parent_bc_packet_id NUMBER;
6154: l_doc_type VARCHAR2(30);
6155: l_request_id NUMBER := fnd_global.conc_request_id();
6156: l_program_id NUMBER := fnd_global.conc_program_id();
6157: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
6158: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
6159: l_num_rows NUMBER := 0;
6160: l_userid NUMBER := NVL(fnd_global.user_id,-1);
6161: l_exp_type VARCHAR2(100);

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

6154: l_doc_type VARCHAR2(30);
6155: l_request_id NUMBER := fnd_global.conc_request_id();
6156: l_program_id NUMBER := fnd_global.conc_program_id();
6157: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
6158: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
6159: l_num_rows NUMBER := 0;
6160: l_userid NUMBER := NVL(fnd_global.user_id,-1);
6161: l_exp_type VARCHAR2(100);
6162: l_expenditure_type VARCHAR2(100);

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

6156: l_program_id NUMBER := fnd_global.conc_program_id();
6157: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
6158: l_update_login NUMBER := NVL(FND_GLOBAL.login_id,-1);
6159: l_num_rows NUMBER := 0;
6160: l_userid NUMBER := NVL(fnd_global.user_id,-1);
6161: l_exp_type VARCHAR2(100);
6162: l_expenditure_type VARCHAR2(100);
6163: l_entered_dr NUMBER;
6164: l_entered_cr NUMBER;

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

8688: ,p_reference1 IN varchar2
8689: ,p_reference2 IN varchar2
8690: ,p_mode IN varchar2) IS
8691:
8692: l_request_id NUMBER := fnd_global.conc_request_id();
8693: l_program_id NUMBER := fnd_global.conc_program_id();
8694: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
8695: l_update_login NUMBER := FND_GLOBAL.login_id;
8696: l_num_rows NUMBER := 0;

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

8689: ,p_reference2 IN varchar2
8690: ,p_mode IN varchar2) IS
8691:
8692: l_request_id NUMBER := fnd_global.conc_request_id();
8693: l_program_id NUMBER := fnd_global.conc_program_id();
8694: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
8695: l_update_login NUMBER := FND_GLOBAL.login_id;
8696: l_num_rows NUMBER := 0;
8697: l_return_status VARCHAR2(1);

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

8690: ,p_mode IN varchar2) IS
8691:
8692: l_request_id NUMBER := fnd_global.conc_request_id();
8693: l_program_id NUMBER := fnd_global.conc_program_id();
8694: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
8695: l_update_login NUMBER := FND_GLOBAL.login_id;
8696: l_num_rows NUMBER := 0;
8697: l_return_status VARCHAR2(1);
8698: l_debug_mode VARCHAR2(10);

Line 8695: l_update_login NUMBER := FND_GLOBAL.login_id;

8691:
8692: l_request_id NUMBER := fnd_global.conc_request_id();
8693: l_program_id NUMBER := fnd_global.conc_program_id();
8694: l_program_application_id NUMBER:= fnd_global.prog_appl_id();
8695: l_update_login NUMBER := FND_GLOBAL.login_id;
8696: l_num_rows NUMBER := 0;
8697: l_return_status VARCHAR2(1);
8698: l_debug_mode VARCHAR2(10);
8699: