DBA Data[Home] [Help]

APPS.OE_DEFAULT_HEADER dependencies on OE_GLOBALS

Line 28: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_method_code

24: (p_header_rec.ship_from_org_id IS NOT NULL AND
25: p_header_rec.ship_from_org_id<> FND_API.G_MISS_NUM) THEN
26:
27: -- 3610480 : Validate freight_carrier_code if shipping_method_code or ship_from_org_id is not null
28: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_method_code
29: ,p_old_header_rec.shipping_method_code) OR
30: NOT OE_GLOBALS.EQUAL(p_header_rec.ship_from_org_id
31: ,p_old_header_rec.ship_from_org_id) OR
32: NOT OE_GLOBALS.EQUAL(p_header_rec.freight_carrier_code

Line 30: NOT OE_GLOBALS.EQUAL(p_header_rec.ship_from_org_id

26:
27: -- 3610480 : Validate freight_carrier_code if shipping_method_code or ship_from_org_id is not null
28: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_method_code
29: ,p_old_header_rec.shipping_method_code) OR
30: NOT OE_GLOBALS.EQUAL(p_header_rec.ship_from_org_id
31: ,p_old_header_rec.ship_from_org_id) OR
32: NOT OE_GLOBALS.EQUAL(p_header_rec.freight_carrier_code
33: ,p_old_header_rec.freight_carrier_code)) THEN
34:

Line 32: NOT OE_GLOBALS.EQUAL(p_header_rec.freight_carrier_code

28: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_method_code
29: ,p_old_header_rec.shipping_method_code) OR
30: NOT OE_GLOBALS.EQUAL(p_header_rec.ship_from_org_id
31: ,p_old_header_rec.ship_from_org_id) OR
32: NOT OE_GLOBALS.EQUAL(p_header_rec.freight_carrier_code
33: ,p_old_header_rec.freight_carrier_code)) THEN
34:
35: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
36: SELECT freight_code

Line 123: IF p_header_rec.operation = oe_globals.g_opr_update THEN

119: oe_order_types_v
120: where
121: order_type_id = p_header_rec.order_type_id;
122:
123: IF p_header_rec.operation = oe_globals.g_opr_update THEN
124: IF (p_old_header_rec.order_category_code <> FND_API.G_MISS_CHAR AND
125: p_old_header_rec.order_category_code IS NOT NULL ) THEN
126: IF NOT OE_GLOBALS.EQUAL(p_old_header_rec.order_category_code,
127: l_category_code) THEN

Line 126: IF NOT OE_GLOBALS.EQUAL(p_old_header_rec.order_category_code,

122:
123: IF p_header_rec.operation = oe_globals.g_opr_update THEN
124: IF (p_old_header_rec.order_category_code <> FND_API.G_MISS_CHAR AND
125: p_old_header_rec.order_category_code IS NOT NULL ) THEN
126: IF NOT OE_GLOBALS.EQUAL(p_old_header_rec.order_category_code,
127: l_category_code) THEN
128: FND_MESSAGE.SET_NAME('ONT','OE_ORD_CAT_CONST');
129: OE_MSG_PUB.ADD;
130: IF l_debug_level > 0 THEN

Line 189: --IF p_header_rec.operation = oe_globals.g_opr_create THEN

185: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
186: --
187: Begin
188:
189: --IF p_header_rec.operation = oe_globals.g_opr_create THEN
190:
191: IF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id,
192: p_old_header_rec.ship_to_org_id) THEN
193:

Line 191: IF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id,

187: Begin
188:
189: --IF p_header_rec.operation = oe_globals.g_opr_create THEN
190:
191: IF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id,
192: p_old_header_rec.ship_to_org_id) THEN
193:
194: lsiteuseid := p_header_rec.ship_to_org_id;
195: OPEN C2;

Line 214: IF NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id,

210: END IF;
211:
212: END IF;
213:
214: IF NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id,
215: p_old_header_rec.invoice_to_org_id) THEN
216:
217: lsiteuseid := p_header_rec.invoice_to_org_id;
218: OPEN C2;

Line 237: IF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id,

