DBA Data[Home] [Help]

APPS.AMW_ASSOC_POST_TXN dependencies on FND_GLOBAL

Line 6: g_user_id NUMBER := fnd_global.user_id;

2: /* $Header: amwpastb.pls 115.1 2004/02/10 03:48:15 abedajna noship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'AMW_ASSOC_POST_TXN';
5: g_file_name CONSTANT VARCHAR2 (12) := 'amwpastb.pls';
6: g_user_id NUMBER := fnd_global.user_id;
7: g_login_id NUMBER := fnd_global.conc_login_id;
8:
9: -- for RISK_ORG and CONTROL_ORG, pass at least p_process_organization_id.
10: -- for library contexts, you do not need to pass anything.

Line 7: g_login_id NUMBER := fnd_global.conc_login_id;

3:
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'AMW_ASSOC_POST_TXN';
5: g_file_name CONSTANT VARCHAR2 (12) := 'amwpastb.pls';
6: g_user_id NUMBER := fnd_global.user_id;
7: g_login_id NUMBER := fnd_global.conc_login_id;
8:
9: -- for RISK_ORG and CONTROL_ORG, pass at least p_process_organization_id.
10: -- for library contexts, you do not need to pass anything.
11: PROCEDURE assoc_post_txn (

Line 69: IF fnd_global.user_id IS NULL THEN

65: amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');
66: -- Initialize API return status to SUCCESS
67: x_return_status := fnd_api.g_ret_sts_success;
68:
69: IF fnd_global.user_id IS NULL THEN
70: amw_utility_pvt.error_message(p_message_name => 'USER_PROFILE_MISSING');
71: RAISE fnd_api.g_exc_error;
72: END IF;
73:

Line 119: FND_GLOBAL.USER_ID,

115: EFFECTIVE_DATE_TO )
116: ( select
117: amw_control_associations_s.nextval,
118: sysdate,
119: FND_GLOBAL.USER_ID,
120: sysdate,
121: FND_GLOBAL.USER_ID,
122: FND_GLOBAL.CONC_LOGIN_ID,
123: control_id,

Line 121: FND_GLOBAL.USER_ID,

117: amw_control_associations_s.nextval,
118: sysdate,
119: FND_GLOBAL.USER_ID,
120: sysdate,
121: FND_GLOBAL.USER_ID,
122: FND_GLOBAL.CONC_LOGIN_ID,
123: control_id,
124: l_risk_assoc_id,
125: 'RISK_ORG',

Line 122: FND_GLOBAL.CONC_LOGIN_ID,

118: sysdate,
119: FND_GLOBAL.USER_ID,
120: sysdate,
121: FND_GLOBAL.USER_ID,
122: FND_GLOBAL.CONC_LOGIN_ID,
123: control_id,
124: l_risk_assoc_id,
125: 'RISK_ORG',
126: ATTRIBUTE_CATEGORY,

Line 186: FND_GLOBAL.USER_ID,

182: OP_EFFECTIVENESS )
183: ( select
184: amw_ap_associations_s.nextval,
185: sysdate,
186: FND_GLOBAL.USER_ID,
187: sysdate,
188: FND_GLOBAL.USER_ID,
189: FND_GLOBAL.CONC_LOGIN_ID,
190: l_org_id,

Line 188: FND_GLOBAL.USER_ID,

184: amw_ap_associations_s.nextval,
185: sysdate,
186: FND_GLOBAL.USER_ID,
187: sysdate,
188: FND_GLOBAL.USER_ID,
189: FND_GLOBAL.CONC_LOGIN_ID,
190: l_org_id,
191: l_process_id2,
192: pk1,

Line 189: FND_GLOBAL.CONC_LOGIN_ID,

185: sysdate,
186: FND_GLOBAL.USER_ID,
187: sysdate,
188: FND_GLOBAL.USER_ID,
189: FND_GLOBAL.CONC_LOGIN_ID,
190: l_org_id,
191: l_process_id2,
192: pk1,
193: 'CTRL_ORG',

Line 259: FND_GLOBAL.USER_ID,

255: OP_EFFECTIVENESS )
256: ( select
257: amw_ap_associations_s.nextval,
258: sysdate,
259: FND_GLOBAL.USER_ID,
260: sysdate,
261: FND_GLOBAL.USER_ID,
262: FND_GLOBAL.CONC_LOGIN_ID,
263: l_org_id,

Line 261: FND_GLOBAL.USER_ID,

257: amw_ap_associations_s.nextval,
258: sysdate,
259: FND_GLOBAL.USER_ID,
260: sysdate,
261: FND_GLOBAL.USER_ID,
262: FND_GLOBAL.CONC_LOGIN_ID,
263: l_org_id,
264: l_process_id2,
265: p_control_id,

Line 262: FND_GLOBAL.CONC_LOGIN_ID,

258: sysdate,
259: FND_GLOBAL.USER_ID,
260: sysdate,
261: FND_GLOBAL.USER_ID,
262: FND_GLOBAL.CONC_LOGIN_ID,
263: l_org_id,
264: l_process_id2,
265: p_control_id,
266: 'CTRL_ORG',