APPS.GMD_RECIPE_MIGRATION dependencies on PM_BTCH_HDR

Line 810: UPDATE pm_btch_hdr

806: from the VR table so we skip the 1st row that returns 101*/
807: /* Thomas - Bug 2562007, Changed the l_dup_counter from > 1 to > 0 */
808: IF (l_dup_counter > 0) THEN
809: BEGIN
810: UPDATE pm_btch_hdr
811: SET fmeff_id = l_fmeff_id
812: WHERE fmeff_id = update_eff_rec.fmeff_id;
813:
814: UPDATE gl_item_cst

Line 869: ,p_target_table => 'PM_BTCH_HDR - CM_CMPT_DTL - GL_ITEM_CST - GMP_FORM_EFF'

865: WHEN OTHERS
866: THEN
867: error_msg := SQLERRM;
868: insert_message (p_source_table => 'GMD_RECIPE_EFF_ASSOC'
869: ,p_target_table => 'PM_BTCH_HDR - CM_CMPT_DTL - GL_ITEM_CST - GMP_FORM_EFF'
870: ,p_source_id => l_fmeff_id
871: ,p_target_id => update_eff_rec.fmeff_id
872: ,p_message => error_msg
873: ,p_error_type => 'U');