eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_POSTALLOC_PVT dependencies on WMS_RULES

Line 27: TYPE t_rule_id IS TABLE OF wms_rules.rule_id%TYPE;

23: g_opa_rule_exists BOOLEAN := TRUE;
24: g_tta_org_id NUMBER := -1;
25: g_tta_rule_exists BOOLEAN := TRUE;
26:
27: TYPE t_rule_id IS TABLE OF wms_rules.rule_id%TYPE;
28: TYPE t_type_hdr_id IS TABLE OF wms_rules.type_hdr_id%TYPE;
29: g_t_opa_rule_id t_rule_id;
30: g_t_opa_type_hdr_id t_type_hdr_id;
31: g_t_tta_rule_id t_rule_id;

Line 28: TYPE t_type_hdr_id IS TABLE OF wms_rules.type_hdr_id%TYPE;

24: g_tta_org_id NUMBER := -1;
25: g_tta_rule_exists BOOLEAN := TRUE;
26:
27: TYPE t_rule_id IS TABLE OF wms_rules.rule_id%TYPE;
28: TYPE t_type_hdr_id IS TABLE OF wms_rules.type_hdr_id%TYPE;
29: g_t_opa_rule_id t_rule_id;
30: g_t_opa_type_hdr_id t_type_hdr_id;
31: g_t_tta_rule_id t_rule_id;
32: g_t_tta_type_hdr_id t_type_hdr_id;

Line 287: FROM wms_rules rules

283: g_opa_org_id := p_organization_id;
284: BEGIN
285: SELECT rules.rule_id, rules.type_hdr_id BULK COLLECT
286: INTO g_t_opa_rule_id, g_t_opa_type_hdr_id
287: FROM wms_rules rules
288: , wms_op_plans_b wop
289: WHERE rules.organization_id IN (g_opa_org_id,-1)
290: AND rules.type_code = 7
291: AND rules.enabled_flag = 'Y'

Line 5139: FROM wms_rules_b rules

5135: g_tta_org_id := p_organization_id;
5136: BEGIN
5137: SELECT rules.rule_id, rules.type_hdr_id BULK COLLECT
5138: INTO g_t_tta_rule_id, g_t_tta_type_hdr_id
5139: FROM wms_rules_b rules
5140: , bom_standard_operations bso
5141: WHERE rules.organization_id IN (g_tta_org_id,-1)
5142: AND rules.type_code = 3
5143: AND rules.enabled_flag = 'Y'