APPS.GMD_ROUTING_STEPS_PUB dependencies on GMD_OPERATIONS

Line 60: l_oprn_no gmd_operations.oprn_no%TYPE;

56: l_routing_id gmd_routings.routing_id%TYPE;
57: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
58: l_enforce_flag GMD_ROUTINGS.enforce_step_dependency%TYPE;
59: l_steprelease_type fm_rout_dtl.steprelease_type%TYPE;
60: l_oprn_no gmd_operations.oprn_no%TYPE;
61: l_oprn_vers gmd_operations.oprn_vers%TYPE;
62: l_rout_eff_start_date DATE;
63: l_rout_eff_end_date DATE;
64:

Line 61: l_oprn_vers gmd_operations.oprn_vers%TYPE;

57: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
58: l_enforce_flag GMD_ROUTINGS.enforce_step_dependency%TYPE;
59: l_steprelease_type fm_rout_dtl.steprelease_type%TYPE;
60: l_oprn_no gmd_operations.oprn_no%TYPE;
61: l_oprn_vers gmd_operations.oprn_vers%TYPE;
62: l_rout_eff_start_date DATE;
63: l_rout_eff_end_date DATE;
64:
65: /* define record type */

Line 80: From gmd_operations_b

76:
77: /* gets the operation no and version associated to the routing detail/Step */
78: Cursor Get_oprn_details(vOprn_id fm_rout_dtl.oprn_id%TYPE) IS
79: Select oprn_no, oprn_vers
80: From gmd_operations_b
81: Where oprn_id = vOprn_id;
82:
83: /* get routing start date */
84: Cursor get_rout_start_date(vRouting_id NUMBER) IS

Line 759: l_oprn_id gmd_operations.oprn_id%TYPE;

755: l_routing_id gmd_routings.routing_id%TYPE;
756: l_routingstep_id fm_rout_dtl.routingStep_id%TYPE;
757: l_routingstep_no fm_rout_dtl.routingStep_no%TYPE;
758: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
759: l_oprn_id gmd_operations.oprn_id%TYPE;
760:
761: /* Define record type that hold the routing data */
762: l_old_routingStep_rec fm_rout_dtl%ROWTYPE;
763: