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:
1520: l_x_header_rec.lock_control := p_lock_control;
1521: l_x_header_rec.header_id := p_header_id;
1522: l_x_header_rec.operation := OE_GLOBALS.G_OPR_LOCK; -- not req.
1523:
1524: -- Call OE_Header_Util.Lock_Row instead of Oe_Order_Pvt.Lock_order
1525:
1526: oe_debug_pub.add('header_id'|| l_x_header_rec.header_id, 1);
1527:
1528: OE_MSG_PUB.initialize;
1525:
1526: oe_debug_pub.add('header_id'|| l_x_header_rec.header_id, 1);
1527:
1528: OE_MSG_PUB.initialize;
1529: OE_Header_Util.Lock_Row
1530: ( x_return_status => l_return_status
1531: , p_x_header_rec => l_x_header_rec );
1532:
1533: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1647: THEN
1648:
1649: -- Query row from DB
1650:
1651: OE_Header_Util.Query_Row
1652: ( p_header_id => p_header_id,
1653: x_header_rec =>g_header_rec
1654: );
1655:
2649:
2650: -- bug 5414929
2651: -- IF l_credit_card_number is null
2652: IF l_trxn_extension_id is not null THEN
2653: OE_Header_Util.Query_card_details
2654: (p_header_id => p_header_rec_type.header_id,
2655: p_credit_card_code => l_credit_card_code,
2656: p_credit_card_holder_name => l_credit_card_holder_name,
2657: p_credit_card_number => l_credit_card_number,
2672: x_header_val_rec.instrument_security_code := l_instrument_security_code;
2673: x_header_val_rec.cc_instrument_id := l_instrument_id;
2674: x_header_val_rec.cc_instrument_assignment_id := l_instrument_assignment_id;
2675:
2676: oe_debug_pub.add('After calling OE_Header_Util.Query_card_details');
2677: oe_debug_pub.add('Security code'||x_header_val_rec.instrument_security_code);
2678: oe_debug_pub.add('Credit card code in populate control fields'||x_header_val_rec.credit_card_code);
2679: BEGIN
2680: IF x_header_val_rec.credit_card_code is not null then
3615: --
3616: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3617: --
3618: BEGIN
3619: IF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE THEN
3620: x_header_rec.accounting_rule_id := TO_NUMBER(p_attr_value);
3621: ELSIF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE_DURATION THEN
3622: x_header_rec.accounting_rule_duration := TO_NUMBER(p_attr_value);
3623: ELSIF p_attr_id = OE_Header_Util.G_AGREEMENT THEN
3617: --
3618: BEGIN
3619: IF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE THEN
3620: x_header_rec.accounting_rule_id := TO_NUMBER(p_attr_value);
3621: ELSIF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE_DURATION THEN
3622: x_header_rec.accounting_rule_duration := TO_NUMBER(p_attr_value);
3623: ELSIF p_attr_id = OE_Header_Util.G_AGREEMENT THEN
3624: x_header_rec.agreement_id := TO_NUMBER(p_attr_value);
3625: ELSIF p_attr_id = OE_Header_Util.G_BLANKET_NUMBER THEN
3619: IF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE THEN
3620: x_header_rec.accounting_rule_id := TO_NUMBER(p_attr_value);
3621: ELSIF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE_DURATION THEN
3622: x_header_rec.accounting_rule_duration := TO_NUMBER(p_attr_value);
3623: ELSIF p_attr_id = OE_Header_Util.G_AGREEMENT THEN
3624: x_header_rec.agreement_id := TO_NUMBER(p_attr_value);
3625: ELSIF p_attr_id = OE_Header_Util.G_BLANKET_NUMBER THEN
3626: x_header_rec.blanket_number := TO_NUMBER(p_attr_value);
3627: --kmuruges
3621: ELSIF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE_DURATION THEN
3622: x_header_rec.accounting_rule_duration := TO_NUMBER(p_attr_value);
3623: ELSIF p_attr_id = OE_Header_Util.G_AGREEMENT THEN
3624: x_header_rec.agreement_id := TO_NUMBER(p_attr_value);
3625: ELSIF p_attr_id = OE_Header_Util.G_BLANKET_NUMBER THEN
3626: x_header_rec.blanket_number := TO_NUMBER(p_attr_value);
3627: --kmuruges
3628: ELSIF p_attr_id = OE_Header_Util.G_quote_date THEN
3629: -- x_header_rec.quote_date := TO_DATE(p_attr_value,l_date_format_mask);
3624: x_header_rec.agreement_id := TO_NUMBER(p_attr_value);
3625: ELSIF p_attr_id = OE_Header_Util.G_BLANKET_NUMBER THEN
3626: x_header_rec.blanket_number := TO_NUMBER(p_attr_value);
3627: --kmuruges
3628: ELSIF p_attr_id = OE_Header_Util.G_quote_date THEN
3629: -- x_header_rec.quote_date := TO_DATE(p_attr_value,l_date_format_mask);
3630: x_header_rec.quote_date := fnd_date.string_to_date(p_attr_value,l_date_format_mask); --bug5402396
3631: ELSIF p_attr_id = OE_Header_Util.G_quote_number THEN
3632: x_header_rec.quote_number := TO_NUMBER(p_attr_value);
3627: --kmuruges
3628: ELSIF p_attr_id = OE_Header_Util.G_quote_date THEN
3629: -- x_header_rec.quote_date := TO_DATE(p_attr_value,l_date_format_mask);
3630: x_header_rec.quote_date := fnd_date.string_to_date(p_attr_value,l_date_format_mask); --bug5402396
3631: ELSIF p_attr_id = OE_Header_Util.G_quote_number THEN
3632: x_header_rec.quote_number := TO_NUMBER(p_attr_value);
3633: ELSIF p_attr_id = OE_Header_Util.G_sales_document_name THEN
3634: x_header_rec.sales_document_name := p_attr_value;
3635: ELSIF p_attr_id = OE_Header_Util.G_transaction_phase THEN
3629: -- x_header_rec.quote_date := TO_DATE(p_attr_value,l_date_format_mask);
3630: x_header_rec.quote_date := fnd_date.string_to_date(p_attr_value,l_date_format_mask); --bug5402396
3631: ELSIF p_attr_id = OE_Header_Util.G_quote_number THEN
3632: x_header_rec.quote_number := TO_NUMBER(p_attr_value);
3633: ELSIF p_attr_id = OE_Header_Util.G_sales_document_name THEN
3634: x_header_rec.sales_document_name := p_attr_value;
3635: ELSIF p_attr_id = OE_Header_Util.G_transaction_phase THEN
3636: x_header_rec.transaction_phase_code := p_attr_value;
3637: ELSIF p_attr_id = OE_Header_Util.G_user_status THEN
3631: ELSIF p_attr_id = OE_Header_Util.G_quote_number THEN
3632: x_header_rec.quote_number := TO_NUMBER(p_attr_value);
3633: ELSIF p_attr_id = OE_Header_Util.G_sales_document_name THEN
3634: x_header_rec.sales_document_name := p_attr_value;
3635: ELSIF p_attr_id = OE_Header_Util.G_transaction_phase THEN
3636: x_header_rec.transaction_phase_code := p_attr_value;
3637: ELSIF p_attr_id = OE_Header_Util.G_user_status THEN
3638: x_header_rec.user_status_code := p_attr_value;
3639: ELSIF p_attr_id = OE_Header_Util.G_draft_submitted THEN
3633: ELSIF p_attr_id = OE_Header_Util.G_sales_document_name THEN
3634: x_header_rec.sales_document_name := p_attr_value;
3635: ELSIF p_attr_id = OE_Header_Util.G_transaction_phase THEN
3636: x_header_rec.transaction_phase_code := p_attr_value;
3637: ELSIF p_attr_id = OE_Header_Util.G_user_status THEN
3638: x_header_rec.user_status_code := p_attr_value;
3639: ELSIF p_attr_id = OE_Header_Util.G_draft_submitted THEN
3640: x_header_rec.draft_submitted_flag := p_attr_value;
3641: ELSIF p_attr_id = OE_Header_Util.G_source_document_version THEN
3635: ELSIF p_attr_id = OE_Header_Util.G_transaction_phase THEN
3636: x_header_rec.transaction_phase_code := p_attr_value;
3637: ELSIF p_attr_id = OE_Header_Util.G_user_status THEN
3638: x_header_rec.user_status_code := p_attr_value;
3639: ELSIF p_attr_id = OE_Header_Util.G_draft_submitted THEN
3640: x_header_rec.draft_submitted_flag := p_attr_value;
3641: ELSIF p_attr_id = OE_Header_Util.G_source_document_version THEN
3642: x_header_rec.source_document_version_number := TO_NUMBER(p_attr_value);
3643: ELSIF p_attr_id = OE_Header_Util.G_sold_to_site_use THEN
3637: ELSIF p_attr_id = OE_Header_Util.G_user_status THEN
3638: x_header_rec.user_status_code := p_attr_value;
3639: ELSIF p_attr_id = OE_Header_Util.G_draft_submitted THEN
3640: x_header_rec.draft_submitted_flag := p_attr_value;
3641: ELSIF p_attr_id = OE_Header_Util.G_source_document_version THEN
3642: x_header_rec.source_document_version_number := TO_NUMBER(p_attr_value);
3643: ELSIF p_attr_id = OE_Header_Util.G_sold_to_site_use THEN
3644: x_header_rec.sold_to_site_use_id := TO_NUMBER(p_attr_value);
3645:
3639: ELSIF p_attr_id = OE_Header_Util.G_draft_submitted THEN
3640: x_header_rec.draft_submitted_flag := p_attr_value;
3641: ELSIF p_attr_id = OE_Header_Util.G_source_document_version THEN
3642: x_header_rec.source_document_version_number := TO_NUMBER(p_attr_value);
3643: ELSIF p_attr_id = OE_Header_Util.G_sold_to_site_use THEN
3644: x_header_rec.sold_to_site_use_id := TO_NUMBER(p_attr_value);
3645:
3646: ELSIF p_attr_id = OE_Header_Util.G_ib_owner THEN
3647: x_header_rec.ib_owner := p_attr_value;
3642: x_header_rec.source_document_version_number := TO_NUMBER(p_attr_value);
3643: ELSIF p_attr_id = OE_Header_Util.G_sold_to_site_use THEN
3644: x_header_rec.sold_to_site_use_id := TO_NUMBER(p_attr_value);
3645:
3646: ELSIF p_attr_id = OE_Header_Util.G_ib_owner THEN
3647: x_header_rec.ib_owner := p_attr_value;
3648: ELSIF p_attr_id = OE_Header_Util.G_ib_installed_at_location THEN
3649: x_header_rec.ib_installed_at_location := p_attr_value;
3650: ELSIF p_attr_id = OE_Header_Util.G_ib_current_location THEN
3644: x_header_rec.sold_to_site_use_id := TO_NUMBER(p_attr_value);
3645:
3646: ELSIF p_attr_id = OE_Header_Util.G_ib_owner THEN
3647: x_header_rec.ib_owner := p_attr_value;
3648: ELSIF p_attr_id = OE_Header_Util.G_ib_installed_at_location THEN
3649: x_header_rec.ib_installed_at_location := p_attr_value;
3650: ELSIF p_attr_id = OE_Header_Util.G_ib_current_location THEN
3651: x_header_rec.ib_current_location := p_attr_value;
3652: ELSIF p_attr_id = OE_Header_Util.G_end_customer_site_use THEN
3646: ELSIF p_attr_id = OE_Header_Util.G_ib_owner THEN
3647: x_header_rec.ib_owner := p_attr_value;
3648: ELSIF p_attr_id = OE_Header_Util.G_ib_installed_at_location THEN
3649: x_header_rec.ib_installed_at_location := p_attr_value;
3650: ELSIF p_attr_id = OE_Header_Util.G_ib_current_location THEN
3651: x_header_rec.ib_current_location := p_attr_value;
3652: ELSIF p_attr_id = OE_Header_Util.G_end_customer_site_use THEN
3653: x_header_rec.end_customer_site_use_id := TO_NUMBER(p_attr_value);
3654: ELSIF p_attr_id = OE_Header_Util.G_end_customer_contact THEN
3648: ELSIF p_attr_id = OE_Header_Util.G_ib_installed_at_location THEN
3649: x_header_rec.ib_installed_at_location := p_attr_value;
3650: ELSIF p_attr_id = OE_Header_Util.G_ib_current_location THEN
3651: x_header_rec.ib_current_location := p_attr_value;
3652: ELSIF p_attr_id = OE_Header_Util.G_end_customer_site_use THEN
3653: x_header_rec.end_customer_site_use_id := TO_NUMBER(p_attr_value);
3654: ELSIF p_attr_id = OE_Header_Util.G_end_customer_contact THEN
3655: x_header_rec.end_customer_contact_id := TO_NUMBER(p_attr_value);
3656: ELSIF p_attr_id = OE_Header_Util.G_end_customer THEN
3650: ELSIF p_attr_id = OE_Header_Util.G_ib_current_location THEN
3651: x_header_rec.ib_current_location := p_attr_value;
3652: ELSIF p_attr_id = OE_Header_Util.G_end_customer_site_use THEN
3653: x_header_rec.end_customer_site_use_id := TO_NUMBER(p_attr_value);
3654: ELSIF p_attr_id = OE_Header_Util.G_end_customer_contact THEN
3655: x_header_rec.end_customer_contact_id := TO_NUMBER(p_attr_value);
3656: ELSIF p_attr_id = OE_Header_Util.G_end_customer THEN
3657: x_header_rec.end_customer_id := TO_NUMBER(p_attr_value);
3658: --kmuruges end
3652: ELSIF p_attr_id = OE_Header_Util.G_end_customer_site_use THEN
3653: x_header_rec.end_customer_site_use_id := TO_NUMBER(p_attr_value);
3654: ELSIF p_attr_id = OE_Header_Util.G_end_customer_contact THEN
3655: x_header_rec.end_customer_contact_id := TO_NUMBER(p_attr_value);
3656: ELSIF p_attr_id = OE_Header_Util.G_end_customer THEN
3657: x_header_rec.end_customer_id := TO_NUMBER(p_attr_value);
3658: --kmuruges end
3659: ELSIF p_attr_id = OE_Header_Util.G_BOOKED THEN
3660: x_header_rec.booked_flag := p_attr_value;
3655: x_header_rec.end_customer_contact_id := TO_NUMBER(p_attr_value);
3656: ELSIF p_attr_id = OE_Header_Util.G_end_customer THEN
3657: x_header_rec.end_customer_id := TO_NUMBER(p_attr_value);
3658: --kmuruges end
3659: ELSIF p_attr_id = OE_Header_Util.G_BOOKED THEN
3660: x_header_rec.booked_flag := p_attr_value;
3661: ELSIF p_attr_id = OE_Header_Util.G_BOOKED_DATE THEN
3662: x_header_rec.booked_date := p_attr_value;
3663: ELSIF p_attr_id = OE_Header_Util.G_CANCELLED THEN
3657: x_header_rec.end_customer_id := TO_NUMBER(p_attr_value);
3658: --kmuruges end
3659: ELSIF p_attr_id = OE_Header_Util.G_BOOKED THEN
3660: x_header_rec.booked_flag := p_attr_value;
3661: ELSIF p_attr_id = OE_Header_Util.G_BOOKED_DATE THEN
3662: x_header_rec.booked_date := p_attr_value;
3663: ELSIF p_attr_id = OE_Header_Util.G_CANCELLED THEN
3664: x_header_rec.cancelled_flag := p_attr_value;
3665: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_RATE THEN
3659: ELSIF p_attr_id = OE_Header_Util.G_BOOKED THEN
3660: x_header_rec.booked_flag := p_attr_value;
3661: ELSIF p_attr_id = OE_Header_Util.G_BOOKED_DATE THEN
3662: x_header_rec.booked_date := p_attr_value;
3663: ELSIF p_attr_id = OE_Header_Util.G_CANCELLED THEN
3664: x_header_rec.cancelled_flag := p_attr_value;
3665: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_RATE THEN
3666: x_header_rec.conversion_rate := TO_NUMBER(p_attr_value);
3667: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_RATE_DATE THEN
3661: ELSIF p_attr_id = OE_Header_Util.G_BOOKED_DATE THEN
3662: x_header_rec.booked_date := p_attr_value;
3663: ELSIF p_attr_id = OE_Header_Util.G_CANCELLED THEN
3664: x_header_rec.cancelled_flag := p_attr_value;
3665: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_RATE THEN
3666: x_header_rec.conversion_rate := TO_NUMBER(p_attr_value);
3667: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_RATE_DATE THEN
3668: --x_header_rec.conversion_rate_date := TO_DATE(p_attr_value,l_date_format_mask);
3669: x_header_rec.conversion_rate_date := fnd_date.string_to_date(p_attr_value,l_date_format_mask); --bug5402396
3663: ELSIF p_attr_id = OE_Header_Util.G_CANCELLED THEN
3664: x_header_rec.cancelled_flag := p_attr_value;
3665: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_RATE THEN
3666: x_header_rec.conversion_rate := TO_NUMBER(p_attr_value);
3667: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_RATE_DATE THEN
3668: --x_header_rec.conversion_rate_date := TO_DATE(p_attr_value,l_date_format_mask);
3669: x_header_rec.conversion_rate_date := fnd_date.string_to_date(p_attr_value,l_date_format_mask); --bug5402396
3670: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_TYPE THEN
3671: x_header_rec.conversion_type_code := p_attr_value;
3666: x_header_rec.conversion_rate := TO_NUMBER(p_attr_value);
3667: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_RATE_DATE THEN
3668: --x_header_rec.conversion_rate_date := TO_DATE(p_attr_value,l_date_format_mask);
3669: x_header_rec.conversion_rate_date := fnd_date.string_to_date(p_attr_value,l_date_format_mask); --bug5402396
3670: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_TYPE THEN
3671: x_header_rec.conversion_type_code := p_attr_value;
3672: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_PREFERENCE_SET THEN
3673: x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := p_attr_value;
3674: ELSIF p_attr_id = OE_Header_Util.G_CUST_PO_NUMBER THEN
3668: --x_header_rec.conversion_rate_date := TO_DATE(p_attr_value,l_date_format_mask);
3669: x_header_rec.conversion_rate_date := fnd_date.string_to_date(p_attr_value,l_date_format_mask); --bug5402396
3670: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_TYPE THEN
3671: x_header_rec.conversion_type_code := p_attr_value;
3672: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_PREFERENCE_SET THEN
3673: x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := p_attr_value;
3674: ELSIF p_attr_id = OE_Header_Util.G_CUST_PO_NUMBER THEN
3675: x_header_rec.cust_po_number := p_attr_value;
3676: ELSIF p_attr_id = OE_Header_Util.G_DEFAULT_FULFILLMENT_SET THEN
3670: ELSIF p_attr_id = OE_Header_Util.G_CONVERSION_TYPE THEN
3671: x_header_rec.conversion_type_code := p_attr_value;
3672: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_PREFERENCE_SET THEN
3673: x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := p_attr_value;
3674: ELSIF p_attr_id = OE_Header_Util.G_CUST_PO_NUMBER THEN
3675: x_header_rec.cust_po_number := p_attr_value;
3676: ELSIF p_attr_id = OE_Header_Util.G_DEFAULT_FULFILLMENT_SET THEN
3677: x_header_rec.DEFAULT_FULFILLMENT_SET := p_attr_value;
3678: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_CONTACT THEN
3672: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_PREFERENCE_SET THEN
3673: x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := p_attr_value;
3674: ELSIF p_attr_id = OE_Header_Util.G_CUST_PO_NUMBER THEN
3675: x_header_rec.cust_po_number := p_attr_value;
3676: ELSIF p_attr_id = OE_Header_Util.G_DEFAULT_FULFILLMENT_SET THEN
3677: x_header_rec.DEFAULT_FULFILLMENT_SET := p_attr_value;
3678: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_CONTACT THEN
3679: x_header_rec.deliver_to_contact_id := TO_NUMBER(p_attr_value);
3680: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_ORG THEN
3674: ELSIF p_attr_id = OE_Header_Util.G_CUST_PO_NUMBER THEN
3675: x_header_rec.cust_po_number := p_attr_value;
3676: ELSIF p_attr_id = OE_Header_Util.G_DEFAULT_FULFILLMENT_SET THEN
3677: x_header_rec.DEFAULT_FULFILLMENT_SET := p_attr_value;
3678: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_CONTACT THEN
3679: x_header_rec.deliver_to_contact_id := TO_NUMBER(p_attr_value);
3680: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_ORG THEN
3681: x_header_rec.deliver_to_org_id := TO_NUMBER(p_attr_value);
3682: ELSIF p_attr_id = OE_Header_Util.G_DEMAND_CLASS THEN
3676: ELSIF p_attr_id = OE_Header_Util.G_DEFAULT_FULFILLMENT_SET THEN
3677: x_header_rec.DEFAULT_FULFILLMENT_SET := p_attr_value;
3678: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_CONTACT THEN
3679: x_header_rec.deliver_to_contact_id := TO_NUMBER(p_attr_value);
3680: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_ORG THEN
3681: x_header_rec.deliver_to_org_id := TO_NUMBER(p_attr_value);
3682: ELSIF p_attr_id = OE_Header_Util.G_DEMAND_CLASS THEN
3683: x_header_rec.demand_class_code := p_attr_value;
3684: ELSIF p_attr_id = OE_Header_Util.G_EXPIRATION_DATE THEN
3678: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_CONTACT THEN
3679: x_header_rec.deliver_to_contact_id := TO_NUMBER(p_attr_value);
3680: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_ORG THEN
3681: x_header_rec.deliver_to_org_id := TO_NUMBER(p_attr_value);
3682: ELSIF p_attr_id = OE_Header_Util.G_DEMAND_CLASS THEN
3683: x_header_rec.demand_class_code := p_attr_value;
3684: ELSIF p_attr_id = OE_Header_Util.G_EXPIRATION_DATE THEN
3685: --x_header_rec.expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
3686: x_header_rec.expiration_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3680: ELSIF p_attr_id = OE_Header_Util.G_DELIVER_TO_ORG THEN
3681: x_header_rec.deliver_to_org_id := TO_NUMBER(p_attr_value);
3682: ELSIF p_attr_id = OE_Header_Util.G_DEMAND_CLASS THEN
3683: x_header_rec.demand_class_code := p_attr_value;
3684: ELSIF p_attr_id = OE_Header_Util.G_EXPIRATION_DATE THEN
3685: --x_header_rec.expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
3686: x_header_rec.expiration_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3687: ELSIF p_attr_id = OE_Header_Util.G_EARLIEST_SCHEDULE_LIMIT THEN
3688: x_header_rec.earliest_schedule_limit := TO_NUMBER(p_attr_value);
3683: x_header_rec.demand_class_code := p_attr_value;
3684: ELSIF p_attr_id = OE_Header_Util.G_EXPIRATION_DATE THEN
3685: --x_header_rec.expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
3686: x_header_rec.expiration_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3687: ELSIF p_attr_id = OE_Header_Util.G_EARLIEST_SCHEDULE_LIMIT THEN
3688: x_header_rec.earliest_schedule_limit := TO_NUMBER(p_attr_value);
3689: ELSIF p_attr_id = OE_Header_Util.G_FOB_POINT THEN
3690: x_header_rec.fob_point_code := p_attr_value;
3691: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_CARRIER THEN
3685: --x_header_rec.expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
3686: x_header_rec.expiration_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3687: ELSIF p_attr_id = OE_Header_Util.G_EARLIEST_SCHEDULE_LIMIT THEN
3688: x_header_rec.earliest_schedule_limit := TO_NUMBER(p_attr_value);
3689: ELSIF p_attr_id = OE_Header_Util.G_FOB_POINT THEN
3690: x_header_rec.fob_point_code := p_attr_value;
3691: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_CARRIER THEN
3692: x_header_rec.freight_carrier_code := p_attr_value;
3693: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_TERMS THEN
3687: ELSIF p_attr_id = OE_Header_Util.G_EARLIEST_SCHEDULE_LIMIT THEN
3688: x_header_rec.earliest_schedule_limit := TO_NUMBER(p_attr_value);
3689: ELSIF p_attr_id = OE_Header_Util.G_FOB_POINT THEN
3690: x_header_rec.fob_point_code := p_attr_value;
3691: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_CARRIER THEN
3692: x_header_rec.freight_carrier_code := p_attr_value;
3693: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_TERMS THEN
3694: x_header_rec.freight_terms_code := p_attr_value;
3695: ELSIF p_attr_id = OE_Header_Util.G_FULFILLMENT_SET_NAME THEN
3689: ELSIF p_attr_id = OE_Header_Util.G_FOB_POINT THEN
3690: x_header_rec.fob_point_code := p_attr_value;
3691: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_CARRIER THEN
3692: x_header_rec.freight_carrier_code := p_attr_value;
3693: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_TERMS THEN
3694: x_header_rec.freight_terms_code := p_attr_value;
3695: ELSIF p_attr_id = OE_Header_Util.G_FULFILLMENT_SET_NAME THEN
3696: x_header_rec.FULFILLMENT_SET_NAME := p_attr_value;
3697: ELSIF p_attr_id = OE_Header_Util.G_HEADER THEN
3691: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_CARRIER THEN
3692: x_header_rec.freight_carrier_code := p_attr_value;
3693: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_TERMS THEN
3694: x_header_rec.freight_terms_code := p_attr_value;
3695: ELSIF p_attr_id = OE_Header_Util.G_FULFILLMENT_SET_NAME THEN
3696: x_header_rec.FULFILLMENT_SET_NAME := p_attr_value;
3697: ELSIF p_attr_id = OE_Header_Util.G_HEADER THEN
3698: x_header_rec.header_id := TO_NUMBER(p_attr_value);
3699: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_CONTACT THEN
3693: ELSIF p_attr_id = OE_Header_Util.G_FREIGHT_TERMS THEN
3694: x_header_rec.freight_terms_code := p_attr_value;
3695: ELSIF p_attr_id = OE_Header_Util.G_FULFILLMENT_SET_NAME THEN
3696: x_header_rec.FULFILLMENT_SET_NAME := p_attr_value;
3697: ELSIF p_attr_id = OE_Header_Util.G_HEADER THEN
3698: x_header_rec.header_id := TO_NUMBER(p_attr_value);
3699: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_CONTACT THEN
3700: x_header_rec.invoice_to_contact_id := TO_NUMBER(p_attr_value);
3701: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_ORG THEN
3695: ELSIF p_attr_id = OE_Header_Util.G_FULFILLMENT_SET_NAME THEN
3696: x_header_rec.FULFILLMENT_SET_NAME := p_attr_value;
3697: ELSIF p_attr_id = OE_Header_Util.G_HEADER THEN
3698: x_header_rec.header_id := TO_NUMBER(p_attr_value);
3699: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_CONTACT THEN
3700: x_header_rec.invoice_to_contact_id := TO_NUMBER(p_attr_value);
3701: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_ORG THEN
3702: x_header_rec.invoice_to_org_id := TO_NUMBER(p_attr_value);
3703: ELSIF p_attr_id = OE_Header_Util.G_INVOICING_RULE THEN
3697: ELSIF p_attr_id = OE_Header_Util.G_HEADER THEN
3698: x_header_rec.header_id := TO_NUMBER(p_attr_value);
3699: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_CONTACT THEN
3700: x_header_rec.invoice_to_contact_id := TO_NUMBER(p_attr_value);
3701: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_ORG THEN
3702: x_header_rec.invoice_to_org_id := TO_NUMBER(p_attr_value);
3703: ELSIF p_attr_id = OE_Header_Util.G_INVOICING_RULE THEN
3704: x_header_rec.invoicing_rule_id := TO_NUMBER(p_attr_value);
3705: ELSIF p_attr_id = OE_Header_Util.G_LATEST_SCHEDULE_LIMIT THEN
3699: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_CONTACT THEN
3700: x_header_rec.invoice_to_contact_id := TO_NUMBER(p_attr_value);
3701: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_ORG THEN
3702: x_header_rec.invoice_to_org_id := TO_NUMBER(p_attr_value);
3703: ELSIF p_attr_id = OE_Header_Util.G_INVOICING_RULE THEN
3704: x_header_rec.invoicing_rule_id := TO_NUMBER(p_attr_value);
3705: ELSIF p_attr_id = OE_Header_Util.G_LATEST_SCHEDULE_LIMIT THEN
3706: x_header_rec.latest_schedule_limit := TO_NUMBER(p_attr_value);
3707: ELSIF p_attr_id = OE_Header_Util.G_LINE_SET_NAME THEN
3701: ELSIF p_attr_id = OE_Header_Util.G_INVOICE_TO_ORG THEN
3702: x_header_rec.invoice_to_org_id := TO_NUMBER(p_attr_value);
3703: ELSIF p_attr_id = OE_Header_Util.G_INVOICING_RULE THEN
3704: x_header_rec.invoicing_rule_id := TO_NUMBER(p_attr_value);
3705: ELSIF p_attr_id = OE_Header_Util.G_LATEST_SCHEDULE_LIMIT THEN
3706: x_header_rec.latest_schedule_limit := TO_NUMBER(p_attr_value);
3707: ELSIF p_attr_id = OE_Header_Util.G_LINE_SET_NAME THEN
3708: x_header_rec.LINE_SET_NAME := p_attr_value;
3709: ELSIF p_attr_id = OE_Header_Util.G_OPEN THEN
3703: ELSIF p_attr_id = OE_Header_Util.G_INVOICING_RULE THEN
3704: x_header_rec.invoicing_rule_id := TO_NUMBER(p_attr_value);
3705: ELSIF p_attr_id = OE_Header_Util.G_LATEST_SCHEDULE_LIMIT THEN
3706: x_header_rec.latest_schedule_limit := TO_NUMBER(p_attr_value);
3707: ELSIF p_attr_id = OE_Header_Util.G_LINE_SET_NAME THEN
3708: x_header_rec.LINE_SET_NAME := p_attr_value;
3709: ELSIF p_attr_id = OE_Header_Util.G_OPEN THEN
3710: x_header_rec.open_flag := p_attr_value;
3711: ELSIF p_attr_id = OE_Header_Util.G_ORDERED_DATE THEN
3705: ELSIF p_attr_id = OE_Header_Util.G_LATEST_SCHEDULE_LIMIT THEN
3706: x_header_rec.latest_schedule_limit := TO_NUMBER(p_attr_value);
3707: ELSIF p_attr_id = OE_Header_Util.G_LINE_SET_NAME THEN
3708: x_header_rec.LINE_SET_NAME := p_attr_value;
3709: ELSIF p_attr_id = OE_Header_Util.G_OPEN THEN
3710: x_header_rec.open_flag := p_attr_value;
3711: ELSIF p_attr_id = OE_Header_Util.G_ORDERED_DATE THEN
3712: -- x_header_rec.ordered_date := TO_DATE(p_attr_value, l_date_format_mask);
3713: x_header_rec.ordered_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3707: ELSIF p_attr_id = OE_Header_Util.G_LINE_SET_NAME THEN
3708: x_header_rec.LINE_SET_NAME := p_attr_value;
3709: ELSIF p_attr_id = OE_Header_Util.G_OPEN THEN
3710: x_header_rec.open_flag := p_attr_value;
3711: ELSIF p_attr_id = OE_Header_Util.G_ORDERED_DATE THEN
3712: -- x_header_rec.ordered_date := TO_DATE(p_attr_value, l_date_format_mask);
3713: x_header_rec.ordered_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3714: ELSIF p_attr_id = OE_Header_Util.G_ORDER_DATE_TYPE_CODE THEN
3715: x_header_rec.order_date_type_code := p_attr_value;
3710: x_header_rec.open_flag := p_attr_value;
3711: ELSIF p_attr_id = OE_Header_Util.G_ORDERED_DATE THEN
3712: -- x_header_rec.ordered_date := TO_DATE(p_attr_value, l_date_format_mask);
3713: x_header_rec.ordered_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3714: ELSIF p_attr_id = OE_Header_Util.G_ORDER_DATE_TYPE_CODE THEN
3715: x_header_rec.order_date_type_code := p_attr_value;
3716: ELSIF p_attr_id = OE_Header_Util.G_ORDER_NUMBER THEN
3717: x_header_rec.order_number := TO_NUMBER(p_attr_value);
3718: ELSIF p_attr_id = OE_Header_Util.G_ORDER_SOURCE THEN
3712: -- x_header_rec.ordered_date := TO_DATE(p_attr_value, l_date_format_mask);
3713: x_header_rec.ordered_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3714: ELSIF p_attr_id = OE_Header_Util.G_ORDER_DATE_TYPE_CODE THEN
3715: x_header_rec.order_date_type_code := p_attr_value;
3716: ELSIF p_attr_id = OE_Header_Util.G_ORDER_NUMBER THEN
3717: x_header_rec.order_number := TO_NUMBER(p_attr_value);
3718: ELSIF p_attr_id = OE_Header_Util.G_ORDER_SOURCE THEN
3719: x_header_rec.order_source_id := TO_NUMBER(p_attr_value);
3720: ELSIF p_attr_id = OE_Header_Util.G_ORDER_TYPE THEN
3714: ELSIF p_attr_id = OE_Header_Util.G_ORDER_DATE_TYPE_CODE THEN
3715: x_header_rec.order_date_type_code := p_attr_value;
3716: ELSIF p_attr_id = OE_Header_Util.G_ORDER_NUMBER THEN
3717: x_header_rec.order_number := TO_NUMBER(p_attr_value);
3718: ELSIF p_attr_id = OE_Header_Util.G_ORDER_SOURCE THEN
3719: x_header_rec.order_source_id := TO_NUMBER(p_attr_value);
3720: ELSIF p_attr_id = OE_Header_Util.G_ORDER_TYPE THEN
3721: x_header_rec.order_type_id := TO_NUMBER(p_attr_value);
3722: ELSIF p_attr_id = OE_Header_Util.G_ORG THEN
3716: ELSIF p_attr_id = OE_Header_Util.G_ORDER_NUMBER THEN
3717: x_header_rec.order_number := TO_NUMBER(p_attr_value);
3718: ELSIF p_attr_id = OE_Header_Util.G_ORDER_SOURCE THEN
3719: x_header_rec.order_source_id := TO_NUMBER(p_attr_value);
3720: ELSIF p_attr_id = OE_Header_Util.G_ORDER_TYPE THEN
3721: x_header_rec.order_type_id := TO_NUMBER(p_attr_value);
3722: ELSIF p_attr_id = OE_Header_Util.G_ORG THEN
3723: x_header_rec.org_id := TO_NUMBER(p_attr_value);
3724: ELSIF p_attr_id = OE_Header_Util.G_ORIG_SYS_DOCUMENT_REF THEN
3718: ELSIF p_attr_id = OE_Header_Util.G_ORDER_SOURCE THEN
3719: x_header_rec.order_source_id := TO_NUMBER(p_attr_value);
3720: ELSIF p_attr_id = OE_Header_Util.G_ORDER_TYPE THEN
3721: x_header_rec.order_type_id := TO_NUMBER(p_attr_value);
3722: ELSIF p_attr_id = OE_Header_Util.G_ORG THEN
3723: x_header_rec.org_id := TO_NUMBER(p_attr_value);
3724: ELSIF p_attr_id = OE_Header_Util.G_ORIG_SYS_DOCUMENT_REF THEN
3725: x_header_rec.orig_sys_document_ref := p_attr_value;
3726: ELSIF p_attr_id = OE_Header_Util.G_PARTIAL_SHIPMENTS_ALLOWED THEN
3720: ELSIF p_attr_id = OE_Header_Util.G_ORDER_TYPE THEN
3721: x_header_rec.order_type_id := TO_NUMBER(p_attr_value);
3722: ELSIF p_attr_id = OE_Header_Util.G_ORG THEN
3723: x_header_rec.org_id := TO_NUMBER(p_attr_value);
3724: ELSIF p_attr_id = OE_Header_Util.G_ORIG_SYS_DOCUMENT_REF THEN
3725: x_header_rec.orig_sys_document_ref := p_attr_value;
3726: ELSIF p_attr_id = OE_Header_Util.G_PARTIAL_SHIPMENTS_ALLOWED THEN
3727: x_header_rec.partial_shipments_allowed := p_attr_value;
3728: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TERM THEN
3722: ELSIF p_attr_id = OE_Header_Util.G_ORG THEN
3723: x_header_rec.org_id := TO_NUMBER(p_attr_value);
3724: ELSIF p_attr_id = OE_Header_Util.G_ORIG_SYS_DOCUMENT_REF THEN
3725: x_header_rec.orig_sys_document_ref := p_attr_value;
3726: ELSIF p_attr_id = OE_Header_Util.G_PARTIAL_SHIPMENTS_ALLOWED THEN
3727: x_header_rec.partial_shipments_allowed := p_attr_value;
3728: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TERM THEN
3729: x_header_rec.payment_term_id := TO_NUMBER(p_attr_value);
3730: ELSIF p_attr_id = OE_Header_Util.G_PRICE_LIST THEN
3724: ELSIF p_attr_id = OE_Header_Util.G_ORIG_SYS_DOCUMENT_REF THEN
3725: x_header_rec.orig_sys_document_ref := p_attr_value;
3726: ELSIF p_attr_id = OE_Header_Util.G_PARTIAL_SHIPMENTS_ALLOWED THEN
3727: x_header_rec.partial_shipments_allowed := p_attr_value;
3728: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TERM THEN
3729: x_header_rec.payment_term_id := TO_NUMBER(p_attr_value);
3730: ELSIF p_attr_id = OE_Header_Util.G_PRICE_LIST THEN
3731: x_header_rec.price_list_id := TO_NUMBER(p_attr_value);
3732: ELSIF p_attr_id = OE_Header_Util.G_PRICING_DATE THEN
3726: ELSIF p_attr_id = OE_Header_Util.G_PARTIAL_SHIPMENTS_ALLOWED THEN
3727: x_header_rec.partial_shipments_allowed := p_attr_value;
3728: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TERM THEN
3729: x_header_rec.payment_term_id := TO_NUMBER(p_attr_value);
3730: ELSIF p_attr_id = OE_Header_Util.G_PRICE_LIST THEN
3731: x_header_rec.price_list_id := TO_NUMBER(p_attr_value);
3732: ELSIF p_attr_id = OE_Header_Util.G_PRICING_DATE THEN
3733: --x_header_rec.pricing_date := TO_DATE(p_attr_value, l_date_format_mask);
3734: x_header_rec.pricing_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3728: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TERM THEN
3729: x_header_rec.payment_term_id := TO_NUMBER(p_attr_value);
3730: ELSIF p_attr_id = OE_Header_Util.G_PRICE_LIST THEN
3731: x_header_rec.price_list_id := TO_NUMBER(p_attr_value);
3732: ELSIF p_attr_id = OE_Header_Util.G_PRICING_DATE THEN
3733: --x_header_rec.pricing_date := TO_DATE(p_attr_value, l_date_format_mask);
3734: x_header_rec.pricing_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3735: ELSIF p_attr_id = OE_Header_Util.G_REQUEST_DATE THEN
3736: --x_header_rec.request_date := TO_DATE(p_attr_value, l_date_format_mask);
3731: x_header_rec.price_list_id := TO_NUMBER(p_attr_value);
3732: ELSIF p_attr_id = OE_Header_Util.G_PRICING_DATE THEN
3733: --x_header_rec.pricing_date := TO_DATE(p_attr_value, l_date_format_mask);
3734: x_header_rec.pricing_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3735: ELSIF p_attr_id = OE_Header_Util.G_REQUEST_DATE THEN
3736: --x_header_rec.request_date := TO_DATE(p_attr_value, l_date_format_mask);
3737: x_header_rec.request_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3738: ELSIF p_attr_id = OE_Header_Util.G_SHIPMENT_PRIORITY THEN
3739: x_header_rec.shipment_priority_code := p_attr_value;
3734: x_header_rec.pricing_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3735: ELSIF p_attr_id = OE_Header_Util.G_REQUEST_DATE THEN
3736: --x_header_rec.request_date := TO_DATE(p_attr_value, l_date_format_mask);
3737: x_header_rec.request_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3738: ELSIF p_attr_id = OE_Header_Util.G_SHIPMENT_PRIORITY THEN
3739: x_header_rec.shipment_priority_code := p_attr_value;
3740: ELSIF p_attr_id = OE_Header_Util.G_SHIPPING_METHOD THEN
3741: x_header_rec.shipping_method_code := p_attr_value;
3742: ELSIF p_attr_id = OE_Header_Util.G_SHIP_FROM_ORG THEN
3736: --x_header_rec.request_date := TO_DATE(p_attr_value, l_date_format_mask);
3737: x_header_rec.request_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3738: ELSIF p_attr_id = OE_Header_Util.G_SHIPMENT_PRIORITY THEN
3739: x_header_rec.shipment_priority_code := p_attr_value;
3740: ELSIF p_attr_id = OE_Header_Util.G_SHIPPING_METHOD THEN
3741: x_header_rec.shipping_method_code := p_attr_value;
3742: ELSIF p_attr_id = OE_Header_Util.G_SHIP_FROM_ORG THEN
3743: x_header_rec.ship_from_org_id := TO_NUMBER(p_attr_value);
3744: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_ABOVE THEN
3738: ELSIF p_attr_id = OE_Header_Util.G_SHIPMENT_PRIORITY THEN
3739: x_header_rec.shipment_priority_code := p_attr_value;
3740: ELSIF p_attr_id = OE_Header_Util.G_SHIPPING_METHOD THEN
3741: x_header_rec.shipping_method_code := p_attr_value;
3742: ELSIF p_attr_id = OE_Header_Util.G_SHIP_FROM_ORG THEN
3743: x_header_rec.ship_from_org_id := TO_NUMBER(p_attr_value);
3744: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_ABOVE THEN
3745: x_header_rec.ship_tolerance_above := TO_NUMBER(p_attr_value);
3746: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_BELOW THEN
3740: ELSIF p_attr_id = OE_Header_Util.G_SHIPPING_METHOD THEN
3741: x_header_rec.shipping_method_code := p_attr_value;
3742: ELSIF p_attr_id = OE_Header_Util.G_SHIP_FROM_ORG THEN
3743: x_header_rec.ship_from_org_id := TO_NUMBER(p_attr_value);
3744: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_ABOVE THEN
3745: x_header_rec.ship_tolerance_above := TO_NUMBER(p_attr_value);
3746: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_BELOW THEN
3747: x_header_rec.ship_tolerance_below := TO_NUMBER(p_attr_value);
3748: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_CONTACT THEN
3742: ELSIF p_attr_id = OE_Header_Util.G_SHIP_FROM_ORG THEN
3743: x_header_rec.ship_from_org_id := TO_NUMBER(p_attr_value);
3744: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_ABOVE THEN
3745: x_header_rec.ship_tolerance_above := TO_NUMBER(p_attr_value);
3746: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_BELOW THEN
3747: x_header_rec.ship_tolerance_below := TO_NUMBER(p_attr_value);
3748: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_CONTACT THEN
3749: x_header_rec.ship_to_contact_id := TO_NUMBER(p_attr_value);
3750: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_ORG THEN
3744: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_ABOVE THEN
3745: x_header_rec.ship_tolerance_above := TO_NUMBER(p_attr_value);
3746: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_BELOW THEN
3747: x_header_rec.ship_tolerance_below := TO_NUMBER(p_attr_value);
3748: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_CONTACT THEN
3749: x_header_rec.ship_to_contact_id := TO_NUMBER(p_attr_value);
3750: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_ORG THEN
3751: x_header_rec.ship_to_org_id := TO_NUMBER(p_attr_value);
3752: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_CONTACT THEN
3746: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TOLERANCE_BELOW THEN
3747: x_header_rec.ship_tolerance_below := TO_NUMBER(p_attr_value);
3748: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_CONTACT THEN
3749: x_header_rec.ship_to_contact_id := TO_NUMBER(p_attr_value);
3750: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_ORG THEN
3751: x_header_rec.ship_to_org_id := TO_NUMBER(p_attr_value);
3752: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_CONTACT THEN
3753: x_header_rec.sold_to_contact_id := TO_NUMBER(p_attr_value);
3754: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_ORG THEN
3748: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_CONTACT THEN
3749: x_header_rec.ship_to_contact_id := TO_NUMBER(p_attr_value);
3750: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_ORG THEN
3751: x_header_rec.ship_to_org_id := TO_NUMBER(p_attr_value);
3752: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_CONTACT THEN
3753: x_header_rec.sold_to_contact_id := TO_NUMBER(p_attr_value);
3754: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_ORG THEN
3755: x_header_rec.sold_to_org_id := TO_NUMBER(p_attr_value);
3756: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_PHONE THEN
3750: ELSIF p_attr_id = OE_Header_Util.G_SHIP_TO_ORG THEN
3751: x_header_rec.ship_to_org_id := TO_NUMBER(p_attr_value);
3752: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_CONTACT THEN
3753: x_header_rec.sold_to_contact_id := TO_NUMBER(p_attr_value);
3754: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_ORG THEN
3755: x_header_rec.sold_to_org_id := TO_NUMBER(p_attr_value);
3756: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_PHONE THEN
3757: x_header_rec.sold_to_phone_id := TO_NUMBER(p_attr_value);
3758: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT THEN
3752: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_CONTACT THEN
3753: x_header_rec.sold_to_contact_id := TO_NUMBER(p_attr_value);
3754: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_ORG THEN
3755: x_header_rec.sold_to_org_id := TO_NUMBER(p_attr_value);
3756: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_PHONE THEN
3757: x_header_rec.sold_to_phone_id := TO_NUMBER(p_attr_value);
3758: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT THEN
3759: x_header_rec.source_document_id := TO_NUMBER(p_attr_value);
3760: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT_TYPE THEN
3754: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_ORG THEN
3755: x_header_rec.sold_to_org_id := TO_NUMBER(p_attr_value);
3756: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_PHONE THEN
3757: x_header_rec.sold_to_phone_id := TO_NUMBER(p_attr_value);
3758: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT THEN
3759: x_header_rec.source_document_id := TO_NUMBER(p_attr_value);
3760: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT_TYPE THEN
3761: x_header_rec.source_document_type_id := TO_NUMBER(p_attr_value);
3762: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT THEN
3756: ELSIF p_attr_id = OE_Header_Util.G_SOLD_TO_PHONE THEN
3757: x_header_rec.sold_to_phone_id := TO_NUMBER(p_attr_value);
3758: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT THEN
3759: x_header_rec.source_document_id := TO_NUMBER(p_attr_value);
3760: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT_TYPE THEN
3761: x_header_rec.source_document_type_id := TO_NUMBER(p_attr_value);
3762: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT THEN
3763: x_header_rec.tax_exempt_flag := p_attr_value;
3764: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_NUMBER THEN
3758: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT THEN
3759: x_header_rec.source_document_id := TO_NUMBER(p_attr_value);
3760: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT_TYPE THEN
3761: x_header_rec.source_document_type_id := TO_NUMBER(p_attr_value);
3762: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT THEN
3763: x_header_rec.tax_exempt_flag := p_attr_value;
3764: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_NUMBER THEN
3765: x_header_rec.tax_exempt_number := p_attr_value;
3766: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_REASON THEN
3760: ELSIF p_attr_id = OE_Header_Util.G_SOURCE_DOCUMENT_TYPE THEN
3761: x_header_rec.source_document_type_id := TO_NUMBER(p_attr_value);
3762: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT THEN
3763: x_header_rec.tax_exempt_flag := p_attr_value;
3764: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_NUMBER THEN
3765: x_header_rec.tax_exempt_number := p_attr_value;
3766: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_REASON THEN
3767: x_header_rec.tax_exempt_reason_code := p_attr_value;
3768: ELSIF p_attr_id = OE_Header_Util.G_TAX_POINT THEN
3762: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT THEN
3763: x_header_rec.tax_exempt_flag := p_attr_value;
3764: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_NUMBER THEN
3765: x_header_rec.tax_exempt_number := p_attr_value;
3766: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_REASON THEN
3767: x_header_rec.tax_exempt_reason_code := p_attr_value;
3768: ELSIF p_attr_id = OE_Header_Util.G_TAX_POINT THEN
3769: x_header_rec.tax_point_code := p_attr_value;
3770: ELSIF p_attr_id = OE_Header_Util.G_TRANSACTIONAL_CURR THEN
3764: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_NUMBER THEN
3765: x_header_rec.tax_exempt_number := p_attr_value;
3766: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_REASON THEN
3767: x_header_rec.tax_exempt_reason_code := p_attr_value;
3768: ELSIF p_attr_id = OE_Header_Util.G_TAX_POINT THEN
3769: x_header_rec.tax_point_code := p_attr_value;
3770: ELSIF p_attr_id = OE_Header_Util.G_TRANSACTIONAL_CURR THEN
3771: x_header_rec.transactional_curr_code := p_attr_value;
3772: ELSIF p_attr_id = OE_Header_Util.G_VERSION_NUMBER THEN
3766: ELSIF p_attr_id = OE_Header_Util.G_TAX_EXEMPT_REASON THEN
3767: x_header_rec.tax_exempt_reason_code := p_attr_value;
3768: ELSIF p_attr_id = OE_Header_Util.G_TAX_POINT THEN
3769: x_header_rec.tax_point_code := p_attr_value;
3770: ELSIF p_attr_id = OE_Header_Util.G_TRANSACTIONAL_CURR THEN
3771: x_header_rec.transactional_curr_code := p_attr_value;
3772: ELSIF p_attr_id = OE_Header_Util.G_VERSION_NUMBER THEN
3773: x_header_rec.version_number := TO_NUMBER(p_attr_value);
3774: ELSIF p_attr_id = OE_Header_Util.G_SALESREP THEN
3768: ELSIF p_attr_id = OE_Header_Util.G_TAX_POINT THEN
3769: x_header_rec.tax_point_code := p_attr_value;
3770: ELSIF p_attr_id = OE_Header_Util.G_TRANSACTIONAL_CURR THEN
3771: x_header_rec.transactional_curr_code := p_attr_value;
3772: ELSIF p_attr_id = OE_Header_Util.G_VERSION_NUMBER THEN
3773: x_header_rec.version_number := TO_NUMBER(p_attr_value);
3774: ELSIF p_attr_id = OE_Header_Util.G_SALESREP THEN
3775: x_header_rec.salesrep_id := TO_NUMBER(p_attr_value);
3776: ELSIF p_attr_id = OE_Header_Util.G_SALES_CHANNEL THEN
3770: ELSIF p_attr_id = OE_Header_Util.G_TRANSACTIONAL_CURR THEN
3771: x_header_rec.transactional_curr_code := p_attr_value;
3772: ELSIF p_attr_id = OE_Header_Util.G_VERSION_NUMBER THEN
3773: x_header_rec.version_number := TO_NUMBER(p_attr_value);
3774: ELSIF p_attr_id = OE_Header_Util.G_SALESREP THEN
3775: x_header_rec.salesrep_id := TO_NUMBER(p_attr_value);
3776: ELSIF p_attr_id = OE_Header_Util.G_SALES_CHANNEL THEN
3777: x_header_rec.sales_channel_code := p_attr_value;
3778: ELSIF p_attr_id = OE_Header_Util.G_RETURN_REASON THEN
3772: ELSIF p_attr_id = OE_Header_Util.G_VERSION_NUMBER THEN
3773: x_header_rec.version_number := TO_NUMBER(p_attr_value);
3774: ELSIF p_attr_id = OE_Header_Util.G_SALESREP THEN
3775: x_header_rec.salesrep_id := TO_NUMBER(p_attr_value);
3776: ELSIF p_attr_id = OE_Header_Util.G_SALES_CHANNEL THEN
3777: x_header_rec.sales_channel_code := p_attr_value;
3778: ELSIF p_attr_id = OE_Header_Util.G_RETURN_REASON THEN
3779: x_header_rec.return_reason_code := p_attr_value;
3780: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TYPE THEN
3774: ELSIF p_attr_id = OE_Header_Util.G_SALESREP THEN
3775: x_header_rec.salesrep_id := TO_NUMBER(p_attr_value);
3776: ELSIF p_attr_id = OE_Header_Util.G_SALES_CHANNEL THEN
3777: x_header_rec.sales_channel_code := p_attr_value;
3778: ELSIF p_attr_id = OE_Header_Util.G_RETURN_REASON THEN
3779: x_header_rec.return_reason_code := p_attr_value;
3780: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TYPE THEN
3781: x_header_rec.payment_type_code := p_attr_value;
3782: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_AMOUNT THEN
3776: ELSIF p_attr_id = OE_Header_Util.G_SALES_CHANNEL THEN
3777: x_header_rec.sales_channel_code := p_attr_value;
3778: ELSIF p_attr_id = OE_Header_Util.G_RETURN_REASON THEN
3779: x_header_rec.return_reason_code := p_attr_value;
3780: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TYPE THEN
3781: x_header_rec.payment_type_code := p_attr_value;
3782: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_AMOUNT THEN
3783: x_header_rec.payment_amount := TO_NUMBER(p_attr_value);
3784: ELSIF p_attr_id = OE_Header_Util.G_CHECK_NUMBER THEN
3778: ELSIF p_attr_id = OE_Header_Util.G_RETURN_REASON THEN
3779: x_header_rec.return_reason_code := p_attr_value;
3780: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TYPE THEN
3781: x_header_rec.payment_type_code := p_attr_value;
3782: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_AMOUNT THEN
3783: x_header_rec.payment_amount := TO_NUMBER(p_attr_value);
3784: ELSIF p_attr_id = OE_Header_Util.G_CHECK_NUMBER THEN
3785: x_header_rec.check_number := p_attr_value;
3786: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD THEN
3780: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_TYPE THEN
3781: x_header_rec.payment_type_code := p_attr_value;
3782: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_AMOUNT THEN
3783: x_header_rec.payment_amount := TO_NUMBER(p_attr_value);
3784: ELSIF p_attr_id = OE_Header_Util.G_CHECK_NUMBER THEN
3785: x_header_rec.check_number := p_attr_value;
3786: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD THEN
3787: x_header_rec.credit_card_code := p_attr_value;
3788: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_HOLDER_NAME THEN
3782: ELSIF p_attr_id = OE_Header_Util.G_PAYMENT_AMOUNT THEN
3783: x_header_rec.payment_amount := TO_NUMBER(p_attr_value);
3784: ELSIF p_attr_id = OE_Header_Util.G_CHECK_NUMBER THEN
3785: x_header_rec.check_number := p_attr_value;
3786: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD THEN
3787: x_header_rec.credit_card_code := p_attr_value;
3788: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_HOLDER_NAME THEN
3789: x_header_rec.credit_card_holder_name := p_attr_value;
3790: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_NUMBER THEN
3784: ELSIF p_attr_id = OE_Header_Util.G_CHECK_NUMBER THEN
3785: x_header_rec.check_number := p_attr_value;
3786: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD THEN
3787: x_header_rec.credit_card_code := p_attr_value;
3788: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_HOLDER_NAME THEN
3789: x_header_rec.credit_card_holder_name := p_attr_value;
3790: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_NUMBER THEN
3791: x_header_rec.credit_card_number := p_attr_value;
3792: ELSIF p_attr_id = Oe_header_util.G_INSTRUMENT_SECURITY THEN--R12 CC Encryption
3786: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD THEN
3787: x_header_rec.credit_card_code := p_attr_value;
3788: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_HOLDER_NAME THEN
3789: x_header_rec.credit_card_holder_name := p_attr_value;
3790: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_NUMBER THEN
3791: x_header_rec.credit_card_number := p_attr_value;
3792: ELSIF p_attr_id = Oe_header_util.G_INSTRUMENT_SECURITY THEN--R12 CC Encryption
3793: x_header_rec.instrument_security_code := p_attr_value;
3794: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT THEN
3788: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_HOLDER_NAME THEN
3789: x_header_rec.credit_card_holder_name := p_attr_value;
3790: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_NUMBER THEN
3791: x_header_rec.credit_card_number := p_attr_value;
3792: ELSIF p_attr_id = Oe_header_util.G_INSTRUMENT_SECURITY THEN--R12 CC Encryption
3793: x_header_rec.instrument_security_code := p_attr_value;
3794: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT THEN
3795: x_header_rec.CC_INSTRUMENT_ID := p_attr_value;
3796: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT_ASSIGNMENT THEN
3790: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_NUMBER THEN
3791: x_header_rec.credit_card_number := p_attr_value;
3792: ELSIF p_attr_id = Oe_header_util.G_INSTRUMENT_SECURITY THEN--R12 CC Encryption
3793: x_header_rec.instrument_security_code := p_attr_value;
3794: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT THEN
3795: x_header_rec.CC_INSTRUMENT_ID := p_attr_value;
3796: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT_ASSIGNMENT THEN
3797: x_header_rec.CC_INSTRUMENT_ASSIGNMENT_ID := p_attr_value; --R12 CC Encryption
3798: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_EXPIRATION_DATE THEN
3792: ELSIF p_attr_id = Oe_header_util.G_INSTRUMENT_SECURITY THEN--R12 CC Encryption
3793: x_header_rec.instrument_security_code := p_attr_value;
3794: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT THEN
3795: x_header_rec.CC_INSTRUMENT_ID := p_attr_value;
3796: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT_ASSIGNMENT THEN
3797: x_header_rec.CC_INSTRUMENT_ASSIGNMENT_ID := p_attr_value; --R12 CC Encryption
3798: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_EXPIRATION_DATE THEN
3799: --x_header_rec.credit_card_expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
3800: x_header_rec.credit_card_expiration_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3794: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT THEN
3795: x_header_rec.CC_INSTRUMENT_ID := p_attr_value;
3796: ELSIF p_attr_id = Oe_header_util.G_CC_INSTRUMENT_ASSIGNMENT THEN
3797: x_header_rec.CC_INSTRUMENT_ASSIGNMENT_ID := p_attr_value; --R12 CC Encryption
3798: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_EXPIRATION_DATE THEN
3799: --x_header_rec.credit_card_expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
3800: x_header_rec.credit_card_expiration_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3801: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_APPROVAL_DATE THEN
3802: -- x_header_rec.credit_card_approval_date := TO_DATE(p_attr_value, l_date_format_mask);
3797: x_header_rec.CC_INSTRUMENT_ASSIGNMENT_ID := p_attr_value; --R12 CC Encryption
3798: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_EXPIRATION_DATE THEN
3799: --x_header_rec.credit_card_expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
3800: x_header_rec.credit_card_expiration_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3801: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_APPROVAL_DATE THEN
3802: -- x_header_rec.credit_card_approval_date := TO_DATE(p_attr_value, l_date_format_mask);
3803: x_header_rec.credit_card_approval_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3804: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_APPROVAL THEN
3805: x_header_rec.credit_card_approval_code := p_attr_value;
3800: x_header_rec.credit_card_expiration_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3801: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_APPROVAL_DATE THEN
3802: -- x_header_rec.credit_card_approval_date := TO_DATE(p_attr_value, l_date_format_mask);
3803: x_header_rec.credit_card_approval_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3804: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_APPROVAL THEN
3805: x_header_rec.credit_card_approval_code := p_attr_value;
3806: ELSIF p_attr_id = OE_Header_Util.G_FIRST_ACK THEN
3807: x_header_rec.first_ack_code := p_attr_value;
3808: ELSIF p_attr_id = OE_Header_Util.G_FIRST_ACK_DATE THEN
3802: -- x_header_rec.credit_card_approval_date := TO_DATE(p_attr_value, l_date_format_mask);
3803: x_header_rec.credit_card_approval_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3804: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_APPROVAL THEN
3805: x_header_rec.credit_card_approval_code := p_attr_value;
3806: ELSIF p_attr_id = OE_Header_Util.G_FIRST_ACK THEN
3807: x_header_rec.first_ack_code := p_attr_value;
3808: ELSIF p_attr_id = OE_Header_Util.G_FIRST_ACK_DATE THEN
3809: -- x_header_rec.first_ack_date := TO_DATE(p_attr_value, l_date_format_mask);
3810: x_header_rec.first_ack_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3804: ELSIF p_attr_id = OE_Header_Util.G_CREDIT_CARD_APPROVAL THEN
3805: x_header_rec.credit_card_approval_code := p_attr_value;
3806: ELSIF p_attr_id = OE_Header_Util.G_FIRST_ACK THEN
3807: x_header_rec.first_ack_code := p_attr_value;
3808: ELSIF p_attr_id = OE_Header_Util.G_FIRST_ACK_DATE THEN
3809: -- x_header_rec.first_ack_date := TO_DATE(p_attr_value, l_date_format_mask);
3810: x_header_rec.first_ack_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3811: ELSIF p_attr_id = OE_Header_Util.G_LAST_ACK THEN
3812: x_header_rec.last_ack_code := p_attr_value;
3807: x_header_rec.first_ack_code := p_attr_value;
3808: ELSIF p_attr_id = OE_Header_Util.G_FIRST_ACK_DATE THEN
3809: -- x_header_rec.first_ack_date := TO_DATE(p_attr_value, l_date_format_mask);
3810: x_header_rec.first_ack_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3811: ELSIF p_attr_id = OE_Header_Util.G_LAST_ACK THEN
3812: x_header_rec.last_ack_code := p_attr_value;
3813: ELSIF p_attr_id = OE_Header_Util.G_SHIPPING_INSTRUCTIONS THEN
3814: x_header_rec.shipping_instructions := p_attr_value;
3815: ELSIF p_attr_id = OE_Header_Util.G_PACKING_INSTRUCTIONS THEN
3809: -- x_header_rec.first_ack_date := TO_DATE(p_attr_value, l_date_format_mask);
3810: x_header_rec.first_ack_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3811: ELSIF p_attr_id = OE_Header_Util.G_LAST_ACK THEN
3812: x_header_rec.last_ack_code := p_attr_value;
3813: ELSIF p_attr_id = OE_Header_Util.G_SHIPPING_INSTRUCTIONS THEN
3814: x_header_rec.shipping_instructions := p_attr_value;
3815: ELSIF p_attr_id = OE_Header_Util.G_PACKING_INSTRUCTIONS THEN
3816: x_header_rec.packing_instructions := p_attr_value;
3817: ELSIF p_attr_id = OE_Header_Util.G_LAST_ACK_DATE THEN
3811: ELSIF p_attr_id = OE_Header_Util.G_LAST_ACK THEN
3812: x_header_rec.last_ack_code := p_attr_value;
3813: ELSIF p_attr_id = OE_Header_Util.G_SHIPPING_INSTRUCTIONS THEN
3814: x_header_rec.shipping_instructions := p_attr_value;
3815: ELSIF p_attr_id = OE_Header_Util.G_PACKING_INSTRUCTIONS THEN
3816: x_header_rec.packing_instructions := p_attr_value;
3817: ELSIF p_attr_id = OE_Header_Util.G_LAST_ACK_DATE THEN
3818: --x_header_rec.last_ack_date := TO_DATE(p_attr_value, l_date_format_mask);
3819: x_header_rec.last_ack_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask);--bug5402396
3813: ELSIF p_attr_id = OE_Header_Util.G_SHIPPING_INSTRUCTIONS THEN
3814: x_header_rec.shipping_instructions := p_attr_value;
3815: ELSIF p_attr_id = OE_Header_Util.G_PACKING_INSTRUCTIONS THEN
3816: x_header_rec.packing_instructions := p_attr_value;
3817: ELSIF p_attr_id = OE_Header_Util.G_LAST_ACK_DATE THEN
3818: --x_header_rec.last_ack_date := TO_DATE(p_attr_value, l_date_format_mask);
3819: x_header_rec.last_ack_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask);--bug5402396
3820: ELSIF p_attr_id = OE_Header_Util.G_ORDER_CATEGORY THEN
3821: x_header_rec.order_category_code := p_attr_value;
3816: x_header_rec.packing_instructions := p_attr_value;
3817: ELSIF p_attr_id = OE_Header_Util.G_LAST_ACK_DATE THEN
3818: --x_header_rec.last_ack_date := TO_DATE(p_attr_value, l_date_format_mask);
3819: x_header_rec.last_ack_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask);--bug5402396
3820: ELSIF p_attr_id = OE_Header_Util.G_ORDER_CATEGORY THEN
3821: x_header_rec.order_category_code := p_attr_value;
3822:
3823: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_TEMPLATE THEN
3824: x_header_rec.contract_template_id := TO_NUMBER(p_attr_value);
3819: x_header_rec.last_ack_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask);--bug5402396
3820: ELSIF p_attr_id = OE_Header_Util.G_ORDER_CATEGORY THEN
3821: x_header_rec.order_category_code := p_attr_value;
3822:
3823: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_TEMPLATE THEN
3824: x_header_rec.contract_template_id := TO_NUMBER(p_attr_value);
3825:
3826: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOC_TYPE THEN
3827: x_header_rec.contract_source_doc_type_code := p_attr_value;
3822:
3823: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_TEMPLATE THEN
3824: x_header_rec.contract_template_id := TO_NUMBER(p_attr_value);
3825:
3826: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOC_TYPE THEN
3827: x_header_rec.contract_source_doc_type_code := p_attr_value;
3828:
3829: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOCUMENT THEN
3830: x_header_rec.contract_source_document_id := TO_NUMBER(p_attr_value);
3825:
3826: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOC_TYPE THEN
3827: x_header_rec.contract_source_doc_type_code := p_attr_value;
3828:
3829: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOCUMENT THEN
3830: x_header_rec.contract_source_document_id := TO_NUMBER(p_attr_value);
3831:
3832: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE THEN
3833: x_header_rec.supplier_signature := p_attr_value;
3828:
3829: ELSIF p_attr_id = OE_Header_Util.G_CONTRACT_SOURCE_DOCUMENT THEN
3830: x_header_rec.contract_source_document_id := TO_NUMBER(p_attr_value);
3831:
3832: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE THEN
3833: x_header_rec.supplier_signature := p_attr_value;
3834: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_SIGNATURE THEN
3835: x_header_rec.customer_signature := p_attr_value;
3836: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_SIGNATURE_DATE THEN
3830: x_header_rec.contract_source_document_id := TO_NUMBER(p_attr_value);
3831:
3832: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE THEN
3833: x_header_rec.supplier_signature := p_attr_value;
3834: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_SIGNATURE THEN
3835: x_header_rec.customer_signature := p_attr_value;
3836: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_SIGNATURE_DATE THEN
3837: -- x_header_rec.customer_signature_date := TO_DATE(p_attr_value, l_date_format_mask);
3838: x_header_rec.customer_signature_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3832: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE THEN
3833: x_header_rec.supplier_signature := p_attr_value;
3834: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_SIGNATURE THEN
3835: x_header_rec.customer_signature := p_attr_value;
3836: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_SIGNATURE_DATE THEN
3837: -- x_header_rec.customer_signature_date := TO_DATE(p_attr_value, l_date_format_mask);
3838: x_header_rec.customer_signature_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3839: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE_DATE THEN
3840: -- x_header_rec.supplier_signature_date := TO_DATE(p_attr_value, l_date_format_mask);
3835: x_header_rec.customer_signature := p_attr_value;
3836: ELSIF p_attr_id = OE_Header_Util.G_CUSTOMER_SIGNATURE_DATE THEN
3837: -- x_header_rec.customer_signature_date := TO_DATE(p_attr_value, l_date_format_mask);
3838: x_header_rec.customer_signature_date := fnd_date.string_to_date(p_attr_value, l_date_format_mask); --bug5402396
3839: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE_DATE THEN
3840: -- x_header_rec.supplier_signature_date := TO_DATE(p_attr_value, l_date_format_mask);
3841: x_header_rec.supplier_signature_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask);
3842:
3843: ELSIF p_attr_id = OE_Header_Util.G_ATTRIBUTE1
3839: ELSIF p_attr_id = OE_Header_Util.G_SUPPLIER_SIGNATURE_DATE THEN
3840: -- x_header_rec.supplier_signature_date := TO_DATE(p_attr_value, l_date_format_mask);
3841: x_header_rec.supplier_signature_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask);
3842:
3843: ELSIF p_attr_id = OE_Header_Util.G_ATTRIBUTE1
3844: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE10
3845: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE11
3846: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12
3847: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
3840: -- x_header_rec.supplier_signature_date := TO_DATE(p_attr_value, l_date_format_mask);
3841: x_header_rec.supplier_signature_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask);
3842:
3843: ELSIF p_attr_id = OE_Header_Util.G_ATTRIBUTE1
3844: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE10
3845: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE11
3846: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12
3847: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
3848: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
3841: x_header_rec.supplier_signature_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask);
3842:
3843: ELSIF p_attr_id = OE_Header_Util.G_ATTRIBUTE1
3844: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE10
3845: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE11
3846: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12
3847: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
3848: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
3849: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
3842:
3843: ELSIF p_attr_id = OE_Header_Util.G_ATTRIBUTE1
3844: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE10
3845: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE11
3846: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12
3847: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
3848: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
3849: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
3850: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
3843: ELSIF p_attr_id = OE_Header_Util.G_ATTRIBUTE1
3844: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE10
3845: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE11
3846: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12
3847: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
3848: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
3849: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
3850: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
3851: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
3844: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE10
3845: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE11
3846: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12
3847: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
3848: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
3849: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
3850: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
3851: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
3852: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
3845: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE11
3846: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12
3847: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
3848: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
3849: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
3850: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
3851: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
3852: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
3853: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
3846: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE12
3847: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
3848: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
3849: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
3850: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
3851: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
3852: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
3853: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
3854: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
3847: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE13
3848: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
3849: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
3850: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
3851: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
3852: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
3853: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
3854: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
3855: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
3848: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE14
3849: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
3850: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
3851: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
3852: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
3853: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
3854: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
3855: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
3856: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
3849: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE15
3850: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
3851: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
3852: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
3853: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
3854: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
3855: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
3856: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
3857: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
3850: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE16 --For bug 2184255
3851: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
3852: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
3853: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
3854: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
3855: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
3856: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
3857: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
3858: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
3851: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE17
3852: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
3853: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
3854: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
3855: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
3856: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
3857: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
3858: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
3859: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
3852: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE18
3853: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
3854: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
3855: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
3856: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
3857: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
3858: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
3859: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
3860: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
3853: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE19
3854: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
3855: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
3856: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
3857: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
3858: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
3859: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
3860: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
3861: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
3854: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE2
3855: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
3856: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
3857: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
3858: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
3859: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
3860: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
3861: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
3862: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE9
3855: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE20
3856: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
3857: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
3858: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
3859: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
3860: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
3861: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
3862: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE9
3863: OR p_attr_id = OE_Header_Util.G_CONTEXT
3856: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE3
3857: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
3858: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
3859: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
3860: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
3861: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
3862: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE9
3863: OR p_attr_id = OE_Header_Util.G_CONTEXT
3864: THEN
3857: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE4
3858: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
3859: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
3860: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
3861: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
3862: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE9
3863: OR p_attr_id = OE_Header_Util.G_CONTEXT
3864: THEN
3865:
3858: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE5
3859: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
3860: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
3861: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
3862: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE9
3863: OR p_attr_id = OE_Header_Util.G_CONTEXT
3864: THEN
3865:
3866: x_header_rec.attribute1 := p_header_dff_rec.attribute1;
3859: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE6
3860: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE7
3861: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE8
3862: OR p_attr_id = OE_Header_Util.G_ATTRIBUTE9
3863: OR p_attr_id = OE_Header_Util.G_CONTEXT
3864: THEN
3865:
3866: x_header_rec.attribute1 := p_header_dff_rec.attribute1;
3867: x_header_rec.attribute10 := p_header_dff_rec.attribute10;
3886: x_header_rec.context := p_header_dff_rec.context;
3887:
3888: -- null; -- Kris get desc flec working
3889:
3890: ELSIF p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE1
3891: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE10
3892: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
3893: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
3894: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
3887:
3888: -- null; -- Kris get desc flec working
3889:
3890: ELSIF p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE1
3891: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE10
3892: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
3893: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
3894: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
3895: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
3888: -- null; -- Kris get desc flec working
3889:
3890: ELSIF p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE1
3891: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE10
3892: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
3893: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
3894: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
3895: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
3896: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
3889:
3890: ELSIF p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE1
3891: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE10
3892: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
3893: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
3894: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
3895: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
3896: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
3897: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
3890: ELSIF p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE1
3891: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE10
3892: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
3893: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
3894: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
3895: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
3896: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
3897: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
3898: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
3891: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE10
3892: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
3893: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
3894: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
3895: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
3896: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
3897: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
3898: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
3899: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
3892: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE11
3893: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
3894: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
3895: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
3896: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
3897: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
3898: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
3899: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
3900: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
3893: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE12
3894: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
3895: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
3896: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
3897: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
3898: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
3899: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
3900: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
3901: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
3894: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE13
3895: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
3896: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
3897: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
3898: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
3899: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
3900: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
3901: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
3902: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
3895: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE14
3896: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
3897: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
3898: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
3899: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
3900: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
3901: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
3902: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
3903: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
3896: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE15
3897: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
3898: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
3899: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
3900: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
3901: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
3902: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
3903: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
3904: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
3897: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE16
3898: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
3899: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
3900: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
3901: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
3902: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
3903: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
3904: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
3905: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
3898: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE17
3899: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
3900: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
3901: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
3902: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
3903: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
3904: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
3905: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
3906: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
3899: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE18
3900: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
3901: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
3902: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
3903: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
3904: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
3905: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
3906: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
3907: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
3900: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE19
3901: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
3902: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
3903: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
3904: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
3905: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
3906: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
3907: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
3908: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
3901: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE2
3902: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
3903: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
3904: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
3905: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
3906: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
3907: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
3908: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
3909: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE9
3902: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE20
3903: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
3904: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
3905: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
3906: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
3907: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
3908: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
3909: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE9
3910: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE_CATEGORY
3903: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE3
3904: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
3905: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
3906: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
3907: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
3908: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
3909: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE9
3910: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE_CATEGORY
3911: THEN
3904: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE4
3905: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
3906: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
3907: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
3908: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
3909: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE9
3910: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE_CATEGORY
3911: THEN
3912:
3905: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE5
3906: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
3907: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
3908: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
3909: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE9
3910: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE_CATEGORY
3911: THEN
3912:
3913: x_header_rec.global_attribute1 := p_header_dff_rec.global_attribute1;
3906: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE6
3907: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE7
3908: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE8
3909: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE9
3910: OR p_attr_id = OE_Header_Util.G_GLOBAL_ATTRIBUTE_CATEGORY
3911: THEN
3912:
3913: x_header_rec.global_attribute1 := p_header_dff_rec.global_attribute1;
3914: x_header_rec.global_attribute10 := p_header_dff_rec.global_attribute10;
3932: x_header_rec.global_attribute9 := p_header_dff_rec.global_attribute9;
3933: x_header_rec.global_attribute_category := p_header_dff_rec.global_attribute_category;
3934:
3935: null; --Kris
3936: ELSIF p_attr_id = OE_Header_Util.G_TP_CONTEXT
3937: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE1
3938: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
3939: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
3940: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
3933: x_header_rec.global_attribute_category := p_header_dff_rec.global_attribute_category;
3934:
3935: null; --Kris
3936: ELSIF p_attr_id = OE_Header_Util.G_TP_CONTEXT
3937: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE1
3938: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
3939: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
3940: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
3941: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
3934:
3935: null; --Kris
3936: ELSIF p_attr_id = OE_Header_Util.G_TP_CONTEXT
3937: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE1
3938: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
3939: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
3940: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
3941: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
3942: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
3935: null; --Kris
3936: ELSIF p_attr_id = OE_Header_Util.G_TP_CONTEXT
3937: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE1
3938: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
3939: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
3940: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
3941: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
3942: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
3943: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
3936: ELSIF p_attr_id = OE_Header_Util.G_TP_CONTEXT
3937: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE1
3938: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
3939: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
3940: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
3941: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
3942: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
3943: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
3944: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
3937: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE1
3938: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
3939: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
3940: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
3941: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
3942: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
3943: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
3944: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
3945: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
3938: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE2
3939: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
3940: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
3941: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
3942: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
3943: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
3944: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
3945: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
3946: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
3939: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE3
3940: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
3941: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
3942: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
3943: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
3944: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
3945: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
3946: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
3947: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
3940: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE4
3941: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
3942: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
3943: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
3944: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
3945: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
3946: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
3947: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
3948: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
3941: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE5
3942: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
3943: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
3944: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
3945: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
3946: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
3947: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
3948: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
3949: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
3942: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE6
3943: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
3944: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
3945: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
3946: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
3947: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
3948: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
3949: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
3950: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE14
3943: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE7
3944: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
3945: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
3946: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
3947: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
3948: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
3949: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
3950: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE14
3951: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE15
3944: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE8
3945: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
3946: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
3947: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
3948: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
3949: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
3950: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE14
3951: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE15
3952: THEN
3945: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE9
3946: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
3947: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
3948: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
3949: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
3950: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE14
3951: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE15
3952: THEN
3953:
3946: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE10
3947: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
3948: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
3949: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
3950: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE14
3951: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE15
3952: THEN
3953:
3954: x_header_rec.tp_attribute1 := p_header_dff_rec.tp_attribute1;
3947: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE11
3948: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE12
3949: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE13
3950: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE14
3951: OR p_attr_id = OE_Header_Util.G_TP_ATTRIBUTE15
3952: THEN
3953:
3954: x_header_rec.tp_attribute1 := p_header_dff_rec.tp_attribute1;
3955: x_header_rec.tp_attribute10 := p_header_dff_rec.tp_attribute10;
4306: -- Initializing return status to SUCCESS
4307: x_return_status := FND_API.G_RET_STS_SUCCESS;
4308:
4309: IF p_header_id IS NOT NULL THEN
4310: OE_Header_Util.Query_Row
4311: ( p_header_id => p_header_id,
4312: x_header_rec =>l_header_rec
4313: );
4314: END IF;
4314: END IF;
4315:
4316: l_header_rec.operation :=p_operation;
4317:
4318: OE_HEADER_UTIL.API_Rec_To_Rowtype_Rec(l_header_rec,l_rowtype_rec);
4319:
4320: -- Initialize security global record
4321: OE_Header_SECURITY.g_record := l_rowtype_rec;
4322: