DBA Data[Home] [Help]

APPS.CN_TRANSACTION_LOAD_PUB dependencies on FND_GLOBAL

Line 9: G_LAST_UPDATED_BY NUMBER := FND_GLOBAL.USER_ID;

5: --+
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_TRANSACTION_LOAD_PUB';
7: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnploadb.pls';
8: G_LAST_UPDATE_DATE DATE := sysdate;
9: G_LAST_UPDATED_BY NUMBER := FND_GLOBAL.USER_ID;
10: G_CREATION_DATE DATE := sysdate;
11: G_CREATED_BY NUMBER := FND_GLOBAL.USER_ID;
12: G_LAST_UPDATE_LOGIN NUMBER := FND_GLOBAL.LOGIN_ID;
13: G_ROWID VARCHAR2(30);

Line 11: G_CREATED_BY NUMBER := FND_GLOBAL.USER_ID;

7: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnploadb.pls';
8: G_LAST_UPDATE_DATE DATE := sysdate;
9: G_LAST_UPDATED_BY NUMBER := FND_GLOBAL.USER_ID;
10: G_CREATION_DATE DATE := sysdate;
11: G_CREATED_BY NUMBER := FND_GLOBAL.USER_ID;
12: G_LAST_UPDATE_LOGIN NUMBER := FND_GLOBAL.LOGIN_ID;
13: G_ROWID VARCHAR2(30);
14: G_PROGRAM_TYPE VARCHAR2(30);
15:

Line 12: G_LAST_UPDATE_LOGIN NUMBER := FND_GLOBAL.LOGIN_ID;

8: G_LAST_UPDATE_DATE DATE := sysdate;
9: G_LAST_UPDATED_BY NUMBER := FND_GLOBAL.USER_ID;
10: G_CREATION_DATE DATE := sysdate;
11: G_CREATED_BY NUMBER := FND_GLOBAL.USER_ID;
12: G_LAST_UPDATE_LOGIN NUMBER := FND_GLOBAL.LOGIN_ID;
13: G_ROWID VARCHAR2(30);
14: G_PROGRAM_TYPE VARCHAR2(30);
15:
16: g_logical_process VARCHAR2(30) := 'LOAD';

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

44: END get_physical_batch_id;
45:
46:
47: PROCEDURE update_error (x_physical_batch_id NUMBER) IS
48: l_user_id NUMBER(15) := fnd_global.user_id;
49: l_resp_id NUMBER(15) := fnd_global.resp_id;
50: l_login_id NUMBER(15) := fnd_global.login_id;
51: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
52: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

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

45:
46:
47: PROCEDURE update_error (x_physical_batch_id NUMBER) IS
48: l_user_id NUMBER(15) := fnd_global.user_id;
49: l_resp_id NUMBER(15) := fnd_global.resp_id;
50: l_login_id NUMBER(15) := fnd_global.login_id;
51: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
52: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
53: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

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

46:
47: PROCEDURE update_error (x_physical_batch_id NUMBER) IS
48: l_user_id NUMBER(15) := fnd_global.user_id;
49: l_resp_id NUMBER(15) := fnd_global.resp_id;
50: l_login_id NUMBER(15) := fnd_global.login_id;
51: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
52: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
53: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
54:

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

47: PROCEDURE update_error (x_physical_batch_id NUMBER) IS
48: l_user_id NUMBER(15) := fnd_global.user_id;
49: l_resp_id NUMBER(15) := fnd_global.resp_id;
50: l_login_id NUMBER(15) := fnd_global.login_id;
51: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
52: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
53: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
54:
55: BEGIN

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

48: l_user_id NUMBER(15) := fnd_global.user_id;
49: l_resp_id NUMBER(15) := fnd_global.resp_id;
50: l_login_id NUMBER(15) := fnd_global.login_id;
51: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
52: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
53: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
54:
55: BEGIN
56: -- Giving the batch an 'ERROR' status prevents subsequent

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

49: l_resp_id NUMBER(15) := fnd_global.resp_id;
50: l_login_id NUMBER(15) := fnd_global.login_id;
51: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
52: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
53: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
54:
55: BEGIN
56: -- Giving the batch an 'ERROR' status prevents subsequent
57: -- physical processes picking it up.

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

1089: l_end_date_tbl l_end_date_tbl_type;
1090: l_count_tbl l_count_tbl_type;
1091:
1092:
1093: l_user_id NUMBER(15) := fnd_global.user_id;
1094: l_resp_id NUMBER(15) := fnd_global.resp_id;
1095: l_login_id NUMBER(15) := fnd_global.login_id;
1096: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
1097: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

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

1090: l_count_tbl l_count_tbl_type;
1091:
1092:
1093: l_user_id NUMBER(15) := fnd_global.user_id;
1094: l_resp_id NUMBER(15) := fnd_global.resp_id;
1095: l_login_id NUMBER(15) := fnd_global.login_id;
1096: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
1097: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
1098: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

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

1091:
1092:
1093: l_user_id NUMBER(15) := fnd_global.user_id;
1094: l_resp_id NUMBER(15) := fnd_global.resp_id;
1095: l_login_id NUMBER(15) := fnd_global.login_id;
1096: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
1097: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
1098: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
1099:

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

1092:
1093: l_user_id NUMBER(15) := fnd_global.user_id;
1094: l_resp_id NUMBER(15) := fnd_global.resp_id;
1095: l_login_id NUMBER(15) := fnd_global.login_id;
1096: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
1097: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
1098: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
1099:
1100: l_logical_batch_id NUMBER;

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

1093: l_user_id NUMBER(15) := fnd_global.user_id;
1094: l_resp_id NUMBER(15) := fnd_global.resp_id;
1095: l_login_id NUMBER(15) := fnd_global.login_id;
1096: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
1097: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
1098: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
1099:
1100: l_logical_batch_id NUMBER;
1101: l_process_batch_id NUMBER;

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

1094: l_resp_id NUMBER(15) := fnd_global.resp_id;
1095: l_login_id NUMBER(15) := fnd_global.login_id;
1096: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
1097: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
1098: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
1099:
1100: l_logical_batch_id NUMBER;
1101: l_process_batch_id NUMBER;
1102: