APPS.WMS_RULE_PVT dependencies on WMS_LABEL_REQUESTS

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

15386: -- Generate Package for Label Rules
15387: IF (l_type_code = 4) THEN
15388: g_stmt := 'select count(*) '
15389: || ' from '
15390: || NVL(g_rule_from, 'WMS_LABEL_REQUESTS wlr')
15391: || ' where wlr.label_request_id = p_label_request_id '
15392: || g_rule_where;
15393: --assemble create package statement
15394: l_pack_sql :=

Line 17244: -- wms_label_requests.

17240: --
17241: -- Notes :
17242: --
17243: -- This procedure retrieves a specific label for a label request in
17244: -- wms_label_requests.
17245: -- This procedure calls the rule package created for Label rules to check
17246: -- which label rule actually matches the label request in question.
17247: --===========================================================================
17248: PROCEDURE applylabel(

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

17286: , rules.rule_weight
17287: , rules.type_hdr_id
17288: , wl.label_format_name
17289: , wl.document_id
17290: FROM wms_rules_b rules, wms_label_formats wl, wms_label_requests wlr
17291: WHERE rules.type_code = 4
17292: AND rules.type_hdr_id = wl.label_format_id
17293: AND wl.label_format_id = NVL(wlr.label_format_id, wl.label_format_id)
17294: AND NVL(format_disable_date, SYSDATE + 1) > SYSDATE --Bug #3452076

Line 17312: FROM wms_label_requests

17308: AND default_format_flag IN ('Y', 'y');
17309:
17310: CURSOR l_label_requests_curs IS
17311: SELECT *
17312: FROM wms_label_requests
17313: WHERE label_request_id = p_label_request_id;
17314:
17315: l_label_req_rc wms_label_requests%ROWTYPE;
17316: l_rule_counter INTEGER;

Line 17315: l_label_req_rc wms_label_requests%ROWTYPE;

17311: SELECT *
17312: FROM wms_label_requests
17313: WHERE label_request_id = p_label_request_id;
17314:
17315: l_label_req_rc wms_label_requests%ROWTYPE;
17316: l_rule_counter INTEGER;
17317: l_debug NUMBER;
17318: ll_ctr NUMBER;
17319: BEGIN

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

17319: BEGIN
17320: SAVEPOINT assignlabelsp;
17321: ----
17322: SELECT count(rules.rule_id ) into ll_ctr
17323: FROM wms_rules_b rules, wms_label_formats wl, wms_label_requests wlr
17324: WHERE rules.type_code = 4
17325: AND rules.type_hdr_id = wl.label_format_id
17326: AND wl.label_format_id = NVL(wlr.label_format_id, wl.label_format_id)
17327: AND NVL(format_disable_date, SYSDATE + 1) > SYSDATE --Bug # 3452076

Line 17422: -- update wms_label_requests table with label_format_id

17418: END IF;
17419: END LOOP;
17420:
17421: IF l_return_status > 0 THEN -- the rule matches the label request
17422: -- update wms_label_requests table with label_format_id
17423:
17424:
17425: UPDATE wms_label_requests wlr
17426: SET wlr.label_format_id = l_label_format_id

Line 17425: UPDATE wms_label_requests wlr

17421: IF l_return_status > 0 THEN -- the rule matches the label request
17422: -- update wms_label_requests table with label_format_id
17423:
17424:
17425: UPDATE wms_label_requests wlr
17426: SET wlr.label_format_id = l_label_format_id
17427: , wlr.rule_id = l_rule_id
17428: , wlr.strategy_id = l_strategy_id
17429: , wlr.rule_weight = l_rule_weight

Line 17468: -- update wms_label_requests table with label_format_id

17464: FETCH l_default_label_curs INTO l_label_format_id, l_label_format_name;
17465: CLOSE l_default_label_curs;
17466: END IF;
17467:
17468: -- update wms_label_requests table with label_format_id
17469:
17470:
17471: UPDATE wms_label_requests wlr
17472: SET wlr.label_format_id = l_label_format_id

Line 17471: UPDATE wms_label_requests wlr

17467:
17468: -- update wms_label_requests table with label_format_id
17469:
17470:
17471: UPDATE wms_label_requests wlr
17472: SET wlr.label_format_id = l_label_format_id
17473: WHERE wlr.label_request_id = p_label_request_id;
17474:
17475: IF l_debug = 1 THEN