APPS.WMS_RULE_PVT dependencies on WMS_LABEL_REQUESTS

Line 12747: || NVL(g_rule_from, 'WMS_LABEL_REQUESTS wlr')

12743: -- Generate Package for Label Rules
12744: IF (l_type_code = 4) THEN
12745: g_stmt := 'select count(*) '
12746: || ' from '
12747: || NVL(g_rule_from, 'WMS_LABEL_REQUESTS wlr')
12748: || ' where wlr.label_request_id = p_label_request_id '
12749: || g_rule_where;
12750: --assemble create package statement
12751: l_pack_sql :=

Line 14593: -- wms_label_requests.

14589: --
14590: -- Notes :
14591: --
14592: -- This procedure retrieves a specific label for a label request in
14593: -- wms_label_requests.
14594: -- This procedure calls the rule package created for Label rules to check
14595: -- which label rule actually matches the label request in question.
14596: --===========================================================================
14597: PROCEDURE applylabel(

Line 14639: FROM wms_rules_b rules, wms_label_formats wl, wms_label_requests wlr

14635: , rules.rule_weight
14636: , rules.type_hdr_id
14637: , wl.label_format_name
14638: , wl.document_id
14639: FROM wms_rules_b rules, wms_label_formats wl, wms_label_requests wlr
14640: WHERE rules.type_code = 4
14641: AND rules.type_hdr_id = wl.label_format_id
14642: AND wl.label_format_id = NVL(wlr.label_format_id, wl.label_format_id)
14643: AND NVL(format_disable_date, SYSDATE + 1) > SYSDATE --Bug #3452076

Line 14667: FROM wms_label_requests

14663: AND default_format_flag IN ('Y', 'y');
14664:
14665: CURSOR l_label_requests_curs IS
14666: SELECT *
14667: FROM wms_label_requests
14668: WHERE label_request_id = p_label_request_id;
14669:
14670: l_label_req_rc wms_label_requests%ROWTYPE;
14671: l_rule_counter INTEGER;

Line 14670: l_label_req_rc wms_label_requests%ROWTYPE;

14666: SELECT *
14667: FROM wms_label_requests
14668: WHERE label_request_id = p_label_request_id;
14669:
14670: l_label_req_rc wms_label_requests%ROWTYPE;
14671: l_rule_counter INTEGER;
14672: l_debug NUMBER;
14673: ll_ctr NUMBER;
14674: BEGIN

Line 14678: FROM wms_rules_b rules, wms_label_formats wl, wms_label_requests wlr

14674: BEGIN
14675: SAVEPOINT assignlabelsp;
14676: ----
14677: SELECT count(rules.rule_id ) into ll_ctr
14678: FROM wms_rules_b rules, wms_label_formats wl, wms_label_requests wlr
14679: WHERE rules.type_code = 4
14680: AND rules.type_hdr_id = wl.label_format_id
14681: AND wl.label_format_id = NVL(wlr.label_format_id, wl.label_format_id)
14682: AND NVL(format_disable_date, SYSDATE + 1) > SYSDATE --Bug # 3452076

Line 14777: -- update wms_label_requests table with label_format_id

14773: END IF;
14774: END LOOP;
14775:
14776: IF l_return_status > 0 THEN -- the rule matches the label request
14777: -- update wms_label_requests table with label_format_id
14778:
14779:
14780: UPDATE wms_label_requests wlr
14781: SET wlr.label_format_id = l_label_format_id

Line 14780: UPDATE wms_label_requests wlr

14776: IF l_return_status > 0 THEN -- the rule matches the label request
14777: -- update wms_label_requests table with label_format_id
14778:
14779:
14780: UPDATE wms_label_requests wlr
14781: SET wlr.label_format_id = l_label_format_id
14782: , wlr.rule_id = l_rule_id
14783: , wlr.strategy_id = l_strategy_id
14784: , wlr.rule_weight = l_rule_weight

Line 14823: -- update wms_label_requests table with label_format_id

14819: FETCH l_default_label_curs INTO l_label_format_id, l_label_format_name;
14820: CLOSE l_default_label_curs;
14821: END IF;
14822:
14823: -- update wms_label_requests table with label_format_id
14824:
14825:
14826: UPDATE wms_label_requests wlr
14827: SET wlr.label_format_id = l_label_format_id

Line 14826: UPDATE wms_label_requests wlr

14822:
14823: -- update wms_label_requests table with label_format_id
14824:
14825:
14826: UPDATE wms_label_requests wlr
14827: SET wlr.label_format_id = l_label_format_id
14828: WHERE wlr.label_request_id = p_label_request_id;
14829:
14830: IF l_debug = 1 THEN