APPS.EGO_CHANGE_PEOPLE_IMPORT_PKG dependencies on MTL_INTERFACE_ERRORS

Line 1089: -- Errors are populated in MTL_INTERFACE_ERRORS

1085: -- API name : Load Interfance Lines
1086: -- TYPE : Public (called by SQL Loader)
1087: -- Pre-reqs : None
1088: -- FUNCTION : Process and Load interfance lines into FND_GRANTS.
1089: -- Errors are populated in MTL_INTERFACE_ERRORS
1090: BEGIN
1091: IF G_CURR_DATASET_ID = -1 THEN
1092: SELECT ENG_CPI_DATASET_ID_S.NEXTVAL
1093: INTO G_CURR_DATASET_ID

Line 1119: -- Errors are populated in MTL_INTERFACE_ERRORS

1115: -- API name : Load Interfance Lines
1116: -- TYPE : Public (called by Concurrent Program)
1117: -- Pre-reqs : None
1118: -- FUNCTION : Process and Load interfance lines into FND_GRANTS.
1119: -- Errors are populated in MTL_INTERFACE_ERRORS
1120:
1121:
1122: --Currently, assume that the user who submits the 'Change People Import'
1123: --is always Internal user. So, can join with PER_ALL_PEOPLE_F to figure

Line 2082: DELETE mtl_interface_errors

2078: IF p_delete_line_type = DELETE_ALL THEN
2079: --
2080: -- delete all lines
2081: --
2082: DELETE mtl_interface_errors
2083: WHERE table_name = G_ERROR_TABLE_NAME
2084: AND transaction_id IN
2085: ( SELECT transaction_id
2086: FROM eng_change_people_intf

Line 2097: DELETE mtl_interface_errors

2093: ELSIF p_delete_line_type = DELETE_ERROR THEN
2094: --
2095: -- delete all error lines
2096: --
2097: DELETE mtl_interface_errors
2098: WHERE table_name = G_ERROR_TABLE_NAME
2099: AND transaction_id IN
2100: ( SELECT transaction_id
2101: FROM eng_change_people_intf