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 89: IF NOT OE_GLOBALS.Equal( p_ship_to_org_id , G_SHIP_TO_ORGANIZATION_ID ) then

85: Region_Loc_zone_tab WSH_UTIL_CORE.Id_Tab_Type;
86: --15885432 End
87: begin
88:
89: IF NOT OE_GLOBALS.Equal( p_ship_to_org_id , G_SHIP_TO_ORGANIZATION_ID ) then
90:
91: IF p_ship_to_org_id IS NULL then
92: RETURN NULL;
93: END IF;

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

165: Return Varchar2
166: IS
167: l_customer_category_code Varchar2(30);
168: begin
169: IF NOT OE_GLOBALS.Equal( p_customer_id , G_CUST_ID ) then
170: SELECT party.CATEGORY_CODE
171: into l_customer_category_code
172: FROM
173: HZ_CUST_ACCOUNTS cust,

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

1106: Return Number
1107: is
1108: l_order_type_id NUMBER;
1109: begin
1110: IF NOT OE_GLOBALS.Equal( p_header_id , G_HEADER_ID ) then
1111: select order_type_id
1112: into l_order_type_id
1113: from oe_order_headers_all
1114: where header_id = p_header_id;

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

1134: is
1135: l_sales_channel_code VARCHAR2(30);
1136: begin
1137:
1138: IF NOT OE_GLOBALS.Equal( p_header_id , G_HDR_ID ) then
1139: select sales_channel_code
1140: into l_sales_channel_code
1141: from oe_order_headers_all
1142: where header_id = p_header_id;