233: END IF;
234:
235: END IF;
236:
237: IF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id,
238: p_old_header_rec.sold_to_org_id) THEN
239:
240: /*OPEN C2;
241: FETCH C2 INTO

Line 384: OE_GLOBALS.Set_Context;

380: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
381: --
382: BEGIN
383:
384: OE_GLOBALS.Set_Context;
385: l_org_id := OE_GLOBALS.G_ORG_ID;
386:
387: RETURN l_org_id;
388:

Line 385: l_org_id := OE_GLOBALS.G_ORG_ID;

381: --
382: BEGIN
383:
384: OE_GLOBALS.Set_Context;
385: l_org_id := OE_GLOBALS.G_ORG_ID;
386:
387: RETURN l_org_id;
388:
389: END Get_Org;

Line 614: AND NOT OE_GLOBALS.EQUAL(p_blanket_number,

610: -- And copy source attribute values from IN parameters
611: -- to the new record e.g. blanket number value is copied
612: -- to p_x_header_rec.
613: IF p_blanket_number IS NOT NULL
614: AND NOT OE_GLOBALS.EQUAL(p_blanket_number,
615: p_x_header_rec.blanket_number)
616: THEN
617: p_x_header_rec.blanket_number := p_blanket_number;
618: l_header_rec := p_x_header_rec;

Line 744: IF l_operation = OE_GLOBALS.G_OPR_CREATE THEN

740: l_operation := p_x_header_rec.operation;
741:
742: -- IMPORTANT: For defaulting to work correctly, none of these fields should be
743: -- dependent on any other field (Refer OEXUDEPB.pls for the list of dependencies)
744: IF l_operation = OE_GLOBALS.G_OPR_CREATE THEN
745:
746: g_header_rec.org_id := Get_Org;
747:
748: IF g_header_rec.created_by = FND_API.G_MISS_NUM THEN

Line 820: AND (NOT OE_GLOBALS.EQUAL(g_header_rec.cust_po_number

816: (g_header_rec.cust_po_number IS NOT NULL AND
817: g_header_rec.cust_po_number <> FND_API.G_MISS_CHAR
818: -- Re-default blanket number only if cust PO
819: -- OR customer is updated
820: AND (NOT OE_GLOBALS.EQUAL(g_header_rec.cust_po_number
821: ,l_old_header_rec.cust_po_number)
822: OR NOT OE_GLOBALS.EQUAL(g_header_rec.sold_to_org_id
823: ,l_old_header_rec.sold_to_org_id))
824: )

Line 822: OR NOT OE_GLOBALS.EQUAL(g_header_rec.sold_to_org_id

818: -- Re-default blanket number only if cust PO
819: -- OR customer is updated
820: AND (NOT OE_GLOBALS.EQUAL(g_header_rec.cust_po_number
821: ,l_old_header_rec.cust_po_number)
822: OR NOT OE_GLOBALS.EQUAL(g_header_rec.sold_to_org_id
823: ,l_old_header_rec.sold_to_org_id))
824: )
825: THEN
826:

Line 916: AND NOT OE_GLOBALS.EQUAL(l_record.cust_po_number

912: -- existing blanket value.
913: AND (l_old_header_rec.blanket_number IS NULL OR
914: l_old_header_rec.blanket_number = FND_API.G_MISS_NUM )
915: AND l_record.sold_to_org_id IS NOT NULL
916: AND NOT OE_GLOBALS.EQUAL(l_record.cust_po_number
917: ,g_header_rec.cust_po_number)
918: THEN
919:
920: if l_debug_level > 0 then

Line 975: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

971: /* Get Contract template */
972: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'
973: AND p_x_header_rec.order_type_id IS NOT NULL
974: AND p_x_header_rec.order_type_id <> FND_API.G_MISS_NUM
975: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
976: AND OE_Contracts_util.check_license = 'Y'
977: THEN
978: p_x_header_rec.contract_template_id :=
979: Get_contract_template_id(p_x_header_rec,

Line 1196: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

1192: END IF;
1193:
1194: IF oe_code_control.code_release_level >= '110510' THEN
1195:
1196: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1197:
1198: IF p_x_header_rec.transaction_phase_code is null then
1199: p_x_header_rec.transaction_phase_code := 'F';
1200: ELSIF p_x_header_rec.transaction_phase_code = 'N' THEN

Line 1223: IF NOT OE_GLOBALS.EQUAL(p_x_header_rec.expiration_date

1219: END IF;
1220:
1221: -- If expiration date is changing, update time component to midnight
1222: -- i.e. to 23:59:59
1223: IF NOT OE_GLOBALS.EQUAL(p_x_header_rec.expiration_date
1224: ,p_old_header_rec.expiration_date)
1225: THEN
1226: p_x_header_rec.expiration_date :=
1227: trunc(p_x_header_rec.expiration_date,'DD') +