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.OE_DEFAULT_PVT dependencies on ONT_HEADER_DEF_HDLR

Line 76: l_payment_type_code := ONT_HEADER_DEF_HDLR.g_record.payment_type_code;

72:
73:
74: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
75:
76: l_payment_type_code := ONT_HEADER_DEF_HDLR.g_record.payment_type_code;
77:
78: IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL
79: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM
80: THEN

Line 78: IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL

74: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
75:
76: l_payment_type_code := ONT_HEADER_DEF_HDLR.g_record.payment_type_code;
77:
78: IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL
79: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM
80: THEN
81:
82: l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;

Line 79: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM

75:
76: l_payment_type_code := ONT_HEADER_DEF_HDLR.g_record.payment_type_code;
77:
78: IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL
79: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM
80: THEN
81:
82: l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;
83: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL

Line 82: l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;

78: IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL
79: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM
80: THEN
81:
82: l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;
83: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
84: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM
85: THEN
86: l_invoice_to_org_id := ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id;

Line 83: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL

79: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM
80: THEN
81:
82: l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;
83: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
84: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM
85: THEN
86: l_invoice_to_org_id := ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id;
87: END IF; -- if ont_header_def_hdlr.g_record.invoice_to...

Line 84: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM

80: THEN
81:
82: l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;
83: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
84: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM
85: THEN
86: l_invoice_to_org_id := ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id;
87: END IF; -- if ont_header_def_hdlr.g_record.invoice_to...
88: ELSE

Line 86: l_invoice_to_org_id := ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id;

82: l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;
83: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
84: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM
85: THEN
86: l_invoice_to_org_id := ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id;
87: END IF; -- if ont_header_def_hdlr.g_record.invoice_to...
88: ELSE
89: RETURN NULL;
90: END IF; -- if ont_header_def_hdlr.g_record.sold_to_org_id is not null

Line 87: END IF; -- if ont_header_def_hdlr.g_record.invoice_to...

83: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
84: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM
85: THEN
86: l_invoice_to_org_id := ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id;
87: END IF; -- if ont_header_def_hdlr.g_record.invoice_to...
88: ELSE
89: RETURN NULL;
90: END IF; -- if ont_header_def_hdlr.g_record.sold_to_org_id is not null
91:

Line 90: END IF; -- if ont_header_def_hdlr.g_record.sold_to_org_id is not null

86: l_invoice_to_org_id := ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id;
87: END IF; -- if ont_header_def_hdlr.g_record.invoice_to...
88: ELSE
89: RETURN NULL;
90: END IF; -- if ont_header_def_hdlr.g_record.sold_to_org_id is not null
91:
92: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
93:
94: l_payment_type_code := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.payment_type_code;

Line 118: --l_trans_curr_code := ONT_HEADER_DEF_HDLR.transactional_curr_code;

114: END IF;
115:
116: /* Fix Bug #2297053:Customer of Invoice To may be different from the Sold To */
117: --R12 CC Encryption Verify
118: --l_trans_curr_code := ONT_HEADER_DEF_HDLR.transactional_curr_code;
119: --R12 CC Encryption
120:
121: IF l_invoice_to_org_id is not null THEN
122: OPEN C_Invoice_To_Cust(l_invoice_to_org_id);

Line 267: ONT_HEADER_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;

263: END IF;
264:
265:
266: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
267: ONT_HEADER_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;
268: ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
269: ONT_HEADER_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
270: ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
271: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;

Line 268: ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;

264:
265:
266: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
267: ONT_HEADER_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;
268: ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
269: ONT_HEADER_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
270: ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
271: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
272: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;

Line 269: ONT_HEADER_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;

265:
266: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
267: ONT_HEADER_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;
268: ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
269: ONT_HEADER_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
270: ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
271: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
272: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;
273: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN

Line 270: ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;

266: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
267: ONT_HEADER_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;
268: ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
269: ONT_HEADER_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
270: ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
271: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
272: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;
273: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
274: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;

Line 345: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_code IS NOT NULL

341: BEGIN
342:
343:
344: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V'
345: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_code IS NOT NULL
346: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR THEN
347: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_code;
348: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'
349: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code IS NOT NULL

Line 346: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR THEN

342:
343:
344: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V'
345: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_code IS NOT NULL
346: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR THEN
347: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_code;
348: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'
349: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code IS NOT NULL
350: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR

Line 347: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_code;

343:
344: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V'
345: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_code IS NOT NULL
346: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR THEN
347: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_code;
348: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'
349: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code IS NOT NULL
350: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR
351: THEN

Line 411: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name IS NOT NULL

407: ** Old defaulting code will not even get executed now.
408: */
409: --R12 CC Encryption
410: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V'
411: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name IS NOT NULL
412: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name
413: <> FND_API.G_MISS_CHAR
414: THEN
415:

Line 412: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name

408: */
409: --R12 CC Encryption
410: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V'
411: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name IS NOT NULL
412: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name
413: <> FND_API.G_MISS_CHAR
414: THEN
415:
416: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name;

Line 416: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name;

412: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name
413: <> FND_API.G_MISS_CHAR
414: THEN
415:
416: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name;
417: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'
418: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name IS NOT NULL
419: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name
420: <> FND_API.G_MISS_CHAR

Line 433: l_credit_card_number := ONT_HEADER_DEF_HDLR.g_record.credit_card_number;

