APPS.AMW_LOAD_RC_DATA dependencies on AMW_RISK_CTRL_INTERFACE

Line 7: /* Reads the amw_risk-ctrl_interface table */

3: /*****************************************************************************/
4: /*****************************************************************************/
5: /*****************************************************************************/
6: /* Major Functionality of the followIng procedure includes: */
7: /* Reads the amw_risk-ctrl_interface table */
8: /* following tables: */
9: /* INSERTS OR UPDATES ARE DONE AGAINIST THE FOLLOWING TABLES */
10: /* Insert into AMW_RISKS_B and AMW_RISKS_TL */
11: /* Insert into AMW_CONTROLS_B and AMW_CONTROLS_TL */

Line 16: /* Updates amw_risk-ctrl_interface, with error messages */

12: /* Insert into AMW_CONTROL_ASSOCIATIONS */
13: /* Insert into AMW_RISK_ASSOCIATIONS */
14: /* Insert into AMW_CONTROL_OBJECTIVES */
15: /* Insert into AMW_CONTROL_ASSERTIONS */
16: /* Updates amw_risk-ctrl_interface, with error messages */
17: /* Deleting successful production inserts, based on profile */
18: /* */
19: /*****************************************************************************/
20: --

Line 297: FROM amw_risk_ctrl_interface

293: --for Risk/Ctrl Classification
294: ,risk_classification
295: ,ctrl_classification
296: ,uom_code
297: FROM amw_risk_ctrl_interface
298: WHERE created_by = DECODE (p_user_id, NULL, created_by, p_user_id)
299: AND batch_id = DECODE (p_batch_id, NULL, batch_id, p_batch_id)
300: AND process_flag IS NULL
301: AND error_flag IS NULL;

Line 336: FROM AMW_RISK_CTRL_INTERFACE

332: SELECT PROCESS_ID
333: ,PROCESS_NAME
334: ,PROCESS_CODE
335: ,risk_control_interface_id
336: FROM AMW_RISK_CTRL_INTERFACE
337: WHERE CREATED_BY=DECODE(P_USER_ID,NULL,CREATED_BY,P_USER_ID)
338: AND BATCH_ID=DECODE(p_batch_id, NULL, batch_id, p_batch_id)
339: AND process_flag IS NULL
340: AND error_flag IS NULL

Line 1705: UPDATE amw_risk_ctrl_interface

1701:
1702:
1703: IF UPPER (l_amw_delt_risk_cntl_intf) <> 'Y' THEN
1704: BEGIN
1705: UPDATE amw_risk_ctrl_interface
1706: SET process_flag = l_process_flag
1707: ,last_update_date = SYSDATE
1708: ,last_updated_by = v_user_id
1709: WHERE batch_id = p_batch_id;

Line 1718: DELETE FROM amw_risk_ctrl_interface

1714: END;
1715: ELSE
1716: IF NOT v_error_found THEN
1717: BEGIN
1718: DELETE FROM amw_risk_ctrl_interface
1719: WHERE batch_id = p_batch_id;
1720:
1721: EXCEPTION
1722: WHEN OTHERS THEN

Line 1740: UPDATE amw_risk_ctrl_interface

1736: BEGIN
1737: IF v_invalid_risk_type is null THEN
1738: v_invalid_risk_type := FND_MESSAGE.GET_STRING('AMW', 'AMW_INVALID_RISK_TYPE');
1739: END IF;
1740: UPDATE amw_risk_ctrl_interface
1741: SET error_flag = 'Y'
1742: ,interface_status = v_invalid_risk_type
1743: WHERE batch_id = p_batch_id;
1744: EXCEPTION

Line 1759: UPDATE amw_risk_ctrl_interface

1755: BEGIN
1756: IF v_invalid_requestor_msg is null THEN
1757: v_invalid_requestor_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_UNKNOWN_EMPLOYEE');
1758: END IF;
1759: UPDATE amw_risk_ctrl_interface
1760: SET error_flag = 'Y'
1761: ,interface_status = v_invalid_requestor_msg
1762: WHERE batch_id = p_batch_id;
1763: EXCEPTION

Line 1776: UPDATE amw_risk_ctrl_interface

1772: BEGIN
1773: IF v_no_import_privilege_msg is null THEN
1774: v_no_import_privilege_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_NO_IMPORT_ACCESS');
1775: END IF;
1776: UPDATE amw_risk_ctrl_interface
1777: SET error_flag = 'Y'
1778: ,interface_status = v_no_import_privilege_msg
1779: WHERE batch_id = p_batch_id;
1780: EXCEPTION

Line 2391: l_interface_status amw_risk_ctrl_interface.interface_status%TYPE;

2387: ,p_table_name IN VARCHAR2
2388: ,p_interface_id IN NUMBER
2389: )
2390: IS
2391: l_interface_status amw_risk_ctrl_interface.interface_status%TYPE;
2392: BEGIN
2393: ROLLBACK; -- rollback any inserts done during the current loop process
2394: v_error_found := TRUE;
2395:

Line 2399: FROM amw_risk_ctrl_interface

2395:
2396: BEGIN
2397: SELECT interface_status
2398: INTO l_interface_status
2399: FROM amw_risk_ctrl_interface
2400: WHERE risk_control_interface_id = p_interface_id;
2401: EXCEPTION
2402: WHEN OTHERS
2403: THEN

Line 2413: UPDATE amw_risk_ctrl_interface

2409: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
2410: END;
2411:
2412: BEGIN
2413: UPDATE amw_risk_ctrl_interface
2414: SET interface_status =
2415: l_interface_status
2416: -- || 'Error Msg: '
2417: || p_err_msg