APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on CST_PERIOD_CLOSE_SUMMARY

Line 1625: FROM cst_period_close_summary

1621: AND acct_period_id = p_period_id
1622: AND summarized_flag = 'N'
1623: AND EXISTS
1624: (SELECT 'Data exists in CPCS'
1625: FROM cst_period_close_summary
1626: WHERE organization_id = p_org_id
1627: AND acct_period_id = p_period_id);
1628:
1629: IF (l_resummarize > 0) THEN

Line 1643: DELETE cst_period_close_summary

1639: END IF;
1640:
1641: l_stmt_num := 35;
1642:
1643: DELETE cst_period_close_summary
1644: WHERE organization_id = p_org_id
1645: AND acct_period_id >= p_period_id;
1646:
1647: /* Updating org_acct_periods in case the customer has not updated summarized_flag

Line 1669: FROM cst_period_close_summary

1665:
1666: --check if CPCS is empty
1667: SELECT count(*)
1668: INTO l_cpcs_count
1669: FROM cst_period_close_summary
1670: WHERE organization_id = p_org_id
1671: AND rownum = 1;
1672:
1673: l_stmt_num := 45;

Line 1894: cst_period_close_summary CPCS

1890: CPCS.subinventory_code,
1891: CPCS.inventory_item_id,
1892: CPCS.rollback_onhand_value
1893: FROM
1894: cst_period_close_summary CPCS
1895: WHERE CPCS.organization_id = p_org_id
1896: AND CPCS.acct_period_id = NVL(l_prior_period_id,-1)
1897:
1898: UNION ALL

Line 1908: cst_period_close_summary CPCS

1904: CPCS.subinventory_code,
1905: CPCS.inventory_item_id,
1906: CPCS.rollback_intransit_value
1907: FROM
1908: cst_period_close_summary CPCS
1909: WHERE CPCS.organization_id = p_org_id
1910: AND CPCS.acct_period_id = NVL(l_prior_period_id,-1)
1911:
1912: UNION ALL

Line 1922: cst_period_close_summary CPCS

1918: CPCS.subinventory_code,
1919: CPCS.inventory_item_id,
1920: CPCS.cumulative_onhand_mta
1921: FROM
1922: cst_period_close_summary CPCS
1923: WHERE CPCS.organization_id = p_org_id
1924: AND CPCS.acct_period_id = NVL(l_prior_period_id,-1)
1925:
1926: UNION ALL

Line 1936: cst_period_close_summary CPCS

1932: CPCS.subinventory_code,
1933: CPCS.inventory_item_id,
1934: CPCS.cumulative_intransit_mta
1935: FROM
1936: cst_period_close_summary CPCS
1937: WHERE CPCS.organization_id = p_org_id
1938: AND CPCS.acct_period_id = NVL(l_prior_period_id,-1);
1939:
1940: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

Line 2224: INTO cst_period_close_summary(

2220: l_stmt_num := 120;
2221: x_return_status := '2';
2222: --period closed -> CPCS
2223: INSERT
2224: INTO cst_period_close_summary(
2225: acct_period_id,
2226: organization_id,
2227: cost_group_id,
2228: subinventory_code,