APPS.CSTPSCEX dependencies on CST_SC_ROLLUP_HISTORY

Line 1519: insert into cst_sc_rollup_history

1515:
1516: l_stmt_num := 30;
1517: -- SCAPI: no insert for supply chain cost reports
1518: IF (i_report_option_type <> -1 or i_report_option_type is null) THEN
1519: insert into cst_sc_rollup_history
1520: (
1521: rollup_id,
1522: explosion_level,
1523: report_level,

Line 1569: from cst_sc_rollup_history

1565: from dual
1566: where not exists
1567: (
1568: select 'x'
1569: from cst_sc_rollup_history
1570: where rollup_id = l_rollup_id
1571: );
1572: END IF;
1573:

Line 1618: update cst_sc_rollup_history CSRH

1614: IF o_error_code <> 0 THEN
1615: RETURN;
1616: END IF;
1617:
1618: update cst_sc_rollup_history CSRH
1619: set CSRH.explosion_time = (SYSDATE - l_timestamp) * 86400
1620: where CSRH.rollup_id = l_rollup_id;
1621:
1622:

Line 1669: update cst_sc_rollup_history CSRH

1665: where rollup_id = l_rollup_id;
1666: END IF;
1667:
1668:
1669: update cst_sc_rollup_history CSRH
1670: set CSRH.low_level_code_time = (SYSDATE - l_timestamp) * 86400
1671: where CSRH.rollup_id = l_rollup_id;
1672:
1673:

Line 1700: update cst_sc_rollup_history CSRH

1696: RETURN;
1697: END IF;
1698: END IF;
1699:
1700: update cst_sc_rollup_history CSRH
1701: set CSRH.remove_costs_time = (SYSDATE - l_timestamp) * 86400
1702: where CSRH.rollup_id = l_rollup_id;
1703:
1704:

Line 1750: update cst_sc_rollup_history CSRH

1746: RETURN;
1747: END IF;
1748: END IF;
1749:
1750: update cst_sc_rollup_history CSRH
1751: set CSRH.rollup_time = (SYSDATE - l_timestamp) * 86400
1752: where CSRH.rollup_id = l_rollup_id;
1753:
1754:

Line 1782: update cst_sc_rollup_history CSRH

1778: END IF;
1779:
1780: END IF;
1781:
1782: update cst_sc_rollup_history CSRH
1783: set CSRH.bom_structure_time = (SYSDATE - l_timestamp) * 86400
1784: where CSRH.rollup_id = l_rollup_id;
1785:
1786: l_timestamp := SYSDATE;