DBA Data[Home] [Help]

APPS.GMF_COPY_ITEM_COST dependencies on CM_SCST_LED

Line 948: * in cm_cmpt_dtl nor delete them from cm_scst_led/cm_acst_led.

944: * Try update of cm_cmpt_dtl first
945: * Update can fail for two reasons: either the row is not there
946: * or, the row exists but is frozen (rollover_ind = 1)
947: * If the costs are frozen in the target period then do not update the rows
948: * in cm_cmpt_dtl nor delete them from cm_scst_led/cm_acst_led.
949: * The item cost rows should be left untouched in the target period even if
950: * one of the components is frozen.
951: */
952:

Line 1159: cm_scst_led

1155: * Update cmpt_dtl
1156: */
1157:
1158: DELETE FROM
1159: cm_scst_led
1160: WHERE
1161: cmpntcost_id = l_updins_cc_id
1162: ;
1163:

Line 1499: * Deletes the child rows from cm_scst_led, cm_acst_led and sets

1495: * PROCEDURE
1496: * delete_item_costs
1497: *
1498: * DESCRIPTION
1499: * Deletes the child rows from cm_scst_led, cm_acst_led and sets
1500: * cmpntcost_id to null in cm_brdn_dtl for the cost parameters passed
1501: * NOTE: We do not have to worry about rollover_ind here since this procedure
1502: * is not even called if the item is frozen in the target period.
1503: *

Line 1562: cm_scst_led

1558: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from acst_led', 3 );
1559:
1560: -- Delete rows from scst_led
1561: DELETE FROM
1562: cm_scst_led
1563: WHERE
1564: cmpntcost_id = r_cc_id.cmpntcost_id
1565: ;
1566: