DBA Data[Home] [Help]

APPS.OE_ITORD_UTIL dependencies on OE_GLOBALS

Line 15: IF NOT OE_GLOBALS.Equal( p_inventory_item_id , G_INVENTORY_ITEM_ID ) then

11: Return Number IS
12: l_item_category_id Number;
13: begin
14:
15: IF NOT OE_GLOBALS.Equal( p_inventory_item_id , G_INVENTORY_ITEM_ID ) then
16: select category_id
17: into l_item_category_id
18: from mtl_item_categories ic,
19: MTL_DEFAULT_CATEGORY_SETS CS

Line 46: IF NOT OE_GLOBALS.Equal( p_customer_id , G_SOLD_TO_ORG_ID ) then

42: Return Number IS
43: l_customer_class_id Number;
44: begin
45:
46: IF NOT OE_GLOBALS.Equal( p_customer_id , G_SOLD_TO_ORG_ID ) then
47:
48: SELECT cp.profile_class_id
49: into l_customer_class_id
50: FROM

Line 86: IF NOT OE_GLOBALS.Equal( p_ship_to_org_id , G_SHIP_TO_ORGANIZATION_ID ) then

82: l_region_id_tbl WSH_UTIL_CORE.ID_TAB_TYPE;
83: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
84: begin
85:
86: IF NOT OE_GLOBALS.Equal( p_ship_to_org_id , G_SHIP_TO_ORGANIZATION_ID ) then
87:
88: IF p_ship_to_org_id IS NULL then
89: RETURN NULL;
90: END IF;

Line 138: IF NOT OE_GLOBALS.Equal( p_customer_id , G_CUST_ID ) then

134: Return Varchar2
135: IS
136: l_customer_category_code Varchar2(30);
137: begin
138: IF NOT OE_GLOBALS.Equal( p_customer_id , G_CUST_ID ) then
139: SELECT party.CATEGORY_CODE
140: into l_customer_category_code
141: FROM
142: HZ_CUST_ACCOUNTS cust,

Line 1079: IF NOT OE_GLOBALS.Equal( p_header_id , G_HEADER_ID ) then

1075: Return Number
1076: is
1077: l_order_type_id NUMBER;
1078: begin
1079: IF NOT OE_GLOBALS.Equal( p_header_id , G_HEADER_ID ) then
1080: select order_type_id
1081: into l_order_type_id
1082: from oe_order_headers_all
1083: where header_id = p_header_id;

Line 1107: IF NOT OE_GLOBALS.Equal( p_header_id , G_HDR_ID ) then

1103: is
1104: l_sales_channel_code VARCHAR2(30);
1105: begin
1106:
1107: IF NOT OE_GLOBALS.Equal( p_header_id , G_HDR_ID ) then
1108: select sales_channel_code
1109: into l_sales_channel_code
1110: from oe_order_headers_all
1111: where header_id = p_header_id;