DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_PVT dependencies on CST_REVENUE_COGS_CONTROL

Line 370: UPDATE cst_revenue_cogs_control

366: l_control_id := p_ledger_id;
367: END IF;
368:
369: -- Update the "Process Upto Date" in the revenue / COGS control table
370: UPDATE cst_revenue_cogs_control
371: SET last_process_upto_date = l_high_date,
372: last_update_date = sysdate,
373: last_updated_by = l_user_id,
374: last_update_login = l_login_id,

Line 380: INSERT INTO cst_revenue_cogs_control (

376: WHERE control_id = l_control_id;
377:
378:
379: IF (SQL%ROWCOUNT = 0) THEN
380: INSERT INTO cst_revenue_cogs_control (
381: CONTROL_ID,
382: LAST_PROCESS_UPTO_DATE,
383: LAST_UPDATE_DATE,
384: LAST_UPDATED_BY,