DBA Data[Home] [Help]

APPS.GMF_COPY_ITEM_COST dependencies on CM_ACST_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 1167: cm_acst_led

1163:
1164: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from scst_led ', 1 );
1165:
1166: DELETE FROM
1167: cm_acst_led
1168: WHERE
1169: cmpntcost_id = l_updins_cc_id
1170: ;
1171:

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 1553: cm_acst_led

1549: ) LOOP
1550:
1551: -- Delete rows from acst_led
1552: DELETE FROM
1553: cm_acst_led
1554: WHERE
1555: cmpntcost_id = r_cc_id.cmpntcost_id
1556: ;
1557: