APPS.GME_MAKE_TO_ORDER_PVT dependencies on GME_MTO_RULES

Line 86: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;

82: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
83: l_rsv_tbl GME_COMMON_PVT.reservations_tab;
84: l_rsv_row_rec MTL_RESERVATIONS%ROWTYPE;
85: l_in_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
86: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;
87: l_mto_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
88:
89: l_item_id NUMBER;
90: l_primary_uom_code VARCHAR2(3);

Line 1139: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;

1135: l_msg_data VARCHAR2 ( 240 );
1136: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1137: l_api_name CONSTANT VARCHAR2(30):= 'line_qualifies_for MTO';
1138: l_in_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
1139: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;
1140: l_mto_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
1141: l_order_line_rec OE_ORDER_LINES_ALL%ROWTYPE;
1142: l_item_type VARCHAR2(30);
1143:

Line 1220: , x_mto_rules_rec OUT NOCOPY GME_MTO_RULES%ROWTYPE

1216:
1217: PROCEDURE retrieve_rule
1218: (
1219: p_mto_assignments_rec IN GME_MTO_RULE_ASSIGNMENTS%ROWTYPE
1220: , x_mto_rules_rec OUT NOCOPY GME_MTO_RULES%ROWTYPE
1221: , x_mto_assignments_rec OUT NOCOPY GME_MTO_RULE_ASSIGNMENTS%ROWTYPE
1222: , x_return_status OUT NOCOPY VARCHAR2
1223: , x_msg_count OUT NOCOPY NUMBER
1224: , x_msg_data OUT NOCOPY VARCHAR2

Line 1229: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;

1225: ) IS
1226:
1227: l_api_name CONSTANT VARCHAR2(30):= 'retrieve_rule';
1228: l_mto_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
1229: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;
1230:
1231: Cursor get_assignment IS
1232: Select decode(site_use_id, null, 0, site_use_id) site_use_id
1233: , decode(customer_id, null, 0, customer_id) customer_id

Line 1258: From gme_mto_rules

1254: ;
1255:
1256: Cursor get_rule IS
1257: Select *
1258: From gme_mto_rules
1259: Where rule_id = l_mto_assignments_rec.rule_id;
1260:
1261: BEGIN
1262: IF (g_debug <= gme_debug.g_log_statement) THEN