APPS.OKS_IMPORT_CONTRACTS dependencies on OKS_HEADERS_INTERFACE

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

47: IS
48: l_stmt_num NUMBER := 0;
49: l_routine CONSTANT VARCHAR2(30) := 'clear_ad_cache';
50: l_product varchar2(30) := 'OKS';
51: l_table_name varchar2(30) := 'OKS_HEADERS_INTERFACE';
52: l_update_name varchar2(30);
53: l_status varchar2(30);
54: l_industry varchar2(30);
55: l_retstatus boolean;

Line 136: -- Manager processing for OKS_HEADERS_INTERFACE table

132: l_report_req_id NUMBER;
133: l_message VARCHAR2(2000);
134: BEGIN
135: --
136: -- Manager processing for OKS_HEADERS_INTERFACE table
137: --
138: IF G_PROCEDURE_LOG THEN
139: fnd_log.string(fnd_log.level_procedure,
140: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,

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

145: 'P_commit_size = ' || P_commit_size );
146: END IF;
147:
148: l_stmt_num := 10;
149: SELECT count(1) INTO l_row_count FROM OKS_HEADERS_INTERFACE
150: WHERE BATCH_ID = P_batch_id
151: AND (INTERFACE_STATUS IS NULL OR INTERFACE_STATUS = 'R')
152: AND rownum = 1;
153: