APPS.OKS_IMPORT_CONTRACTS_WORKER dependencies on OKS_INT_ERROR_STG_TEMP

Line 62: SET hst.INTERFACE_STATUS = (CASE WHEN EXISTS (SELECT 'X' FROM OKS_INT_ERROR_STG_TEMP

58:
59: l_stmt_num := 10;
60:
61: UPDATE OKS_INT_HEADER_STG_TEMP hst
62: SET hst.INTERFACE_STATUS = (CASE WHEN EXISTS (SELECT 'X' FROM OKS_INT_ERROR_STG_TEMP
63: WHERE hst.HEADER_INTERFACE_ROWID = HEADER_INTERFACE_ROWID)
64: THEN 'E'
65: ELSE 'S'
66: END);

Line 131: FROM OKS_INT_ERROR_STG_TEMP OIES, OKS_HEADERS_INTERFACE OHI

127: OIES.INTERFACE_SOURCE_TABLE,
128: OHI.HEADER_INTERFACE_ID,
129: OIES.INTERFACE_ID,
130: OIES.ERROR_MSG
131: FROM OKS_INT_ERROR_STG_TEMP OIES, OKS_HEADERS_INTERFACE OHI
132: WHERE OIES.HEADER_INTERFACE_ROWID = OHI.ROWID;
133:
134: l_stmt_num := 20;
135:

Line 137: SET ohi.INTERFACE_STATUS = (CASE WHEN EXISTS (SELECT 'X' FROM OKS_INT_ERROR_STG_TEMP WHERE ohi.ROWID = HEADER_INTERFACE_ROWID)

133:
134: l_stmt_num := 20;
135:
136: UPDATE OKS_HEADERS_INTERFACE ohi
137: SET ohi.INTERFACE_STATUS = (CASE WHEN EXISTS (SELECT 'X' FROM OKS_INT_ERROR_STG_TEMP WHERE ohi.ROWID = HEADER_INTERFACE_ROWID)
138: THEN 'E'
139: WHEN P_mode = 'I' THEN 'S'
140: ELSE NULL
141: END),

Line 305: FROM OKS_INT_ERROR_STG_TEMP) INVALID_Q;

301: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_SALES_CREDITS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) SALES_CREDITS_INVALID,
302: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_NOTES_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) NOTES_INVALID
303: FROM (SELECT distinct INTERFACE_SOURCE_TABLE,
304: count(distinct INTERFACE_ID) over (partition by INTERFACE_SOURCE_TABLE) INVALID_COUNT
305: FROM OKS_INT_ERROR_STG_TEMP) INVALID_Q;
306:
307: IF G_PROCEDURE_LOG THEN
308: fnd_log.string(fnd_log.level_procedure,
309: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,

Line 354: DELETE FROM OKS_INT_ERROR_STG_TEMP;

350: DELETE FROM OKS_COVERED_SITE_STG_TEMP;
351: DELETE FROM OKS_COVERED_SYSTEM_STG_TEMP;
352: DELETE FROM OKS_INT_COVERED_LEVEL_STG_TEMP;
353: DELETE FROM OKS_INT_USAGE_COUNTER_STG_TEMP;
354: DELETE FROM OKS_INT_ERROR_STG_TEMP;
355: DELETE FROM OKS_INT_SALES_CREDIT_STG_TEMP;
356:
357: IF G_PROCEDURE_LOG THEN
358: fnd_log.string(fnd_log.level_procedure,