APPS.CST_REVENUECOGSMATCH_PVT dependencies on CST_REVENUE_COGS_CONTROL

Line 298: UPDATE cst_revenue_cogs_control

294:
295: Print_MessageStack;
296:
297: -- Update the "Process Upto Date" in the revenue / COGS control table
298: UPDATE cst_revenue_cogs_control
299: SET last_process_upto_date = l_high_date,
300: last_update_date = sysdate,
301: last_updated_by = l_user_id,
302: last_update_login = l_login_id,

Line 307: INSERT INTO cst_revenue_cogs_control (

303: request_id = l_request_id
304: WHERE control_id = 1;
305:
306: IF (SQL%ROWCOUNT = 0) THEN
307: INSERT INTO cst_revenue_cogs_control (
308: CONTROL_ID,
309: LAST_PROCESS_UPTO_DATE,
310: LAST_UPDATE_DATE,
311: LAST_UPDATED_BY,