APPS.GMD_RECIPE_MIGRATION dependencies on CM_CMPT_DTL

Line 170: CURSOR cm_cmpt_dtl_cur (pfmeff_id NUMBER )

166: WHERE item_id = v_item_id
167: AND delete_mark = 0 );
168:
169: /* Get the costing details based on effectivities that have cost rollup done */
170: CURSOR cm_cmpt_dtl_cur (pfmeff_id NUMBER )
171: IS
172: SELECT *
173: FROM cm_cmpt_dtl
174: WHERE fmeff_id = pfmeff_id;

Line 173: FROM cm_cmpt_dtl

169: /* Get the costing details based on effectivities that have cost rollup done */
170: CURSOR cm_cmpt_dtl_cur (pfmeff_id NUMBER )
171: IS
172: SELECT *
173: FROM cm_cmpt_dtl
174: WHERE fmeff_id = pfmeff_id;
175:
176: /* Defining all local variables */
177: l_recipe_id gmd_recipes.recipe_id%TYPE := 0;

Line 822: /* Since table cm_cmpt_dtl could have many fmeff_ids

818: UPDATE gmp_form_eff
819: SET fmeff_id = l_fmeff_id
820: WHERE fmeff_id = update_eff_rec.fmeff_id;
821:
822: /* Since table cm_cmpt_dtl could have many fmeff_ids
823: row to be updated the system might run out of rollback segment
824: space - to prevent this we provide regular interval commits */
825: SELECT NVL ( COUNT (* ), 0 )
826: INTO l_cm_counter

Line 827: FROM cm_cmpt_dtl

823: row to be updated the system might run out of rollback segment
824: space - to prevent this we provide regular interval commits */
825: SELECT NVL ( COUNT (* ), 0 )
826: INTO l_cm_counter
827: FROM cm_cmpt_dtl
828: WHERE fmeff_id = update_eff_rec.fmeff_id;
829:
830: FOR k IN cm_cmpt_dtl_cur ( update_eff_rec.fmeff_id )
831: LOOP

Line 830: FOR k IN cm_cmpt_dtl_cur ( update_eff_rec.fmeff_id )

826: INTO l_cm_counter
827: FROM cm_cmpt_dtl
828: WHERE fmeff_id = update_eff_rec.fmeff_id;
829:
830: FOR k IN cm_cmpt_dtl_cur ( update_eff_rec.fmeff_id )
831: LOOP
832: UPDATE cm_cmpt_dtl
833: SET fmeff_id = l_fmeff_id
834: WHERE fmeff_id = update_eff_rec.fmeff_id

Line 832: UPDATE cm_cmpt_dtl

828: WHERE fmeff_id = update_eff_rec.fmeff_id;
829:
830: FOR k IN cm_cmpt_dtl_cur ( update_eff_rec.fmeff_id )
831: LOOP
832: UPDATE cm_cmpt_dtl
833: SET fmeff_id = l_fmeff_id
834: WHERE fmeff_id = update_eff_rec.fmeff_id
835: AND ROWNUM < 51;
836: COMMIT;

Line 838: IF ( cm_cmpt_dtl_cur%ROWCOUNT > l_cm_counter/50 )

834: WHERE fmeff_id = update_eff_rec.fmeff_id
835: AND ROWNUM < 51;
836: COMMIT;
837: SAVEPOINT recipe_migration;
838: IF ( cm_cmpt_dtl_cur%ROWCOUNT > l_cm_counter/50 )
839: THEN
840: l_cm_counter := 0;
841: EXIT;
842: END IF;

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');