APPS.OKS_IMPORT_PURGE dependencies on OKS_HEADERS_INTERFACE

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

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

Line 129: -- Manager processing for OKS_HEADERS_INTERFACE table

125: l_msg_count NUMBER;
126: l_row_count NUMBER := 0;
127: BEGIN
128: --
129: -- Manager processing for OKS_HEADERS_INTERFACE table
130: --
131: IF G_PROCEDURE_LOG THEN
132: fnd_log.string(fnd_log.level_procedure,
133: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,

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

138: END IF;
139:
140: l_stmt_num := 10;
141:
142: SELECT count(1) INTO l_row_count FROM OKS_HEADERS_INTERFACE
143: WHERE BATCH_ID = P_batch_id
144: AND INTERFACE_STATUS = 'S'
145: AND rownum = 1;
146: