APPS.GMDFMVAL_PUB dependencies on CM_CMPT_DTL

Line 573: /* cm_cmpt_dtl table is zero or does not exist, */

569: /* determining if a cost rollup has been done. */
570: /* If it has, returning a 900 denotes that */
571: /* effectivity is not subject to change and is locked */
572: /* down. Otherwise if the rollover indicator in the */
573: /* cm_cmpt_dtl table is zero or does not exist, */
574: /* allow modification to the effectivity. */
575:
576: /* SYNOPSIS: */
577: /* iret := GMD_EFFECTIVITY_LOCKED_STATUS(pfmeff_id); */

Line 591: WHERE EXISTS (SELECT 1 FROM cm_cmpt_dtl

587: iret NUMBER;
588:
589: CURSOR locked_val_cur(pfmeff_id NUMBER) IS
590: SELECT 1 FROM sys.dual
591: WHERE EXISTS (SELECT 1 FROM cm_cmpt_dtl
592: WHERE fmeff_id = pfmeff_id
593: AND rollover_ind = 1) ;
594: BEGIN
595: OPEN locked_val_cur(pfmeff_id);

Line 620: /* cm_cmpt_dtl table is zero or does not exist, */

616: /* determining if a cost rollup has been done. */
617: /* If it has, returning a -92215 denotes that */
618: /* effectivity is not subject to change and is locked */
619: /* down. Otherwise if the rollover indicator in the */
620: /* cm_cmpt_dtl table is zero or does not exist, */
621: /* allow modification to the effectivity. */
622: /* */
623: /* This validation is for CHANGES only! */
624: /* */

Line 646: cm_cmpt_dtl cost

642: CURSOR locked_val IS
643: SELECT rcp.formula_id
644: FROM gmd_recipe_validity_rules vr,
645: gmd_recipes_b rcp,
646: cm_cmpt_dtl cost
647: WHERE rcp.formula_id = pformula_id
648: AND vr.recipe_validity_rule_id = cost.fmeff_id
649: AND vr.recipe_id = rcp.recipe_id
650: AND cost.rollover_ind = 1;