APPS.OKS_IMPORT_CONTRACTS_WORKER dependencies on OKS_HEADERS_INTERFACE

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 136: UPDATE OKS_HEADERS_INTERFACE ohi

132: WHERE OIES.HEADER_INTERFACE_ROWID = OHI.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

Line 297: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_HEADERS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) HEADERS_INVALID,

293: SELECT P_batch_id BATCH_ID,
294: P_parent_request_id PARENT_REQUEST_ID,
295: G_WORKER_REQ_ID REQUEST_ID,
296: 2 STATISTIC_TYPE_ID,
297: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_HEADERS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) HEADERS_INVALID,
298: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_LINES_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) LINES_INVALID,
299: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_COVERED_LEVELS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) COVERED_LEVELS_INVALID,
300: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_USAGE_COUNTERS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) USAGE_COUNTERS_INVALID,
301: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_SALES_CREDITS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) SALES_CREDITS_INVALID,

Line 398: l_table_name varchar2(30) := 'OKS_HEADERS_INTERFACE';

394: IS
395: l_stmt_num NUMBER := 0;
396: l_routine CONSTANT VARCHAR2(30) := 'Worker_process';
397: l_product varchar2(30) := 'OKS';
398: l_table_name varchar2(30) := 'OKS_HEADERS_INTERFACE';
399: l_update_name varchar2(30);
400: l_status varchar2(30);
401: l_industry varchar2(30);
402: l_retstatus boolean;

Line 413: -- Worker processing for OKS_HEADERS_INTERFACE table

409: l_msg_count NUMBER;
410: l_row_count NUMBER := 0;
411: BEGIN
412: --
413: -- Worker processing for OKS_HEADERS_INTERFACE table
414: --
415: IF G_PROCEDURE_LOG THEN
416: fnd_log.string(fnd_log.level_procedure,
417: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,

Line 474: SELECT count(1) INTO l_row_count FROM OKS_HEADERS_INTERFACE

470:
471: WHILE (l_any_rows_to_process = TRUE)
472: LOOP
473: l_stmt_num := 40;
474: SELECT count(1) INTO l_row_count FROM OKS_HEADERS_INTERFACE
475: WHERE ROWID BETWEEN l_start_rowid AND l_end_rowid
476: AND BATCH_ID = P_batch_id
477: AND (INTERFACE_STATUS IS NULL OR INTERFACE_STATUS = 'R')
478: AND rownum = 1;