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 3633: x_header_rec.quote_date := fnd_date.string_to_date(p_attr_value,l_date_format_mask); --bug5402396

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

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

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

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

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

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

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

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

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

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

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

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

3799: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT_ASSIGNMENT THEN
3800: x_header_rec.CC_INSTRUMENT_ASSIGNMENT_ID := p_attr_value; --R12 CC Encryption
3801: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_EXPIRATION_DATE THEN
3802: --x_header_rec.credit_card_expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
3803: x_header_rec.credit_card_expiration_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_DATE THEN
3805: -- x_header_rec.credit_card_approval_date := TO_DATE(p_attr_value, l_date_format_mask);
3806: x_header_rec.credit_card_approval_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3807: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_APPROVAL THEN

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

3802: --x_header_rec.credit_card_expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
3803: x_header_rec.credit_card_expiration_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_DATE THEN
3805: -- x_header_rec.credit_card_approval_date := TO_DATE(p_attr_value, l_date_format_mask);
3806: x_header_rec.credit_card_approval_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3807: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_APPROVAL THEN
3808: x_header_rec.credit_card_approval_code := p_attr_value;
3809: ELSIF p_attr_id = OE_Header_Util.G_FIRST_ACK THEN
3810: x_header_rec.first_ack_code := p_attr_value;

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

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

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

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

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

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

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

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