APPS.GME_MAKE_TO_ORDER_PVT dependencies on GME_MTO_RULES

Line 76: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;

72: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
73: l_rsv_tbl GME_COMMON_PVT.reservations_tab;
74: l_rsv_row_rec MTL_RESERVATIONS%ROWTYPE;
75: l_in_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
76: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;
77: l_mto_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
78:
79: l_item_id NUMBER;
80: l_primary_uom_code VARCHAR2(3);

Line 1035: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;

1031: l_msg_data VARCHAR2 ( 240 );
1032: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1033: l_api_name CONSTANT VARCHAR2(30):= 'line_qualifies_for MTO';
1034: l_in_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
1035: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;
1036: l_mto_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
1037: l_order_line_rec OE_ORDER_LINES_ALL%ROWTYPE;
1038: l_item_type VARCHAR2(30);
1039:

Line 1116: , x_mto_rules_rec OUT NOCOPY GME_MTO_RULES%ROWTYPE

1112:
1113: PROCEDURE retrieve_rule
1114: (
1115: p_mto_assignments_rec IN GME_MTO_RULE_ASSIGNMENTS%ROWTYPE
1116: , x_mto_rules_rec OUT NOCOPY GME_MTO_RULES%ROWTYPE
1117: , x_mto_assignments_rec OUT NOCOPY GME_MTO_RULE_ASSIGNMENTS%ROWTYPE
1118: , x_return_status OUT NOCOPY VARCHAR2
1119: , x_msg_count OUT NOCOPY NUMBER
1120: , x_msg_data OUT NOCOPY VARCHAR2

Line 1125: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;

1121: ) IS
1122:
1123: l_api_name CONSTANT VARCHAR2(30):= 'retrieve_rule';
1124: l_mto_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
1125: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;
1126:
1127: Cursor get_assignment IS
1128: Select decode(site_use_id, null, 0, site_use_id) site_use_id
1129: , decode(customer_id, null, 0, customer_id) customer_id

Line 1154: From gme_mto_rules

1150: ;
1151:
1152: Cursor get_rule IS
1153: Select *
1154: From gme_mto_rules
1155: Where rule_id = l_mto_assignments_rec.rule_id;
1156:
1157: BEGIN
1158: IF (g_debug <= gme_debug.g_log_statement) THEN