DBA Data[Home] [Help]

APPS.OE_OE_FORM_HEADER dependencies on FND_DATE

Line 378: x_header_rec.quote_date := fnd_date.string_to_date(p_attr_value,l_date_format_mask); --bug5402396

374: x_header_rec.blanket_number := TO_NUMBER(p_attr_value);
375: --kmuruges
376: ELSIF p_attr_id = OE_Header_Util.G_quote_date THEN
377: -- x_header_rec.quote_date := TO_DATE(p_attr_value,l_date_format_mask);
378: x_header_rec.quote_date := fnd_date.string_to_date(p_attr_value,l_date_format_mask); --bug5402396
379: ELSIF p_attr_id = OE_Header_Util.G_quote_number THEN
380: x_header_rec.quote_number := TO_NUMBER(p_attr_value);
381: ELSIF p_attr_id = OE_Header_Util.G_sales_document_name THEN
382: x_header_rec.sales_document_name := p_attr_value;

Line 417: x_header_rec.conversion_rate_date := fnd_date.string_to_date(p_attr_value,l_date_format_mask); --bug5402396

413: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_RATE THEN
414: x_header_rec.conversion_rate := TO_NUMBER(p_attr_value);
415: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_RATE_DATE THEN
416: -- x_header_rec.conversion_rate_date := TO_DATE(p_attr_value,l_date_format_mask);
417: x_header_rec.conversion_rate_date := fnd_date.string_to_date(p_attr_value,l_date_format_mask); --bug5402396
418: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_TYPE THEN
419: x_header_rec.conversion_type_code := p_attr_value;
420: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_PREFERENCE_SET THEN
421: x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := p_attr_value;

Line 434: x_header_rec.expiration_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask);--bug5402396

430: ELSIF p_attr_id = OE_Header_Util.G_DEMAND_CLASS THEN
431: x_header_rec.demand_class_code := p_attr_value;
432: ELSIF p_attr_id = OE_Header_Util.G_EXPIRATION_DATE THEN
433: -- x_header_rec.expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
434: x_header_rec.expiration_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask);--bug5402396
435: ELSIF p_attr_id = OE_Header_Util.G_EARLIEST_SCHEDULE_LIMIT THEN
436: x_header_rec.earliest_schedule_limit := TO_NUMBER(p_attr_value);
437: ELSIF p_attr_id = OE_Header_Util.G_FOB_POINT THEN
438: x_header_rec.fob_point_code := p_attr_value;

Line 461: x_header_rec.ordered_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396

457: ELSIF p_attr_id = OE_Header_Util.G_OPEN THEN
458: x_header_rec.open_flag := p_attr_value;
459: ELSIF p_attr_id = OE_Header_Util.G_ORDERED_DATE THEN
460: -- x_header_rec.ordered_date := TO_DATE(p_attr_value, l_date_format_mask);
461: x_header_rec.ordered_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
462: ELSIF p_attr_id = OE_Header_Util.G_ORDER_DATE_TYPE_CODE THEN
463: x_header_rec.order_date_type_code := p_attr_value;
464: ELSIF p_attr_id = OE_Header_Util.G_ORDER_NUMBER THEN
465: x_header_rec.order_number := TO_NUMBER(p_attr_value);

Line 482: x_header_rec.pricing_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396

478: ELSIF p_attr_id = OE_Header_Util.G_PRICE_LIST THEN
479: x_header_rec.price_list_id := TO_NUMBER(p_attr_value);
480: ELSIF p_attr_id = OE_Header_Util.G_PRICING_DATE THEN
481: -- x_header_rec.pricing_date := TO_DATE(p_attr_value, l_date_format_mask);
482: x_header_rec.pricing_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
483: ELSIF p_attr_id = OE_Header_Util.G_REQUEST_DATE THEN
484: -- x_header_rec.request_date := TO_DATE(p_attr_value, l_date_format_mask);
485: x_header_rec.request_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
486: ELSIF p_attr_id = OE_Header_Util.G_SHIPMENT_PRIORITY THEN

Line 485: x_header_rec.request_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396

481: -- x_header_rec.pricing_date := TO_DATE(p_attr_value, l_date_format_mask);
482: x_header_rec.pricing_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
483: ELSIF p_attr_id = OE_Header_Util.G_REQUEST_DATE THEN
484: -- x_header_rec.request_date := TO_DATE(p_attr_value, l_date_format_mask);
485: x_header_rec.request_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
486: ELSIF p_attr_id = OE_Header_Util.G_SHIPMENT_PRIORITY THEN
487: x_header_rec.shipment_priority_code := p_attr_value;
488: ELSIF p_attr_id = OE_Header_Util.G_SHIPPING_METHOD THEN
489: x_header_rec.shipping_method_code := p_attr_value;

Line 548: x_header_rec.credit_card_expiration_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396

544: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT_ASSIGNMENT THEN
545: x_header_rec.CC_INSTRUMENT_ASSIGNMENT_ID := p_attr_value; --R12 CC Encryption
546: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_EXPIRATION_DATE THEN
547: -- x_header_rec.credit_card_expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
548: x_header_rec.credit_card_expiration_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
549: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_APPROVAL_DATE THEN
550: -- x_header_rec.credit_card_approval_date := TO_DATE(p_attr_value, l_date_format_mask);
551: x_header_rec.credit_card_approval_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
552: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_APPROVAL THEN

Line 551: x_header_rec.credit_card_approval_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396

547: -- x_header_rec.credit_card_expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
548: x_header_rec.credit_card_expiration_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
549: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_APPROVAL_DATE THEN
550: -- x_header_rec.credit_card_approval_date := TO_DATE(p_attr_value, l_date_format_mask);
551: x_header_rec.credit_card_approval_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
552: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_APPROVAL THEN
553: x_header_rec.credit_card_approval_code := p_attr_value;
554: ELSIF p_attr_id = OE_Header_Util.G_FIRST_ACK THEN
555: x_header_rec.first_ack_code := p_attr_value;

Line 558: x_header_rec.first_ack_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396

554: ELSIF p_attr_id = OE_Header_Util.G_FIRST_ACK THEN
555: x_header_rec.first_ack_code := p_attr_value;
556: ELSIF p_attr_id = OE_Header_Util.G_FIRST_ACK_DATE THEN
557: -- x_header_rec.first_ack_date := TO_DATE(p_attr_value, l_date_format_mask);
558: x_header_rec.first_ack_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
559: ELSIF p_attr_id = OE_Header_Util.G_LAST_ACK THEN
560: x_header_rec.last_ack_code := p_attr_value;
561: ELSIF p_attr_id = OE_Header_Util.G_SHIPPING_INSTRUCTIONS THEN
562: x_header_rec.shipping_instructions := p_attr_value;

Line 567: x_header_rec.last_ack_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396

563: ELSIF p_attr_id = OE_Header_Util.G_PACKING_INSTRUCTIONS THEN
564: x_header_rec.packing_instructions := p_attr_value;
565: ELSIF p_attr_id = OE_Header_Util.G_LAST_ACK_DATE THEN
566: -- x_header_rec.last_ack_date := TO_DATE(p_attr_value, l_date_format_mask);
567: x_header_rec.last_ack_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
568: ELSIF p_attr_id = OE_Header_Util.G_ORDER_CATEGORY THEN
569: x_header_rec.order_category_code := p_attr_value;
570: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_TEMPLATE THEN
571: x_header_rec.contract_template_id := TO_NUMBER(p_attr_value);

Line 582: x_header_rec.customer_signature_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396

578: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_SIGNATURE THEN
579: x_header_rec.customer_signature := p_attr_value;
580: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_SIGNATURE_DATE THEN
581: -- x_header_rec.customer_signature_date := TO_DATE(p_attr_value, l_date_format_mask);
582: x_header_rec.customer_signature_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
583: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE_DATE THEN
584: -- x_header_rec.supplier_signature_date := TO_DATE(p_attr_value, l_date_format_mask);
585: x_header_rec.supplier_signature_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
586: ELSIF p_attr_id = OE_Header_Util.G_ATTRIBUTE1

Line 585: x_header_rec.supplier_signature_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396

581: -- x_header_rec.customer_signature_date := TO_DATE(p_attr_value, l_date_format_mask);
582: x_header_rec.customer_signature_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
583: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE_DATE THEN
584: -- x_header_rec.supplier_signature_date := TO_DATE(p_attr_value, l_date_format_mask);
585: x_header_rec.supplier_signature_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
586: ELSIF p_attr_id = OE_Header_Util.G_ATTRIBUTE1
587: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE10
588: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE11
589: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12

Line 3630: x_header_rec.quote_date := fnd_date.string_to_date(p_attr_value,l_date_format_mask); --bug5402396

3626: x_header_rec.blanket_number := TO_NUMBER(p_attr_value);
3627: --kmuruges
3628: ELSIF p_attr_id = OE_Header_Util.G_quote_date THEN
3629: -- x_header_rec.quote_date := TO_DATE(p_attr_value,l_date_format_mask);
3630: x_header_rec.quote_date := fnd_date.string_to_date(p_attr_value,l_date_format_mask); --bug5402396
3631: ELSIF p_attr_id = OE_Header_Util.G_quote_number THEN
3632: x_header_rec.quote_number := TO_NUMBER(p_attr_value);
3633: ELSIF p_attr_id = OE_Header_Util.G_sales_document_name THEN
3634: x_header_rec.sales_document_name := p_attr_value;

Line 3669: x_header_rec.conversion_rate_date := fnd_date.string_to_date(p_attr_value,l_date_format_mask); --bug5402396

3665: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_RATE THEN
3666: x_header_rec.conversion_rate := TO_NUMBER(p_attr_value);
3667: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_RATE_DATE THEN
3668: --x_header_rec.conversion_rate_date := TO_DATE(p_attr_value,l_date_format_mask);
3669: x_header_rec.conversion_rate_date := fnd_date.string_to_date(p_attr_value,l_date_format_mask); --bug5402396
3670: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_TYPE THEN
3671: x_header_rec.conversion_type_code := p_attr_value;
3672: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_PREFERENCE_SET THEN
3673: x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := p_attr_value;

Line 3686: x_header_rec.expiration_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396

3682: ELSIF p_attr_id = OE_Header_Util.G_DEMAND_CLASS THEN
3683: x_header_rec.demand_class_code := p_attr_value;
3684: ELSIF p_attr_id = OE_Header_Util.G_EXPIRATION_DATE THEN
3685: --x_header_rec.expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
3686: x_header_rec.expiration_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3687: ELSIF p_attr_id = OE_Header_Util.G_EARLIEST_SCHEDULE_LIMIT THEN
3688: x_header_rec.earliest_schedule_limit := TO_NUMBER(p_attr_value);
3689: ELSIF p_attr_id = OE_Header_Util.G_FOB_POINT THEN
3690: x_header_rec.fob_point_code := p_attr_value;

Line 3713: x_header_rec.ordered_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396

3709: ELSIF p_attr_id = OE_Header_Util.G_OPEN THEN
3710: x_header_rec.open_flag := p_attr_value;
3711: ELSIF p_attr_id = OE_Header_Util.G_ORDERED_DATE THEN
3712: -- x_header_rec.ordered_date := TO_DATE(p_attr_value, l_date_format_mask);
3713: x_header_rec.ordered_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3714: ELSIF p_attr_id = OE_Header_Util.G_ORDER_DATE_TYPE_CODE THEN
3715: x_header_rec.order_date_type_code := p_attr_value;
3716: ELSIF p_attr_id = OE_Header_Util.G_ORDER_NUMBER THEN
3717: x_header_rec.order_number := TO_NUMBER(p_attr_value);

Line 3734: x_header_rec.pricing_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396

3730: ELSIF p_attr_id = OE_Header_Util.G_PRICE_LIST THEN
3731: x_header_rec.price_list_id := TO_NUMBER(p_attr_value);
3732: ELSIF p_attr_id = OE_Header_Util.G_PRICING_DATE THEN
3733: --x_header_rec.pricing_date := TO_DATE(p_attr_value, l_date_format_mask);
3734: x_header_rec.pricing_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3735: ELSIF p_attr_id = OE_Header_Util.G_REQUEST_DATE THEN
3736: --x_header_rec.request_date := TO_DATE(p_attr_value, l_date_format_mask);
3737: x_header_rec.request_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3738: ELSIF p_attr_id = OE_Header_Util.G_SHIPMENT_PRIORITY THEN

Line 3737: x_header_rec.request_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396

3733: --x_header_rec.pricing_date := TO_DATE(p_attr_value, l_date_format_mask);
3734: x_header_rec.pricing_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3735: ELSIF p_attr_id = OE_Header_Util.G_REQUEST_DATE THEN
3736: --x_header_rec.request_date := TO_DATE(p_attr_value, l_date_format_mask);
3737: x_header_rec.request_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3738: ELSIF p_attr_id = OE_Header_Util.G_SHIPMENT_PRIORITY THEN
3739: x_header_rec.shipment_priority_code := p_attr_value;
3740: ELSIF p_attr_id = OE_Header_Util.G_SHIPPING_METHOD THEN
3741: x_header_rec.shipping_method_code := p_attr_value;

Line 3800: x_header_rec.credit_card_expiration_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396

3796: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT_ASSIGNMENT THEN
3797: x_header_rec.CC_INSTRUMENT_ASSIGNMENT_ID := p_attr_value; --R12 CC Encryption
3798: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_EXPIRATION_DATE THEN
3799: --x_header_rec.credit_card_expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
3800: x_header_rec.credit_card_expiration_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3801: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_APPROVAL_DATE THEN
3802: -- x_header_rec.credit_card_approval_date := TO_DATE(p_attr_value, l_date_format_mask);
3803: x_header_rec.credit_card_approval_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3804: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_APPROVAL THEN

Line 3803: x_header_rec.credit_card_approval_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396

3799: --x_header_rec.credit_card_expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
3800: x_header_rec.credit_card_expiration_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3801: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_APPROVAL_DATE THEN
3802: -- x_header_rec.credit_card_approval_date := TO_DATE(p_attr_value, l_date_format_mask);
3803: x_header_rec.credit_card_approval_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3804: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_APPROVAL THEN
3805: x_header_rec.credit_card_approval_code := p_attr_value;
3806: ELSIF p_attr_id = OE_Header_Util.G_FIRST_ACK THEN
3807: x_header_rec.first_ack_code := p_attr_value;

Line 3810: x_header_rec.first_ack_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396

3806: ELSIF p_attr_id = OE_Header_Util.G_FIRST_ACK THEN
3807: x_header_rec.first_ack_code := p_attr_value;
3808: ELSIF p_attr_id = OE_Header_Util.G_FIRST_ACK_DATE THEN
3809: -- x_header_rec.first_ack_date := TO_DATE(p_attr_value, l_date_format_mask);
3810: x_header_rec.first_ack_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3811: ELSIF p_attr_id = OE_Header_Util.G_LAST_ACK THEN
3812: x_header_rec.last_ack_code := p_attr_value;
3813: ELSIF p_attr_id = OE_Header_Util.G_SHIPPING_INSTRUCTIONS THEN
3814: x_header_rec.shipping_instructions := p_attr_value;

Line 3819: x_header_rec.last_ack_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask);--bug5402396

3815: ELSIF p_attr_id = OE_Header_Util.G_PACKING_INSTRUCTIONS THEN
3816: x_header_rec.packing_instructions := p_attr_value;
3817: ELSIF p_attr_id = OE_Header_Util.G_LAST_ACK_DATE THEN
3818: --x_header_rec.last_ack_date := TO_DATE(p_attr_value, l_date_format_mask);
3819: x_header_rec.last_ack_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask);--bug5402396
3820: ELSIF p_attr_id = OE_Header_Util.G_ORDER_CATEGORY THEN
3821: x_header_rec.order_category_code := p_attr_value;
3822:
3823: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_TEMPLATE THEN

Line 3838: x_header_rec.customer_signature_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396

3834: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_SIGNATURE THEN
3835: x_header_rec.customer_signature := p_attr_value;
3836: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_SIGNATURE_DATE THEN
3837: -- x_header_rec.customer_signature_date := TO_DATE(p_attr_value, l_date_format_mask);
3838: x_header_rec.customer_signature_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3839: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE_DATE THEN
3840: -- x_header_rec.supplier_signature_date := TO_DATE(p_attr_value, l_date_format_mask);
3841: x_header_rec.supplier_signature_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask);
3842:

Line 3841: x_header_rec.supplier_signature_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask);

3837: -- x_header_rec.customer_signature_date := TO_DATE(p_attr_value, l_date_format_mask);
3838: x_header_rec.customer_signature_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3839: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE_DATE THEN
3840: -- x_header_rec.supplier_signature_date := TO_DATE(p_attr_value, l_date_format_mask);
3841: x_header_rec.supplier_signature_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask);
3842:
3843: ELSIF p_attr_id = OE_Header_Util.G_ATTRIBUTE1
3844: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE10
3845: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE11