184:
185:
186: -- Load OUT NOCOPY /* file.sql.39 change */ parameters.
187:
188: x_header_val_rec := OE_Header_Util.Get_Values
189: ( p_header_rec => x_header_rec
190: );
191:
192: -- Write to cache.
363:
364:
365: oe_debuG_pub.add('attri id'||p_attr_id);
366: oe_debug_pub.add('attr val ksur'||p_attr_value);
367: IF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE THEN
368: x_header_rec.accounting_rule_id := TO_NUMBER(p_attr_value);
369: ELSIF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE_DURATION THEN
370: x_header_rec.accounting_rule_duration := TO_NUMBER(p_attr_value);
371: ELSIF p_attr_id = OE_Header_Util.G_AGREEMENT THEN
365: oe_debuG_pub.add('attri id'||p_attr_id);
366: oe_debug_pub.add('attr val ksur'||p_attr_value);
367: IF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE THEN
368: x_header_rec.accounting_rule_id := TO_NUMBER(p_attr_value);
369: ELSIF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE_DURATION THEN
370: x_header_rec.accounting_rule_duration := TO_NUMBER(p_attr_value);
371: ELSIF p_attr_id = OE_Header_Util.G_AGREEMENT THEN
372: x_header_rec.agreement_id := TO_NUMBER(p_attr_value);
373: ELSIF p_attr_id = OE_Header_Util.G_BLANKET_NUMBER THEN
367: IF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE THEN
368: x_header_rec.accounting_rule_id := TO_NUMBER(p_attr_value);
369: ELSIF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE_DURATION THEN
370: x_header_rec.accounting_rule_duration := TO_NUMBER(p_attr_value);
371: ELSIF p_attr_id = OE_Header_Util.G_AGREEMENT THEN
372: x_header_rec.agreement_id := TO_NUMBER(p_attr_value);
373: ELSIF p_attr_id = OE_Header_Util.G_BLANKET_NUMBER THEN
374: x_header_rec.blanket_number := TO_NUMBER(p_attr_value);
375: --kmuruges
369: ELSIF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE_DURATION THEN
370: x_header_rec.accounting_rule_duration := TO_NUMBER(p_attr_value);
371: ELSIF p_attr_id = OE_Header_Util.G_AGREEMENT THEN
372: x_header_rec.agreement_id := TO_NUMBER(p_attr_value);
373: ELSIF p_attr_id = OE_Header_Util.G_BLANKET_NUMBER THEN
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);
372: x_header_rec.agreement_id := TO_NUMBER(p_attr_value);
373: ELSIF p_attr_id = OE_Header_Util.G_BLANKET_NUMBER THEN
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);
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;
383: ELSIF p_attr_id = OE_Header_Util.G_transaction_phase 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;
383: ELSIF p_attr_id = OE_Header_Util.G_transaction_phase THEN
384: x_header_rec.transaction_phase_code := p_attr_value;
385: ELSIF p_attr_id = OE_Header_Util.G_user_status THEN
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;
383: ELSIF p_attr_id = OE_Header_Util.G_transaction_phase THEN
384: x_header_rec.transaction_phase_code := p_attr_value;
385: ELSIF p_attr_id = OE_Header_Util.G_user_status THEN
386: x_header_rec.user_status_code := p_attr_value;
387: ELSIF p_attr_id = OE_Header_Util.G_draft_submitted THEN
381: ELSIF p_attr_id = OE_Header_Util.G_sales_document_name THEN
382: x_header_rec.sales_document_name := p_attr_value;
383: ELSIF p_attr_id = OE_Header_Util.G_transaction_phase THEN
384: x_header_rec.transaction_phase_code := p_attr_value;
385: ELSIF p_attr_id = OE_Header_Util.G_user_status THEN
386: x_header_rec.user_status_code := p_attr_value;
387: ELSIF p_attr_id = OE_Header_Util.G_draft_submitted THEN
388: x_header_rec.draft_submitted_flag := p_attr_value;
389: ELSIF p_attr_id = OE_Header_Util.G_source_document_version THEN
383: ELSIF p_attr_id = OE_Header_Util.G_transaction_phase THEN
384: x_header_rec.transaction_phase_code := p_attr_value;
385: ELSIF p_attr_id = OE_Header_Util.G_user_status THEN
386: x_header_rec.user_status_code := p_attr_value;
387: ELSIF p_attr_id = OE_Header_Util.G_draft_submitted THEN
388: x_header_rec.draft_submitted_flag := p_attr_value;
389: ELSIF p_attr_id = OE_Header_Util.G_source_document_version THEN
390: x_header_rec.source_document_version_number := TO_NUMBER(p_attr_value);
391: ELSIF p_attr_id = OE_Header_Util.G_sold_to_site_use THEN
385: ELSIF p_attr_id = OE_Header_Util.G_user_status THEN
386: x_header_rec.user_status_code := p_attr_value;
387: ELSIF p_attr_id = OE_Header_Util.G_draft_submitted THEN
388: x_header_rec.draft_submitted_flag := p_attr_value;
389: ELSIF p_attr_id = OE_Header_Util.G_source_document_version THEN
390: x_header_rec.source_document_version_number := TO_NUMBER(p_attr_value);
391: ELSIF p_attr_id = OE_Header_Util.G_sold_to_site_use THEN
392: x_header_rec.sold_to_site_use_id := TO_NUMBER(p_attr_value);
393:
387: ELSIF p_attr_id = OE_Header_Util.G_draft_submitted THEN
388: x_header_rec.draft_submitted_flag := p_attr_value;
389: ELSIF p_attr_id = OE_Header_Util.G_source_document_version THEN
390: x_header_rec.source_document_version_number := TO_NUMBER(p_attr_value);
391: ELSIF p_attr_id = OE_Header_Util.G_sold_to_site_use THEN
392: x_header_rec.sold_to_site_use_id := TO_NUMBER(p_attr_value);
393:
394: ELSIF p_attr_id = OE_Header_Util.G_ib_owner THEN
395: x_header_rec.ib_owner := p_attr_value;
390: x_header_rec.source_document_version_number := TO_NUMBER(p_attr_value);
391: ELSIF p_attr_id = OE_Header_Util.G_sold_to_site_use THEN
392: x_header_rec.sold_to_site_use_id := TO_NUMBER(p_attr_value);
393:
394: ELSIF p_attr_id = OE_Header_Util.G_ib_owner THEN
395: x_header_rec.ib_owner := p_attr_value;
396: ELSIF p_attr_id = OE_Header_Util.G_ib_installed_at_location THEN
397: x_header_rec.ib_installed_at_location := p_attr_value;
398: ELSIF p_attr_id = OE_Header_Util.G_ib_current_location THEN
392: x_header_rec.sold_to_site_use_id := TO_NUMBER(p_attr_value);
393:
394: ELSIF p_attr_id = OE_Header_Util.G_ib_owner THEN
395: x_header_rec.ib_owner := p_attr_value;
396: ELSIF p_attr_id = OE_Header_Util.G_ib_installed_at_location THEN
397: x_header_rec.ib_installed_at_location := p_attr_value;
398: ELSIF p_attr_id = OE_Header_Util.G_ib_current_location THEN
399: x_header_rec.ib_current_location := p_attr_value;
400: ELSIF p_attr_id = OE_Header_Util.G_end_customer_site_use THEN
394: ELSIF p_attr_id = OE_Header_Util.G_ib_owner THEN
395: x_header_rec.ib_owner := p_attr_value;
396: ELSIF p_attr_id = OE_Header_Util.G_ib_installed_at_location THEN
397: x_header_rec.ib_installed_at_location := p_attr_value;
398: ELSIF p_attr_id = OE_Header_Util.G_ib_current_location THEN
399: x_header_rec.ib_current_location := p_attr_value;
400: ELSIF p_attr_id = OE_Header_Util.G_end_customer_site_use THEN
401: x_header_rec.end_customer_site_use_id := TO_NUMBER(p_attr_value);
402: ELSIF p_attr_id = OE_Header_Util.G_end_customer_contact THEN
396: ELSIF p_attr_id = OE_Header_Util.G_ib_installed_at_location THEN
397: x_header_rec.ib_installed_at_location := p_attr_value;
398: ELSIF p_attr_id = OE_Header_Util.G_ib_current_location THEN
399: x_header_rec.ib_current_location := p_attr_value;
400: ELSIF p_attr_id = OE_Header_Util.G_end_customer_site_use THEN
401: x_header_rec.end_customer_site_use_id := TO_NUMBER(p_attr_value);
402: ELSIF p_attr_id = OE_Header_Util.G_end_customer_contact THEN
403: x_header_rec.end_customer_contact_id := TO_NUMBER(p_attr_value);
404: ELSIF p_attr_id = OE_Header_Util.G_end_customer THEN
398: ELSIF p_attr_id = OE_Header_Util.G_ib_current_location THEN
399: x_header_rec.ib_current_location := p_attr_value;
400: ELSIF p_attr_id = OE_Header_Util.G_end_customer_site_use THEN
401: x_header_rec.end_customer_site_use_id := TO_NUMBER(p_attr_value);
402: ELSIF p_attr_id = OE_Header_Util.G_end_customer_contact THEN
403: x_header_rec.end_customer_contact_id := TO_NUMBER(p_attr_value);
404: ELSIF p_attr_id = OE_Header_Util.G_end_customer THEN
405: x_header_rec.end_customer_id := TO_NUMBER(p_attr_value);
406: --kmuruges end
400: ELSIF p_attr_id = OE_Header_Util.G_end_customer_site_use THEN
401: x_header_rec.end_customer_site_use_id := TO_NUMBER(p_attr_value);
402: ELSIF p_attr_id = OE_Header_Util.G_end_customer_contact THEN
403: x_header_rec.end_customer_contact_id := TO_NUMBER(p_attr_value);
404: ELSIF p_attr_id = OE_Header_Util.G_end_customer THEN
405: x_header_rec.end_customer_id := TO_NUMBER(p_attr_value);
406: --kmuruges end
407: ELSIF p_attr_id = OE_Header_Util.G_BOOKED THEN
408: x_header_rec.booked_flag := p_attr_value;
403: x_header_rec.end_customer_contact_id := TO_NUMBER(p_attr_value);
404: ELSIF p_attr_id = OE_Header_Util.G_end_customer THEN
405: x_header_rec.end_customer_id := TO_NUMBER(p_attr_value);
406: --kmuruges end
407: ELSIF p_attr_id = OE_Header_Util.G_BOOKED THEN
408: x_header_rec.booked_flag := p_attr_value;
409: ELSIF p_attr_id = OE_Header_Util.G_BOOKED_DATE THEN
410: x_header_rec.booked_date := p_attr_value;
411: ELSIF p_attr_id = OE_Header_Util.G_CANCELLED THEN
405: x_header_rec.end_customer_id := TO_NUMBER(p_attr_value);
406: --kmuruges end
407: ELSIF p_attr_id = OE_Header_Util.G_BOOKED THEN
408: x_header_rec.booked_flag := p_attr_value;
409: ELSIF p_attr_id = OE_Header_Util.G_BOOKED_DATE THEN
410: x_header_rec.booked_date := p_attr_value;
411: ELSIF p_attr_id = OE_Header_Util.G_CANCELLED THEN
412: x_header_rec.cancelled_flag := p_attr_value;
413: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_RATE THEN
407: ELSIF p_attr_id = OE_Header_Util.G_BOOKED THEN
408: x_header_rec.booked_flag := p_attr_value;
409: ELSIF p_attr_id = OE_Header_Util.G_BOOKED_DATE THEN
410: x_header_rec.booked_date := p_attr_value;
411: ELSIF p_attr_id = OE_Header_Util.G_CANCELLED THEN
412: x_header_rec.cancelled_flag := p_attr_value;
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
409: ELSIF p_attr_id = OE_Header_Util.G_BOOKED_DATE THEN
410: x_header_rec.booked_date := p_attr_value;
411: ELSIF p_attr_id = OE_Header_Util.G_CANCELLED THEN
412: x_header_rec.cancelled_flag := p_attr_value;
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
411: ELSIF p_attr_id = OE_Header_Util.G_CANCELLED THEN
412: x_header_rec.cancelled_flag := p_attr_value;
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;
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;
422: ELSIF p_attr_id = OE_Header_Util.G_CUST_PO_NUMBER 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;
422: ELSIF p_attr_id = OE_Header_Util.G_CUST_PO_NUMBER THEN
423: x_header_rec.cust_po_number := p_attr_value;
424: ELSIF p_attr_id = OE_Header_Util.G_DEFAULT_FULFILLMENT_SET THEN
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;
422: ELSIF p_attr_id = OE_Header_Util.G_CUST_PO_NUMBER THEN
423: x_header_rec.cust_po_number := p_attr_value;
424: ELSIF p_attr_id = OE_Header_Util.G_DEFAULT_FULFILLMENT_SET THEN
425: x_header_rec.DEFAULT_FULFILLMENT_SET := p_attr_value;
426: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_CONTACT THEN
420: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_PREFERENCE_SET THEN
421: x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := p_attr_value;
422: ELSIF p_attr_id = OE_Header_Util.G_CUST_PO_NUMBER THEN
423: x_header_rec.cust_po_number := p_attr_value;
424: ELSIF p_attr_id = OE_Header_Util.G_DEFAULT_FULFILLMENT_SET THEN
425: x_header_rec.DEFAULT_FULFILLMENT_SET := p_attr_value;
426: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_CONTACT THEN
427: x_header_rec.deliver_to_contact_id := TO_NUMBER(p_attr_value);
428: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_ORG THEN
422: ELSIF p_attr_id = OE_Header_Util.G_CUST_PO_NUMBER THEN
423: x_header_rec.cust_po_number := p_attr_value;
424: ELSIF p_attr_id = OE_Header_Util.G_DEFAULT_FULFILLMENT_SET THEN
425: x_header_rec.DEFAULT_FULFILLMENT_SET := p_attr_value;
426: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_CONTACT THEN
427: x_header_rec.deliver_to_contact_id := TO_NUMBER(p_attr_value);
428: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_ORG THEN
429: x_header_rec.deliver_to_org_id := TO_NUMBER(p_attr_value);
430: ELSIF p_attr_id = OE_Header_Util.G_DEMAND_CLASS THEN
424: ELSIF p_attr_id = OE_Header_Util.G_DEFAULT_FULFILLMENT_SET THEN
425: x_header_rec.DEFAULT_FULFILLMENT_SET := p_attr_value;
426: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_CONTACT THEN
427: x_header_rec.deliver_to_contact_id := TO_NUMBER(p_attr_value);
428: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_ORG THEN
429: x_header_rec.deliver_to_org_id := TO_NUMBER(p_attr_value);
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
426: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_CONTACT THEN
427: x_header_rec.deliver_to_contact_id := TO_NUMBER(p_attr_value);
428: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_ORG THEN
429: x_header_rec.deliver_to_org_id := TO_NUMBER(p_attr_value);
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
428: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_ORG THEN
429: x_header_rec.deliver_to_org_id := TO_NUMBER(p_attr_value);
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);
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;
439: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_CARRIER 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;
439: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_CARRIER THEN
440: x_header_rec.freight_carrier_code := p_attr_value;
441: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_TERMS THEN
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;
439: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_CARRIER THEN
440: x_header_rec.freight_carrier_code := p_attr_value;
441: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_TERMS THEN
442: x_header_rec.freight_terms_code := p_attr_value;
443: ELSIF p_attr_id = OE_Header_Util.G_FULFILLMENT_SET_NAME THEN
437: ELSIF p_attr_id = OE_Header_Util.G_FOB_POINT THEN
438: x_header_rec.fob_point_code := p_attr_value;
439: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_CARRIER THEN
440: x_header_rec.freight_carrier_code := p_attr_value;
441: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_TERMS THEN
442: x_header_rec.freight_terms_code := p_attr_value;
443: ELSIF p_attr_id = OE_Header_Util.G_FULFILLMENT_SET_NAME THEN
444: x_header_rec.FULFILLMENT_SET_NAME := p_attr_value;
445: ELSIF p_attr_id = OE_Header_Util.G_HEADER THEN
439: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_CARRIER THEN
440: x_header_rec.freight_carrier_code := p_attr_value;
441: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_TERMS THEN
442: x_header_rec.freight_terms_code := p_attr_value;
443: ELSIF p_attr_id = OE_Header_Util.G_FULFILLMENT_SET_NAME THEN
444: x_header_rec.FULFILLMENT_SET_NAME := p_attr_value;
445: ELSIF p_attr_id = OE_Header_Util.G_HEADER THEN
446: x_header_rec.header_id := TO_NUMBER(p_attr_value);
447: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_CONTACT THEN
441: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_TERMS THEN
442: x_header_rec.freight_terms_code := p_attr_value;
443: ELSIF p_attr_id = OE_Header_Util.G_FULFILLMENT_SET_NAME THEN
444: x_header_rec.FULFILLMENT_SET_NAME := p_attr_value;
445: ELSIF p_attr_id = OE_Header_Util.G_HEADER THEN
446: x_header_rec.header_id := TO_NUMBER(p_attr_value);
447: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_CONTACT THEN
448: x_header_rec.invoice_to_contact_id := TO_NUMBER(p_attr_value);
449: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_ORG THEN
443: ELSIF p_attr_id = OE_Header_Util.G_FULFILLMENT_SET_NAME THEN
444: x_header_rec.FULFILLMENT_SET_NAME := p_attr_value;
445: ELSIF p_attr_id = OE_Header_Util.G_HEADER THEN
446: x_header_rec.header_id := TO_NUMBER(p_attr_value);
447: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_CONTACT THEN
448: x_header_rec.invoice_to_contact_id := TO_NUMBER(p_attr_value);
449: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_ORG THEN
450: x_header_rec.invoice_to_org_id := TO_NUMBER(p_attr_value);
451: ELSIF p_attr_id = OE_Header_Util.G_INVOICING_RULE THEN
445: ELSIF p_attr_id = OE_Header_Util.G_HEADER THEN
446: x_header_rec.header_id := TO_NUMBER(p_attr_value);
447: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_CONTACT THEN
448: x_header_rec.invoice_to_contact_id := TO_NUMBER(p_attr_value);
449: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_ORG THEN
450: x_header_rec.invoice_to_org_id := TO_NUMBER(p_attr_value);
451: ELSIF p_attr_id = OE_Header_Util.G_INVOICING_RULE THEN
452: x_header_rec.invoicing_rule_id := TO_NUMBER(p_attr_value);
453: ELSIF p_attr_id = OE_Header_Util.G_LATEST_SCHEDULE_LIMIT THEN
447: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_CONTACT THEN
448: x_header_rec.invoice_to_contact_id := TO_NUMBER(p_attr_value);
449: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_ORG THEN
450: x_header_rec.invoice_to_org_id := TO_NUMBER(p_attr_value);
451: ELSIF p_attr_id = OE_Header_Util.G_INVOICING_RULE THEN
452: x_header_rec.invoicing_rule_id := TO_NUMBER(p_attr_value);
453: ELSIF p_attr_id = OE_Header_Util.G_LATEST_SCHEDULE_LIMIT THEN
454: x_header_rec.latest_schedule_limit := TO_NUMBER(p_attr_value);
455: ELSIF p_attr_id = OE_Header_Util.G_LINE_SET_NAME THEN
449: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_ORG THEN
450: x_header_rec.invoice_to_org_id := TO_NUMBER(p_attr_value);
451: ELSIF p_attr_id = OE_Header_Util.G_INVOICING_RULE THEN
452: x_header_rec.invoicing_rule_id := TO_NUMBER(p_attr_value);
453: ELSIF p_attr_id = OE_Header_Util.G_LATEST_SCHEDULE_LIMIT THEN
454: x_header_rec.latest_schedule_limit := TO_NUMBER(p_attr_value);
455: ELSIF p_attr_id = OE_Header_Util.G_LINE_SET_NAME THEN
456: x_header_rec.LINE_SET_NAME := p_attr_value;
457: ELSIF p_attr_id = OE_Header_Util.G_OPEN THEN
451: ELSIF p_attr_id = OE_Header_Util.G_INVOICING_RULE THEN
452: x_header_rec.invoicing_rule_id := TO_NUMBER(p_attr_value);
453: ELSIF p_attr_id = OE_Header_Util.G_LATEST_SCHEDULE_LIMIT THEN
454: x_header_rec.latest_schedule_limit := TO_NUMBER(p_attr_value);
455: ELSIF p_attr_id = OE_Header_Util.G_LINE_SET_NAME THEN
456: x_header_rec.LINE_SET_NAME := p_attr_value;
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
453: ELSIF p_attr_id = OE_Header_Util.G_LATEST_SCHEDULE_LIMIT THEN
454: x_header_rec.latest_schedule_limit := TO_NUMBER(p_attr_value);
455: ELSIF p_attr_id = OE_Header_Util.G_LINE_SET_NAME THEN
456: x_header_rec.LINE_SET_NAME := p_attr_value;
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
455: ELSIF p_attr_id = OE_Header_Util.G_LINE_SET_NAME THEN
456: x_header_rec.LINE_SET_NAME := p_attr_value;
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;
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);
466: ELSIF p_attr_id = OE_Header_Util.G_ORDER_SOURCE 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);
466: ELSIF p_attr_id = OE_Header_Util.G_ORDER_SOURCE THEN
467: x_header_rec.order_source_id := TO_NUMBER(p_attr_value);
468: ELSIF p_attr_id = OE_Header_Util.G_ORDER_TYPE THEN
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);
466: ELSIF p_attr_id = OE_Header_Util.G_ORDER_SOURCE THEN
467: x_header_rec.order_source_id := TO_NUMBER(p_attr_value);
468: ELSIF p_attr_id = OE_Header_Util.G_ORDER_TYPE THEN
469: x_header_rec.order_type_id := TO_NUMBER(p_attr_value);
470: ELSIF p_attr_id = OE_Header_Util.G_ORG THEN
464: ELSIF p_attr_id = OE_Header_Util.G_ORDER_NUMBER THEN
465: x_header_rec.order_number := TO_NUMBER(p_attr_value);
466: ELSIF p_attr_id = OE_Header_Util.G_ORDER_SOURCE THEN
467: x_header_rec.order_source_id := TO_NUMBER(p_attr_value);
468: ELSIF p_attr_id = OE_Header_Util.G_ORDER_TYPE THEN
469: x_header_rec.order_type_id := TO_NUMBER(p_attr_value);
470: ELSIF p_attr_id = OE_Header_Util.G_ORG THEN
471: x_header_rec.org_id := TO_NUMBER(p_attr_value);
472: ELSIF p_attr_id = OE_Header_Util.G_ORIG_SYS_DOCUMENT_REF THEN
466: ELSIF p_attr_id = OE_Header_Util.G_ORDER_SOURCE THEN
467: x_header_rec.order_source_id := TO_NUMBER(p_attr_value);
468: ELSIF p_attr_id = OE_Header_Util.G_ORDER_TYPE THEN
469: x_header_rec.order_type_id := TO_NUMBER(p_attr_value);
470: ELSIF p_attr_id = OE_Header_Util.G_ORG THEN
471: x_header_rec.org_id := TO_NUMBER(p_attr_value);
472: ELSIF p_attr_id = OE_Header_Util.G_ORIG_SYS_DOCUMENT_REF THEN
473: x_header_rec.orig_sys_document_ref := p_attr_value;
474: ELSIF p_attr_id = OE_Header_Util.G_PARTIAL_SHIPMENTS_ALLOWED THEN
468: ELSIF p_attr_id = OE_Header_Util.G_ORDER_TYPE THEN
469: x_header_rec.order_type_id := TO_NUMBER(p_attr_value);
470: ELSIF p_attr_id = OE_Header_Util.G_ORG THEN
471: x_header_rec.org_id := TO_NUMBER(p_attr_value);
472: ELSIF p_attr_id = OE_Header_Util.G_ORIG_SYS_DOCUMENT_REF THEN
473: x_header_rec.orig_sys_document_ref := p_attr_value;
474: ELSIF p_attr_id = OE_Header_Util.G_PARTIAL_SHIPMENTS_ALLOWED THEN
475: x_header_rec.partial_shipments_allowed := p_attr_value;
476: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TERM THEN
470: ELSIF p_attr_id = OE_Header_Util.G_ORG THEN
471: x_header_rec.org_id := TO_NUMBER(p_attr_value);
472: ELSIF p_attr_id = OE_Header_Util.G_ORIG_SYS_DOCUMENT_REF THEN
473: x_header_rec.orig_sys_document_ref := p_attr_value;
474: ELSIF p_attr_id = OE_Header_Util.G_PARTIAL_SHIPMENTS_ALLOWED THEN
475: x_header_rec.partial_shipments_allowed := p_attr_value;
476: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TERM THEN
477: x_header_rec.payment_term_id := TO_NUMBER(p_attr_value);
478: ELSIF p_attr_id = OE_Header_Util.G_PRICE_LIST THEN
472: ELSIF p_attr_id = OE_Header_Util.G_ORIG_SYS_DOCUMENT_REF THEN
473: x_header_rec.orig_sys_document_ref := p_attr_value;
474: ELSIF p_attr_id = OE_Header_Util.G_PARTIAL_SHIPMENTS_ALLOWED THEN
475: x_header_rec.partial_shipments_allowed := p_attr_value;
476: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TERM THEN
477: x_header_rec.payment_term_id := TO_NUMBER(p_attr_value);
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
474: ELSIF p_attr_id = OE_Header_Util.G_PARTIAL_SHIPMENTS_ALLOWED THEN
475: x_header_rec.partial_shipments_allowed := p_attr_value;
476: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TERM THEN
477: x_header_rec.payment_term_id := TO_NUMBER(p_attr_value);
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
476: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TERM THEN
477: x_header_rec.payment_term_id := TO_NUMBER(p_attr_value);
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);
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
487: x_header_rec.shipment_priority_code := p_attr_value;
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;
490: ELSIF p_attr_id = OE_Header_Util.G_SHIP_FROM_ORG 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;
490: ELSIF p_attr_id = OE_Header_Util.G_SHIP_FROM_ORG THEN
491: x_header_rec.ship_from_org_id := TO_NUMBER(p_attr_value);
492: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_ABOVE THEN
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;
490: ELSIF p_attr_id = OE_Header_Util.G_SHIP_FROM_ORG THEN
491: x_header_rec.ship_from_org_id := TO_NUMBER(p_attr_value);
492: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_ABOVE THEN
493: x_header_rec.ship_tolerance_above := TO_NUMBER(p_attr_value);
494: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_BELOW THEN
488: ELSIF p_attr_id = OE_Header_Util.G_SHIPPING_METHOD THEN
489: x_header_rec.shipping_method_code := p_attr_value;
490: ELSIF p_attr_id = OE_Header_Util.G_SHIP_FROM_ORG THEN
491: x_header_rec.ship_from_org_id := TO_NUMBER(p_attr_value);
492: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_ABOVE THEN
493: x_header_rec.ship_tolerance_above := TO_NUMBER(p_attr_value);
494: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_BELOW THEN
495: x_header_rec.ship_tolerance_below := TO_NUMBER(p_attr_value);
496: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_CONTACT THEN
490: ELSIF p_attr_id = OE_Header_Util.G_SHIP_FROM_ORG THEN
491: x_header_rec.ship_from_org_id := TO_NUMBER(p_attr_value);
492: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_ABOVE THEN
493: x_header_rec.ship_tolerance_above := TO_NUMBER(p_attr_value);
494: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_BELOW THEN
495: x_header_rec.ship_tolerance_below := TO_NUMBER(p_attr_value);
496: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_CONTACT THEN
497: x_header_rec.ship_to_contact_id := TO_NUMBER(p_attr_value);
498: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_ORG THEN
492: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_ABOVE THEN
493: x_header_rec.ship_tolerance_above := TO_NUMBER(p_attr_value);
494: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_BELOW THEN
495: x_header_rec.ship_tolerance_below := TO_NUMBER(p_attr_value);
496: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_CONTACT THEN
497: x_header_rec.ship_to_contact_id := TO_NUMBER(p_attr_value);
498: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_ORG THEN
499: x_header_rec.ship_to_org_id := TO_NUMBER(p_attr_value);
500: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_CONTACT THEN
494: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_BELOW THEN
495: x_header_rec.ship_tolerance_below := TO_NUMBER(p_attr_value);
496: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_CONTACT THEN
497: x_header_rec.ship_to_contact_id := TO_NUMBER(p_attr_value);
498: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_ORG THEN
499: x_header_rec.ship_to_org_id := TO_NUMBER(p_attr_value);
500: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_CONTACT THEN
501: x_header_rec.sold_to_contact_id := TO_NUMBER(p_attr_value);
502: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_ORG THEN
496: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_CONTACT THEN
497: x_header_rec.ship_to_contact_id := TO_NUMBER(p_attr_value);
498: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_ORG THEN
499: x_header_rec.ship_to_org_id := TO_NUMBER(p_attr_value);
500: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_CONTACT THEN
501: x_header_rec.sold_to_contact_id := TO_NUMBER(p_attr_value);
502: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_ORG THEN
503: x_header_rec.sold_to_org_id := TO_NUMBER(p_attr_value);
504: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_PHONE THEN
498: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_ORG THEN
499: x_header_rec.ship_to_org_id := TO_NUMBER(p_attr_value);
500: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_CONTACT THEN
501: x_header_rec.sold_to_contact_id := TO_NUMBER(p_attr_value);
502: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_ORG THEN
503: x_header_rec.sold_to_org_id := TO_NUMBER(p_attr_value);
504: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_PHONE THEN
505: x_header_rec.sold_to_phone_id := TO_NUMBER(p_attr_value);
506: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT THEN
500: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_CONTACT THEN
501: x_header_rec.sold_to_contact_id := TO_NUMBER(p_attr_value);
502: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_ORG THEN
503: x_header_rec.sold_to_org_id := TO_NUMBER(p_attr_value);
504: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_PHONE THEN
505: x_header_rec.sold_to_phone_id := TO_NUMBER(p_attr_value);
506: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT THEN
507: x_header_rec.source_document_id := TO_NUMBER(p_attr_value);
508: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT_TYPE THEN
502: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_ORG THEN
503: x_header_rec.sold_to_org_id := TO_NUMBER(p_attr_value);
504: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_PHONE THEN
505: x_header_rec.sold_to_phone_id := TO_NUMBER(p_attr_value);
506: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT THEN
507: x_header_rec.source_document_id := TO_NUMBER(p_attr_value);
508: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT_TYPE THEN
509: x_header_rec.source_document_type_id := TO_NUMBER(p_attr_value);
510: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT THEN
504: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_PHONE THEN
505: x_header_rec.sold_to_phone_id := TO_NUMBER(p_attr_value);
506: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT THEN
507: x_header_rec.source_document_id := TO_NUMBER(p_attr_value);
508: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT_TYPE THEN
509: x_header_rec.source_document_type_id := TO_NUMBER(p_attr_value);
510: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT THEN
511: x_header_rec.tax_exempt_flag := p_attr_value;
512: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_NUMBER THEN
506: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT THEN
507: x_header_rec.source_document_id := TO_NUMBER(p_attr_value);
508: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT_TYPE THEN
509: x_header_rec.source_document_type_id := TO_NUMBER(p_attr_value);
510: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT THEN
511: x_header_rec.tax_exempt_flag := p_attr_value;
512: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_NUMBER THEN
513: x_header_rec.tax_exempt_number := p_attr_value;
514: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_REASON THEN
508: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT_TYPE THEN
509: x_header_rec.source_document_type_id := TO_NUMBER(p_attr_value);
510: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT THEN
511: x_header_rec.tax_exempt_flag := p_attr_value;
512: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_NUMBER THEN
513: x_header_rec.tax_exempt_number := p_attr_value;
514: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_REASON THEN
515: x_header_rec.tax_exempt_reason_code := p_attr_value;
516: ELSIF p_attr_id = OE_Header_Util.G_TAX_POINT THEN
510: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT THEN
511: x_header_rec.tax_exempt_flag := p_attr_value;
512: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_NUMBER THEN
513: x_header_rec.tax_exempt_number := p_attr_value;
514: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_REASON THEN
515: x_header_rec.tax_exempt_reason_code := p_attr_value;
516: ELSIF p_attr_id = OE_Header_Util.G_TAX_POINT THEN
517: x_header_rec.tax_point_code := p_attr_value;
518: ELSIF p_attr_id = OE_Header_Util.G_TRANSACTIONAL_CURR THEN
512: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_NUMBER THEN
513: x_header_rec.tax_exempt_number := p_attr_value;
514: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_REASON THEN
515: x_header_rec.tax_exempt_reason_code := p_attr_value;
516: ELSIF p_attr_id = OE_Header_Util.G_TAX_POINT THEN
517: x_header_rec.tax_point_code := p_attr_value;
518: ELSIF p_attr_id = OE_Header_Util.G_TRANSACTIONAL_CURR THEN
519: x_header_rec.transactional_curr_code := p_attr_value;
520: ELSIF p_attr_id = OE_Header_Util.G_VERSION_NUMBER THEN
514: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_REASON THEN
515: x_header_rec.tax_exempt_reason_code := p_attr_value;
516: ELSIF p_attr_id = OE_Header_Util.G_TAX_POINT THEN
517: x_header_rec.tax_point_code := p_attr_value;
518: ELSIF p_attr_id = OE_Header_Util.G_TRANSACTIONAL_CURR THEN
519: x_header_rec.transactional_curr_code := p_attr_value;
520: ELSIF p_attr_id = OE_Header_Util.G_VERSION_NUMBER THEN
521: x_header_rec.version_number := TO_NUMBER(p_attr_value);
522: ELSIF p_attr_id = OE_Header_Util.G_SALESREP THEN
516: ELSIF p_attr_id = OE_Header_Util.G_TAX_POINT THEN
517: x_header_rec.tax_point_code := p_attr_value;
518: ELSIF p_attr_id = OE_Header_Util.G_TRANSACTIONAL_CURR THEN
519: x_header_rec.transactional_curr_code := p_attr_value;
520: ELSIF p_attr_id = OE_Header_Util.G_VERSION_NUMBER THEN
521: x_header_rec.version_number := TO_NUMBER(p_attr_value);
522: ELSIF p_attr_id = OE_Header_Util.G_SALESREP THEN
523: x_header_rec.salesrep_id := TO_NUMBER(p_attr_value);
524: ELSIF p_attr_id = OE_Header_Util.G_SALES_CHANNEL THEN
518: ELSIF p_attr_id = OE_Header_Util.G_TRANSACTIONAL_CURR THEN
519: x_header_rec.transactional_curr_code := p_attr_value;
520: ELSIF p_attr_id = OE_Header_Util.G_VERSION_NUMBER THEN
521: x_header_rec.version_number := TO_NUMBER(p_attr_value);
522: ELSIF p_attr_id = OE_Header_Util.G_SALESREP THEN
523: x_header_rec.salesrep_id := TO_NUMBER(p_attr_value);
524: ELSIF p_attr_id = OE_Header_Util.G_SALES_CHANNEL THEN
525: x_header_rec.sales_channel_code := p_attr_value;
526: ELSIF p_attr_id = OE_Header_Util.G_RETURN_REASON THEN
520: ELSIF p_attr_id = OE_Header_Util.G_VERSION_NUMBER THEN
521: x_header_rec.version_number := TO_NUMBER(p_attr_value);
522: ELSIF p_attr_id = OE_Header_Util.G_SALESREP THEN
523: x_header_rec.salesrep_id := TO_NUMBER(p_attr_value);
524: ELSIF p_attr_id = OE_Header_Util.G_SALES_CHANNEL THEN
525: x_header_rec.sales_channel_code := p_attr_value;
526: ELSIF p_attr_id = OE_Header_Util.G_RETURN_REASON THEN
527: x_header_rec.return_reason_code := p_attr_value;
528: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TYPE THEN
522: ELSIF p_attr_id = OE_Header_Util.G_SALESREP THEN
523: x_header_rec.salesrep_id := TO_NUMBER(p_attr_value);
524: ELSIF p_attr_id = OE_Header_Util.G_SALES_CHANNEL THEN
525: x_header_rec.sales_channel_code := p_attr_value;
526: ELSIF p_attr_id = OE_Header_Util.G_RETURN_REASON THEN
527: x_header_rec.return_reason_code := p_attr_value;
528: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TYPE THEN
529: x_header_rec.payment_type_code := p_attr_value;
530: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_AMOUNT THEN
524: ELSIF p_attr_id = OE_Header_Util.G_SALES_CHANNEL THEN
525: x_header_rec.sales_channel_code := p_attr_value;
526: ELSIF p_attr_id = OE_Header_Util.G_RETURN_REASON THEN
527: x_header_rec.return_reason_code := p_attr_value;
528: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TYPE THEN
529: x_header_rec.payment_type_code := p_attr_value;
530: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_AMOUNT THEN
531: x_header_rec.payment_amount := TO_NUMBER(p_attr_value);
532: ELSIF p_attr_id = OE_Header_Util.G_CHECK_NUMBER THEN
526: ELSIF p_attr_id = OE_Header_Util.G_RETURN_REASON THEN
527: x_header_rec.return_reason_code := p_attr_value;
528: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TYPE THEN
529: x_header_rec.payment_type_code := p_attr_value;
530: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_AMOUNT THEN
531: x_header_rec.payment_amount := TO_NUMBER(p_attr_value);
532: ELSIF p_attr_id = OE_Header_Util.G_CHECK_NUMBER THEN
533: x_header_rec.check_number := p_attr_value;
534: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD THEN
528: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TYPE THEN
529: x_header_rec.payment_type_code := p_attr_value;
530: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_AMOUNT THEN
531: x_header_rec.payment_amount := TO_NUMBER(p_attr_value);
532: ELSIF p_attr_id = OE_Header_Util.G_CHECK_NUMBER THEN
533: x_header_rec.check_number := p_attr_value;
534: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD THEN
535: x_header_rec.credit_card_code := p_attr_value;
536: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_HOLDER_NAME THEN
530: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_AMOUNT THEN
531: x_header_rec.payment_amount := TO_NUMBER(p_attr_value);
532: ELSIF p_attr_id = OE_Header_Util.G_CHECK_NUMBER THEN
533: x_header_rec.check_number := p_attr_value;
534: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD THEN
535: x_header_rec.credit_card_code := p_attr_value;
536: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_HOLDER_NAME THEN
537: x_header_rec.credit_card_holder_name := p_attr_value;
538: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_NUMBER THEN
532: ELSIF p_attr_id = OE_Header_Util.G_CHECK_NUMBER THEN
533: x_header_rec.check_number := p_attr_value;
534: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD THEN
535: x_header_rec.credit_card_code := p_attr_value;
536: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_HOLDER_NAME THEN
537: x_header_rec.credit_card_holder_name := p_attr_value;
538: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_NUMBER THEN
539: x_header_rec.credit_card_number := p_attr_value;
540: ELSIF p_attr_id = Oe_header_util.G_INSTRUMENT_SECURITY THEN--R12 CC Encryption
534: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD THEN
535: x_header_rec.credit_card_code := p_attr_value;
536: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_HOLDER_NAME THEN
537: x_header_rec.credit_card_holder_name := p_attr_value;
538: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_NUMBER THEN
539: x_header_rec.credit_card_number := p_attr_value;
540: ELSIF p_attr_id = Oe_header_util.G_INSTRUMENT_SECURITY THEN--R12 CC Encryption
541: x_header_rec.instrument_security_code := p_attr_value;
542: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT THEN
536: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_HOLDER_NAME THEN
537: x_header_rec.credit_card_holder_name := p_attr_value;
538: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_NUMBER THEN
539: x_header_rec.credit_card_number := p_attr_value;
540: ELSIF p_attr_id = Oe_header_util.G_INSTRUMENT_SECURITY THEN--R12 CC Encryption
541: x_header_rec.instrument_security_code := p_attr_value;
542: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT THEN
543: x_header_rec.CC_INSTRUMENT_ID := p_attr_value;
544: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT_ASSIGNMENT THEN
538: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_NUMBER THEN
539: x_header_rec.credit_card_number := p_attr_value;
540: ELSIF p_attr_id = Oe_header_util.G_INSTRUMENT_SECURITY THEN--R12 CC Encryption
541: x_header_rec.instrument_security_code := p_attr_value;
542: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT THEN
543: x_header_rec.CC_INSTRUMENT_ID := p_attr_value;
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
540: ELSIF p_attr_id = Oe_header_util.G_INSTRUMENT_SECURITY THEN--R12 CC Encryption
541: x_header_rec.instrument_security_code := p_attr_value;
542: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT THEN
543: x_header_rec.CC_INSTRUMENT_ID := p_attr_value;
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
542: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT THEN
543: x_header_rec.CC_INSTRUMENT_ID := p_attr_value;
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);
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
553: x_header_rec.credit_card_approval_code := p_attr_value;
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;
556: ELSIF p_attr_id = OE_Header_Util.G_FIRST_ACK_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;
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
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;
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;
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;
563: ELSIF p_attr_id = OE_Header_Util.G_PACKING_INSTRUCTIONS 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;
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
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;
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
561: ELSIF p_attr_id = OE_Header_Util.G_SHIPPING_INSTRUCTIONS THEN
562: x_header_rec.shipping_instructions := p_attr_value;
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;
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);
572: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOC_TYPE 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);
572: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOC_TYPE THEN
573: x_header_rec.contract_source_doc_type_code := p_attr_value;
574: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOCUMENT THEN
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);
572: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOC_TYPE THEN
573: x_header_rec.contract_source_doc_type_code := p_attr_value;
574: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOCUMENT THEN
575: x_header_rec.contract_source_document_id := TO_NUMBER(p_attr_value);
576: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE THEN
570: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_TEMPLATE THEN
571: x_header_rec.contract_template_id := TO_NUMBER(p_attr_value);
572: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOC_TYPE THEN
573: x_header_rec.contract_source_doc_type_code := p_attr_value;
574: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOCUMENT THEN
575: x_header_rec.contract_source_document_id := TO_NUMBER(p_attr_value);
576: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE THEN
577: x_header_rec.supplier_signature := p_attr_value;
578: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_SIGNATURE THEN
572: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOC_TYPE THEN
573: x_header_rec.contract_source_doc_type_code := p_attr_value;
574: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOCUMENT THEN
575: x_header_rec.contract_source_document_id := TO_NUMBER(p_attr_value);
576: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE THEN
577: x_header_rec.supplier_signature := p_attr_value;
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
574: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOCUMENT THEN
575: x_header_rec.contract_source_document_id := TO_NUMBER(p_attr_value);
576: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE THEN
577: x_header_rec.supplier_signature := p_attr_value;
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
576: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE THEN
577: x_header_rec.supplier_signature := p_attr_value;
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);
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
587: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE10
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
590: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
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
590: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
591: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
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
590: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
591: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
592: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
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
590: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
591: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
592: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
593: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
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
590: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
591: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
592: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
593: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
594: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
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
590: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
591: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
592: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
593: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
594: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
595: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
588: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE11
589: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12
590: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
591: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
592: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
593: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
594: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
595: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
596: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
589: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12
590: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
591: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
592: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
593: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
594: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
595: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
596: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
597: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
590: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
591: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
592: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
593: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
594: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
595: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
596: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
597: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
598: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
591: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
592: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
593: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
594: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
595: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
596: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
597: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
598: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
599: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
592: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
593: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
594: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
595: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
596: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
597: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
598: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
599: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
600: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
593: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
594: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
595: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
596: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
597: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
598: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
599: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
600: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
601: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
594: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
595: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
596: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
597: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
598: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
599: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
600: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
601: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
602: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
595: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
596: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
597: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
598: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
599: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
600: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
601: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
602: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
603: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
596: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
597: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
598: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
599: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
600: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
601: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
602: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
603: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
604: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
597: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
598: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
599: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
600: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
601: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
602: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
603: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
604: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
605: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE9
598: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
599: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
600: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
601: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
602: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
603: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
604: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
605: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE9
606: OR p_attr_id = OE_Header_Util.G_CONTEXT
599: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
600: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
601: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
602: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
603: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
604: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
605: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE9
606: OR p_attr_id = OE_Header_Util.G_CONTEXT
607: THEN
600: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
601: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
602: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
603: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
604: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
605: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE9
606: OR p_attr_id = OE_Header_Util.G_CONTEXT
607: THEN
608:
601: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
602: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
603: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
604: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
605: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE9
606: OR p_attr_id = OE_Header_Util.G_CONTEXT
607: THEN
608:
609: x_header_rec.attribute1 := p_header_dff_rec.attribute1;
602: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
603: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
604: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
605: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE9
606: OR p_attr_id = OE_Header_Util.G_CONTEXT
607: THEN
608:
609: x_header_rec.attribute1 := p_header_dff_rec.attribute1;
610: x_header_rec.attribute10 := p_header_dff_rec.attribute10;
629: x_header_rec.context := p_header_dff_rec.context;
630:
631: -- null; -- Kris get desc flec working
632:
633: ELSIF p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE1
634: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE10
635: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
636: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
637: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
630:
631: -- null; -- Kris get desc flec working
632:
633: ELSIF p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE1
634: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE10
635: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
636: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
637: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
638: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
631: -- null; -- Kris get desc flec working
632:
633: ELSIF p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE1
634: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE10
635: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
636: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
637: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
638: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
639: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
632:
633: ELSIF p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE1
634: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE10
635: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
636: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
637: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
638: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
639: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
640: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
633: ELSIF p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE1
634: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE10
635: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
636: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
637: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
638: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
639: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
640: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
641: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
634: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE10
635: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
636: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
637: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
638: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
639: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
640: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
641: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
642: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
635: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
636: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
637: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
638: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
639: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
640: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
641: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
642: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
643: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
636: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
637: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
638: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
639: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
640: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
641: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
642: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
643: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
644: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
637: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
638: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
639: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
640: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
641: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
642: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
643: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
644: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
645: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
638: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
639: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
640: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
641: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
642: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
643: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
644: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
645: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
646: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
639: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
640: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
641: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
642: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
643: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
644: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
645: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
646: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
647: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
640: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
641: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
642: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
643: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
644: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
645: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
646: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
647: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
648: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
641: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
642: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
643: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
644: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
645: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
646: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
647: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
648: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
649: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
642: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
643: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
644: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
645: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
646: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
647: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
648: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
649: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
650: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
643: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
644: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
645: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
646: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
647: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
648: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
649: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
650: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
651: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
644: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
645: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
646: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
647: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
648: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
649: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
650: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
651: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
652: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE9
645: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
646: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
647: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
648: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
649: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
650: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
651: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
652: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE9
653: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE_CATEGORY
646: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
647: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
648: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
649: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
650: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
651: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
652: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE9
653: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE_CATEGORY
654: THEN
647: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
648: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
649: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
650: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
651: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
652: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE9
653: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE_CATEGORY
654: THEN
655:
648: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
649: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
650: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
651: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
652: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE9
653: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE_CATEGORY
654: THEN
655:
656: x_header_rec.global_attribute1 := p_header_dff_rec.global_attribute1;
649: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
650: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
651: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
652: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE9
653: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE_CATEGORY
654: THEN
655:
656: x_header_rec.global_attribute1 := p_header_dff_rec.global_attribute1;
657: x_header_rec.global_attribute10 := p_header_dff_rec.global_attribute10;
675: x_header_rec.global_attribute9 := p_header_dff_rec.global_attribute9;
676: x_header_rec.global_attribute_category := p_header_dff_rec.global_attribute_category;
677:
678: null; --Kris
679: ELSIF p_attr_id = OE_Header_Util.G_TP_CONTEXT
680: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE1
681: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
682: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
683: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
676: x_header_rec.global_attribute_category := p_header_dff_rec.global_attribute_category;
677:
678: null; --Kris
679: ELSIF p_attr_id = OE_Header_Util.G_TP_CONTEXT
680: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE1
681: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
682: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
683: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
684: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
677:
678: null; --Kris
679: ELSIF p_attr_id = OE_Header_Util.G_TP_CONTEXT
680: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE1
681: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
682: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
683: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
684: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
685: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
678: null; --Kris
679: ELSIF p_attr_id = OE_Header_Util.G_TP_CONTEXT
680: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE1
681: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
682: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
683: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
684: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
685: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
686: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
679: ELSIF p_attr_id = OE_Header_Util.G_TP_CONTEXT
680: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE1
681: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
682: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
683: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
684: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
685: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
686: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
687: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
680: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE1
681: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
682: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
683: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
684: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
685: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
686: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
687: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
688: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
681: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
682: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
683: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
684: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
685: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
686: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
687: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
688: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
689: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
682: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
683: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
684: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
685: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
686: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
687: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
688: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
689: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
690: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
683: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
684: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
685: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
686: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
687: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
688: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
689: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
690: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
691: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
684: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
685: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
686: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
687: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
688: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
689: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
690: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
691: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
692: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
685: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
686: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
687: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
688: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
689: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
690: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
691: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
692: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
693: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE14
686: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
687: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
688: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
689: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
690: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
691: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
692: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
693: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE14
694: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE15
687: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
688: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
689: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
690: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
691: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
692: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
693: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE14
694: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE15
695: THEN
688: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
689: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
690: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
691: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
692: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
693: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE14
694: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE15
695: THEN
696:
689: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
690: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
691: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
692: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
693: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE14
694: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE15
695: THEN
696:
697: x_header_rec.tp_attribute1 := p_header_dff_rec.tp_attribute1;
690: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
691: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
692: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
693: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE14
694: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE15
695: THEN
696:
697: x_header_rec.tp_attribute1 := p_header_dff_rec.tp_attribute1;
698: x_header_rec.tp_attribute10 := p_header_dff_rec.tp_attribute10;
766:
767:
768: -- Load display out NOCOPY parameters if any
769:
770: x_header_val_rec := OE_Header_Util.Get_Values
771: ( p_header_rec => x_header_rec
772: , p_old_header_rec => x_old_header_rec
773: );
774:
902: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
903: BEGIN
904:
905: SAVEPOINT Header_Validate_And_Write;
906: OE_HEADER_UTIL.g_rollback_done := 'N'; -- bug 12759791
907: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.VALIDATE_AND_WRITE', 1);
908:
909: -- Set the UI flag
910: OE_GLOBALS.G_UI_FLAG := TRUE;
1056:
1057: WHEN FND_API.G_EXC_ERROR THEN
1058:
1059: OE_GLOBALS.G_UI_FLAG := FALSE;
1060: IF Nvl(OE_HEADER_UTIL.g_rollback_done,'N') <> 'Y' THEN -- bug 12759791
1061: ROLLBACK TO SAVEPOINT Header_Validate_And_Write;
1062: END IF;
1063:
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1521: l_x_header_rec.lock_control := p_lock_control;
1522: l_x_header_rec.header_id := p_header_id;
1523: l_x_header_rec.operation := OE_GLOBALS.G_OPR_LOCK; -- not req.
1524:
1525: -- Call OE_Header_Util.Lock_Row instead of Oe_Order_Pvt.Lock_order
1526:
1527: oe_debug_pub.add('header_id'|| l_x_header_rec.header_id, 1);
1528:
1529: OE_MSG_PUB.initialize;
1526:
1527: oe_debug_pub.add('header_id'|| l_x_header_rec.header_id, 1);
1528:
1529: OE_MSG_PUB.initialize;
1530: OE_Header_Util.Lock_Row
1531: ( x_return_status => l_return_status
1532: , p_x_header_rec => l_x_header_rec );
1533:
1534: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1648: THEN
1649:
1650: -- Query row from DB
1651:
1652: OE_Header_Util.Query_Row
1653: ( p_header_id => p_header_id,
1654: x_header_rec =>g_header_rec
1655: );
1656:
2650:
2651: -- bug 5414929
2652: -- IF l_credit_card_number is null
2653: IF l_trxn_extension_id is not null THEN
2654: OE_Header_Util.Query_card_details
2655: (p_header_id => p_header_rec_type.header_id,
2656: p_credit_card_code => l_credit_card_code,
2657: p_credit_card_holder_name => l_credit_card_holder_name,
2658: p_credit_card_number => l_credit_card_number,
2673: x_header_val_rec.instrument_security_code := l_instrument_security_code;
2674: x_header_val_rec.cc_instrument_id := l_instrument_id;
2675: x_header_val_rec.cc_instrument_assignment_id := l_instrument_assignment_id;
2676:
2677: oe_debug_pub.add('After calling OE_Header_Util.Query_card_details');
2678: oe_debug_pub.add('Security code'||x_header_val_rec.instrument_security_code);
2679: --oe_debug_pub.add('Credit card code in populate control fields'||x_header_val_rec.credit_card_code);
2680: BEGIN
2681: IF x_header_val_rec.credit_card_code is not null then
3618: --
3619: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3620: --
3621: BEGIN
3622: IF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE THEN
3623: x_header_rec.accounting_rule_id := TO_NUMBER(p_attr_value);
3624: ELSIF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE_DURATION THEN
3625: x_header_rec.accounting_rule_duration := TO_NUMBER(p_attr_value);
3626: ELSIF p_attr_id = OE_Header_Util.G_AGREEMENT THEN
3620: --
3621: BEGIN
3622: IF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE THEN
3623: x_header_rec.accounting_rule_id := TO_NUMBER(p_attr_value);
3624: ELSIF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE_DURATION THEN
3625: x_header_rec.accounting_rule_duration := TO_NUMBER(p_attr_value);
3626: ELSIF p_attr_id = OE_Header_Util.G_AGREEMENT THEN
3627: x_header_rec.agreement_id := TO_NUMBER(p_attr_value);
3628: ELSIF p_attr_id = OE_Header_Util.G_BLANKET_NUMBER THEN
3622: IF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE THEN
3623: x_header_rec.accounting_rule_id := TO_NUMBER(p_attr_value);
3624: ELSIF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE_DURATION THEN
3625: x_header_rec.accounting_rule_duration := TO_NUMBER(p_attr_value);
3626: ELSIF p_attr_id = OE_Header_Util.G_AGREEMENT THEN
3627: x_header_rec.agreement_id := TO_NUMBER(p_attr_value);
3628: ELSIF p_attr_id = OE_Header_Util.G_BLANKET_NUMBER THEN
3629: x_header_rec.blanket_number := TO_NUMBER(p_attr_value);
3630: --kmuruges
3624: ELSIF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE_DURATION THEN
3625: x_header_rec.accounting_rule_duration := TO_NUMBER(p_attr_value);
3626: ELSIF p_attr_id = OE_Header_Util.G_AGREEMENT THEN
3627: x_header_rec.agreement_id := TO_NUMBER(p_attr_value);
3628: ELSIF p_attr_id = OE_Header_Util.G_BLANKET_NUMBER THEN
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);
3627: x_header_rec.agreement_id := TO_NUMBER(p_attr_value);
3628: ELSIF p_attr_id = OE_Header_Util.G_BLANKET_NUMBER THEN
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);
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;
3638: ELSIF p_attr_id = OE_Header_Util.G_transaction_phase 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;
3638: ELSIF p_attr_id = OE_Header_Util.G_transaction_phase THEN
3639: x_header_rec.transaction_phase_code := p_attr_value;
3640: ELSIF p_attr_id = OE_Header_Util.G_user_status THEN
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;
3638: ELSIF p_attr_id = OE_Header_Util.G_transaction_phase THEN
3639: x_header_rec.transaction_phase_code := p_attr_value;
3640: ELSIF p_attr_id = OE_Header_Util.G_user_status THEN
3641: x_header_rec.user_status_code := p_attr_value;
3642: ELSIF p_attr_id = OE_Header_Util.G_draft_submitted THEN
3636: ELSIF p_attr_id = OE_Header_Util.G_sales_document_name THEN
3637: x_header_rec.sales_document_name := p_attr_value;
3638: ELSIF p_attr_id = OE_Header_Util.G_transaction_phase THEN
3639: x_header_rec.transaction_phase_code := p_attr_value;
3640: ELSIF p_attr_id = OE_Header_Util.G_user_status THEN
3641: x_header_rec.user_status_code := p_attr_value;
3642: ELSIF p_attr_id = OE_Header_Util.G_draft_submitted THEN
3643: x_header_rec.draft_submitted_flag := p_attr_value;
3644: ELSIF p_attr_id = OE_Header_Util.G_source_document_version THEN
3638: ELSIF p_attr_id = OE_Header_Util.G_transaction_phase THEN
3639: x_header_rec.transaction_phase_code := p_attr_value;
3640: ELSIF p_attr_id = OE_Header_Util.G_user_status THEN
3641: x_header_rec.user_status_code := p_attr_value;
3642: ELSIF p_attr_id = OE_Header_Util.G_draft_submitted THEN
3643: x_header_rec.draft_submitted_flag := p_attr_value;
3644: ELSIF p_attr_id = OE_Header_Util.G_source_document_version THEN
3645: x_header_rec.source_document_version_number := TO_NUMBER(p_attr_value);
3646: ELSIF p_attr_id = OE_Header_Util.G_sold_to_site_use THEN
3640: ELSIF p_attr_id = OE_Header_Util.G_user_status THEN
3641: x_header_rec.user_status_code := p_attr_value;
3642: ELSIF p_attr_id = OE_Header_Util.G_draft_submitted THEN
3643: x_header_rec.draft_submitted_flag := p_attr_value;
3644: ELSIF p_attr_id = OE_Header_Util.G_source_document_version THEN
3645: x_header_rec.source_document_version_number := TO_NUMBER(p_attr_value);
3646: ELSIF p_attr_id = OE_Header_Util.G_sold_to_site_use THEN
3647: x_header_rec.sold_to_site_use_id := TO_NUMBER(p_attr_value);
3648:
3642: ELSIF p_attr_id = OE_Header_Util.G_draft_submitted THEN
3643: x_header_rec.draft_submitted_flag := p_attr_value;
3644: ELSIF p_attr_id = OE_Header_Util.G_source_document_version THEN
3645: x_header_rec.source_document_version_number := TO_NUMBER(p_attr_value);
3646: ELSIF p_attr_id = OE_Header_Util.G_sold_to_site_use THEN
3647: x_header_rec.sold_to_site_use_id := TO_NUMBER(p_attr_value);
3648:
3649: ELSIF p_attr_id = OE_Header_Util.G_ib_owner THEN
3650: x_header_rec.ib_owner := p_attr_value;
3645: x_header_rec.source_document_version_number := TO_NUMBER(p_attr_value);
3646: ELSIF p_attr_id = OE_Header_Util.G_sold_to_site_use THEN
3647: x_header_rec.sold_to_site_use_id := TO_NUMBER(p_attr_value);
3648:
3649: ELSIF p_attr_id = OE_Header_Util.G_ib_owner THEN
3650: x_header_rec.ib_owner := p_attr_value;
3651: ELSIF p_attr_id = OE_Header_Util.G_ib_installed_at_location THEN
3652: x_header_rec.ib_installed_at_location := p_attr_value;
3653: ELSIF p_attr_id = OE_Header_Util.G_ib_current_location THEN
3647: x_header_rec.sold_to_site_use_id := TO_NUMBER(p_attr_value);
3648:
3649: ELSIF p_attr_id = OE_Header_Util.G_ib_owner THEN
3650: x_header_rec.ib_owner := p_attr_value;
3651: ELSIF p_attr_id = OE_Header_Util.G_ib_installed_at_location THEN
3652: x_header_rec.ib_installed_at_location := p_attr_value;
3653: ELSIF p_attr_id = OE_Header_Util.G_ib_current_location THEN
3654: x_header_rec.ib_current_location := p_attr_value;
3655: ELSIF p_attr_id = OE_Header_Util.G_end_customer_site_use THEN
3649: ELSIF p_attr_id = OE_Header_Util.G_ib_owner THEN
3650: x_header_rec.ib_owner := p_attr_value;
3651: ELSIF p_attr_id = OE_Header_Util.G_ib_installed_at_location THEN
3652: x_header_rec.ib_installed_at_location := p_attr_value;
3653: ELSIF p_attr_id = OE_Header_Util.G_ib_current_location THEN
3654: x_header_rec.ib_current_location := p_attr_value;
3655: ELSIF p_attr_id = OE_Header_Util.G_end_customer_site_use THEN
3656: x_header_rec.end_customer_site_use_id := TO_NUMBER(p_attr_value);
3657: ELSIF p_attr_id = OE_Header_Util.G_end_customer_contact THEN
3651: ELSIF p_attr_id = OE_Header_Util.G_ib_installed_at_location THEN
3652: x_header_rec.ib_installed_at_location := p_attr_value;
3653: ELSIF p_attr_id = OE_Header_Util.G_ib_current_location THEN
3654: x_header_rec.ib_current_location := p_attr_value;
3655: ELSIF p_attr_id = OE_Header_Util.G_end_customer_site_use THEN
3656: x_header_rec.end_customer_site_use_id := TO_NUMBER(p_attr_value);
3657: ELSIF p_attr_id = OE_Header_Util.G_end_customer_contact THEN
3658: x_header_rec.end_customer_contact_id := TO_NUMBER(p_attr_value);
3659: ELSIF p_attr_id = OE_Header_Util.G_end_customer THEN
3653: ELSIF p_attr_id = OE_Header_Util.G_ib_current_location THEN
3654: x_header_rec.ib_current_location := p_attr_value;
3655: ELSIF p_attr_id = OE_Header_Util.G_end_customer_site_use THEN
3656: x_header_rec.end_customer_site_use_id := TO_NUMBER(p_attr_value);
3657: ELSIF p_attr_id = OE_Header_Util.G_end_customer_contact THEN
3658: x_header_rec.end_customer_contact_id := TO_NUMBER(p_attr_value);
3659: ELSIF p_attr_id = OE_Header_Util.G_end_customer THEN
3660: x_header_rec.end_customer_id := TO_NUMBER(p_attr_value);
3661: --kmuruges end
3655: ELSIF p_attr_id = OE_Header_Util.G_end_customer_site_use THEN
3656: x_header_rec.end_customer_site_use_id := TO_NUMBER(p_attr_value);
3657: ELSIF p_attr_id = OE_Header_Util.G_end_customer_contact THEN
3658: x_header_rec.end_customer_contact_id := TO_NUMBER(p_attr_value);
3659: ELSIF p_attr_id = OE_Header_Util.G_end_customer THEN
3660: x_header_rec.end_customer_id := TO_NUMBER(p_attr_value);
3661: --kmuruges end
3662: ELSIF p_attr_id = OE_Header_Util.G_BOOKED THEN
3663: x_header_rec.booked_flag := p_attr_value;
3658: x_header_rec.end_customer_contact_id := TO_NUMBER(p_attr_value);
3659: ELSIF p_attr_id = OE_Header_Util.G_end_customer THEN
3660: x_header_rec.end_customer_id := TO_NUMBER(p_attr_value);
3661: --kmuruges end
3662: ELSIF p_attr_id = OE_Header_Util.G_BOOKED THEN
3663: x_header_rec.booked_flag := p_attr_value;
3664: ELSIF p_attr_id = OE_Header_Util.G_BOOKED_DATE THEN
3665: x_header_rec.booked_date := p_attr_value;
3666: ELSIF p_attr_id = OE_Header_Util.G_CANCELLED THEN
3660: x_header_rec.end_customer_id := TO_NUMBER(p_attr_value);
3661: --kmuruges end
3662: ELSIF p_attr_id = OE_Header_Util.G_BOOKED THEN
3663: x_header_rec.booked_flag := p_attr_value;
3664: ELSIF p_attr_id = OE_Header_Util.G_BOOKED_DATE THEN
3665: x_header_rec.booked_date := p_attr_value;
3666: ELSIF p_attr_id = OE_Header_Util.G_CANCELLED THEN
3667: x_header_rec.cancelled_flag := p_attr_value;
3668: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_RATE THEN
3662: ELSIF p_attr_id = OE_Header_Util.G_BOOKED THEN
3663: x_header_rec.booked_flag := p_attr_value;
3664: ELSIF p_attr_id = OE_Header_Util.G_BOOKED_DATE THEN
3665: x_header_rec.booked_date := p_attr_value;
3666: ELSIF p_attr_id = OE_Header_Util.G_CANCELLED THEN
3667: x_header_rec.cancelled_flag := p_attr_value;
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
3664: ELSIF p_attr_id = OE_Header_Util.G_BOOKED_DATE THEN
3665: x_header_rec.booked_date := p_attr_value;
3666: ELSIF p_attr_id = OE_Header_Util.G_CANCELLED THEN
3667: x_header_rec.cancelled_flag := p_attr_value;
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
3666: ELSIF p_attr_id = OE_Header_Util.G_CANCELLED THEN
3667: x_header_rec.cancelled_flag := p_attr_value;
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;
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;
3677: ELSIF p_attr_id = OE_Header_Util.G_CUST_PO_NUMBER 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;
3677: ELSIF p_attr_id = OE_Header_Util.G_CUST_PO_NUMBER THEN
3678: x_header_rec.cust_po_number := p_attr_value;
3679: ELSIF p_attr_id = OE_Header_Util.G_DEFAULT_FULFILLMENT_SET THEN
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;
3677: ELSIF p_attr_id = OE_Header_Util.G_CUST_PO_NUMBER THEN
3678: x_header_rec.cust_po_number := p_attr_value;
3679: ELSIF p_attr_id = OE_Header_Util.G_DEFAULT_FULFILLMENT_SET THEN
3680: x_header_rec.DEFAULT_FULFILLMENT_SET := p_attr_value;
3681: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_CONTACT THEN
3675: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_PREFERENCE_SET THEN
3676: x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := p_attr_value;
3677: ELSIF p_attr_id = OE_Header_Util.G_CUST_PO_NUMBER THEN
3678: x_header_rec.cust_po_number := p_attr_value;
3679: ELSIF p_attr_id = OE_Header_Util.G_DEFAULT_FULFILLMENT_SET THEN
3680: x_header_rec.DEFAULT_FULFILLMENT_SET := p_attr_value;
3681: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_CONTACT THEN
3682: x_header_rec.deliver_to_contact_id := TO_NUMBER(p_attr_value);
3683: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_ORG THEN
3677: ELSIF p_attr_id = OE_Header_Util.G_CUST_PO_NUMBER THEN
3678: x_header_rec.cust_po_number := p_attr_value;
3679: ELSIF p_attr_id = OE_Header_Util.G_DEFAULT_FULFILLMENT_SET THEN
3680: x_header_rec.DEFAULT_FULFILLMENT_SET := p_attr_value;
3681: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_CONTACT THEN
3682: x_header_rec.deliver_to_contact_id := TO_NUMBER(p_attr_value);
3683: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_ORG THEN
3684: x_header_rec.deliver_to_org_id := TO_NUMBER(p_attr_value);
3685: ELSIF p_attr_id = OE_Header_Util.G_DEMAND_CLASS THEN
3679: ELSIF p_attr_id = OE_Header_Util.G_DEFAULT_FULFILLMENT_SET THEN
3680: x_header_rec.DEFAULT_FULFILLMENT_SET := p_attr_value;
3681: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_CONTACT THEN
3682: x_header_rec.deliver_to_contact_id := TO_NUMBER(p_attr_value);
3683: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_ORG THEN
3684: x_header_rec.deliver_to_org_id := TO_NUMBER(p_attr_value);
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
3681: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_CONTACT THEN
3682: x_header_rec.deliver_to_contact_id := TO_NUMBER(p_attr_value);
3683: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_ORG THEN
3684: x_header_rec.deliver_to_org_id := TO_NUMBER(p_attr_value);
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
3683: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_ORG THEN
3684: x_header_rec.deliver_to_org_id := TO_NUMBER(p_attr_value);
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);
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;
3694: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_CARRIER 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;
3694: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_CARRIER THEN
3695: x_header_rec.freight_carrier_code := p_attr_value;
3696: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_TERMS THEN
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;
3694: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_CARRIER THEN
3695: x_header_rec.freight_carrier_code := p_attr_value;
3696: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_TERMS THEN
3697: x_header_rec.freight_terms_code := p_attr_value;
3698: ELSIF p_attr_id = OE_Header_Util.G_FULFILLMENT_SET_NAME THEN
3692: ELSIF p_attr_id = OE_Header_Util.G_FOB_POINT THEN
3693: x_header_rec.fob_point_code := p_attr_value;
3694: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_CARRIER THEN
3695: x_header_rec.freight_carrier_code := p_attr_value;
3696: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_TERMS THEN
3697: x_header_rec.freight_terms_code := p_attr_value;
3698: ELSIF p_attr_id = OE_Header_Util.G_FULFILLMENT_SET_NAME THEN
3699: x_header_rec.FULFILLMENT_SET_NAME := p_attr_value;
3700: ELSIF p_attr_id = OE_Header_Util.G_HEADER THEN
3694: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_CARRIER THEN
3695: x_header_rec.freight_carrier_code := p_attr_value;
3696: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_TERMS THEN
3697: x_header_rec.freight_terms_code := p_attr_value;
3698: ELSIF p_attr_id = OE_Header_Util.G_FULFILLMENT_SET_NAME THEN
3699: x_header_rec.FULFILLMENT_SET_NAME := p_attr_value;
3700: ELSIF p_attr_id = OE_Header_Util.G_HEADER THEN
3701: x_header_rec.header_id := TO_NUMBER(p_attr_value);
3702: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_CONTACT THEN
3696: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_TERMS THEN
3697: x_header_rec.freight_terms_code := p_attr_value;
3698: ELSIF p_attr_id = OE_Header_Util.G_FULFILLMENT_SET_NAME THEN
3699: x_header_rec.FULFILLMENT_SET_NAME := p_attr_value;
3700: ELSIF p_attr_id = OE_Header_Util.G_HEADER THEN
3701: x_header_rec.header_id := TO_NUMBER(p_attr_value);
3702: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_CONTACT THEN
3703: x_header_rec.invoice_to_contact_id := TO_NUMBER(p_attr_value);
3704: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_ORG THEN
3698: ELSIF p_attr_id = OE_Header_Util.G_FULFILLMENT_SET_NAME THEN
3699: x_header_rec.FULFILLMENT_SET_NAME := p_attr_value;
3700: ELSIF p_attr_id = OE_Header_Util.G_HEADER THEN
3701: x_header_rec.header_id := TO_NUMBER(p_attr_value);
3702: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_CONTACT THEN
3703: x_header_rec.invoice_to_contact_id := TO_NUMBER(p_attr_value);
3704: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_ORG THEN
3705: x_header_rec.invoice_to_org_id := TO_NUMBER(p_attr_value);
3706: ELSIF p_attr_id = OE_Header_Util.G_INVOICING_RULE THEN
3700: ELSIF p_attr_id = OE_Header_Util.G_HEADER THEN
3701: x_header_rec.header_id := TO_NUMBER(p_attr_value);
3702: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_CONTACT THEN
3703: x_header_rec.invoice_to_contact_id := TO_NUMBER(p_attr_value);
3704: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_ORG THEN
3705: x_header_rec.invoice_to_org_id := TO_NUMBER(p_attr_value);
3706: ELSIF p_attr_id = OE_Header_Util.G_INVOICING_RULE THEN
3707: x_header_rec.invoicing_rule_id := TO_NUMBER(p_attr_value);
3708: ELSIF p_attr_id = OE_Header_Util.G_LATEST_SCHEDULE_LIMIT THEN
3702: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_CONTACT THEN
3703: x_header_rec.invoice_to_contact_id := TO_NUMBER(p_attr_value);
3704: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_ORG THEN
3705: x_header_rec.invoice_to_org_id := TO_NUMBER(p_attr_value);
3706: ELSIF p_attr_id = OE_Header_Util.G_INVOICING_RULE THEN
3707: x_header_rec.invoicing_rule_id := TO_NUMBER(p_attr_value);
3708: ELSIF p_attr_id = OE_Header_Util.G_LATEST_SCHEDULE_LIMIT THEN
3709: x_header_rec.latest_schedule_limit := TO_NUMBER(p_attr_value);
3710: ELSIF p_attr_id = OE_Header_Util.G_LINE_SET_NAME THEN
3704: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_ORG THEN
3705: x_header_rec.invoice_to_org_id := TO_NUMBER(p_attr_value);
3706: ELSIF p_attr_id = OE_Header_Util.G_INVOICING_RULE THEN
3707: x_header_rec.invoicing_rule_id := TO_NUMBER(p_attr_value);
3708: ELSIF p_attr_id = OE_Header_Util.G_LATEST_SCHEDULE_LIMIT THEN
3709: x_header_rec.latest_schedule_limit := TO_NUMBER(p_attr_value);
3710: ELSIF p_attr_id = OE_Header_Util.G_LINE_SET_NAME THEN
3711: x_header_rec.LINE_SET_NAME := p_attr_value;
3712: ELSIF p_attr_id = OE_Header_Util.G_OPEN THEN
3706: ELSIF p_attr_id = OE_Header_Util.G_INVOICING_RULE THEN
3707: x_header_rec.invoicing_rule_id := TO_NUMBER(p_attr_value);
3708: ELSIF p_attr_id = OE_Header_Util.G_LATEST_SCHEDULE_LIMIT THEN
3709: x_header_rec.latest_schedule_limit := TO_NUMBER(p_attr_value);
3710: ELSIF p_attr_id = OE_Header_Util.G_LINE_SET_NAME THEN
3711: x_header_rec.LINE_SET_NAME := p_attr_value;
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
3708: ELSIF p_attr_id = OE_Header_Util.G_LATEST_SCHEDULE_LIMIT THEN
3709: x_header_rec.latest_schedule_limit := TO_NUMBER(p_attr_value);
3710: ELSIF p_attr_id = OE_Header_Util.G_LINE_SET_NAME THEN
3711: x_header_rec.LINE_SET_NAME := p_attr_value;
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
3710: ELSIF p_attr_id = OE_Header_Util.G_LINE_SET_NAME THEN
3711: x_header_rec.LINE_SET_NAME := p_attr_value;
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;
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);
3721: ELSIF p_attr_id = OE_Header_Util.G_ORDER_SOURCE 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);
3721: ELSIF p_attr_id = OE_Header_Util.G_ORDER_SOURCE THEN
3722: x_header_rec.order_source_id := TO_NUMBER(p_attr_value);
3723: ELSIF p_attr_id = OE_Header_Util.G_ORDER_TYPE THEN
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);
3721: ELSIF p_attr_id = OE_Header_Util.G_ORDER_SOURCE THEN
3722: x_header_rec.order_source_id := TO_NUMBER(p_attr_value);
3723: ELSIF p_attr_id = OE_Header_Util.G_ORDER_TYPE THEN
3724: x_header_rec.order_type_id := TO_NUMBER(p_attr_value);
3725: ELSIF p_attr_id = OE_Header_Util.G_ORG THEN
3719: ELSIF p_attr_id = OE_Header_Util.G_ORDER_NUMBER THEN
3720: x_header_rec.order_number := TO_NUMBER(p_attr_value);
3721: ELSIF p_attr_id = OE_Header_Util.G_ORDER_SOURCE THEN
3722: x_header_rec.order_source_id := TO_NUMBER(p_attr_value);
3723: ELSIF p_attr_id = OE_Header_Util.G_ORDER_TYPE THEN
3724: x_header_rec.order_type_id := TO_NUMBER(p_attr_value);
3725: ELSIF p_attr_id = OE_Header_Util.G_ORG THEN
3726: x_header_rec.org_id := TO_NUMBER(p_attr_value);
3727: ELSIF p_attr_id = OE_Header_Util.G_ORIG_SYS_DOCUMENT_REF THEN
3721: ELSIF p_attr_id = OE_Header_Util.G_ORDER_SOURCE THEN
3722: x_header_rec.order_source_id := TO_NUMBER(p_attr_value);
3723: ELSIF p_attr_id = OE_Header_Util.G_ORDER_TYPE THEN
3724: x_header_rec.order_type_id := TO_NUMBER(p_attr_value);
3725: ELSIF p_attr_id = OE_Header_Util.G_ORG THEN
3726: x_header_rec.org_id := TO_NUMBER(p_attr_value);
3727: ELSIF p_attr_id = OE_Header_Util.G_ORIG_SYS_DOCUMENT_REF THEN
3728: x_header_rec.orig_sys_document_ref := p_attr_value;
3729: ELSIF p_attr_id = OE_Header_Util.G_PARTIAL_SHIPMENTS_ALLOWED THEN
3723: ELSIF p_attr_id = OE_Header_Util.G_ORDER_TYPE THEN
3724: x_header_rec.order_type_id := TO_NUMBER(p_attr_value);
3725: ELSIF p_attr_id = OE_Header_Util.G_ORG THEN
3726: x_header_rec.org_id := TO_NUMBER(p_attr_value);
3727: ELSIF p_attr_id = OE_Header_Util.G_ORIG_SYS_DOCUMENT_REF THEN
3728: x_header_rec.orig_sys_document_ref := p_attr_value;
3729: ELSIF p_attr_id = OE_Header_Util.G_PARTIAL_SHIPMENTS_ALLOWED THEN
3730: x_header_rec.partial_shipments_allowed := p_attr_value;
3731: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TERM THEN
3725: ELSIF p_attr_id = OE_Header_Util.G_ORG THEN
3726: x_header_rec.org_id := TO_NUMBER(p_attr_value);
3727: ELSIF p_attr_id = OE_Header_Util.G_ORIG_SYS_DOCUMENT_REF THEN
3728: x_header_rec.orig_sys_document_ref := p_attr_value;
3729: ELSIF p_attr_id = OE_Header_Util.G_PARTIAL_SHIPMENTS_ALLOWED THEN
3730: x_header_rec.partial_shipments_allowed := p_attr_value;
3731: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TERM THEN
3732: x_header_rec.payment_term_id := TO_NUMBER(p_attr_value);
3733: ELSIF p_attr_id = OE_Header_Util.G_PRICE_LIST THEN
3727: ELSIF p_attr_id = OE_Header_Util.G_ORIG_SYS_DOCUMENT_REF THEN
3728: x_header_rec.orig_sys_document_ref := p_attr_value;
3729: ELSIF p_attr_id = OE_Header_Util.G_PARTIAL_SHIPMENTS_ALLOWED THEN
3730: x_header_rec.partial_shipments_allowed := p_attr_value;
3731: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TERM THEN
3732: x_header_rec.payment_term_id := TO_NUMBER(p_attr_value);
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
3729: ELSIF p_attr_id = OE_Header_Util.G_PARTIAL_SHIPMENTS_ALLOWED THEN
3730: x_header_rec.partial_shipments_allowed := p_attr_value;
3731: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TERM THEN
3732: x_header_rec.payment_term_id := TO_NUMBER(p_attr_value);
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
3731: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TERM THEN
3732: x_header_rec.payment_term_id := TO_NUMBER(p_attr_value);
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);
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
3742: x_header_rec.shipment_priority_code := p_attr_value;
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;
3745: ELSIF p_attr_id = OE_Header_Util.G_SHIP_FROM_ORG 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;
3745: ELSIF p_attr_id = OE_Header_Util.G_SHIP_FROM_ORG THEN
3746: x_header_rec.ship_from_org_id := TO_NUMBER(p_attr_value);
3747: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_ABOVE THEN
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;
3745: ELSIF p_attr_id = OE_Header_Util.G_SHIP_FROM_ORG THEN
3746: x_header_rec.ship_from_org_id := TO_NUMBER(p_attr_value);
3747: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_ABOVE THEN
3748: x_header_rec.ship_tolerance_above := TO_NUMBER(p_attr_value);
3749: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_BELOW THEN
3743: ELSIF p_attr_id = OE_Header_Util.G_SHIPPING_METHOD THEN
3744: x_header_rec.shipping_method_code := p_attr_value;
3745: ELSIF p_attr_id = OE_Header_Util.G_SHIP_FROM_ORG THEN
3746: x_header_rec.ship_from_org_id := TO_NUMBER(p_attr_value);
3747: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_ABOVE THEN
3748: x_header_rec.ship_tolerance_above := TO_NUMBER(p_attr_value);
3749: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_BELOW THEN
3750: x_header_rec.ship_tolerance_below := TO_NUMBER(p_attr_value);
3751: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_CONTACT THEN
3745: ELSIF p_attr_id = OE_Header_Util.G_SHIP_FROM_ORG THEN
3746: x_header_rec.ship_from_org_id := TO_NUMBER(p_attr_value);
3747: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_ABOVE THEN
3748: x_header_rec.ship_tolerance_above := TO_NUMBER(p_attr_value);
3749: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_BELOW THEN
3750: x_header_rec.ship_tolerance_below := TO_NUMBER(p_attr_value);
3751: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_CONTACT THEN
3752: x_header_rec.ship_to_contact_id := TO_NUMBER(p_attr_value);
3753: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_ORG THEN
3747: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_ABOVE THEN
3748: x_header_rec.ship_tolerance_above := TO_NUMBER(p_attr_value);
3749: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_BELOW THEN
3750: x_header_rec.ship_tolerance_below := TO_NUMBER(p_attr_value);
3751: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_CONTACT THEN
3752: x_header_rec.ship_to_contact_id := TO_NUMBER(p_attr_value);
3753: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_ORG THEN
3754: x_header_rec.ship_to_org_id := TO_NUMBER(p_attr_value);
3755: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_CONTACT THEN
3749: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_BELOW THEN
3750: x_header_rec.ship_tolerance_below := TO_NUMBER(p_attr_value);
3751: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_CONTACT THEN
3752: x_header_rec.ship_to_contact_id := TO_NUMBER(p_attr_value);
3753: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_ORG THEN
3754: x_header_rec.ship_to_org_id := TO_NUMBER(p_attr_value);
3755: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_CONTACT THEN
3756: x_header_rec.sold_to_contact_id := TO_NUMBER(p_attr_value);
3757: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_ORG THEN
3751: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_CONTACT THEN
3752: x_header_rec.ship_to_contact_id := TO_NUMBER(p_attr_value);
3753: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_ORG THEN
3754: x_header_rec.ship_to_org_id := TO_NUMBER(p_attr_value);
3755: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_CONTACT THEN
3756: x_header_rec.sold_to_contact_id := TO_NUMBER(p_attr_value);
3757: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_ORG THEN
3758: x_header_rec.sold_to_org_id := TO_NUMBER(p_attr_value);
3759: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_PHONE THEN
3753: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_ORG THEN
3754: x_header_rec.ship_to_org_id := TO_NUMBER(p_attr_value);
3755: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_CONTACT THEN
3756: x_header_rec.sold_to_contact_id := TO_NUMBER(p_attr_value);
3757: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_ORG THEN
3758: x_header_rec.sold_to_org_id := TO_NUMBER(p_attr_value);
3759: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_PHONE THEN
3760: x_header_rec.sold_to_phone_id := TO_NUMBER(p_attr_value);
3761: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT THEN
3755: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_CONTACT THEN
3756: x_header_rec.sold_to_contact_id := TO_NUMBER(p_attr_value);
3757: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_ORG THEN
3758: x_header_rec.sold_to_org_id := TO_NUMBER(p_attr_value);
3759: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_PHONE THEN
3760: x_header_rec.sold_to_phone_id := TO_NUMBER(p_attr_value);
3761: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT THEN
3762: x_header_rec.source_document_id := TO_NUMBER(p_attr_value);
3763: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT_TYPE THEN
3757: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_ORG THEN
3758: x_header_rec.sold_to_org_id := TO_NUMBER(p_attr_value);
3759: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_PHONE THEN
3760: x_header_rec.sold_to_phone_id := TO_NUMBER(p_attr_value);
3761: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT THEN
3762: x_header_rec.source_document_id := TO_NUMBER(p_attr_value);
3763: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT_TYPE THEN
3764: x_header_rec.source_document_type_id := TO_NUMBER(p_attr_value);
3765: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT THEN
3759: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_PHONE THEN
3760: x_header_rec.sold_to_phone_id := TO_NUMBER(p_attr_value);
3761: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT THEN
3762: x_header_rec.source_document_id := TO_NUMBER(p_attr_value);
3763: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT_TYPE THEN
3764: x_header_rec.source_document_type_id := TO_NUMBER(p_attr_value);
3765: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT THEN
3766: x_header_rec.tax_exempt_flag := p_attr_value;
3767: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_NUMBER THEN
3761: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT THEN
3762: x_header_rec.source_document_id := TO_NUMBER(p_attr_value);
3763: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT_TYPE THEN
3764: x_header_rec.source_document_type_id := TO_NUMBER(p_attr_value);
3765: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT THEN
3766: x_header_rec.tax_exempt_flag := p_attr_value;
3767: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_NUMBER THEN
3768: x_header_rec.tax_exempt_number := p_attr_value;
3769: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_REASON THEN
3763: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT_TYPE THEN
3764: x_header_rec.source_document_type_id := TO_NUMBER(p_attr_value);
3765: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT THEN
3766: x_header_rec.tax_exempt_flag := p_attr_value;
3767: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_NUMBER THEN
3768: x_header_rec.tax_exempt_number := p_attr_value;
3769: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_REASON THEN
3770: x_header_rec.tax_exempt_reason_code := p_attr_value;
3771: ELSIF p_attr_id = OE_Header_Util.G_TAX_POINT THEN
3765: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT THEN
3766: x_header_rec.tax_exempt_flag := p_attr_value;
3767: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_NUMBER THEN
3768: x_header_rec.tax_exempt_number := p_attr_value;
3769: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_REASON THEN
3770: x_header_rec.tax_exempt_reason_code := p_attr_value;
3771: ELSIF p_attr_id = OE_Header_Util.G_TAX_POINT THEN
3772: x_header_rec.tax_point_code := p_attr_value;
3773: ELSIF p_attr_id = OE_Header_Util.G_TRANSACTIONAL_CURR THEN
3767: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_NUMBER THEN
3768: x_header_rec.tax_exempt_number := p_attr_value;
3769: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_REASON THEN
3770: x_header_rec.tax_exempt_reason_code := p_attr_value;
3771: ELSIF p_attr_id = OE_Header_Util.G_TAX_POINT THEN
3772: x_header_rec.tax_point_code := p_attr_value;
3773: ELSIF p_attr_id = OE_Header_Util.G_TRANSACTIONAL_CURR THEN
3774: x_header_rec.transactional_curr_code := p_attr_value;
3775: ELSIF p_attr_id = OE_Header_Util.G_VERSION_NUMBER THEN
3769: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_REASON THEN
3770: x_header_rec.tax_exempt_reason_code := p_attr_value;
3771: ELSIF p_attr_id = OE_Header_Util.G_TAX_POINT THEN
3772: x_header_rec.tax_point_code := p_attr_value;
3773: ELSIF p_attr_id = OE_Header_Util.G_TRANSACTIONAL_CURR THEN
3774: x_header_rec.transactional_curr_code := p_attr_value;
3775: ELSIF p_attr_id = OE_Header_Util.G_VERSION_NUMBER THEN
3776: x_header_rec.version_number := TO_NUMBER(p_attr_value);
3777: ELSIF p_attr_id = OE_Header_Util.G_SALESREP THEN
3771: ELSIF p_attr_id = OE_Header_Util.G_TAX_POINT THEN
3772: x_header_rec.tax_point_code := p_attr_value;
3773: ELSIF p_attr_id = OE_Header_Util.G_TRANSACTIONAL_CURR THEN
3774: x_header_rec.transactional_curr_code := p_attr_value;
3775: ELSIF p_attr_id = OE_Header_Util.G_VERSION_NUMBER THEN
3776: x_header_rec.version_number := TO_NUMBER(p_attr_value);
3777: ELSIF p_attr_id = OE_Header_Util.G_SALESREP THEN
3778: x_header_rec.salesrep_id := TO_NUMBER(p_attr_value);
3779: ELSIF p_attr_id = OE_Header_Util.G_SALES_CHANNEL THEN
3773: ELSIF p_attr_id = OE_Header_Util.G_TRANSACTIONAL_CURR THEN
3774: x_header_rec.transactional_curr_code := p_attr_value;
3775: ELSIF p_attr_id = OE_Header_Util.G_VERSION_NUMBER THEN
3776: x_header_rec.version_number := TO_NUMBER(p_attr_value);
3777: ELSIF p_attr_id = OE_Header_Util.G_SALESREP THEN
3778: x_header_rec.salesrep_id := TO_NUMBER(p_attr_value);
3779: ELSIF p_attr_id = OE_Header_Util.G_SALES_CHANNEL THEN
3780: x_header_rec.sales_channel_code := p_attr_value;
3781: ELSIF p_attr_id = OE_Header_Util.G_RETURN_REASON THEN
3775: ELSIF p_attr_id = OE_Header_Util.G_VERSION_NUMBER THEN
3776: x_header_rec.version_number := TO_NUMBER(p_attr_value);
3777: ELSIF p_attr_id = OE_Header_Util.G_SALESREP THEN
3778: x_header_rec.salesrep_id := TO_NUMBER(p_attr_value);
3779: ELSIF p_attr_id = OE_Header_Util.G_SALES_CHANNEL THEN
3780: x_header_rec.sales_channel_code := p_attr_value;
3781: ELSIF p_attr_id = OE_Header_Util.G_RETURN_REASON THEN
3782: x_header_rec.return_reason_code := p_attr_value;
3783: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TYPE THEN
3777: ELSIF p_attr_id = OE_Header_Util.G_SALESREP THEN
3778: x_header_rec.salesrep_id := TO_NUMBER(p_attr_value);
3779: ELSIF p_attr_id = OE_Header_Util.G_SALES_CHANNEL THEN
3780: x_header_rec.sales_channel_code := p_attr_value;
3781: ELSIF p_attr_id = OE_Header_Util.G_RETURN_REASON THEN
3782: x_header_rec.return_reason_code := p_attr_value;
3783: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TYPE THEN
3784: x_header_rec.payment_type_code := p_attr_value;
3785: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_AMOUNT THEN
3779: ELSIF p_attr_id = OE_Header_Util.G_SALES_CHANNEL THEN
3780: x_header_rec.sales_channel_code := p_attr_value;
3781: ELSIF p_attr_id = OE_Header_Util.G_RETURN_REASON THEN
3782: x_header_rec.return_reason_code := p_attr_value;
3783: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TYPE THEN
3784: x_header_rec.payment_type_code := p_attr_value;
3785: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_AMOUNT THEN
3786: x_header_rec.payment_amount := TO_NUMBER(p_attr_value);
3787: ELSIF p_attr_id = OE_Header_Util.G_CHECK_NUMBER THEN
3781: ELSIF p_attr_id = OE_Header_Util.G_RETURN_REASON THEN
3782: x_header_rec.return_reason_code := p_attr_value;
3783: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TYPE THEN
3784: x_header_rec.payment_type_code := p_attr_value;
3785: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_AMOUNT THEN
3786: x_header_rec.payment_amount := TO_NUMBER(p_attr_value);
3787: ELSIF p_attr_id = OE_Header_Util.G_CHECK_NUMBER THEN
3788: x_header_rec.check_number := p_attr_value;
3789: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD THEN
3783: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TYPE THEN
3784: x_header_rec.payment_type_code := p_attr_value;
3785: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_AMOUNT THEN
3786: x_header_rec.payment_amount := TO_NUMBER(p_attr_value);
3787: ELSIF p_attr_id = OE_Header_Util.G_CHECK_NUMBER THEN
3788: x_header_rec.check_number := p_attr_value;
3789: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD THEN
3790: x_header_rec.credit_card_code := p_attr_value;
3791: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_HOLDER_NAME THEN
3785: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_AMOUNT THEN
3786: x_header_rec.payment_amount := TO_NUMBER(p_attr_value);
3787: ELSIF p_attr_id = OE_Header_Util.G_CHECK_NUMBER THEN
3788: x_header_rec.check_number := p_attr_value;
3789: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD THEN
3790: x_header_rec.credit_card_code := p_attr_value;
3791: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_HOLDER_NAME THEN
3792: x_header_rec.credit_card_holder_name := p_attr_value;
3793: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_NUMBER THEN
3787: ELSIF p_attr_id = OE_Header_Util.G_CHECK_NUMBER THEN
3788: x_header_rec.check_number := p_attr_value;
3789: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD THEN
3790: x_header_rec.credit_card_code := p_attr_value;
3791: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_HOLDER_NAME THEN
3792: x_header_rec.credit_card_holder_name := p_attr_value;
3793: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_NUMBER THEN
3794: x_header_rec.credit_card_number := p_attr_value;
3795: ELSIF p_attr_id = Oe_header_util.G_INSTRUMENT_SECURITY THEN--R12 CC Encryption
3789: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD THEN
3790: x_header_rec.credit_card_code := p_attr_value;
3791: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_HOLDER_NAME THEN
3792: x_header_rec.credit_card_holder_name := p_attr_value;
3793: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_NUMBER THEN
3794: x_header_rec.credit_card_number := p_attr_value;
3795: ELSIF p_attr_id = Oe_header_util.G_INSTRUMENT_SECURITY THEN--R12 CC Encryption
3796: x_header_rec.instrument_security_code := p_attr_value;
3797: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT THEN
3791: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_HOLDER_NAME THEN
3792: x_header_rec.credit_card_holder_name := p_attr_value;
3793: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_NUMBER THEN
3794: x_header_rec.credit_card_number := p_attr_value;
3795: ELSIF p_attr_id = Oe_header_util.G_INSTRUMENT_SECURITY THEN--R12 CC Encryption
3796: x_header_rec.instrument_security_code := p_attr_value;
3797: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT THEN
3798: x_header_rec.CC_INSTRUMENT_ID := p_attr_value;
3799: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT_ASSIGNMENT THEN
3793: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_NUMBER THEN
3794: x_header_rec.credit_card_number := p_attr_value;
3795: ELSIF p_attr_id = Oe_header_util.G_INSTRUMENT_SECURITY THEN--R12 CC Encryption
3796: x_header_rec.instrument_security_code := p_attr_value;
3797: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT THEN
3798: x_header_rec.CC_INSTRUMENT_ID := p_attr_value;
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
3795: ELSIF p_attr_id = Oe_header_util.G_INSTRUMENT_SECURITY THEN--R12 CC Encryption
3796: x_header_rec.instrument_security_code := p_attr_value;
3797: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT THEN
3798: x_header_rec.CC_INSTRUMENT_ID := p_attr_value;
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
3797: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT THEN
3798: x_header_rec.CC_INSTRUMENT_ID := p_attr_value;
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);
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
3808: x_header_rec.credit_card_approval_code := p_attr_value;
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;
3811: ELSIF p_attr_id = OE_Header_Util.G_FIRST_ACK_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;
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
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;
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;
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;
3818: ELSIF p_attr_id = OE_Header_Util.G_PACKING_INSTRUCTIONS 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;
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
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;
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
3816: ELSIF p_attr_id = OE_Header_Util.G_SHIPPING_INSTRUCTIONS THEN
3817: x_header_rec.shipping_instructions := p_attr_value;
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;
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
3827: x_header_rec.contract_template_id := TO_NUMBER(p_attr_value);
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
3827: x_header_rec.contract_template_id := TO_NUMBER(p_attr_value);
3828:
3829: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOC_TYPE THEN
3830: x_header_rec.contract_source_doc_type_code := p_attr_value;
3825:
3826: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_TEMPLATE THEN
3827: x_header_rec.contract_template_id := TO_NUMBER(p_attr_value);
3828:
3829: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOC_TYPE THEN
3830: x_header_rec.contract_source_doc_type_code := p_attr_value;
3831:
3832: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOCUMENT THEN
3833: x_header_rec.contract_source_document_id := TO_NUMBER(p_attr_value);
3828:
3829: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOC_TYPE THEN
3830: x_header_rec.contract_source_doc_type_code := p_attr_value;
3831:
3832: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOCUMENT THEN
3833: x_header_rec.contract_source_document_id := TO_NUMBER(p_attr_value);
3834:
3835: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE THEN
3836: x_header_rec.supplier_signature := p_attr_value;
3831:
3832: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOCUMENT THEN
3833: x_header_rec.contract_source_document_id := TO_NUMBER(p_attr_value);
3834:
3835: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE THEN
3836: x_header_rec.supplier_signature := p_attr_value;
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
3833: x_header_rec.contract_source_document_id := TO_NUMBER(p_attr_value);
3834:
3835: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE THEN
3836: x_header_rec.supplier_signature := p_attr_value;
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
3835: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE THEN
3836: x_header_rec.supplier_signature := p_attr_value;
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);
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:
3846: ELSIF p_attr_id = OE_Header_Util.G_ATTRIBUTE1
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
3849: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12
3850: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
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
3849: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12
3850: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
3851: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
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
3849: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12
3850: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
3851: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
3852: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
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
3849: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12
3850: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
3851: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
3852: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
3853: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
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
3849: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12
3850: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
3851: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
3852: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
3853: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
3854: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
3847: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE10
3848: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE11
3849: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12
3850: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
3851: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
3852: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
3853: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
3854: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
3855: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
3848: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE11
3849: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12
3850: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
3851: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
3852: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
3853: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
3854: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
3855: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
3856: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
3849: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12
3850: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
3851: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
3852: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
3853: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
3854: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
3855: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
3856: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
3857: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
3850: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
3851: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
3852: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
3853: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
3854: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
3855: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
3856: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
3857: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
3858: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
3851: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
3852: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
3853: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
3854: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
3855: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
3856: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
3857: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
3858: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
3859: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
3852: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
3853: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
3854: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
3855: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
3856: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
3857: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
3858: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
3859: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
3860: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
3853: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
3854: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
3855: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
3856: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
3857: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
3858: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
3859: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
3860: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
3861: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
3854: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
3855: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
3856: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
3857: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
3858: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
3859: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
3860: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
3861: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
3862: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
3855: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
3856: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
3857: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
3858: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
3859: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
3860: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
3861: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
3862: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
3863: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
3856: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
3857: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
3858: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
3859: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
3860: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
3861: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
3862: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
3863: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
3864: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
3857: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
3858: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
3859: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
3860: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
3861: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
3862: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
3863: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
3864: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
3865: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE9
3858: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
3859: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
3860: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
3861: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
3862: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
3863: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
3864: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
3865: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE9
3866: OR p_attr_id = OE_Header_Util.G_CONTEXT
3859: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
3860: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
3861: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
3862: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
3863: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
3864: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
3865: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE9
3866: OR p_attr_id = OE_Header_Util.G_CONTEXT
3867: THEN
3860: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
3861: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
3862: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
3863: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
3864: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
3865: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE9
3866: OR p_attr_id = OE_Header_Util.G_CONTEXT
3867: THEN
3868:
3861: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
3862: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
3863: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
3864: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
3865: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE9
3866: OR p_attr_id = OE_Header_Util.G_CONTEXT
3867: THEN
3868:
3869: x_header_rec.attribute1 := p_header_dff_rec.attribute1;
3862: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
3863: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
3864: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
3865: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE9
3866: OR p_attr_id = OE_Header_Util.G_CONTEXT
3867: THEN
3868:
3869: x_header_rec.attribute1 := p_header_dff_rec.attribute1;
3870: x_header_rec.attribute10 := p_header_dff_rec.attribute10;
3889: x_header_rec.context := p_header_dff_rec.context;
3890:
3891: -- null; -- Kris get desc flec working
3892:
3893: ELSIF p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE1
3894: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE10
3895: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
3896: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
3897: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
3890:
3891: -- null; -- Kris get desc flec working
3892:
3893: ELSIF p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE1
3894: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE10
3895: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
3896: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
3897: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
3898: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
3891: -- null; -- Kris get desc flec working
3892:
3893: ELSIF p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE1
3894: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE10
3895: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
3896: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
3897: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
3898: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
3899: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
3892:
3893: ELSIF p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE1
3894: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE10
3895: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
3896: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
3897: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
3898: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
3899: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
3900: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
3893: ELSIF p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE1
3894: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE10
3895: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
3896: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
3897: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
3898: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
3899: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
3900: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
3901: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
3894: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE10
3895: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
3896: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
3897: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
3898: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
3899: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
3900: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
3901: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
3902: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
3895: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
3896: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
3897: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
3898: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
3899: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
3900: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
3901: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
3902: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
3903: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
3896: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
3897: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
3898: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
3899: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
3900: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
3901: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
3902: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
3903: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
3904: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
3897: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
3898: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
3899: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
3900: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
3901: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
3902: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
3903: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
3904: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
3905: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
3898: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
3899: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
3900: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
3901: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
3902: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
3903: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
3904: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
3905: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
3906: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
3899: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
3900: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
3901: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
3902: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
3903: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
3904: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
3905: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
3906: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
3907: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
3900: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
3901: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
3902: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
3903: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
3904: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
3905: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
3906: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
3907: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
3908: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
3901: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
3902: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
3903: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
3904: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
3905: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
3906: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
3907: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
3908: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
3909: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
3902: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
3903: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
3904: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
3905: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
3906: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
3907: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
3908: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
3909: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
3910: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
3903: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
3904: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
3905: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
3906: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
3907: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
3908: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
3909: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
3910: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
3911: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
3904: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
3905: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
3906: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
3907: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
3908: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
3909: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
3910: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
3911: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
3912: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE9
3905: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
3906: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
3907: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
3908: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
3909: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
3910: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
3911: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
3912: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE9
3913: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE_CATEGORY
3906: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
3907: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
3908: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
3909: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
3910: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
3911: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
3912: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE9
3913: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE_CATEGORY
3914: THEN
3907: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
3908: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
3909: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
3910: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
3911: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
3912: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE9
3913: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE_CATEGORY
3914: THEN
3915:
3908: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
3909: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
3910: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
3911: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
3912: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE9
3913: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE_CATEGORY
3914: THEN
3915:
3916: x_header_rec.global_attribute1 := p_header_dff_rec.global_attribute1;
3909: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
3910: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
3911: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
3912: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE9
3913: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE_CATEGORY
3914: THEN
3915:
3916: x_header_rec.global_attribute1 := p_header_dff_rec.global_attribute1;
3917: x_header_rec.global_attribute10 := p_header_dff_rec.global_attribute10;
3935: x_header_rec.global_attribute9 := p_header_dff_rec.global_attribute9;
3936: x_header_rec.global_attribute_category := p_header_dff_rec.global_attribute_category;
3937:
3938: null; --Kris
3939: ELSIF p_attr_id = OE_Header_Util.G_TP_CONTEXT
3940: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE1
3941: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
3942: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
3943: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
3936: x_header_rec.global_attribute_category := p_header_dff_rec.global_attribute_category;
3937:
3938: null; --Kris
3939: ELSIF p_attr_id = OE_Header_Util.G_TP_CONTEXT
3940: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE1
3941: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
3942: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
3943: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
3944: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
3937:
3938: null; --Kris
3939: ELSIF p_attr_id = OE_Header_Util.G_TP_CONTEXT
3940: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE1
3941: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
3942: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
3943: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
3944: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
3945: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
3938: null; --Kris
3939: ELSIF p_attr_id = OE_Header_Util.G_TP_CONTEXT
3940: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE1
3941: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
3942: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
3943: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
3944: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
3945: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
3946: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
3939: ELSIF p_attr_id = OE_Header_Util.G_TP_CONTEXT
3940: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE1
3941: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
3942: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
3943: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
3944: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
3945: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
3946: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
3947: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
3940: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE1
3941: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
3942: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
3943: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
3944: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
3945: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
3946: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
3947: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
3948: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
3941: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
3942: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
3943: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
3944: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
3945: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
3946: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
3947: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
3948: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
3949: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
3942: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
3943: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
3944: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
3945: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
3946: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
3947: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
3948: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
3949: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
3950: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
3943: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
3944: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
3945: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
3946: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
3947: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
3948: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
3949: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
3950: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
3951: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
3944: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
3945: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
3946: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
3947: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
3948: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
3949: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
3950: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
3951: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
3952: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
3945: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
3946: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
3947: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
3948: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
3949: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
3950: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
3951: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
3952: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
3953: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE14
3946: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
3947: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
3948: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
3949: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
3950: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
3951: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
3952: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
3953: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE14
3954: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE15
3947: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
3948: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
3949: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
3950: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
3951: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
3952: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
3953: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE14
3954: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE15
3955: THEN
3948: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
3949: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
3950: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
3951: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
3952: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
3953: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE14
3954: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE15
3955: THEN
3956:
3949: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
3950: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
3951: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
3952: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
3953: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE14
3954: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE15
3955: THEN
3956:
3957: x_header_rec.tp_attribute1 := p_header_dff_rec.tp_attribute1;
3950: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
3951: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
3952: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
3953: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE14
3954: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE15
3955: THEN
3956:
3957: x_header_rec.tp_attribute1 := p_header_dff_rec.tp_attribute1;
3958: x_header_rec.tp_attribute10 := p_header_dff_rec.tp_attribute10;
4309: -- Initializing return status to SUCCESS
4310: x_return_status := FND_API.G_RET_STS_SUCCESS;
4311:
4312: IF p_header_id IS NOT NULL THEN
4313: OE_Header_Util.Query_Row
4314: ( p_header_id => p_header_id,
4315: x_header_rec =>l_header_rec
4316: );
4317: END IF;
4317: END IF;
4318:
4319: l_header_rec.operation :=p_operation;
4320:
4321: OE_HEADER_UTIL.API_Rec_To_Rowtype_Rec(l_header_rec,l_rowtype_rec);
4322:
4323: -- Initialize security global record
4324: OE_Header_SECURITY.g_record := l_rowtype_rec;
4325: