APPS.CSTPSCEX dependencies on CST_SC_ROLLUP_HISTORY

Line 1562: insert into cst_sc_rollup_history

1558:
1559: l_stmt_num := 30;
1560: -- SCAPI: no insert for supply chain cost reports
1561: IF (i_report_option_type <> -1 or i_report_option_type is null) THEN
1562: insert into cst_sc_rollup_history
1563: (
1564: rollup_id,
1565: explosion_level,
1566: report_level,

Line 1612: from cst_sc_rollup_history

1608: from dual
1609: where not exists
1610: (
1611: select 'x'
1612: from cst_sc_rollup_history
1613: where rollup_id = l_rollup_id
1614: );
1615: END IF;
1616:

Line 1661: update cst_sc_rollup_history CSRH

1657: IF o_error_code <> 0 THEN
1658: RETURN;
1659: END IF;
1660:
1661: update cst_sc_rollup_history CSRH
1662: set CSRH.explosion_time = (SYSDATE - l_timestamp) * 86400
1663: where CSRH.rollup_id = l_rollup_id;
1664:
1665:

Line 1724: update cst_sc_rollup_history CSRH

1720: where rollup_id = l_rollup_id;
1721: END IF;
1722:
1723:
1724: update cst_sc_rollup_history CSRH
1725: set CSRH.low_level_code_time = (SYSDATE - l_timestamp) * 86400
1726: where CSRH.rollup_id = l_rollup_id;
1727:
1728:

Line 1755: update cst_sc_rollup_history CSRH

1751: RETURN;
1752: END IF;
1753: END IF;
1754:
1755: update cst_sc_rollup_history CSRH
1756: set CSRH.remove_costs_time = (SYSDATE - l_timestamp) * 86400
1757: where CSRH.rollup_id = l_rollup_id;
1758:
1759:

Line 1805: update cst_sc_rollup_history CSRH

1801: RETURN;
1802: END IF;
1803: END IF;
1804:
1805: update cst_sc_rollup_history CSRH
1806: set CSRH.rollup_time = (SYSDATE - l_timestamp) * 86400
1807: where CSRH.rollup_id = l_rollup_id;
1808:
1809:

Line 1837: update cst_sc_rollup_history CSRH

1833: END IF;
1834:
1835: END IF;
1836:
1837: update cst_sc_rollup_history CSRH
1838: set CSRH.bom_structure_time = (SYSDATE - l_timestamp) * 86400
1839: where CSRH.rollup_id = l_rollup_id;
1840:
1841: l_timestamp := SYSDATE;