APPS.AMW_LOAD_RCM_ORG_DATA dependencies on AMW_RCM_ORG_INTERFACE

Line 300: FROM amw_rcm_org_interface

296: --npanandi 12.12.2004: added below for classification
297: ,risk_classification
298: ,ctrl_classification
299: ,uom_code
300: FROM amw_rcm_org_interface
301: WHERE created_by = DECODE (p_user_id, NULL, created_by, p_user_id)
302: AND batch_id = DECODE (p_batch_id, NULL, batch_id, p_batch_id)
303: AND process_flag IS NULL
304: AND error_flag IS NULL;

Line 312: FROM AMW_RCM_ORG_INTERFACE

308: ,PROCESS_ID
309: ,PROCESS_NAME
310: ,PROCESS_CODE
311: ,rcm_org_interface_id
312: FROM AMW_RCM_ORG_INTERFACE
313: WHERE CREATED_BY=DECODE(P_USER_ID,NULL,CREATED_BY,P_USER_ID)
314: AND BATCH_ID=DECODE(p_batch_id, NULL, batch_id, p_batch_id)
315: AND process_flag IS NULL
316: AND error_flag IS NULL

Line 1836: UPDATE amw_rcm_org_interface

1832: END IF;
1833:
1834: IF UPPER (l_amw_delt_rcm_org_intf) <> 'Y' THEN
1835: BEGIN
1836: UPDATE amw_rcm_org_interface
1837: SET process_flag = l_process_flag
1838: ,last_update_date = SYSDATE
1839: ,last_updated_by = v_user_id
1840: WHERE batch_id = p_batch_id;

Line 1848: DELETE FROM amw_rcm_org_interface WHERE batch_id = p_batch_id;

1844: END;
1845: ELSE
1846: IF NOT v_error_found THEN
1847: BEGIN
1848: DELETE FROM amw_rcm_org_interface WHERE batch_id = p_batch_id;
1849:
1850: EXCEPTION
1851: WHEN OTHERS THEN
1852: fnd_file.put_line (fnd_file.LOG,'err in delete interface records: '||SUBSTR (SQLERRM, 1, 200));

Line 1866: UPDATE amw_rcm_org_interface

1862: BEGIN
1863: IF v_invalid_risk_type is null THEN
1864: v_invalid_risk_type := FND_MESSAGE.GET_STRING('AMW', 'AMW_INVALID_RISK_TYPE');
1865: END IF;
1866: UPDATE amw_rcm_org_interface
1867: SET error_flag = 'Y'
1868: ,interface_status = v_invalid_risk_type
1869: WHERE batch_id = p_batch_id;
1870: EXCEPTION

Line 1882: UPDATE amw_rcm_org_interface

1878: BEGIN
1879: IF v_invalid_requestor_msg is null THEN
1880: v_invalid_requestor_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_UNKNOWN_EMPLOYEE');
1881: END IF;
1882: UPDATE amw_rcm_org_interface
1883: SET error_flag = 'Y'
1884: ,interface_status = v_invalid_requestor_msg
1885: WHERE batch_id = p_batch_id;
1886: EXCEPTION

Line 1897: UPDATE amw_rcm_org_interface

1893: BEGIN
1894: IF v_no_import_privilege_msg is null THEN
1895: v_no_import_privilege_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_NO_IMPORT_ACCESS');
1896: END IF;
1897: UPDATE amw_rcm_org_interface
1898: SET error_flag = 'Y'
1899: ,interface_status = v_no_import_privilege_msg
1900: WHERE batch_id = p_batch_id;
1901: EXCEPTION

Line 2521: l_interface_status amw_rcm_org_interface.interface_status%TYPE;

2517: p_err_msg IN VARCHAR2
2518: ,p_table_name IN VARCHAR2
2519: ,p_interface_id IN NUMBER)
2520: IS
2521: l_interface_status amw_rcm_org_interface.interface_status%TYPE;
2522: BEGIN
2523: ROLLBACK; -- rollback any inserts done during the current loop process
2524: v_error_found := TRUE;
2525:

Line 2531: FROM amw_rcm_org_interface

2527:
2528: BEGIN
2529: SELECT interface_status
2530: INTO l_interface_status
2531: FROM amw_rcm_org_interface
2532: WHERE rcm_org_interface_id = p_interface_id;
2533: EXCEPTION
2534: WHEN OTHERS THEN
2535: v_err_msg :='interface_id: = '|| p_interface_id|| ' '|| SUBSTR (SQLERRM, 1, 100);

Line 2540: UPDATE amw_rcm_org_interface

2536: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
2537: END;
2538:
2539: BEGIN
2540: UPDATE amw_rcm_org_interface
2541: SET interface_status =l_interface_status|| p_err_msg|| '**'
2542: ,error_flag = 'Y'
2543: WHERE rcm_org_interface_id = p_interface_id;
2544: