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.
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 (
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:
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,
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',
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,
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,
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,
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',
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,
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,
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',