429: END IF;
430: RETURN NULL;
431:
432: /*IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
433: l_credit_card_number := ONT_HEADER_DEF_HDLR.g_record.credit_card_number;
434: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
435: l_credit_card_number := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_number;
436: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN
437: l_credit_card_number := ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_number;

Line 454: IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL

450: -- code below is not needed. Hence the return statement is above this line
451:
452: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
453:
454: IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL
455: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM
456: THEN
457:
458: l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;

Line 455: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM

451:
452: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
453:
454: IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL
455: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM
456: THEN
457:
458: l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;
459: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL

Line 458: l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;

454: IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL
455: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM
456: THEN
457:
458: l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;
459: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
460: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM
461: THEN
462: l_invoice_to_org_id := ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id;

Line 459: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL

455: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM
456: THEN
457:
458: l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;
459: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
460: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM
461: THEN
462: l_invoice_to_org_id := ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id;
463: END IF; -- if ont_header_def_hdlr.g_record.invoice_to...

Line 460: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM

456: THEN
457:
458: l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;
459: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
460: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM
461: THEN
462: l_invoice_to_org_id := ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id;
463: END IF; -- if ont_header_def_hdlr.g_record.invoice_to...
464: END IF; -- if ont_header_def_hdlr.g_record.sold_to_org_id is not null

Line 462: l_invoice_to_org_id := ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id;

458: l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;
459: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
460: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM
461: THEN
462: l_invoice_to_org_id := ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id;
463: END IF; -- if ont_header_def_hdlr.g_record.invoice_to...
464: END IF; -- if ont_header_def_hdlr.g_record.sold_to_org_id is not null
465:
466: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN

Line 463: END IF; -- if ont_header_def_hdlr.g_record.invoice_to...

459: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
460: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM
461: THEN
462: l_invoice_to_org_id := ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id;
463: END IF; -- if ont_header_def_hdlr.g_record.invoice_to...
464: END IF; -- if ont_header_def_hdlr.g_record.sold_to_org_id is not null
465:
466: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
467:

Line 464: END IF; -- if ont_header_def_hdlr.g_record.sold_to_org_id is not null

460: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM
461: THEN
462: l_invoice_to_org_id := ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id;
463: END IF; -- if ont_header_def_hdlr.g_record.invoice_to...
464: END IF; -- if ont_header_def_hdlr.g_record.sold_to_org_id is not null
465:
466: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
467:
468: OPEN get_hdr_sold_inv(ONT_HEADER_PAYMENT_DEF_HDLR.g_record.header_id);

Line 541: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date IS NOT NULL

537: BEGIN
538:
539: --R12 CC Encryption
540: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V'
541: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date IS NOT NULL
542: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date
543: <> FND_API.G_MISS_DATE
544: THEN
545: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date;

Line 542: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date

538:
539: --R12 CC Encryption
540: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V'
541: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date IS NOT NULL
542: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date
543: <> FND_API.G_MISS_DATE
544: THEN
545: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date;
546: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'

Line 545: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date;

541: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date IS NOT NULL
542: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date
543: <> FND_API.G_MISS_DATE
544: THEN
545: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date;
546: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'
547: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date IS NOT NULL
548: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date
549: <> FND_API.G_MISS_DATE

Line 568: l_credit_card_number := ONT_HEADER_DEF_HDLR.g_record.credit_card_number;

564: ** Old defaulting code will not even get executed now.
565: */
566:
567: /*IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
568: l_credit_card_number := ONT_HEADER_DEF_HDLR.g_record.credit_card_number;
569: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
570: l_credit_card_number := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_number;
571: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN
572: l_credit_card_number := ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_number;

Line 584: IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL

580: END IF;
581:
582: RETURN l_CC_Expiration_Date;
583:
584: IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL
585: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM THEN
586: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
587: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
588: l_Bank_Account_ID := arp_bank_pkg.get_primary_bank_acct

Line 585: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM THEN

581:
582: RETURN l_CC_Expiration_Date;
583:
584: IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL
585: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM THEN
586: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
587: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
588: l_Bank_Account_ID := arp_bank_pkg.get_primary_bank_acct
589: (ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id

Line 586: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL

582: RETURN l_CC_Expiration_Date;
583:
584: IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL
585: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM THEN
586: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
587: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
588: l_Bank_Account_ID := arp_bank_pkg.get_primary_bank_acct
589: (ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id
590: , ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id

Line 587: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM THEN

583:
584: IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL
585: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM THEN
586: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
587: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
588: l_Bank_Account_ID := arp_bank_pkg.get_primary_bank_acct
589: (ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id
590: , ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id
591: , TRUE);

Line 589: (ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id

585: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM THEN
586: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
587: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
588: l_Bank_Account_ID := arp_bank_pkg.get_primary_bank_acct
589: (ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id
590: , ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id
591: , TRUE);
592: ELSE
593: l_Bank_Account_ID := arp_bank_pkg.get_primary_bank_acct

Line 590: , ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id

586: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
587: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
588: l_Bank_Account_ID := arp_bank_pkg.get_primary_bank_acct
589: (ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id
590: , ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id
591: , TRUE);
592: ELSE
593: l_Bank_Account_ID := arp_bank_pkg.get_primary_bank_acct
594: (ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id);

Line 594: (ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id);

590: , ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id
591: , TRUE);
592: ELSE
593: l_Bank_Account_ID := arp_bank_pkg.get_primary_bank_acct
594: (ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id);
595: END IF;
596: ELSE
597: RETURN NULL;
598: END IF;

Line 654: IF ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id IS NOT NULL AND

650: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
651: --
652: BEGIN
653: /***
654: IF ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id IS NOT NULL AND
655: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND
656: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND
657: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND
658: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND

Line 655: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND

651: --
652: BEGIN
653: /***
654: IF ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id IS NOT NULL AND
655: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND
656: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND
657: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND
658: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND
659: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE

Line 656: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND

652: BEGIN
653: /***
654: IF ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id IS NOT NULL AND
655: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND
656: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND
657: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND
658: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND
659: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE
660: THEN

Line 657: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND

653: /***
654: IF ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id IS NOT NULL AND
655: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND
656: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND
657: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND
658: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND
659: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE
660: THEN
661:

Line 658: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND

654: IF ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id IS NOT NULL AND
655: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND
656: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND
657: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND
658: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND
659: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE
660: THEN
661:
662:

Line 659: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE

655: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND
656: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND
657: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND
658: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND
659: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE
660: THEN
661:
662:
663: OPEN C_Std_Tax_Exemption(ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id,

Line 663: OPEN C_Std_Tax_Exemption(ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id,

659: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE
660: THEN
661:
662:
663: OPEN C_Std_Tax_Exemption(ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id,
664: ONT_HEADER_DEF_HDLR.g_record.Invoice_To_Org_id,
665: ONT_HEADER_DEF_HDLR.g_record.ordered_date);
666: FETCH C_Std_Tax_Exemption INTO l_tax_exempt_number;
667: CLOSE C_Std_Tax_Exemption;

Line 664: ONT_HEADER_DEF_HDLR.g_record.Invoice_To_Org_id,

660: THEN
661:
662:
663: OPEN C_Std_Tax_Exemption(ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id,
664: ONT_HEADER_DEF_HDLR.g_record.Invoice_To_Org_id,
665: ONT_HEADER_DEF_HDLR.g_record.ordered_date);
666: FETCH C_Std_Tax_Exemption INTO l_tax_exempt_number;
667: CLOSE C_Std_Tax_Exemption;
668: END IF;

Line 665: ONT_HEADER_DEF_HDLR.g_record.ordered_date);

661:
662:
663: OPEN C_Std_Tax_Exemption(ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id,
664: ONT_HEADER_DEF_HDLR.g_record.Invoice_To_Org_id,
665: ONT_HEADER_DEF_HDLR.g_record.ordered_date);
666: FETCH C_Std_Tax_Exemption INTO l_tax_exempt_number;
667: CLOSE C_Std_Tax_Exemption;
668: END IF;
669: RETURN l_tax_exempt_number;

Line 717: IF ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id IS NOT NULL AND

713: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
714: --
715: BEGIN
716: /***
717: IF ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id IS NOT NULL AND
718: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND
719: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND
720: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND
721: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND

Line 718: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND

714: --
715: BEGIN
716: /***
717: IF ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id IS NOT NULL AND
718: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND
719: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND
720: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND
721: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND
722: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE

Line 719: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND

715: BEGIN
716: /***
717: IF ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id IS NOT NULL AND
718: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND
719: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND
720: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND
721: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND
722: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE
723: THEN

Line 720: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND

716: /***
717: IF ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id IS NOT NULL AND
718: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND
719: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND
720: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND
721: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND
722: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE
723: THEN
724:

Line 721: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND

717: IF ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id IS NOT NULL AND
718: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND
719: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND
720: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND
721: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND
722: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE
723: THEN
724:
725: OPEN C_Std_Tax_Exemption(ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id,

Line 722: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE

718: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND
719: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND
720: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND
721: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND
722: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE
723: THEN
724:
725: OPEN C_Std_Tax_Exemption(ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id,
726: ONT_HEADER_DEF_HDLR.g_record.Invoice_To_Org_id,

Line 725: OPEN C_Std_Tax_Exemption(ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id,

721: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND
722: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE
723: THEN
724:
725: OPEN C_Std_Tax_Exemption(ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id,
726: ONT_HEADER_DEF_HDLR.g_record.Invoice_To_Org_id,
727: ONT_HEADER_DEF_HDLR.g_record.ordered_date);
728: FETCH C_Std_Tax_Exemption INTO l_tax_exempt_reason_code;
729: CLOSE C_Std_Tax_Exemption;

Line 726: ONT_HEADER_DEF_HDLR.g_record.Invoice_To_Org_id,

722: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE
723: THEN
724:
725: OPEN C_Std_Tax_Exemption(ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id,
726: ONT_HEADER_DEF_HDLR.g_record.Invoice_To_Org_id,
727: ONT_HEADER_DEF_HDLR.g_record.ordered_date);
728: FETCH C_Std_Tax_Exemption INTO l_tax_exempt_reason_code;
729: CLOSE C_Std_Tax_Exemption;
730: END IF;

Line 727: ONT_HEADER_DEF_HDLR.g_record.ordered_date);

723: THEN
724:
725: OPEN C_Std_Tax_Exemption(ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id,
726: ONT_HEADER_DEF_HDLR.g_record.Invoice_To_Org_id,
727: ONT_HEADER_DEF_HDLR.g_record.ordered_date);
728: FETCH C_Std_Tax_Exemption INTO l_tax_exempt_reason_code;
729: CLOSE C_Std_Tax_Exemption;
730: END IF;
731: RETURN l_tax_exempt_reason_code;

Line 1026: ONT_HEADER_Def_Hdlr.g_record.tax_exempt_number := NULL;

1022:
1023: EXCEPTION
1024: WHEN NO_DATA_FOUND THEN
1025: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
1026: ONT_HEADER_Def_Hdlr.g_record.tax_exempt_number := NULL;
1027: ONT_HEADER_Def_Hdlr.g_record.tax_exempt_reason_code := NULL;
1028: ELSIF p_database_object_name = 'OE_AK_ORDER_LINES_V' THEN
1029: ONT_LINE_Def_Hdlr.g_record.tax_exempt_number := NULL;
1030: ONT_LINE_Def_Hdlr.g_record.tax_exempt_reason_code := NULL;

Line 1027: ONT_HEADER_Def_Hdlr.g_record.tax_exempt_reason_code := NULL;

1023: EXCEPTION
1024: WHEN NO_DATA_FOUND THEN
1025: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
1026: ONT_HEADER_Def_Hdlr.g_record.tax_exempt_number := NULL;
1027: ONT_HEADER_Def_Hdlr.g_record.tax_exempt_reason_code := NULL;
1028: ELSIF p_database_object_name = 'OE_AK_ORDER_LINES_V' THEN
1029: ONT_LINE_Def_Hdlr.g_record.tax_exempt_number := NULL;
1030: ONT_LINE_Def_Hdlr.g_record.tax_exempt_reason_code := NULL;
1031: END IF;

Line 1562: l_sold_to_org_id := ONT_HEADER_DEF_HDLR.g_record.SOLD_TO_ORG_ID;

1558: --
1559: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1560: --
1561: BEGIN
1562: l_sold_to_org_id := ONT_HEADER_DEF_HDLR.g_record.SOLD_TO_ORG_ID;
1563: IF l_debug_level > 0 THEN
1564: oe_debug_pub.add('ENTER Get_Primary_Customer_Location');
1565: oe_debug_pub.add('Sold To Org ID :'||l_sold_to_org_id);
1566: END IF;

Line 1625: l_org_id:= ONT_HEADER_DEF_HDLR.g_record.org_id;

1621: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1622: --
1623: l_header_id number;
1624: BEGIN
1625: l_org_id:= ONT_HEADER_DEF_HDLR.g_record.org_id;
1626: IF l_debug_level > 0 THEN
1627: oe_debug_pub.add('Entering Get_Receipt_Method');
1628: END IF;
1629:

Line 1645: l_header_id := ONT_HEADER_DEF_HDLR.g_record.header_id;

1641: IF l_debug_level > 0 THEN
1642: oe_debug_pub.add('payment_type_code from line payments'||l_payment_type_code ||':org_id:'||l_org_id);
1643: END IF;
1644: ELSIF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
1645: l_header_id := ONT_HEADER_DEF_HDLR.g_record.header_id;
1646: END IF;
1647:
1648: IF l_payment_type_code IS NOT NULL AND
1649: l_payment_type_code <> FND_API.G_MISS_CHAR AND

Line 1728: l_sold_to_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;

1724: oe_debug_pub.add('Enter Get_Primary_Deliver_To');
1725: END IF;
1726:
1727: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
1728: l_sold_to_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;
1729: ELSIF p_database_object_name = 'OE_AK_ORDER_LINES_V' THEN
1730: l_sold_to_org_id := ONT_LINE_DEF_HDLR.g_record.sold_to_org_id;
1731: ELSE
1732: IF l_debug_level > 0 THEN