[Home] [Help]
2589: aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
2590: aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
2591: aPlsqlItem.LATEST_ACCEPTABLE_DATE := aSqlItem.LATEST_ACCEPTABLE_DATE;
2592: aPlsqlItem.LINE_CATEGORY_CODE := aSqlItem.LINE_CATEGORY_CODE;
2593: aPlsqlItem.LINE_ID := FND_API.G_MISS_NUM; -- aSqlItem.LINE_ID;
2594: aPlsqlItem.LINE_NUMBER := aSqlItem.LINE_NUMBER;
2595: aPlsqlItem.LINE_TYPE_ID := aSqlItem.LINE_TYPE_ID;
2596: aPlsqlItem.LINK_TO_LINE_REF := aSqlItem.LINK_TO_LINE_REF;
2597: aPlsqlItem.LINK_TO_LINE_ID := aSqlItem.LINK_TO_LINE_ID;
2665: aPlsqlItem.SCHEDULE_ARRIVAL_DATE := aSqlItem.SCHEDULE_ARRIVAL_DATE;
2666: aPlsqlItem.SCHEDULE_SHIP_DATE := aSqlItem.SCHEDULE_SHIP_DATE;
2667: aPlsqlItem.SCHEDULE_ACTION_CODE := aSqlItem.SCHEDULE_ACTION_CODE;
2668: aPlsqlItem.SCHEDULE_STATUS_CODE := aSqlItem.SCHEDULE_STATUS_CODE;
2669: aPlsqlItem.SHIPMENT_NUMBER := FND_API.G_MISS_NUM; --aSqlItem.SHIPMENT_NUMBER;
2670: aPlsqlItem.SHIPMENT_PRIORITY_CODE := aSqlItem.SHIPMENT_PRIORITY_CODE;
2671: aPlsqlItem.SHIPPED_QUANTITY := aSqlItem.SHIPPED_QUANTITY;
2672: aPlsqlItem.SHIPPED_QUANTITY2 := aSqlItem.SHIPPED_QUANTITY2;
2673: aPlsqlItem.SHIPPING_INTERFACED_FLAG := aSqlItem.SHIPPING_INTERFACED_FLAG;
5057: APPS.OE_ORDER_PUB.PROCESS_ORDER(
5058: p_header_rec.org_id, -- MOAC Changes in R12
5059: NULL, -- MOAC Changes in R12
5060: 1.0,
5061: FND_API.G_TRUE,
5062: FND_API.G_TRUE,
5063: FND_API.G_FALSE,
5064: X_RETURN_STATUS,
5065: L_MSG_COUNT,
5058: p_header_rec.org_id, -- MOAC Changes in R12
5059: NULL, -- MOAC Changes in R12
5060: 1.0,
5061: FND_API.G_TRUE,
5062: FND_API.G_TRUE,
5063: FND_API.G_FALSE,
5064: X_RETURN_STATUS,
5065: L_MSG_COUNT,
5066: L_MSG_DATA,
5059: NULL, -- MOAC Changes in R12
5060: 1.0,
5061: FND_API.G_TRUE,
5062: FND_API.G_TRUE,
5063: FND_API.G_FALSE,
5064: X_RETURN_STATUS,
5065: L_MSG_COUNT,
5066: L_MSG_DATA,
5067: P_HEADER_REC_,
5199: -- Ensure to have a clean message object table
5200: x_messages := OE_MESSAGE_OBJ_T();
5201:
5202: IF ( l_msg_count > 1 AND
5203: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
5204: FOR i IN 1..l_msg_count LOOP
5205: x_messages.EXTEND;
5206: x_messages(i) :=
5207: OE_MESSAGE_OBJ(
5437:
5438: oe_debug_pub.add('Entering Convert_line_null_to_miss', 1);
5439:
5440: IF p_x_line_rec.unit_cost IS NULL THEN
5441: p_x_line_rec.unit_cost := FND_API.G_MISS_NUM;
5442: END IF;
5443:
5444: IF p_x_line_rec.accounting_rule_id IS NULL THEN
5445: p_x_line_rec.accounting_rule_id := FND_API.G_MISS_NUM;
5441: p_x_line_rec.unit_cost := FND_API.G_MISS_NUM;
5442: END IF;
5443:
5444: IF p_x_line_rec.accounting_rule_id IS NULL THEN
5445: p_x_line_rec.accounting_rule_id := FND_API.G_MISS_NUM;
5446: END IF;
5447:
5448: IF p_x_line_rec.accounting_rule_duration IS NULL THEN
5449: p_x_line_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
5445: p_x_line_rec.accounting_rule_id := FND_API.G_MISS_NUM;
5446: END IF;
5447:
5448: IF p_x_line_rec.accounting_rule_duration IS NULL THEN
5449: p_x_line_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
5450: END IF;
5451:
5452: IF p_x_line_rec.actual_arrival_date IS NULL THEN
5453: p_x_line_rec.actual_arrival_date := FND_API.G_MISS_DATE;
5449: p_x_line_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
5450: END IF;
5451:
5452: IF p_x_line_rec.actual_arrival_date IS NULL THEN
5453: p_x_line_rec.actual_arrival_date := FND_API.G_MISS_DATE;
5454: END IF;
5455:
5456: IF p_x_line_rec.actual_shipment_date IS NULL THEN
5457: p_x_line_rec.actual_shipment_date := FND_API.G_MISS_DATE;
5453: p_x_line_rec.actual_arrival_date := FND_API.G_MISS_DATE;
5454: END IF;
5455:
5456: IF p_x_line_rec.actual_shipment_date IS NULL THEN
5457: p_x_line_rec.actual_shipment_date := FND_API.G_MISS_DATE;
5458: END IF;
5459:
5460: IF p_x_line_rec.agreement_id IS NULL THEN
5461: p_x_line_rec.agreement_id := FND_API.G_MISS_NUM;
5457: p_x_line_rec.actual_shipment_date := FND_API.G_MISS_DATE;
5458: END IF;
5459:
5460: IF p_x_line_rec.agreement_id IS NULL THEN
5461: p_x_line_rec.agreement_id := FND_API.G_MISS_NUM;
5462: END IF;
5463:
5464: IF p_x_line_rec.arrival_set_id IS NULL THEN
5465: p_x_line_rec.arrival_set_id := FND_API.G_MISS_NUM;
5461: p_x_line_rec.agreement_id := FND_API.G_MISS_NUM;
5462: END IF;
5463:
5464: IF p_x_line_rec.arrival_set_id IS NULL THEN
5465: p_x_line_rec.arrival_set_id := FND_API.G_MISS_NUM;
5466: END IF;
5467:
5468: IF p_x_line_rec.ato_line_id IS NULL THEN
5469: p_x_line_rec.ato_line_id := FND_API.G_MISS_NUM;
5465: p_x_line_rec.arrival_set_id := FND_API.G_MISS_NUM;
5466: END IF;
5467:
5468: IF p_x_line_rec.ato_line_id IS NULL THEN
5469: p_x_line_rec.ato_line_id := FND_API.G_MISS_NUM;
5470: END IF;
5471:
5472: IF p_x_line_rec.upgraded_flag IS NULL THEN
5473: p_x_line_rec.upgraded_flag := FND_API.G_MISS_CHAR;
5469: p_x_line_rec.ato_line_id := FND_API.G_MISS_NUM;
5470: END IF;
5471:
5472: IF p_x_line_rec.upgraded_flag IS NULL THEN
5473: p_x_line_rec.upgraded_flag := FND_API.G_MISS_CHAR;
5474: END IF;
5475:
5476: IF p_x_line_rec.attribute1 IS NULL THEN
5477: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
5473: p_x_line_rec.upgraded_flag := FND_API.G_MISS_CHAR;
5474: END IF;
5475:
5476: IF p_x_line_rec.attribute1 IS NULL THEN
5477: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
5478: END IF;
5479:
5480: IF p_x_line_rec.attribute10 IS NULL THEN
5481: p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
5477: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
5478: END IF;
5479:
5480: IF p_x_line_rec.attribute10 IS NULL THEN
5481: p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
5482: END IF;
5483:
5484: IF p_x_line_rec.attribute11 IS NULL THEN
5485: p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
5481: p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
5482: END IF;
5483:
5484: IF p_x_line_rec.attribute11 IS NULL THEN
5485: p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
5486: END IF;
5487:
5488: IF p_x_line_rec.attribute12 IS NULL THEN
5489: p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
5485: p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
5486: END IF;
5487:
5488: IF p_x_line_rec.attribute12 IS NULL THEN
5489: p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
5490: END IF;
5491:
5492: IF p_x_line_rec.attribute13 IS NULL THEN
5493: p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
5489: p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
5490: END IF;
5491:
5492: IF p_x_line_rec.attribute13 IS NULL THEN
5493: p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
5494: END IF;
5495:
5496: IF p_x_line_rec.attribute14 IS NULL THEN
5497: p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
5493: p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
5494: END IF;
5495:
5496: IF p_x_line_rec.attribute14 IS NULL THEN
5497: p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
5498: END IF;
5499:
5500: IF p_x_line_rec.attribute15 IS NULL THEN
5501: p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
5497: p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
5498: END IF;
5499:
5500: IF p_x_line_rec.attribute15 IS NULL THEN
5501: p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
5502: END IF;
5503:
5504: IF p_x_line_rec.attribute16 IS NULL THEN
5505: p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR;
5501: p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
5502: END IF;
5503:
5504: IF p_x_line_rec.attribute16 IS NULL THEN
5505: p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR;
5506: END IF;
5507:
5508: IF p_x_line_rec.attribute17 IS NULL THEN
5509: p_x_line_rec.attribute17 := FND_API.G_MISS_CHAR;
5505: p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR;
5506: END IF;
5507:
5508: IF p_x_line_rec.attribute17 IS NULL THEN
5509: p_x_line_rec.attribute17 := FND_API.G_MISS_CHAR;
5510: END IF;
5511:
5512: IF p_x_line_rec.attribute18 IS NULL THEN
5513: p_x_line_rec.attribute18 := FND_API.G_MISS_CHAR;
5509: p_x_line_rec.attribute17 := FND_API.G_MISS_CHAR;
5510: END IF;
5511:
5512: IF p_x_line_rec.attribute18 IS NULL THEN
5513: p_x_line_rec.attribute18 := FND_API.G_MISS_CHAR;
5514: END IF;
5515:
5516: IF p_x_line_rec.attribute19 IS NULL THEN
5517: p_x_line_rec.attribute19 := FND_API.G_MISS_CHAR;
5513: p_x_line_rec.attribute18 := FND_API.G_MISS_CHAR;
5514: END IF;
5515:
5516: IF p_x_line_rec.attribute19 IS NULL THEN
5517: p_x_line_rec.attribute19 := FND_API.G_MISS_CHAR;
5518: END IF;
5519:
5520: IF p_x_line_rec.attribute2 IS NULL THEN
5521: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
5517: p_x_line_rec.attribute19 := FND_API.G_MISS_CHAR;
5518: END IF;
5519:
5520: IF p_x_line_rec.attribute2 IS NULL THEN
5521: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
5522: END IF;
5523:
5524: IF p_x_line_rec.attribute20 IS NULL THEN
5525: p_x_line_rec.attribute20 := FND_API.G_MISS_CHAR;
5521: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
5522: END IF;
5523:
5524: IF p_x_line_rec.attribute20 IS NULL THEN
5525: p_x_line_rec.attribute20 := FND_API.G_MISS_CHAR;
5526: END IF;
5527:
5528: IF p_x_line_rec.attribute3 IS NULL THEN
5529: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
5525: p_x_line_rec.attribute20 := FND_API.G_MISS_CHAR;
5526: END IF;
5527:
5528: IF p_x_line_rec.attribute3 IS NULL THEN
5529: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
5530: END IF;
5531:
5532: IF p_x_line_rec.attribute4 IS NULL THEN
5533: p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
5529: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
5530: END IF;
5531:
5532: IF p_x_line_rec.attribute4 IS NULL THEN
5533: p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
5534: END IF;
5535:
5536: IF p_x_line_rec.attribute5 IS NULL THEN
5537: p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
5533: p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
5534: END IF;
5535:
5536: IF p_x_line_rec.attribute5 IS NULL THEN
5537: p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
5538: END IF;
5539:
5540: IF p_x_line_rec.attribute6 IS NULL THEN
5541: p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
5537: p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
5538: END IF;
5539:
5540: IF p_x_line_rec.attribute6 IS NULL THEN
5541: p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
5542: END IF;
5543:
5544: IF p_x_line_rec.attribute7 IS NULL THEN
5545: p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
5541: p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
5542: END IF;
5543:
5544: IF p_x_line_rec.attribute7 IS NULL THEN
5545: p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
5546: END IF;
5547:
5548: IF p_x_line_rec.attribute8 IS NULL THEN
5549: p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
5545: p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
5546: END IF;
5547:
5548: IF p_x_line_rec.attribute8 IS NULL THEN
5549: p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
5550: END IF;
5551:
5552: IF p_x_line_rec.attribute9 IS NULL THEN
5553: p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
5549: p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
5550: END IF;
5551:
5552: IF p_x_line_rec.attribute9 IS NULL THEN
5553: p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
5554: END IF;
5555:
5556: IF p_x_line_rec.auto_selected_quantity IS NULL THEN
5557: p_x_line_rec.auto_selected_quantity := FND_API.G_MISS_NUM;
5553: p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
5554: END IF;
5555:
5556: IF p_x_line_rec.auto_selected_quantity IS NULL THEN
5557: p_x_line_rec.auto_selected_quantity := FND_API.G_MISS_NUM;
5558: END IF;
5559: IF p_x_line_rec.authorized_to_ship_flag IS NULL THEN
5560: p_x_line_rec.authorized_to_ship_flag := FND_API.G_MISS_CHAR;
5561: END IF;
5556: IF p_x_line_rec.auto_selected_quantity IS NULL THEN
5557: p_x_line_rec.auto_selected_quantity := FND_API.G_MISS_NUM;
5558: END IF;
5559: IF p_x_line_rec.authorized_to_ship_flag IS NULL THEN
5560: p_x_line_rec.authorized_to_ship_flag := FND_API.G_MISS_CHAR;
5561: END IF;
5562:
5563: IF p_x_line_rec.booked_flag IS NULL THEN
5564: p_x_line_rec.booked_flag := FND_API.G_MISS_CHAR;
5560: p_x_line_rec.authorized_to_ship_flag := FND_API.G_MISS_CHAR;
5561: END IF;
5562:
5563: IF p_x_line_rec.booked_flag IS NULL THEN
5564: p_x_line_rec.booked_flag := FND_API.G_MISS_CHAR;
5565: END IF;
5566:
5567: IF p_x_line_rec.cancelled_flag IS NULL THEN
5568: p_x_line_rec.cancelled_flag := FND_API.G_MISS_CHAR;
5564: p_x_line_rec.booked_flag := FND_API.G_MISS_CHAR;
5565: END IF;
5566:
5567: IF p_x_line_rec.cancelled_flag IS NULL THEN
5568: p_x_line_rec.cancelled_flag := FND_API.G_MISS_CHAR;
5569: END IF;
5570:
5571: IF p_x_line_rec.cancelled_quantity IS NULL THEN
5572: p_x_line_rec.cancelled_quantity := FND_API.G_MISS_NUM;
5568: p_x_line_rec.cancelled_flag := FND_API.G_MISS_CHAR;
5569: END IF;
5570:
5571: IF p_x_line_rec.cancelled_quantity IS NULL THEN
5572: p_x_line_rec.cancelled_quantity := FND_API.G_MISS_NUM;
5573: END IF;
5574:
5575: IF p_x_line_rec.component_code IS NULL THEN
5576: p_x_line_rec.component_code := FND_API.G_MISS_CHAR;
5572: p_x_line_rec.cancelled_quantity := FND_API.G_MISS_NUM;
5573: END IF;
5574:
5575: IF p_x_line_rec.component_code IS NULL THEN
5576: p_x_line_rec.component_code := FND_API.G_MISS_CHAR;
5577: END IF;
5578:
5579: IF p_x_line_rec.component_number IS NULL THEN
5580: p_x_line_rec.component_number := FND_API.G_MISS_NUM;
5576: p_x_line_rec.component_code := FND_API.G_MISS_CHAR;
5577: END IF;
5578:
5579: IF p_x_line_rec.component_number IS NULL THEN
5580: p_x_line_rec.component_number := FND_API.G_MISS_NUM;
5581: END IF;
5582:
5583: IF p_x_line_rec.component_sequence_id IS NULL THEN
5584: p_x_line_rec.component_sequence_id := FND_API.G_MISS_NUM;
5580: p_x_line_rec.component_number := FND_API.G_MISS_NUM;
5581: END IF;
5582:
5583: IF p_x_line_rec.component_sequence_id IS NULL THEN
5584: p_x_line_rec.component_sequence_id := FND_API.G_MISS_NUM;
5585: END IF;
5586:
5587: IF p_x_line_rec.config_header_id IS NULL THEN
5588: p_x_line_rec.config_header_id := FND_API.G_MISS_NUM;
5584: p_x_line_rec.component_sequence_id := FND_API.G_MISS_NUM;
5585: END IF;
5586:
5587: IF p_x_line_rec.config_header_id IS NULL THEN
5588: p_x_line_rec.config_header_id := FND_API.G_MISS_NUM;
5589: END IF;
5590:
5591: IF p_x_line_rec.config_rev_nbr IS NULL THEN
5592: p_x_line_rec.config_rev_nbr := FND_API.G_MISS_NUM;
5588: p_x_line_rec.config_header_id := FND_API.G_MISS_NUM;
5589: END IF;
5590:
5591: IF p_x_line_rec.config_rev_nbr IS NULL THEN
5592: p_x_line_rec.config_rev_nbr := FND_API.G_MISS_NUM;
5593: END IF;
5594:
5595: IF p_x_line_rec.config_display_sequence IS NULL THEN
5596: p_x_line_rec.config_display_sequence := FND_API.G_MISS_NUM;
5592: p_x_line_rec.config_rev_nbr := FND_API.G_MISS_NUM;
5593: END IF;
5594:
5595: IF p_x_line_rec.config_display_sequence IS NULL THEN
5596: p_x_line_rec.config_display_sequence := FND_API.G_MISS_NUM;
5597: END IF;
5598:
5599: IF p_x_line_rec.configuration_id IS NULL THEN
5600: p_x_line_rec.configuration_id := FND_API.G_MISS_NUM;
5596: p_x_line_rec.config_display_sequence := FND_API.G_MISS_NUM;
5597: END IF;
5598:
5599: IF p_x_line_rec.configuration_id IS NULL THEN
5600: p_x_line_rec.configuration_id := FND_API.G_MISS_NUM;
5601: END IF;
5602:
5603: IF p_x_line_rec.context IS NULL THEN
5604: p_x_line_rec.context := FND_API.G_MISS_CHAR;
5600: p_x_line_rec.configuration_id := FND_API.G_MISS_NUM;
5601: END IF;
5602:
5603: IF p_x_line_rec.context IS NULL THEN
5604: p_x_line_rec.context := FND_API.G_MISS_CHAR;
5605: END IF;
5606:
5607: IF p_x_line_rec.created_by IS NULL THEN
5608: p_x_line_rec.created_by := FND_API.G_MISS_NUM;
5604: p_x_line_rec.context := FND_API.G_MISS_CHAR;
5605: END IF;
5606:
5607: IF p_x_line_rec.created_by IS NULL THEN
5608: p_x_line_rec.created_by := FND_API.G_MISS_NUM;
5609: END IF;
5610:
5611: IF p_x_line_rec.creation_date IS NULL THEN
5612: p_x_line_rec.creation_date := FND_API.G_MISS_DATE;
5608: p_x_line_rec.created_by := FND_API.G_MISS_NUM;
5609: END IF;
5610:
5611: IF p_x_line_rec.creation_date IS NULL THEN
5612: p_x_line_rec.creation_date := FND_API.G_MISS_DATE;
5613: END IF;
5614:
5615: IF p_x_line_rec.credit_invoice_line_id IS NULL THEN
5616: p_x_line_rec.credit_invoice_line_id := FND_API.G_MISS_NUM;
5612: p_x_line_rec.creation_date := FND_API.G_MISS_DATE;
5613: END IF;
5614:
5615: IF p_x_line_rec.credit_invoice_line_id IS NULL THEN
5616: p_x_line_rec.credit_invoice_line_id := FND_API.G_MISS_NUM;
5617: END IF;
5618:
5619: IF p_x_line_rec.customer_dock_code IS NULL THEN
5620: p_x_line_rec.customer_dock_code := FND_API.G_MISS_CHAR;
5616: p_x_line_rec.credit_invoice_line_id := FND_API.G_MISS_NUM;
5617: END IF;
5618:
5619: IF p_x_line_rec.customer_dock_code IS NULL THEN
5620: p_x_line_rec.customer_dock_code := FND_API.G_MISS_CHAR;
5621: END IF;
5622:
5623: IF p_x_line_rec.customer_job IS NULL THEN
5624: p_x_line_rec.customer_job := FND_API.G_MISS_CHAR;
5620: p_x_line_rec.customer_dock_code := FND_API.G_MISS_CHAR;
5621: END IF;
5622:
5623: IF p_x_line_rec.customer_job IS NULL THEN
5624: p_x_line_rec.customer_job := FND_API.G_MISS_CHAR;
5625: END IF;
5626:
5627: IF p_x_line_rec.customer_production_line IS NULL THEN
5628: p_x_line_rec.customer_production_line := FND_API.G_MISS_CHAR;
5624: p_x_line_rec.customer_job := FND_API.G_MISS_CHAR;
5625: END IF;
5626:
5627: IF p_x_line_rec.customer_production_line IS NULL THEN
5628: p_x_line_rec.customer_production_line := FND_API.G_MISS_CHAR;
5629: END IF;
5630:
5631: IF p_x_line_rec.cust_production_seq_num IS NULL THEN
5632: p_x_line_rec.cust_production_seq_num := FND_API.G_MISS_CHAR;
5628: p_x_line_rec.customer_production_line := FND_API.G_MISS_CHAR;
5629: END IF;
5630:
5631: IF p_x_line_rec.cust_production_seq_num IS NULL THEN
5632: p_x_line_rec.cust_production_seq_num := FND_API.G_MISS_CHAR;
5633: END IF;
5634:
5635: IF p_x_line_rec.customer_trx_line_id IS NULL THEN
5636: p_x_line_rec.customer_trx_line_id := FND_API.G_MISS_NUM;
5632: p_x_line_rec.cust_production_seq_num := FND_API.G_MISS_CHAR;
5633: END IF;
5634:
5635: IF p_x_line_rec.customer_trx_line_id IS NULL THEN
5636: p_x_line_rec.customer_trx_line_id := FND_API.G_MISS_NUM;
5637: END IF;
5638:
5639: IF p_x_line_rec.cust_model_serial_number IS NULL THEN
5640: p_x_line_rec.cust_model_serial_number := FND_API.G_MISS_CHAR;
5636: p_x_line_rec.customer_trx_line_id := FND_API.G_MISS_NUM;
5637: END IF;
5638:
5639: IF p_x_line_rec.cust_model_serial_number IS NULL THEN
5640: p_x_line_rec.cust_model_serial_number := FND_API.G_MISS_CHAR;
5641: END IF;
5642:
5643: IF p_x_line_rec.cust_po_number IS NULL THEN
5644: p_x_line_rec.cust_po_number := FND_API.G_MISS_CHAR;
5640: p_x_line_rec.cust_model_serial_number := FND_API.G_MISS_CHAR;
5641: END IF;
5642:
5643: IF p_x_line_rec.cust_po_number IS NULL THEN
5644: p_x_line_rec.cust_po_number := FND_API.G_MISS_CHAR;
5645: END IF;
5646:
5647: IF p_x_line_rec.customer_line_number IS NULL THEN
5648: p_x_line_rec.customer_line_number := FND_API.G_MISS_CHAR;
5644: p_x_line_rec.cust_po_number := FND_API.G_MISS_CHAR;
5645: END IF;
5646:
5647: IF p_x_line_rec.customer_line_number IS NULL THEN
5648: p_x_line_rec.customer_line_number := FND_API.G_MISS_CHAR;
5649: END IF;
5650:
5651: IF p_x_line_rec.customer_shipment_number IS NULL THEN
5652: p_x_line_rec.customer_shipment_number := FND_API.G_MISS_CHAR;
5648: p_x_line_rec.customer_line_number := FND_API.G_MISS_CHAR;
5649: END IF;
5650:
5651: IF p_x_line_rec.customer_shipment_number IS NULL THEN
5652: p_x_line_rec.customer_shipment_number := FND_API.G_MISS_CHAR;
5653: END IF;
5654:
5655: IF p_x_line_rec.delivery_lead_time IS NULL THEN
5656: p_x_line_rec.delivery_lead_time := FND_API.G_MISS_NUM;
5652: p_x_line_rec.customer_shipment_number := FND_API.G_MISS_CHAR;
5653: END IF;
5654:
5655: IF p_x_line_rec.delivery_lead_time IS NULL THEN
5656: p_x_line_rec.delivery_lead_time := FND_API.G_MISS_NUM;
5657: END IF;
5658:
5659: IF p_x_line_rec.deliver_to_contact_id IS NULL THEN
5660: p_x_line_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
5656: p_x_line_rec.delivery_lead_time := FND_API.G_MISS_NUM;
5657: END IF;
5658:
5659: IF p_x_line_rec.deliver_to_contact_id IS NULL THEN
5660: p_x_line_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
5661: END IF;
5662:
5663: IF p_x_line_rec.deliver_to_org_id IS NULL THEN
5664: p_x_line_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
5660: p_x_line_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
5661: END IF;
5662:
5663: IF p_x_line_rec.deliver_to_org_id IS NULL THEN
5664: p_x_line_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
5665: END IF;
5666:
5667: IF p_x_line_rec.demand_bucket_type_code IS NULL THEN
5668: p_x_line_rec.demand_bucket_type_code := FND_API.G_MISS_CHAR;
5664: p_x_line_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
5665: END IF;
5666:
5667: IF p_x_line_rec.demand_bucket_type_code IS NULL THEN
5668: p_x_line_rec.demand_bucket_type_code := FND_API.G_MISS_CHAR;
5669: END IF;
5670:
5671: IF p_x_line_rec.demand_class_code IS NULL THEN
5672: p_x_line_rec.demand_class_code := FND_API.G_MISS_CHAR;
5668: p_x_line_rec.demand_bucket_type_code := FND_API.G_MISS_CHAR;
5669: END IF;
5670:
5671: IF p_x_line_rec.demand_class_code IS NULL THEN
5672: p_x_line_rec.demand_class_code := FND_API.G_MISS_CHAR;
5673: END IF;
5674:
5675: IF p_x_line_rec.dep_plan_required_flag IS NULL THEN
5676: p_x_line_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
5672: p_x_line_rec.demand_class_code := FND_API.G_MISS_CHAR;
5673: END IF;
5674:
5675: IF p_x_line_rec.dep_plan_required_flag IS NULL THEN
5676: p_x_line_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
5677: END IF;
5678:
5679: IF p_x_line_rec.earliest_acceptable_date IS NULL THEN
5680: p_x_line_rec.earliest_acceptable_date := FND_API.G_MISS_DATE;
5676: p_x_line_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
5677: END IF;
5678:
5679: IF p_x_line_rec.earliest_acceptable_date IS NULL THEN
5680: p_x_line_rec.earliest_acceptable_date := FND_API.G_MISS_DATE;
5681: END IF;
5682:
5683: IF p_x_line_rec.explosion_date IS NULL THEN
5684: p_x_line_rec.explosion_date := FND_API.G_MISS_DATE;
5680: p_x_line_rec.earliest_acceptable_date := FND_API.G_MISS_DATE;
5681: END IF;
5682:
5683: IF p_x_line_rec.explosion_date IS NULL THEN
5684: p_x_line_rec.explosion_date := FND_API.G_MISS_DATE;
5685: END IF;
5686:
5687: IF p_x_line_rec.fob_point_code IS NULL THEN
5688: p_x_line_rec.fob_point_code := FND_API.G_MISS_CHAR;
5684: p_x_line_rec.explosion_date := FND_API.G_MISS_DATE;
5685: END IF;
5686:
5687: IF p_x_line_rec.fob_point_code IS NULL THEN
5688: p_x_line_rec.fob_point_code := FND_API.G_MISS_CHAR;
5689: END IF;
5690:
5691: IF p_x_line_rec.freight_carrier_code IS NULL THEN
5692: p_x_line_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
5688: p_x_line_rec.fob_point_code := FND_API.G_MISS_CHAR;
5689: END IF;
5690:
5691: IF p_x_line_rec.freight_carrier_code IS NULL THEN
5692: p_x_line_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
5693: END IF;
5694:
5695: IF p_x_line_rec.freight_terms_code IS NULL THEN
5696: p_x_line_rec.freight_terms_code := FND_API.G_MISS_CHAR;
5692: p_x_line_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
5693: END IF;
5694:
5695: IF p_x_line_rec.freight_terms_code IS NULL THEN
5696: p_x_line_rec.freight_terms_code := FND_API.G_MISS_CHAR;
5697: END IF;
5698:
5699: IF p_x_line_rec.fulfilled_quantity IS NULL THEN
5700: p_x_line_rec.fulfilled_quantity := FND_API.G_MISS_NUM;
5696: p_x_line_rec.freight_terms_code := FND_API.G_MISS_CHAR;
5697: END IF;
5698:
5699: IF p_x_line_rec.fulfilled_quantity IS NULL THEN
5700: p_x_line_rec.fulfilled_quantity := FND_API.G_MISS_NUM;
5701: END IF;
5702:
5703: IF p_x_line_rec.fulfilled_flag IS NULL THEN
5704: p_x_line_rec.fulfilled_flag := FND_API.G_MISS_CHAR;
5700: p_x_line_rec.fulfilled_quantity := FND_API.G_MISS_NUM;
5701: END IF;
5702:
5703: IF p_x_line_rec.fulfilled_flag IS NULL THEN
5704: p_x_line_rec.fulfilled_flag := FND_API.G_MISS_CHAR;
5705: END IF;
5706:
5707: IF p_x_line_rec.fulfillment_method_code IS NULL THEN
5708: p_x_line_rec.fulfillment_method_code := FND_API.G_MISS_CHAR;
5704: p_x_line_rec.fulfilled_flag := FND_API.G_MISS_CHAR;
5705: END IF;
5706:
5707: IF p_x_line_rec.fulfillment_method_code IS NULL THEN
5708: p_x_line_rec.fulfillment_method_code := FND_API.G_MISS_CHAR;
5709: END IF;
5710:
5711: IF p_x_line_rec.fulfillment_date IS NULL THEN
5712: p_x_line_rec.fulfillment_date := FND_API.G_MISS_DATE;
5708: p_x_line_rec.fulfillment_method_code := FND_API.G_MISS_CHAR;
5709: END IF;
5710:
5711: IF p_x_line_rec.fulfillment_date IS NULL THEN
5712: p_x_line_rec.fulfillment_date := FND_API.G_MISS_DATE;
5713: END IF;
5714:
5715: IF p_x_line_rec.global_attribute1 IS NULL THEN
5716: p_x_line_rec.global_attribute1 := FND_API.G_MISS_CHAR;
5712: p_x_line_rec.fulfillment_date := FND_API.G_MISS_DATE;
5713: END IF;
5714:
5715: IF p_x_line_rec.global_attribute1 IS NULL THEN
5716: p_x_line_rec.global_attribute1 := FND_API.G_MISS_CHAR;
5717: END IF;
5718:
5719: IF p_x_line_rec.global_attribute10 IS NULL THEN
5720: p_x_line_rec.global_attribute10 := FND_API.G_MISS_CHAR;
5716: p_x_line_rec.global_attribute1 := FND_API.G_MISS_CHAR;
5717: END IF;
5718:
5719: IF p_x_line_rec.global_attribute10 IS NULL THEN
5720: p_x_line_rec.global_attribute10 := FND_API.G_MISS_CHAR;
5721: END IF;
5722:
5723: IF p_x_line_rec.global_attribute11 IS NULL THEN
5724: p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
5720: p_x_line_rec.global_attribute10 := FND_API.G_MISS_CHAR;
5721: END IF;
5722:
5723: IF p_x_line_rec.global_attribute11 IS NULL THEN
5724: p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
5725: END IF;
5726:
5727: IF p_x_line_rec.global_attribute12 IS NULL THEN
5728: p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
5724: p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
5725: END IF;
5726:
5727: IF p_x_line_rec.global_attribute12 IS NULL THEN
5728: p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
5729: END IF;
5730:
5731: IF p_x_line_rec.global_attribute13 IS NULL THEN
5732: p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
5728: p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
5729: END IF;
5730:
5731: IF p_x_line_rec.global_attribute13 IS NULL THEN
5732: p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
5733: END IF;
5734:
5735: IF p_x_line_rec.global_attribute14 IS NULL THEN
5736: p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
5732: p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
5733: END IF;
5734:
5735: IF p_x_line_rec.global_attribute14 IS NULL THEN
5736: p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
5737: END IF;
5738:
5739: IF p_x_line_rec.global_attribute15 IS NULL THEN
5740: p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
5736: p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
5737: END IF;
5738:
5739: IF p_x_line_rec.global_attribute15 IS NULL THEN
5740: p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
5741: END IF;
5742:
5743: IF p_x_line_rec.global_attribute16 IS NULL THEN
5744: p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
5740: p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
5741: END IF;
5742:
5743: IF p_x_line_rec.global_attribute16 IS NULL THEN
5744: p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
5745: END IF;
5746:
5747: IF p_x_line_rec.global_attribute17 IS NULL THEN
5748: p_x_line_rec.global_attribute17 := FND_API.G_MISS_CHAR;
5744: p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
5745: END IF;
5746:
5747: IF p_x_line_rec.global_attribute17 IS NULL THEN
5748: p_x_line_rec.global_attribute17 := FND_API.G_MISS_CHAR;
5749: END IF;
5750:
5751: IF p_x_line_rec.global_attribute18 IS NULL THEN
5752: p_x_line_rec.global_attribute18 := FND_API.G_MISS_CHAR;
5748: p_x_line_rec.global_attribute17 := FND_API.G_MISS_CHAR;
5749: END IF;
5750:
5751: IF p_x_line_rec.global_attribute18 IS NULL THEN
5752: p_x_line_rec.global_attribute18 := FND_API.G_MISS_CHAR;
5753: END IF;
5754:
5755: IF p_x_line_rec.global_attribute19 IS NULL THEN
5756: p_x_line_rec.global_attribute19 := FND_API.G_MISS_CHAR;
5752: p_x_line_rec.global_attribute18 := FND_API.G_MISS_CHAR;
5753: END IF;
5754:
5755: IF p_x_line_rec.global_attribute19 IS NULL THEN
5756: p_x_line_rec.global_attribute19 := FND_API.G_MISS_CHAR;
5757: END IF;
5758:
5759: IF p_x_line_rec.global_attribute2 IS NULL THEN
5760: p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
5756: p_x_line_rec.global_attribute19 := FND_API.G_MISS_CHAR;
5757: END IF;
5758:
5759: IF p_x_line_rec.global_attribute2 IS NULL THEN
5760: p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
5761: END IF;
5762:
5763: IF p_x_line_rec.global_attribute20 IS NULL THEN
5764: p_x_line_rec.global_attribute20 := FND_API.G_MISS_CHAR;
5760: p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
5761: END IF;
5762:
5763: IF p_x_line_rec.global_attribute20 IS NULL THEN
5764: p_x_line_rec.global_attribute20 := FND_API.G_MISS_CHAR;
5765: END IF;
5766:
5767: IF p_x_line_rec.global_attribute3 IS NULL THEN
5768: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
5764: p_x_line_rec.global_attribute20 := FND_API.G_MISS_CHAR;
5765: END IF;
5766:
5767: IF p_x_line_rec.global_attribute3 IS NULL THEN
5768: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
5769: END IF;
5770:
5771: IF p_x_line_rec.global_attribute4 IS NULL THEN
5772: p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
5768: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
5769: END IF;
5770:
5771: IF p_x_line_rec.global_attribute4 IS NULL THEN
5772: p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
5773: END IF;
5774:
5775: IF p_x_line_rec.global_attribute5 IS NULL THEN
5776: p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
5772: p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
5773: END IF;
5774:
5775: IF p_x_line_rec.global_attribute5 IS NULL THEN
5776: p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
5777: END IF;
5778:
5779: IF p_x_line_rec.global_attribute6 IS NULL THEN
5780: p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
5776: p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
5777: END IF;
5778:
5779: IF p_x_line_rec.global_attribute6 IS NULL THEN
5780: p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
5781: END IF;
5782:
5783: IF p_x_line_rec.global_attribute7 IS NULL THEN
5784: p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
5780: p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
5781: END IF;
5782:
5783: IF p_x_line_rec.global_attribute7 IS NULL THEN
5784: p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
5785: END IF;
5786:
5787: IF p_x_line_rec.global_attribute8 IS NULL THEN
5788: p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
5784: p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
5785: END IF;
5786:
5787: IF p_x_line_rec.global_attribute8 IS NULL THEN
5788: p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
5789: END IF;
5790:
5791: IF p_x_line_rec.global_attribute9 IS NULL THEN
5792: p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
5788: p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
5789: END IF;
5790:
5791: IF p_x_line_rec.global_attribute9 IS NULL THEN
5792: p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
5793: END IF;
5794:
5795: IF p_x_line_rec.global_attribute_category IS NULL THEN
5796: p_x_line_rec.global_attribute_category := FND_API.G_MISS_CHAR;
5792: p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
5793: END IF;
5794:
5795: IF p_x_line_rec.global_attribute_category IS NULL THEN
5796: p_x_line_rec.global_attribute_category := FND_API.G_MISS_CHAR;
5797: END IF;
5798:
5799: IF p_x_line_rec.header_id IS NULL THEN
5800: p_x_line_rec.header_id := FND_API.G_MISS_NUM;
5796: p_x_line_rec.global_attribute_category := FND_API.G_MISS_CHAR;
5797: END IF;
5798:
5799: IF p_x_line_rec.header_id IS NULL THEN
5800: p_x_line_rec.header_id := FND_API.G_MISS_NUM;
5801: END IF;
5802:
5803: IF p_x_line_rec.industry_attribute1 IS NULL THEN
5804: p_x_line_rec.industry_attribute1 := FND_API.G_MISS_CHAR;
5800: p_x_line_rec.header_id := FND_API.G_MISS_NUM;
5801: END IF;
5802:
5803: IF p_x_line_rec.industry_attribute1 IS NULL THEN
5804: p_x_line_rec.industry_attribute1 := FND_API.G_MISS_CHAR;
5805: END IF;
5806:
5807: IF p_x_line_rec.industry_attribute10 IS NULL THEN
5808: p_x_line_rec.industry_attribute10 := FND_API.G_MISS_CHAR;
5804: p_x_line_rec.industry_attribute1 := FND_API.G_MISS_CHAR;
5805: END IF;
5806:
5807: IF p_x_line_rec.industry_attribute10 IS NULL THEN
5808: p_x_line_rec.industry_attribute10 := FND_API.G_MISS_CHAR;
5809: END IF;
5810:
5811: IF p_x_line_rec.industry_attribute11 IS NULL THEN
5812: p_x_line_rec.industry_attribute11 := FND_API.G_MISS_CHAR;
5808: p_x_line_rec.industry_attribute10 := FND_API.G_MISS_CHAR;
5809: END IF;
5810:
5811: IF p_x_line_rec.industry_attribute11 IS NULL THEN
5812: p_x_line_rec.industry_attribute11 := FND_API.G_MISS_CHAR;
5813: END IF;
5814:
5815: IF p_x_line_rec.industry_attribute12 IS NULL THEN
5816: p_x_line_rec.industry_attribute12 := FND_API.G_MISS_CHAR;
5812: p_x_line_rec.industry_attribute11 := FND_API.G_MISS_CHAR;
5813: END IF;
5814:
5815: IF p_x_line_rec.industry_attribute12 IS NULL THEN
5816: p_x_line_rec.industry_attribute12 := FND_API.G_MISS_CHAR;
5817: END IF;
5818:
5819: IF p_x_line_rec.industry_attribute13 IS NULL THEN
5820: p_x_line_rec.industry_attribute13 := FND_API.G_MISS_CHAR;
5816: p_x_line_rec.industry_attribute12 := FND_API.G_MISS_CHAR;
5817: END IF;
5818:
5819: IF p_x_line_rec.industry_attribute13 IS NULL THEN
5820: p_x_line_rec.industry_attribute13 := FND_API.G_MISS_CHAR;
5821: END IF;
5822:
5823: IF p_x_line_rec.industry_attribute14 IS NULL THEN
5824: p_x_line_rec.industry_attribute14 := FND_API.G_MISS_CHAR;
5820: p_x_line_rec.industry_attribute13 := FND_API.G_MISS_CHAR;
5821: END IF;
5822:
5823: IF p_x_line_rec.industry_attribute14 IS NULL THEN
5824: p_x_line_rec.industry_attribute14 := FND_API.G_MISS_CHAR;
5825: END IF;
5826:
5827: IF p_x_line_rec.industry_attribute15 IS NULL THEN
5828: p_x_line_rec.industry_attribute15 := FND_API.G_MISS_CHAR;
5824: p_x_line_rec.industry_attribute14 := FND_API.G_MISS_CHAR;
5825: END IF;
5826:
5827: IF p_x_line_rec.industry_attribute15 IS NULL THEN
5828: p_x_line_rec.industry_attribute15 := FND_API.G_MISS_CHAR;
5829: END IF;
5830:
5831: IF p_x_line_rec.industry_attribute16 IS NULL THEN
5832: p_x_line_rec.industry_attribute16 := FND_API.G_MISS_CHAR;
5828: p_x_line_rec.industry_attribute15 := FND_API.G_MISS_CHAR;
5829: END IF;
5830:
5831: IF p_x_line_rec.industry_attribute16 IS NULL THEN
5832: p_x_line_rec.industry_attribute16 := FND_API.G_MISS_CHAR;
5833: END IF;
5834:
5835: IF p_x_line_rec.industry_attribute17 IS NULL THEN
5836: p_x_line_rec.industry_attribute17 := FND_API.G_MISS_CHAR;
5832: p_x_line_rec.industry_attribute16 := FND_API.G_MISS_CHAR;
5833: END IF;
5834:
5835: IF p_x_line_rec.industry_attribute17 IS NULL THEN
5836: p_x_line_rec.industry_attribute17 := FND_API.G_MISS_CHAR;
5837: END IF;
5838:
5839: IF p_x_line_rec.industry_attribute18 IS NULL THEN
5840: p_x_line_rec.industry_attribute18 := FND_API.G_MISS_CHAR;
5836: p_x_line_rec.industry_attribute17 := FND_API.G_MISS_CHAR;
5837: END IF;
5838:
5839: IF p_x_line_rec.industry_attribute18 IS NULL THEN
5840: p_x_line_rec.industry_attribute18 := FND_API.G_MISS_CHAR;
5841: END IF;
5842:
5843: IF p_x_line_rec.industry_attribute19 IS NULL THEN
5844: p_x_line_rec.industry_attribute19 := FND_API.G_MISS_CHAR;
5840: p_x_line_rec.industry_attribute18 := FND_API.G_MISS_CHAR;
5841: END IF;
5842:
5843: IF p_x_line_rec.industry_attribute19 IS NULL THEN
5844: p_x_line_rec.industry_attribute19 := FND_API.G_MISS_CHAR;
5845: END IF;
5846:
5847: IF p_x_line_rec.industry_attribute20 IS NULL THEN
5848: p_x_line_rec.industry_attribute20 := FND_API.G_MISS_CHAR;
5844: p_x_line_rec.industry_attribute19 := FND_API.G_MISS_CHAR;
5845: END IF;
5846:
5847: IF p_x_line_rec.industry_attribute20 IS NULL THEN
5848: p_x_line_rec.industry_attribute20 := FND_API.G_MISS_CHAR;
5849: END IF;
5850:
5851: IF p_x_line_rec.industry_attribute21 IS NULL THEN
5852: p_x_line_rec.industry_attribute21 := FND_API.G_MISS_CHAR;
5848: p_x_line_rec.industry_attribute20 := FND_API.G_MISS_CHAR;
5849: END IF;
5850:
5851: IF p_x_line_rec.industry_attribute21 IS NULL THEN
5852: p_x_line_rec.industry_attribute21 := FND_API.G_MISS_CHAR;
5853: END IF;
5854:
5855: IF p_x_line_rec.industry_attribute22 IS NULL THEN
5856: p_x_line_rec.industry_attribute22 := FND_API.G_MISS_CHAR;
5852: p_x_line_rec.industry_attribute21 := FND_API.G_MISS_CHAR;
5853: END IF;
5854:
5855: IF p_x_line_rec.industry_attribute22 IS NULL THEN
5856: p_x_line_rec.industry_attribute22 := FND_API.G_MISS_CHAR;
5857: END IF;
5858:
5859: IF p_x_line_rec.industry_attribute23 IS NULL THEN
5860: p_x_line_rec.industry_attribute23 := FND_API.G_MISS_CHAR;
5856: p_x_line_rec.industry_attribute22 := FND_API.G_MISS_CHAR;
5857: END IF;
5858:
5859: IF p_x_line_rec.industry_attribute23 IS NULL THEN
5860: p_x_line_rec.industry_attribute23 := FND_API.G_MISS_CHAR;
5861: END IF;
5862:
5863: IF p_x_line_rec.industry_attribute24 IS NULL THEN
5864: p_x_line_rec.industry_attribute24 := FND_API.G_MISS_CHAR;
5860: p_x_line_rec.industry_attribute23 := FND_API.G_MISS_CHAR;
5861: END IF;
5862:
5863: IF p_x_line_rec.industry_attribute24 IS NULL THEN
5864: p_x_line_rec.industry_attribute24 := FND_API.G_MISS_CHAR;
5865: END IF;
5866:
5867: IF p_x_line_rec.industry_attribute25 IS NULL THEN
5868: p_x_line_rec.industry_attribute25 := FND_API.G_MISS_CHAR;
5864: p_x_line_rec.industry_attribute24 := FND_API.G_MISS_CHAR;
5865: END IF;
5866:
5867: IF p_x_line_rec.industry_attribute25 IS NULL THEN
5868: p_x_line_rec.industry_attribute25 := FND_API.G_MISS_CHAR;
5869: END IF;
5870:
5871: IF p_x_line_rec.industry_attribute26 IS NULL THEN
5872: p_x_line_rec.industry_attribute26 := FND_API.G_MISS_CHAR;
5868: p_x_line_rec.industry_attribute25 := FND_API.G_MISS_CHAR;
5869: END IF;
5870:
5871: IF p_x_line_rec.industry_attribute26 IS NULL THEN
5872: p_x_line_rec.industry_attribute26 := FND_API.G_MISS_CHAR;
5873: END IF;
5874:
5875: IF p_x_line_rec.industry_attribute27 IS NULL THEN
5876: p_x_line_rec.industry_attribute27 := FND_API.G_MISS_CHAR;
5872: p_x_line_rec.industry_attribute26 := FND_API.G_MISS_CHAR;
5873: END IF;
5874:
5875: IF p_x_line_rec.industry_attribute27 IS NULL THEN
5876: p_x_line_rec.industry_attribute27 := FND_API.G_MISS_CHAR;
5877: END IF;
5878:
5879: IF p_x_line_rec.industry_attribute28 IS NULL THEN
5880: p_x_line_rec.industry_attribute28 := FND_API.G_MISS_CHAR;
5876: p_x_line_rec.industry_attribute27 := FND_API.G_MISS_CHAR;
5877: END IF;
5878:
5879: IF p_x_line_rec.industry_attribute28 IS NULL THEN
5880: p_x_line_rec.industry_attribute28 := FND_API.G_MISS_CHAR;
5881: END IF;
5882:
5883: IF p_x_line_rec.industry_attribute29 IS NULL THEN
5884: p_x_line_rec.industry_attribute29 := FND_API.G_MISS_CHAR;
5880: p_x_line_rec.industry_attribute28 := FND_API.G_MISS_CHAR;
5881: END IF;
5882:
5883: IF p_x_line_rec.industry_attribute29 IS NULL THEN
5884: p_x_line_rec.industry_attribute29 := FND_API.G_MISS_CHAR;
5885: END IF;
5886:
5887: IF p_x_line_rec.industry_attribute30 IS NULL THEN
5888: p_x_line_rec.industry_attribute30 := FND_API.G_MISS_CHAR;
5884: p_x_line_rec.industry_attribute29 := FND_API.G_MISS_CHAR;
5885: END IF;
5886:
5887: IF p_x_line_rec.industry_attribute30 IS NULL THEN
5888: p_x_line_rec.industry_attribute30 := FND_API.G_MISS_CHAR;
5889: END IF;
5890:
5891: IF p_x_line_rec.industry_attribute2 IS NULL THEN
5892: p_x_line_rec.industry_attribute2 := FND_API.G_MISS_CHAR;
5888: p_x_line_rec.industry_attribute30 := FND_API.G_MISS_CHAR;
5889: END IF;
5890:
5891: IF p_x_line_rec.industry_attribute2 IS NULL THEN
5892: p_x_line_rec.industry_attribute2 := FND_API.G_MISS_CHAR;
5893: END IF;
5894:
5895: IF p_x_line_rec.industry_attribute3 IS NULL THEN
5896: p_x_line_rec.industry_attribute3 := FND_API.G_MISS_CHAR;
5892: p_x_line_rec.industry_attribute2 := FND_API.G_MISS_CHAR;
5893: END IF;
5894:
5895: IF p_x_line_rec.industry_attribute3 IS NULL THEN
5896: p_x_line_rec.industry_attribute3 := FND_API.G_MISS_CHAR;
5897: END IF;
5898:
5899: IF p_x_line_rec.industry_attribute4 IS NULL THEN
5900: p_x_line_rec.industry_attribute4 := FND_API.G_MISS_CHAR;
5896: p_x_line_rec.industry_attribute3 := FND_API.G_MISS_CHAR;
5897: END IF;
5898:
5899: IF p_x_line_rec.industry_attribute4 IS NULL THEN
5900: p_x_line_rec.industry_attribute4 := FND_API.G_MISS_CHAR;
5901: END IF;
5902:
5903: IF p_x_line_rec.industry_attribute5 IS NULL THEN
5904: p_x_line_rec.industry_attribute5 := FND_API.G_MISS_CHAR;
5900: p_x_line_rec.industry_attribute4 := FND_API.G_MISS_CHAR;
5901: END IF;
5902:
5903: IF p_x_line_rec.industry_attribute5 IS NULL THEN
5904: p_x_line_rec.industry_attribute5 := FND_API.G_MISS_CHAR;
5905: END IF;
5906:
5907: IF p_x_line_rec.industry_attribute6 IS NULL THEN
5908: p_x_line_rec.industry_attribute6 := FND_API.G_MISS_CHAR;
5904: p_x_line_rec.industry_attribute5 := FND_API.G_MISS_CHAR;
5905: END IF;
5906:
5907: IF p_x_line_rec.industry_attribute6 IS NULL THEN
5908: p_x_line_rec.industry_attribute6 := FND_API.G_MISS_CHAR;
5909: END IF;
5910:
5911: IF p_x_line_rec.industry_attribute7 IS NULL THEN
5912: p_x_line_rec.industry_attribute7 := FND_API.G_MISS_CHAR;
5908: p_x_line_rec.industry_attribute6 := FND_API.G_MISS_CHAR;
5909: END IF;
5910:
5911: IF p_x_line_rec.industry_attribute7 IS NULL THEN
5912: p_x_line_rec.industry_attribute7 := FND_API.G_MISS_CHAR;
5913: END IF;
5914:
5915: IF p_x_line_rec.industry_attribute8 IS NULL THEN
5916: p_x_line_rec.industry_attribute8 := FND_API.G_MISS_CHAR;
5912: p_x_line_rec.industry_attribute7 := FND_API.G_MISS_CHAR;
5913: END IF;
5914:
5915: IF p_x_line_rec.industry_attribute8 IS NULL THEN
5916: p_x_line_rec.industry_attribute8 := FND_API.G_MISS_CHAR;
5917: END IF;
5918:
5919: IF p_x_line_rec.industry_attribute9 IS NULL THEN
5920: p_x_line_rec.industry_attribute9 := FND_API.G_MISS_CHAR;
5916: p_x_line_rec.industry_attribute8 := FND_API.G_MISS_CHAR;
5917: END IF;
5918:
5919: IF p_x_line_rec.industry_attribute9 IS NULL THEN
5920: p_x_line_rec.industry_attribute9 := FND_API.G_MISS_CHAR;
5921: END IF;
5922:
5923: IF p_x_line_rec.industry_context IS NULL THEN
5924: p_x_line_rec.industry_context := FND_API.G_MISS_CHAR;
5920: p_x_line_rec.industry_attribute9 := FND_API.G_MISS_CHAR;
5921: END IF;
5922:
5923: IF p_x_line_rec.industry_context IS NULL THEN
5924: p_x_line_rec.industry_context := FND_API.G_MISS_CHAR;
5925: END IF;
5926:
5927: /* TP_ATTRIBUTE */
5928: IF p_x_line_rec.tp_context IS NULL THEN
5925: END IF;
5926:
5927: /* TP_ATTRIBUTE */
5928: IF p_x_line_rec.tp_context IS NULL THEN
5929: p_x_line_rec.tp_context := FND_API.G_MISS_CHAR;
5930: END IF;
5931: IF p_x_line_rec.tp_attribute1 IS NULL THEN
5932: p_x_line_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
5933: END IF;
5928: IF p_x_line_rec.tp_context IS NULL THEN
5929: p_x_line_rec.tp_context := FND_API.G_MISS_CHAR;
5930: END IF;
5931: IF p_x_line_rec.tp_attribute1 IS NULL THEN
5932: p_x_line_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
5933: END IF;
5934: IF p_x_line_rec.tp_attribute2 IS NULL THEN
5935: p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
5936: END IF;
5931: IF p_x_line_rec.tp_attribute1 IS NULL THEN
5932: p_x_line_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
5933: END IF;
5934: IF p_x_line_rec.tp_attribute2 IS NULL THEN
5935: p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
5936: END IF;
5937: IF p_x_line_rec.tp_attribute3 IS NULL THEN
5938: p_x_line_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
5939: END IF;
5934: IF p_x_line_rec.tp_attribute2 IS NULL THEN
5935: p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
5936: END IF;
5937: IF p_x_line_rec.tp_attribute3 IS NULL THEN
5938: p_x_line_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
5939: END IF;
5940: IF p_x_line_rec.tp_attribute4 IS NULL THEN
5941: p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
5942: END IF;
5937: IF p_x_line_rec.tp_attribute3 IS NULL THEN
5938: p_x_line_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
5939: END IF;
5940: IF p_x_line_rec.tp_attribute4 IS NULL THEN
5941: p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
5942: END IF;
5943: IF p_x_line_rec.tp_attribute5 IS NULL THEN
5944: p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
5945: END IF;
5940: IF p_x_line_rec.tp_attribute4 IS NULL THEN
5941: p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
5942: END IF;
5943: IF p_x_line_rec.tp_attribute5 IS NULL THEN
5944: p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
5945: END IF;
5946: IF p_x_line_rec.tp_attribute6 IS NULL THEN
5947: p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
5948: END IF;
5943: IF p_x_line_rec.tp_attribute5 IS NULL THEN
5944: p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
5945: END IF;
5946: IF p_x_line_rec.tp_attribute6 IS NULL THEN
5947: p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
5948: END IF;
5949: IF p_x_line_rec.tp_attribute7 IS NULL THEN
5950: p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
5951: END IF;
5946: IF p_x_line_rec.tp_attribute6 IS NULL THEN
5947: p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
5948: END IF;
5949: IF p_x_line_rec.tp_attribute7 IS NULL THEN
5950: p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
5951: END IF;
5952: IF p_x_line_rec.tp_attribute8 IS NULL THEN
5953: p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
5954: END IF;
5949: IF p_x_line_rec.tp_attribute7 IS NULL THEN
5950: p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
5951: END IF;
5952: IF p_x_line_rec.tp_attribute8 IS NULL THEN
5953: p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
5954: END IF;
5955: IF p_x_line_rec.tp_attribute9 IS NULL THEN
5956: p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
5957: END IF;
5952: IF p_x_line_rec.tp_attribute8 IS NULL THEN
5953: p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
5954: END IF;
5955: IF p_x_line_rec.tp_attribute9 IS NULL THEN
5956: p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
5957: END IF;
5958: IF p_x_line_rec.tp_attribute10 IS NULL THEN
5959: p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
5960: END IF;
5955: IF p_x_line_rec.tp_attribute9 IS NULL THEN
5956: p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
5957: END IF;
5958: IF p_x_line_rec.tp_attribute10 IS NULL THEN
5959: p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
5960: END IF;
5961: IF p_x_line_rec.tp_attribute11 IS NULL THEN
5962: p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
5963: END IF;
5958: IF p_x_line_rec.tp_attribute10 IS NULL THEN
5959: p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
5960: END IF;
5961: IF p_x_line_rec.tp_attribute11 IS NULL THEN
5962: p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
5963: END IF;
5964: IF p_x_line_rec.tp_attribute12 IS NULL THEN
5965: p_x_line_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
5966: END IF;
5961: IF p_x_line_rec.tp_attribute11 IS NULL THEN
5962: p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
5963: END IF;
5964: IF p_x_line_rec.tp_attribute12 IS NULL THEN
5965: p_x_line_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
5966: END IF;
5967: IF p_x_line_rec.tp_attribute13 IS NULL THEN
5968: p_x_line_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
5969: END IF;
5964: IF p_x_line_rec.tp_attribute12 IS NULL THEN
5965: p_x_line_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
5966: END IF;
5967: IF p_x_line_rec.tp_attribute13 IS NULL THEN
5968: p_x_line_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
5969: END IF;
5970: IF p_x_line_rec.tp_attribute14 IS NULL THEN
5971: p_x_line_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
5972: END IF;
5967: IF p_x_line_rec.tp_attribute13 IS NULL THEN
5968: p_x_line_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
5969: END IF;
5970: IF p_x_line_rec.tp_attribute14 IS NULL THEN
5971: p_x_line_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
5972: END IF;
5973: IF p_x_line_rec.tp_attribute15 IS NULL THEN
5974: p_x_line_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
5975: END IF;
5970: IF p_x_line_rec.tp_attribute14 IS NULL THEN
5971: p_x_line_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
5972: END IF;
5973: IF p_x_line_rec.tp_attribute15 IS NULL THEN
5974: p_x_line_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
5975: END IF;
5976:
5977:
5978: IF p_x_line_rec.intermed_ship_to_contact_id IS NULL THEN
5975: END IF;
5976:
5977:
5978: IF p_x_line_rec.intermed_ship_to_contact_id IS NULL THEN
5979: p_x_line_rec.intermed_ship_to_contact_id := FND_API.G_MISS_NUM;
5980: END IF;
5981:
5982: IF p_x_line_rec.intermed_ship_to_org_id IS NULL THEN
5983: p_x_line_rec.intermed_ship_to_org_id := FND_API.G_MISS_NUM;
5979: p_x_line_rec.intermed_ship_to_contact_id := FND_API.G_MISS_NUM;
5980: END IF;
5981:
5982: IF p_x_line_rec.intermed_ship_to_org_id IS NULL THEN
5983: p_x_line_rec.intermed_ship_to_org_id := FND_API.G_MISS_NUM;
5984: END IF;
5985:
5986: IF p_x_line_rec.inventory_item_id IS NULL THEN
5987: p_x_line_rec.inventory_item_id := FND_API.G_MISS_NUM;
5983: p_x_line_rec.intermed_ship_to_org_id := FND_API.G_MISS_NUM;
5984: END IF;
5985:
5986: IF p_x_line_rec.inventory_item_id IS NULL THEN
5987: p_x_line_rec.inventory_item_id := FND_API.G_MISS_NUM;
5988: END IF;
5989:
5990: IF p_x_line_rec.invoice_interface_status_code IS NULL THEN
5991: p_x_line_rec.invoice_interface_status_code := FND_API.G_MISS_CHAR;
5987: p_x_line_rec.inventory_item_id := FND_API.G_MISS_NUM;
5988: END IF;
5989:
5990: IF p_x_line_rec.invoice_interface_status_code IS NULL THEN
5991: p_x_line_rec.invoice_interface_status_code := FND_API.G_MISS_CHAR;
5992: END IF;
5993:
5994: IF p_x_line_rec.invoice_to_contact_id IS NULL THEN
5995: p_x_line_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
5991: p_x_line_rec.invoice_interface_status_code := FND_API.G_MISS_CHAR;
5992: END IF;
5993:
5994: IF p_x_line_rec.invoice_to_contact_id IS NULL THEN
5995: p_x_line_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
5996: END IF;
5997:
5998: IF p_x_line_rec.invoiced_quantity IS NULL THEN
5999: p_x_line_rec.invoiced_quantity := FND_API.G_MISS_NUM;
5995: p_x_line_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
5996: END IF;
5997:
5998: IF p_x_line_rec.invoiced_quantity IS NULL THEN
5999: p_x_line_rec.invoiced_quantity := FND_API.G_MISS_NUM;
6000: END IF;
6001:
6002: IF p_x_line_rec.invoice_to_org_id IS NULL THEN
6003: p_x_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
5999: p_x_line_rec.invoiced_quantity := FND_API.G_MISS_NUM;
6000: END IF;
6001:
6002: IF p_x_line_rec.invoice_to_org_id IS NULL THEN
6003: p_x_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
6004: END IF;
6005:
6006: IF p_x_line_rec.invoicing_rule_id IS NULL THEN
6007: p_x_line_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
6003: p_x_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
6004: END IF;
6005:
6006: IF p_x_line_rec.invoicing_rule_id IS NULL THEN
6007: p_x_line_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
6008: END IF;
6009:
6010: IF p_x_line_rec.ordered_item_id IS NULL THEN
6011: p_x_line_rec.ordered_item_id := FND_API.G_MISS_NUM;
6007: p_x_line_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
6008: END IF;
6009:
6010: IF p_x_line_rec.ordered_item_id IS NULL THEN
6011: p_x_line_rec.ordered_item_id := FND_API.G_MISS_NUM;
6012: END IF;
6013:
6014: IF p_x_line_rec.item_identifier_type IS NULL THEN
6015: p_x_line_rec.item_identifier_type := FND_API.G_MISS_CHAR;
6011: p_x_line_rec.ordered_item_id := FND_API.G_MISS_NUM;
6012: END IF;
6013:
6014: IF p_x_line_rec.item_identifier_type IS NULL THEN
6015: p_x_line_rec.item_identifier_type := FND_API.G_MISS_CHAR;
6016: END IF;
6017:
6018: IF p_x_line_rec.ordered_item IS NULL THEN
6019: p_x_line_rec.ordered_item := FND_API.G_MISS_CHAR;
6015: p_x_line_rec.item_identifier_type := FND_API.G_MISS_CHAR;
6016: END IF;
6017:
6018: IF p_x_line_rec.ordered_item IS NULL THEN
6019: p_x_line_rec.ordered_item := FND_API.G_MISS_CHAR;
6020: END IF;
6021:
6022: IF p_x_line_rec.item_revision IS NULL THEN
6023: p_x_line_rec.item_revision := FND_API.G_MISS_CHAR;
6019: p_x_line_rec.ordered_item := FND_API.G_MISS_CHAR;
6020: END IF;
6021:
6022: IF p_x_line_rec.item_revision IS NULL THEN
6023: p_x_line_rec.item_revision := FND_API.G_MISS_CHAR;
6024: END IF;
6025:
6026: IF p_x_line_rec.item_type_code IS NULL THEN
6027: p_x_line_rec.item_type_code := FND_API.G_MISS_CHAR;
6023: p_x_line_rec.item_revision := FND_API.G_MISS_CHAR;
6024: END IF;
6025:
6026: IF p_x_line_rec.item_type_code IS NULL THEN
6027: p_x_line_rec.item_type_code := FND_API.G_MISS_CHAR;
6028: END IF;
6029:
6030: IF p_x_line_rec.last_updated_by IS NULL THEN
6031: p_x_line_rec.last_updated_by := FND_API.G_MISS_NUM;
6027: p_x_line_rec.item_type_code := FND_API.G_MISS_CHAR;
6028: END IF;
6029:
6030: IF p_x_line_rec.last_updated_by IS NULL THEN
6031: p_x_line_rec.last_updated_by := FND_API.G_MISS_NUM;
6032: END IF;
6033:
6034: IF p_x_line_rec.last_update_date IS NULL THEN
6035: p_x_line_rec.last_update_date := FND_API.G_MISS_DATE;
6031: p_x_line_rec.last_updated_by := FND_API.G_MISS_NUM;
6032: END IF;
6033:
6034: IF p_x_line_rec.last_update_date IS NULL THEN
6035: p_x_line_rec.last_update_date := FND_API.G_MISS_DATE;
6036: END IF;
6037:
6038: IF p_x_line_rec.last_update_login IS NULL THEN
6039: p_x_line_rec.last_update_login := FND_API.G_MISS_NUM;
6035: p_x_line_rec.last_update_date := FND_API.G_MISS_DATE;
6036: END IF;
6037:
6038: IF p_x_line_rec.last_update_login IS NULL THEN
6039: p_x_line_rec.last_update_login := FND_API.G_MISS_NUM;
6040: END IF;
6041:
6042: IF p_x_line_rec.latest_acceptable_date IS NULL THEN
6043: p_x_line_rec.latest_acceptable_date := FND_API.G_MISS_DATE;
6039: p_x_line_rec.last_update_login := FND_API.G_MISS_NUM;
6040: END IF;
6041:
6042: IF p_x_line_rec.latest_acceptable_date IS NULL THEN
6043: p_x_line_rec.latest_acceptable_date := FND_API.G_MISS_DATE;
6044: END IF;
6045:
6046: IF p_x_line_rec.line_category_code IS NULL THEN
6047: p_x_line_rec.line_category_code := FND_API.G_MISS_CHAR;
6043: p_x_line_rec.latest_acceptable_date := FND_API.G_MISS_DATE;
6044: END IF;
6045:
6046: IF p_x_line_rec.line_category_code IS NULL THEN
6047: p_x_line_rec.line_category_code := FND_API.G_MISS_CHAR;
6048: END IF;
6049:
6050: IF p_x_line_rec.line_id IS NULL THEN
6051: p_x_line_rec.line_id := FND_API.G_MISS_NUM;
6047: p_x_line_rec.line_category_code := FND_API.G_MISS_CHAR;
6048: END IF;
6049:
6050: IF p_x_line_rec.line_id IS NULL THEN
6051: p_x_line_rec.line_id := FND_API.G_MISS_NUM;
6052: END IF;
6053:
6054: IF p_x_line_rec.line_number IS NULL THEN
6055: p_x_line_rec.line_number := FND_API.G_MISS_NUM;
6051: p_x_line_rec.line_id := FND_API.G_MISS_NUM;
6052: END IF;
6053:
6054: IF p_x_line_rec.line_number IS NULL THEN
6055: p_x_line_rec.line_number := FND_API.G_MISS_NUM;
6056: END IF;
6057:
6058: IF p_x_line_rec.line_type_id IS NULL THEN
6059: p_x_line_rec.line_type_id := FND_API.G_MISS_NUM;
6055: p_x_line_rec.line_number := FND_API.G_MISS_NUM;
6056: END IF;
6057:
6058: IF p_x_line_rec.line_type_id IS NULL THEN
6059: p_x_line_rec.line_type_id := FND_API.G_MISS_NUM;
6060: END IF;
6061:
6062: IF p_x_line_rec.link_to_line_id IS NULL THEN
6063: p_x_line_rec.link_to_line_id := FND_API.G_MISS_NUM;
6059: p_x_line_rec.line_type_id := FND_API.G_MISS_NUM;
6060: END IF;
6061:
6062: IF p_x_line_rec.link_to_line_id IS NULL THEN
6063: p_x_line_rec.link_to_line_id := FND_API.G_MISS_NUM;
6064: END IF;
6065:
6066: IF p_x_line_rec.model_group_number IS NULL THEN
6067: p_x_line_rec.model_group_number := FND_API.G_MISS_NUM;
6063: p_x_line_rec.link_to_line_id := FND_API.G_MISS_NUM;
6064: END IF;
6065:
6066: IF p_x_line_rec.model_group_number IS NULL THEN
6067: p_x_line_rec.model_group_number := FND_API.G_MISS_NUM;
6068: END IF;
6069:
6070: IF p_x_line_rec.mfg_component_sequence_id IS NULL THEN
6071: p_x_line_rec.mfg_component_sequence_id := FND_API.G_MISS_NUM;
6067: p_x_line_rec.model_group_number := FND_API.G_MISS_NUM;
6068: END IF;
6069:
6070: IF p_x_line_rec.mfg_component_sequence_id IS NULL THEN
6071: p_x_line_rec.mfg_component_sequence_id := FND_API.G_MISS_NUM;
6072: END IF;
6073:
6074: IF p_x_line_rec.mfg_lead_time IS NULL THEN
6075: p_x_line_rec.mfg_lead_time := FND_API.G_MISS_NUM;
6071: p_x_line_rec.mfg_component_sequence_id := FND_API.G_MISS_NUM;
6072: END IF;
6073:
6074: IF p_x_line_rec.mfg_lead_time IS NULL THEN
6075: p_x_line_rec.mfg_lead_time := FND_API.G_MISS_NUM;
6076: END IF;
6077:
6078: IF p_x_line_rec.open_flag IS NULL THEN
6079: p_x_line_rec.open_flag := FND_API.G_MISS_CHAR;
6075: p_x_line_rec.mfg_lead_time := FND_API.G_MISS_NUM;
6076: END IF;
6077:
6078: IF p_x_line_rec.open_flag IS NULL THEN
6079: p_x_line_rec.open_flag := FND_API.G_MISS_CHAR;
6080: END IF;
6081:
6082: IF p_x_line_rec.option_flag IS NULL THEN
6083: p_x_line_rec.option_flag := FND_API.G_MISS_CHAR;
6079: p_x_line_rec.open_flag := FND_API.G_MISS_CHAR;
6080: END IF;
6081:
6082: IF p_x_line_rec.option_flag IS NULL THEN
6083: p_x_line_rec.option_flag := FND_API.G_MISS_CHAR;
6084: END IF;
6085:
6086: IF p_x_line_rec.option_number IS NULL THEN
6087: p_x_line_rec.option_number := FND_API.G_MISS_NUM;
6083: p_x_line_rec.option_flag := FND_API.G_MISS_CHAR;
6084: END IF;
6085:
6086: IF p_x_line_rec.option_number IS NULL THEN
6087: p_x_line_rec.option_number := FND_API.G_MISS_NUM;
6088: END IF;
6089:
6090: IF p_x_line_rec.ordered_quantity IS NULL THEN
6091: p_x_line_rec.ordered_quantity := FND_API.G_MISS_NUM;
6087: p_x_line_rec.option_number := FND_API.G_MISS_NUM;
6088: END IF;
6089:
6090: IF p_x_line_rec.ordered_quantity IS NULL THEN
6091: p_x_line_rec.ordered_quantity := FND_API.G_MISS_NUM;
6092: END IF;
6093:
6094: IF p_x_line_rec.order_quantity_uom IS NULL THEN
6095: p_x_line_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
6091: p_x_line_rec.ordered_quantity := FND_API.G_MISS_NUM;
6092: END IF;
6093:
6094: IF p_x_line_rec.order_quantity_uom IS NULL THEN
6095: p_x_line_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
6096: END IF;
6097:
6098: IF p_x_line_rec.ordered_quantity2 IS NULL THEN
6099: p_x_line_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
6095: p_x_line_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
6096: END IF;
6097:
6098: IF p_x_line_rec.ordered_quantity2 IS NULL THEN
6099: p_x_line_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
6100: END IF;
6101:
6102: IF p_x_line_rec.ordered_quantity_uom2 IS NULL THEN
6103: p_x_line_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
6099: p_x_line_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
6100: END IF;
6101:
6102: IF p_x_line_rec.ordered_quantity_uom2 IS NULL THEN
6103: p_x_line_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
6104: END IF;
6105:
6106: IF p_x_line_rec.org_id IS NULL THEN
6107: p_x_line_rec.org_id := FND_API.G_MISS_NUM;
6103: p_x_line_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
6104: END IF;
6105:
6106: IF p_x_line_rec.org_id IS NULL THEN
6107: p_x_line_rec.org_id := FND_API.G_MISS_NUM;
6108: END IF;
6109:
6110: IF p_x_line_rec.orig_sys_document_ref IS NULL THEN
6111: p_x_line_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
6107: p_x_line_rec.org_id := FND_API.G_MISS_NUM;
6108: END IF;
6109:
6110: IF p_x_line_rec.orig_sys_document_ref IS NULL THEN
6111: p_x_line_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
6112: END IF;
6113:
6114: IF p_x_line_rec.orig_sys_line_ref IS NULL THEN
6115: p_x_line_rec.orig_sys_line_ref := FND_API.G_MISS_CHAR;
6111: p_x_line_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
6112: END IF;
6113:
6114: IF p_x_line_rec.orig_sys_line_ref IS NULL THEN
6115: p_x_line_rec.orig_sys_line_ref := FND_API.G_MISS_CHAR;
6116: END IF;
6117:
6118: IF p_x_line_rec.orig_sys_shipment_ref IS NULL THEN
6119: p_x_line_rec.orig_sys_shipment_ref := FND_API.G_MISS_CHAR;
6115: p_x_line_rec.orig_sys_line_ref := FND_API.G_MISS_CHAR;
6116: END IF;
6117:
6118: IF p_x_line_rec.orig_sys_shipment_ref IS NULL THEN
6119: p_x_line_rec.orig_sys_shipment_ref := FND_API.G_MISS_CHAR;
6120: END IF;
6121:
6122: IF p_x_line_rec.original_list_price IS NULL THEN
6123: p_x_line_rec.original_list_price:= FND_API.G_MISS_NUM;
6119: p_x_line_rec.orig_sys_shipment_ref := FND_API.G_MISS_CHAR;
6120: END IF;
6121:
6122: IF p_x_line_rec.original_list_price IS NULL THEN
6123: p_x_line_rec.original_list_price:= FND_API.G_MISS_NUM;
6124: END IF;
6125:
6126: IF p_x_line_rec.over_ship_reason_code IS NULL THEN
6127: p_x_line_rec.over_ship_reason_code := FND_API.G_MISS_CHAR;
6123: p_x_line_rec.original_list_price:= FND_API.G_MISS_NUM;
6124: END IF;
6125:
6126: IF p_x_line_rec.over_ship_reason_code IS NULL THEN
6127: p_x_line_rec.over_ship_reason_code := FND_API.G_MISS_CHAR;
6128: END IF;
6129:
6130: IF p_x_line_rec.over_ship_resolved_flag IS NULL THEN
6131: p_x_line_rec.over_ship_resolved_flag := FND_API.G_MISS_CHAR;
6127: p_x_line_rec.over_ship_reason_code := FND_API.G_MISS_CHAR;
6128: END IF;
6129:
6130: IF p_x_line_rec.over_ship_resolved_flag IS NULL THEN
6131: p_x_line_rec.over_ship_resolved_flag := FND_API.G_MISS_CHAR;
6132: END IF;
6133:
6134: IF p_x_line_rec.payment_term_id IS NULL THEN
6135: p_x_line_rec.payment_term_id := FND_API.G_MISS_NUM;
6131: p_x_line_rec.over_ship_resolved_flag := FND_API.G_MISS_CHAR;
6132: END IF;
6133:
6134: IF p_x_line_rec.payment_term_id IS NULL THEN
6135: p_x_line_rec.payment_term_id := FND_API.G_MISS_NUM;
6136: END IF;
6137:
6138: IF p_x_line_rec.planning_priority IS NULL THEN
6139: p_x_line_rec.planning_priority := FND_API.G_MISS_NUM;
6135: p_x_line_rec.payment_term_id := FND_API.G_MISS_NUM;
6136: END IF;
6137:
6138: IF p_x_line_rec.planning_priority IS NULL THEN
6139: p_x_line_rec.planning_priority := FND_API.G_MISS_NUM;
6140: END IF;
6141:
6142: IF p_x_line_rec.preferred_grade IS NULL THEN
6143: p_x_line_rec.preferred_grade := FND_API.G_MISS_CHAR;
6139: p_x_line_rec.planning_priority := FND_API.G_MISS_NUM;
6140: END IF;
6141:
6142: IF p_x_line_rec.preferred_grade IS NULL THEN
6143: p_x_line_rec.preferred_grade := FND_API.G_MISS_CHAR;
6144: END IF;
6145:
6146: IF p_x_line_rec.price_list_id IS NULL THEN
6147: p_x_line_rec.price_list_id := FND_API.G_MISS_NUM;
6143: p_x_line_rec.preferred_grade := FND_API.G_MISS_CHAR;
6144: END IF;
6145:
6146: IF p_x_line_rec.price_list_id IS NULL THEN
6147: p_x_line_rec.price_list_id := FND_API.G_MISS_NUM;
6148: END IF;
6149:
6150: IF p_x_line_rec.price_request_code IS NULL THEN
6151: p_x_line_rec.price_request_code := FND_API.G_MISS_CHAR;
6147: p_x_line_rec.price_list_id := FND_API.G_MISS_NUM;
6148: END IF;
6149:
6150: IF p_x_line_rec.price_request_code IS NULL THEN
6151: p_x_line_rec.price_request_code := FND_API.G_MISS_CHAR;
6152: END IF;
6153:
6154: IF p_x_line_rec.pricing_attribute1 IS NULL THEN
6155: p_x_line_rec.pricing_attribute1 := FND_API.G_MISS_CHAR;
6151: p_x_line_rec.price_request_code := FND_API.G_MISS_CHAR;
6152: END IF;
6153:
6154: IF p_x_line_rec.pricing_attribute1 IS NULL THEN
6155: p_x_line_rec.pricing_attribute1 := FND_API.G_MISS_CHAR;
6156: END IF;
6157:
6158: IF p_x_line_rec.pricing_attribute10 IS NULL THEN
6159: p_x_line_rec.pricing_attribute10 := FND_API.G_MISS_CHAR;
6155: p_x_line_rec.pricing_attribute1 := FND_API.G_MISS_CHAR;
6156: END IF;
6157:
6158: IF p_x_line_rec.pricing_attribute10 IS NULL THEN
6159: p_x_line_rec.pricing_attribute10 := FND_API.G_MISS_CHAR;
6160: END IF;
6161:
6162: IF p_x_line_rec.pricing_attribute2 IS NULL THEN
6163: p_x_line_rec.pricing_attribute2 := FND_API.G_MISS_CHAR;
6159: p_x_line_rec.pricing_attribute10 := FND_API.G_MISS_CHAR;
6160: END IF;
6161:
6162: IF p_x_line_rec.pricing_attribute2 IS NULL THEN
6163: p_x_line_rec.pricing_attribute2 := FND_API.G_MISS_CHAR;
6164: END IF;
6165:
6166: IF p_x_line_rec.pricing_attribute3 IS NULL THEN
6167: p_x_line_rec.pricing_attribute3 := FND_API.G_MISS_CHAR;
6163: p_x_line_rec.pricing_attribute2 := FND_API.G_MISS_CHAR;
6164: END IF;
6165:
6166: IF p_x_line_rec.pricing_attribute3 IS NULL THEN
6167: p_x_line_rec.pricing_attribute3 := FND_API.G_MISS_CHAR;
6168: END IF;
6169:
6170: IF p_x_line_rec.pricing_attribute4 IS NULL THEN
6171: p_x_line_rec.pricing_attribute4 := FND_API.G_MISS_CHAR;
6167: p_x_line_rec.pricing_attribute3 := FND_API.G_MISS_CHAR;
6168: END IF;
6169:
6170: IF p_x_line_rec.pricing_attribute4 IS NULL THEN
6171: p_x_line_rec.pricing_attribute4 := FND_API.G_MISS_CHAR;
6172: END IF;
6173:
6174: IF p_x_line_rec.pricing_attribute5 IS NULL THEN
6175: p_x_line_rec.pricing_attribute5 := FND_API.G_MISS_CHAR;
6171: p_x_line_rec.pricing_attribute4 := FND_API.G_MISS_CHAR;
6172: END IF;
6173:
6174: IF p_x_line_rec.pricing_attribute5 IS NULL THEN
6175: p_x_line_rec.pricing_attribute5 := FND_API.G_MISS_CHAR;
6176: END IF;
6177:
6178: IF p_x_line_rec.pricing_attribute6 IS NULL THEN
6179: p_x_line_rec.pricing_attribute6 := FND_API.G_MISS_CHAR;
6175: p_x_line_rec.pricing_attribute5 := FND_API.G_MISS_CHAR;
6176: END IF;
6177:
6178: IF p_x_line_rec.pricing_attribute6 IS NULL THEN
6179: p_x_line_rec.pricing_attribute6 := FND_API.G_MISS_CHAR;
6180: END IF;
6181:
6182: IF p_x_line_rec.pricing_attribute7 IS NULL THEN
6183: p_x_line_rec.pricing_attribute7 := FND_API.G_MISS_CHAR;
6179: p_x_line_rec.pricing_attribute6 := FND_API.G_MISS_CHAR;
6180: END IF;
6181:
6182: IF p_x_line_rec.pricing_attribute7 IS NULL THEN
6183: p_x_line_rec.pricing_attribute7 := FND_API.G_MISS_CHAR;
6184: END IF;
6185:
6186: IF p_x_line_rec.pricing_attribute8 IS NULL THEN
6187: p_x_line_rec.pricing_attribute8 := FND_API.G_MISS_CHAR;
6183: p_x_line_rec.pricing_attribute7 := FND_API.G_MISS_CHAR;
6184: END IF;
6185:
6186: IF p_x_line_rec.pricing_attribute8 IS NULL THEN
6187: p_x_line_rec.pricing_attribute8 := FND_API.G_MISS_CHAR;
6188: END IF;
6189:
6190: IF p_x_line_rec.pricing_attribute9 IS NULL THEN
6191: p_x_line_rec.pricing_attribute9 := FND_API.G_MISS_CHAR;
6187: p_x_line_rec.pricing_attribute8 := FND_API.G_MISS_CHAR;
6188: END IF;
6189:
6190: IF p_x_line_rec.pricing_attribute9 IS NULL THEN
6191: p_x_line_rec.pricing_attribute9 := FND_API.G_MISS_CHAR;
6192: END IF;
6193:
6194: IF p_x_line_rec.pricing_context IS NULL THEN
6195: p_x_line_rec.pricing_context := FND_API.G_MISS_CHAR;
6191: p_x_line_rec.pricing_attribute9 := FND_API.G_MISS_CHAR;
6192: END IF;
6193:
6194: IF p_x_line_rec.pricing_context IS NULL THEN
6195: p_x_line_rec.pricing_context := FND_API.G_MISS_CHAR;
6196: END IF;
6197:
6198: IF p_x_line_rec.pricing_date IS NULL THEN
6199: p_x_line_rec.pricing_date := FND_API.G_MISS_DATE;
6195: p_x_line_rec.pricing_context := FND_API.G_MISS_CHAR;
6196: END IF;
6197:
6198: IF p_x_line_rec.pricing_date IS NULL THEN
6199: p_x_line_rec.pricing_date := FND_API.G_MISS_DATE;
6200: END IF;
6201:
6202: IF p_x_line_rec.pricing_quantity IS NULL THEN
6203: p_x_line_rec.pricing_quantity := FND_API.G_MISS_NUM;
6199: p_x_line_rec.pricing_date := FND_API.G_MISS_DATE;
6200: END IF;
6201:
6202: IF p_x_line_rec.pricing_quantity IS NULL THEN
6203: p_x_line_rec.pricing_quantity := FND_API.G_MISS_NUM;
6204: END IF;
6205:
6206: IF p_x_line_rec.pricing_quantity_uom IS NULL THEN
6207: p_x_line_rec.pricing_quantity_uom := FND_API.G_MISS_CHAR;
6203: p_x_line_rec.pricing_quantity := FND_API.G_MISS_NUM;
6204: END IF;
6205:
6206: IF p_x_line_rec.pricing_quantity_uom IS NULL THEN
6207: p_x_line_rec.pricing_quantity_uom := FND_API.G_MISS_CHAR;
6208: END IF;
6209:
6210: IF p_x_line_rec.program_application_id IS NULL THEN
6211: p_x_line_rec.program_application_id := FND_API.G_MISS_NUM;
6207: p_x_line_rec.pricing_quantity_uom := FND_API.G_MISS_CHAR;
6208: END IF;
6209:
6210: IF p_x_line_rec.program_application_id IS NULL THEN
6211: p_x_line_rec.program_application_id := FND_API.G_MISS_NUM;
6212: END IF;
6213:
6214: IF p_x_line_rec.program_id IS NULL THEN
6215: p_x_line_rec.program_id := FND_API.G_MISS_NUM;
6211: p_x_line_rec.program_application_id := FND_API.G_MISS_NUM;
6212: END IF;
6213:
6214: IF p_x_line_rec.program_id IS NULL THEN
6215: p_x_line_rec.program_id := FND_API.G_MISS_NUM;
6216: END IF;
6217:
6218: IF p_x_line_rec.program_update_date IS NULL THEN
6219: p_x_line_rec.program_update_date := FND_API.G_MISS_DATE;
6215: p_x_line_rec.program_id := FND_API.G_MISS_NUM;
6216: END IF;
6217:
6218: IF p_x_line_rec.program_update_date IS NULL THEN
6219: p_x_line_rec.program_update_date := FND_API.G_MISS_DATE;
6220: END IF;
6221:
6222: IF p_x_line_rec.project_id IS NULL THEN
6223: p_x_line_rec.project_id := FND_API.G_MISS_NUM;
6219: p_x_line_rec.program_update_date := FND_API.G_MISS_DATE;
6220: END IF;
6221:
6222: IF p_x_line_rec.project_id IS NULL THEN
6223: p_x_line_rec.project_id := FND_API.G_MISS_NUM;
6224: END IF;
6225:
6226: IF p_x_line_rec.promise_date IS NULL THEN
6227: p_x_line_rec.promise_date := FND_API.G_MISS_DATE;
6223: p_x_line_rec.project_id := FND_API.G_MISS_NUM;
6224: END IF;
6225:
6226: IF p_x_line_rec.promise_date IS NULL THEN
6227: p_x_line_rec.promise_date := FND_API.G_MISS_DATE;
6228: END IF;
6229:
6230: IF p_x_line_rec.re_source_flag IS NULL THEN
6231: p_x_line_rec.re_source_flag := FND_API.G_MISS_CHAR;
6227: p_x_line_rec.promise_date := FND_API.G_MISS_DATE;
6228: END IF;
6229:
6230: IF p_x_line_rec.re_source_flag IS NULL THEN
6231: p_x_line_rec.re_source_flag := FND_API.G_MISS_CHAR;
6232: END IF;
6233:
6234: IF p_x_line_rec.reference_customer_trx_line_id IS NULL THEN
6235: p_x_line_rec.reference_customer_trx_line_id := FND_API.G_MISS_NUM;
6231: p_x_line_rec.re_source_flag := FND_API.G_MISS_CHAR;
6232: END IF;
6233:
6234: IF p_x_line_rec.reference_customer_trx_line_id IS NULL THEN
6235: p_x_line_rec.reference_customer_trx_line_id := FND_API.G_MISS_NUM;
6236: END IF;
6237:
6238: IF p_x_line_rec.reference_header_id IS NULL THEN
6239: p_x_line_rec.reference_header_id := FND_API.G_MISS_NUM;
6235: p_x_line_rec.reference_customer_trx_line_id := FND_API.G_MISS_NUM;
6236: END IF;
6237:
6238: IF p_x_line_rec.reference_header_id IS NULL THEN
6239: p_x_line_rec.reference_header_id := FND_API.G_MISS_NUM;
6240: END IF;
6241:
6242: IF p_x_line_rec.reference_line_id IS NULL THEN
6243: p_x_line_rec.reference_line_id := FND_API.G_MISS_NUM;
6239: p_x_line_rec.reference_header_id := FND_API.G_MISS_NUM;
6240: END IF;
6241:
6242: IF p_x_line_rec.reference_line_id IS NULL THEN
6243: p_x_line_rec.reference_line_id := FND_API.G_MISS_NUM;
6244: END IF;
6245:
6246: IF p_x_line_rec.reference_type IS NULL THEN
6247: p_x_line_rec.reference_type := FND_API.G_MISS_CHAR;
6243: p_x_line_rec.reference_line_id := FND_API.G_MISS_NUM;
6244: END IF;
6245:
6246: IF p_x_line_rec.reference_type IS NULL THEN
6247: p_x_line_rec.reference_type := FND_API.G_MISS_CHAR;
6248: END IF;
6249:
6250:
6251:
6249:
6250:
6251:
6252: IF p_x_line_rec.request_date IS NULL THEN
6253: p_x_line_rec.request_date := FND_API.G_MISS_DATE;
6254: END IF;
6255:
6256: IF p_x_line_rec.request_id IS NULL THEN
6257: p_x_line_rec.request_id := FND_API.G_MISS_NUM;
6253: p_x_line_rec.request_date := FND_API.G_MISS_DATE;
6254: END IF;
6255:
6256: IF p_x_line_rec.request_id IS NULL THEN
6257: p_x_line_rec.request_id := FND_API.G_MISS_NUM;
6258: END IF;
6259:
6260: IF p_x_line_rec.return_attribute1 IS NULL THEN
6261: p_x_line_rec.return_attribute1 := FND_API.G_MISS_CHAR;
6257: p_x_line_rec.request_id := FND_API.G_MISS_NUM;
6258: END IF;
6259:
6260: IF p_x_line_rec.return_attribute1 IS NULL THEN
6261: p_x_line_rec.return_attribute1 := FND_API.G_MISS_CHAR;
6262: END IF;
6263:
6264: IF p_x_line_rec.return_attribute10 IS NULL THEN
6265: p_x_line_rec.return_attribute10 := FND_API.G_MISS_CHAR;
6261: p_x_line_rec.return_attribute1 := FND_API.G_MISS_CHAR;
6262: END IF;
6263:
6264: IF p_x_line_rec.return_attribute10 IS NULL THEN
6265: p_x_line_rec.return_attribute10 := FND_API.G_MISS_CHAR;
6266: END IF;
6267:
6268: IF p_x_line_rec.return_attribute11 IS NULL THEN
6269: p_x_line_rec.return_attribute11 := FND_API.G_MISS_CHAR;
6265: p_x_line_rec.return_attribute10 := FND_API.G_MISS_CHAR;
6266: END IF;
6267:
6268: IF p_x_line_rec.return_attribute11 IS NULL THEN
6269: p_x_line_rec.return_attribute11 := FND_API.G_MISS_CHAR;
6270: END IF;
6271:
6272: IF p_x_line_rec.return_attribute12 IS NULL THEN
6273: p_x_line_rec.return_attribute12 := FND_API.G_MISS_CHAR;
6269: p_x_line_rec.return_attribute11 := FND_API.G_MISS_CHAR;
6270: END IF;
6271:
6272: IF p_x_line_rec.return_attribute12 IS NULL THEN
6273: p_x_line_rec.return_attribute12 := FND_API.G_MISS_CHAR;
6274: END IF;
6275:
6276: IF p_x_line_rec.return_attribute13 IS NULL THEN
6277: p_x_line_rec.return_attribute13 := FND_API.G_MISS_CHAR;
6273: p_x_line_rec.return_attribute12 := FND_API.G_MISS_CHAR;
6274: END IF;
6275:
6276: IF p_x_line_rec.return_attribute13 IS NULL THEN
6277: p_x_line_rec.return_attribute13 := FND_API.G_MISS_CHAR;
6278: END IF;
6279:
6280: IF p_x_line_rec.return_attribute14 IS NULL THEN
6281: p_x_line_rec.return_attribute14 := FND_API.G_MISS_CHAR;
6277: p_x_line_rec.return_attribute13 := FND_API.G_MISS_CHAR;
6278: END IF;
6279:
6280: IF p_x_line_rec.return_attribute14 IS NULL THEN
6281: p_x_line_rec.return_attribute14 := FND_API.G_MISS_CHAR;
6282: END IF;
6283:
6284: IF p_x_line_rec.return_attribute15 IS NULL THEN
6285: p_x_line_rec.return_attribute15 := FND_API.G_MISS_CHAR;
6281: p_x_line_rec.return_attribute14 := FND_API.G_MISS_CHAR;
6282: END IF;
6283:
6284: IF p_x_line_rec.return_attribute15 IS NULL THEN
6285: p_x_line_rec.return_attribute15 := FND_API.G_MISS_CHAR;
6286: END IF;
6287:
6288: IF p_x_line_rec.return_attribute2 IS NULL THEN
6289: p_x_line_rec.return_attribute2 := FND_API.G_MISS_CHAR;
6285: p_x_line_rec.return_attribute15 := FND_API.G_MISS_CHAR;
6286: END IF;
6287:
6288: IF p_x_line_rec.return_attribute2 IS NULL THEN
6289: p_x_line_rec.return_attribute2 := FND_API.G_MISS_CHAR;
6290: END IF;
6291:
6292: IF p_x_line_rec.return_attribute3 IS NULL THEN
6293: p_x_line_rec.return_attribute3 := FND_API.G_MISS_CHAR;
6289: p_x_line_rec.return_attribute2 := FND_API.G_MISS_CHAR;
6290: END IF;
6291:
6292: IF p_x_line_rec.return_attribute3 IS NULL THEN
6293: p_x_line_rec.return_attribute3 := FND_API.G_MISS_CHAR;
6294: END IF;
6295:
6296: IF p_x_line_rec.return_attribute4 IS NULL THEN
6297: p_x_line_rec.return_attribute4 := FND_API.G_MISS_CHAR;
6293: p_x_line_rec.return_attribute3 := FND_API.G_MISS_CHAR;
6294: END IF;
6295:
6296: IF p_x_line_rec.return_attribute4 IS NULL THEN
6297: p_x_line_rec.return_attribute4 := FND_API.G_MISS_CHAR;
6298: END IF;
6299:
6300: IF p_x_line_rec.return_attribute5 IS NULL THEN
6301: p_x_line_rec.return_attribute5 := FND_API.G_MISS_CHAR;
6297: p_x_line_rec.return_attribute4 := FND_API.G_MISS_CHAR;
6298: END IF;
6299:
6300: IF p_x_line_rec.return_attribute5 IS NULL THEN
6301: p_x_line_rec.return_attribute5 := FND_API.G_MISS_CHAR;
6302: END IF;
6303:
6304: IF p_x_line_rec.return_attribute6 IS NULL THEN
6305: p_x_line_rec.return_attribute6 := FND_API.G_MISS_CHAR;
6301: p_x_line_rec.return_attribute5 := FND_API.G_MISS_CHAR;
6302: END IF;
6303:
6304: IF p_x_line_rec.return_attribute6 IS NULL THEN
6305: p_x_line_rec.return_attribute6 := FND_API.G_MISS_CHAR;
6306: END IF;
6307:
6308: IF p_x_line_rec.return_attribute7 IS NULL THEN
6309: p_x_line_rec.return_attribute7 := FND_API.G_MISS_CHAR;
6305: p_x_line_rec.return_attribute6 := FND_API.G_MISS_CHAR;
6306: END IF;
6307:
6308: IF p_x_line_rec.return_attribute7 IS NULL THEN
6309: p_x_line_rec.return_attribute7 := FND_API.G_MISS_CHAR;
6310: END IF;
6311:
6312: IF p_x_line_rec.return_attribute8 IS NULL THEN
6313: p_x_line_rec.return_attribute8 := FND_API.G_MISS_CHAR;
6309: p_x_line_rec.return_attribute7 := FND_API.G_MISS_CHAR;
6310: END IF;
6311:
6312: IF p_x_line_rec.return_attribute8 IS NULL THEN
6313: p_x_line_rec.return_attribute8 := FND_API.G_MISS_CHAR;
6314: END IF;
6315:
6316: IF p_x_line_rec.return_attribute9 IS NULL THEN
6317: p_x_line_rec.return_attribute9 := FND_API.G_MISS_CHAR;
6313: p_x_line_rec.return_attribute8 := FND_API.G_MISS_CHAR;
6314: END IF;
6315:
6316: IF p_x_line_rec.return_attribute9 IS NULL THEN
6317: p_x_line_rec.return_attribute9 := FND_API.G_MISS_CHAR;
6318: END IF;
6319:
6320: IF p_x_line_rec.return_context IS NULL THEN
6321: p_x_line_rec.return_context := FND_API.G_MISS_CHAR;
6317: p_x_line_rec.return_attribute9 := FND_API.G_MISS_CHAR;
6318: END IF;
6319:
6320: IF p_x_line_rec.return_context IS NULL THEN
6321: p_x_line_rec.return_context := FND_API.G_MISS_CHAR;
6322: END IF;
6323: IF p_x_line_rec.return_reason_code IS NULL THEN
6324: p_x_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
6325: END IF;
6320: IF p_x_line_rec.return_context IS NULL THEN
6321: p_x_line_rec.return_context := FND_API.G_MISS_CHAR;
6322: END IF;
6323: IF p_x_line_rec.return_reason_code IS NULL THEN
6324: p_x_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
6325: END IF;
6326:
6327: IF p_x_line_rec.salesrep_id IS NULL THEN
6328: oe_debug_pub.add('PSU Salesrep is null');
6325: END IF;
6326:
6327: IF p_x_line_rec.salesrep_id IS NULL THEN
6328: oe_debug_pub.add('PSU Salesrep is null');
6329: p_x_line_rec.salesrep_id := FND_API.G_MISS_NUM;
6330: null;
6331: END IF;
6332:
6333: IF p_x_line_rec.rla_schedule_type_code IS NULL THEN
6330: null;
6331: END IF;
6332:
6333: IF p_x_line_rec.rla_schedule_type_code IS NULL THEN
6334: p_x_line_rec.rla_schedule_type_code := FND_API.G_MISS_CHAR;
6335: END IF;
6336:
6337: IF p_x_line_rec.schedule_arrival_date IS NULL THEN
6338: p_x_line_rec.schedule_arrival_date := FND_API.G_MISS_DATE;
6334: p_x_line_rec.rla_schedule_type_code := FND_API.G_MISS_CHAR;
6335: END IF;
6336:
6337: IF p_x_line_rec.schedule_arrival_date IS NULL THEN
6338: p_x_line_rec.schedule_arrival_date := FND_API.G_MISS_DATE;
6339: END IF;
6340:
6341: IF p_x_line_rec.schedule_ship_date IS NULL THEN
6342: p_x_line_rec.schedule_ship_date := FND_API.G_MISS_DATE;
6338: p_x_line_rec.schedule_arrival_date := FND_API.G_MISS_DATE;
6339: END IF;
6340:
6341: IF p_x_line_rec.schedule_ship_date IS NULL THEN
6342: p_x_line_rec.schedule_ship_date := FND_API.G_MISS_DATE;
6343: END IF;
6344:
6345: IF p_x_line_rec.schedule_action_code IS NULL THEN
6346: p_x_line_rec.schedule_action_code := FND_API.G_MISS_CHAR;
6342: p_x_line_rec.schedule_ship_date := FND_API.G_MISS_DATE;
6343: END IF;
6344:
6345: IF p_x_line_rec.schedule_action_code IS NULL THEN
6346: p_x_line_rec.schedule_action_code := FND_API.G_MISS_CHAR;
6347: END IF;
6348:
6349: IF p_x_line_rec.schedule_status_code IS NULL THEN
6350: p_x_line_rec.schedule_status_code := FND_API.G_MISS_CHAR;
6346: p_x_line_rec.schedule_action_code := FND_API.G_MISS_CHAR;
6347: END IF;
6348:
6349: IF p_x_line_rec.schedule_status_code IS NULL THEN
6350: p_x_line_rec.schedule_status_code := FND_API.G_MISS_CHAR;
6351: END IF;
6352:
6353: IF p_x_line_rec.shipment_number IS NULL THEN
6354: p_x_line_rec.shipment_number := FND_API.G_MISS_NUM;
6350: p_x_line_rec.schedule_status_code := FND_API.G_MISS_CHAR;
6351: END IF;
6352:
6353: IF p_x_line_rec.shipment_number IS NULL THEN
6354: p_x_line_rec.shipment_number := FND_API.G_MISS_NUM;
6355: END IF;
6356:
6357: IF p_x_line_rec.shipment_priority_code IS NULL THEN
6358: p_x_line_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
6354: p_x_line_rec.shipment_number := FND_API.G_MISS_NUM;
6355: END IF;
6356:
6357: IF p_x_line_rec.shipment_priority_code IS NULL THEN
6358: p_x_line_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
6359: END IF;
6360:
6361: IF p_x_line_rec.shipped_quantity IS NULL THEN
6362: p_x_line_rec.shipped_quantity := FND_API.G_MISS_NUM;
6358: p_x_line_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
6359: END IF;
6360:
6361: IF p_x_line_rec.shipped_quantity IS NULL THEN
6362: p_x_line_rec.shipped_quantity := FND_API.G_MISS_NUM;
6363: END IF;
6364:
6365: IF p_x_line_rec.shipped_quantity2 IS NULL THEN
6366: p_x_line_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
6362: p_x_line_rec.shipped_quantity := FND_API.G_MISS_NUM;
6363: END IF;
6364:
6365: IF p_x_line_rec.shipped_quantity2 IS NULL THEN
6366: p_x_line_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
6367: END IF;
6368:
6369: IF p_x_line_rec.shipping_method_code IS NULL THEN
6370: p_x_line_rec.shipping_method_code := FND_API.G_MISS_CHAR;
6366: p_x_line_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
6367: END IF;
6368:
6369: IF p_x_line_rec.shipping_method_code IS NULL THEN
6370: p_x_line_rec.shipping_method_code := FND_API.G_MISS_CHAR;
6371: END IF;
6372:
6373: IF p_x_line_rec.shipping_quantity IS NULL THEN
6374: p_x_line_rec.shipping_quantity := FND_API.G_MISS_NUM;
6370: p_x_line_rec.shipping_method_code := FND_API.G_MISS_CHAR;
6371: END IF;
6372:
6373: IF p_x_line_rec.shipping_quantity IS NULL THEN
6374: p_x_line_rec.shipping_quantity := FND_API.G_MISS_NUM;
6375: END IF;
6376:
6377: IF p_x_line_rec.shipping_quantity2 IS NULL THEN
6378: p_x_line_rec.shipping_quantity2 := FND_API.G_MISS_NUM;
6374: p_x_line_rec.shipping_quantity := FND_API.G_MISS_NUM;
6375: END IF;
6376:
6377: IF p_x_line_rec.shipping_quantity2 IS NULL THEN
6378: p_x_line_rec.shipping_quantity2 := FND_API.G_MISS_NUM;
6379: END IF;
6380:
6381: IF p_x_line_rec.shipping_quantity_uom IS NULL THEN
6382: p_x_line_rec.shipping_quantity_uom := FND_API.G_MISS_CHAR;
6378: p_x_line_rec.shipping_quantity2 := FND_API.G_MISS_NUM;
6379: END IF;
6380:
6381: IF p_x_line_rec.shipping_quantity_uom IS NULL THEN
6382: p_x_line_rec.shipping_quantity_uom := FND_API.G_MISS_CHAR;
6383: END IF;
6384:
6385: IF p_x_line_rec.ship_from_org_id IS NULL THEN
6386: p_x_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
6382: p_x_line_rec.shipping_quantity_uom := FND_API.G_MISS_CHAR;
6383: END IF;
6384:
6385: IF p_x_line_rec.ship_from_org_id IS NULL THEN
6386: p_x_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
6387: END IF;
6388:
6389: IF p_x_line_rec.subinventory IS NULL THEN
6390: p_x_line_rec.subinventory := FND_API.G_MISS_CHAR;
6386: p_x_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
6387: END IF;
6388:
6389: IF p_x_line_rec.subinventory IS NULL THEN
6390: p_x_line_rec.subinventory := FND_API.G_MISS_CHAR;
6391: END IF;
6392:
6393: IF p_x_line_rec.ship_model_complete_flag IS NULL THEN
6394: p_x_line_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
6390: p_x_line_rec.subinventory := FND_API.G_MISS_CHAR;
6391: END IF;
6392:
6393: IF p_x_line_rec.ship_model_complete_flag IS NULL THEN
6394: p_x_line_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
6395: END IF;
6396: IF p_x_line_rec.ship_set_id IS NULL THEN
6397: p_x_line_rec.ship_set_id := FND_API.G_MISS_NUM;
6398: END IF;
6393: IF p_x_line_rec.ship_model_complete_flag IS NULL THEN
6394: p_x_line_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
6395: END IF;
6396: IF p_x_line_rec.ship_set_id IS NULL THEN
6397: p_x_line_rec.ship_set_id := FND_API.G_MISS_NUM;
6398: END IF;
6399:
6400: IF p_x_line_rec.ship_tolerance_above IS NULL THEN
6401: p_x_line_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
6397: p_x_line_rec.ship_set_id := FND_API.G_MISS_NUM;
6398: END IF;
6399:
6400: IF p_x_line_rec.ship_tolerance_above IS NULL THEN
6401: p_x_line_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
6402: END IF;
6403:
6404: IF p_x_line_rec.ship_tolerance_below IS NULL THEN
6405: p_x_line_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
6401: p_x_line_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
6402: END IF;
6403:
6404: IF p_x_line_rec.ship_tolerance_below IS NULL THEN
6405: p_x_line_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
6406: END IF;
6407:
6408: IF p_x_line_rec.shippable_flag IS NULL THEN
6409: p_x_line_rec.shippable_flag := FND_API.G_MISS_CHAR;
6405: p_x_line_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
6406: END IF;
6407:
6408: IF p_x_line_rec.shippable_flag IS NULL THEN
6409: p_x_line_rec.shippable_flag := FND_API.G_MISS_CHAR;
6410: END IF;
6411:
6412: IF p_x_line_rec.shipping_interfaced_flag IS NULL THEN
6413: p_x_line_rec.shipping_interfaced_flag := FND_API.G_MISS_CHAR;
6409: p_x_line_rec.shippable_flag := FND_API.G_MISS_CHAR;
6410: END IF;
6411:
6412: IF p_x_line_rec.shipping_interfaced_flag IS NULL THEN
6413: p_x_line_rec.shipping_interfaced_flag := FND_API.G_MISS_CHAR;
6414: END IF;
6415:
6416: IF p_x_line_rec.ship_to_contact_id IS NULL THEN
6417: p_x_line_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
6413: p_x_line_rec.shipping_interfaced_flag := FND_API.G_MISS_CHAR;
6414: END IF;
6415:
6416: IF p_x_line_rec.ship_to_contact_id IS NULL THEN
6417: p_x_line_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
6418: END IF;
6419:
6420: IF p_x_line_rec.ship_to_org_id IS NULL THEN
6421: p_x_line_rec.ship_to_org_id := FND_API.G_MISS_NUM;
6417: p_x_line_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
6418: END IF;
6419:
6420: IF p_x_line_rec.ship_to_org_id IS NULL THEN
6421: p_x_line_rec.ship_to_org_id := FND_API.G_MISS_NUM;
6422: END IF;
6423:
6424: IF p_x_line_rec.sold_from_org_id IS NULL THEN
6425: p_x_line_rec.sold_from_org_id := FND_API.G_MISS_NUM;
6421: p_x_line_rec.ship_to_org_id := FND_API.G_MISS_NUM;
6422: END IF;
6423:
6424: IF p_x_line_rec.sold_from_org_id IS NULL THEN
6425: p_x_line_rec.sold_from_org_id := FND_API.G_MISS_NUM;
6426: END IF;
6427:
6428: -- p_x_line_rec.sold_to_org_id := 1006; -- ZB
6429: IF p_x_line_rec.sold_to_org_id IS NULL THEN
6427:
6428: -- p_x_line_rec.sold_to_org_id := 1006; -- ZB
6429: IF p_x_line_rec.sold_to_org_id IS NULL THEN
6430: oe_debug_pub.add('Sold to is null');
6431: p_x_line_rec.sold_to_org_id := FND_API.G_MISS_NUM;
6432: END IF;
6433:
6434: IF p_x_line_rec.sort_order IS NULL THEN
6435: p_x_line_rec.sort_order := FND_API.G_MISS_CHAR;
6431: p_x_line_rec.sold_to_org_id := FND_API.G_MISS_NUM;
6432: END IF;
6433:
6434: IF p_x_line_rec.sort_order IS NULL THEN
6435: p_x_line_rec.sort_order := FND_API.G_MISS_CHAR;
6436: END IF;
6437:
6438: IF p_x_line_rec.source_document_id IS NULL THEN
6439: p_x_line_rec.source_document_id := FND_API.G_MISS_NUM;
6435: p_x_line_rec.sort_order := FND_API.G_MISS_CHAR;
6436: END IF;
6437:
6438: IF p_x_line_rec.source_document_id IS NULL THEN
6439: p_x_line_rec.source_document_id := FND_API.G_MISS_NUM;
6440: END IF;
6441:
6442: IF p_x_line_rec.source_document_line_id IS NULL THEN
6443: p_x_line_rec.source_document_line_id := FND_API.G_MISS_NUM;
6439: p_x_line_rec.source_document_id := FND_API.G_MISS_NUM;
6440: END IF;
6441:
6442: IF p_x_line_rec.source_document_line_id IS NULL THEN
6443: p_x_line_rec.source_document_line_id := FND_API.G_MISS_NUM;
6444: END IF;
6445:
6446: IF p_x_line_rec.source_document_type_id IS NULL THEN
6447: p_x_line_rec.source_document_type_id := FND_API.G_MISS_NUM;
6443: p_x_line_rec.source_document_line_id := FND_API.G_MISS_NUM;
6444: END IF;
6445:
6446: IF p_x_line_rec.source_document_type_id IS NULL THEN
6447: p_x_line_rec.source_document_type_id := FND_API.G_MISS_NUM;
6448: END IF;
6449:
6450: IF p_x_line_rec.source_type_code IS NULL THEN
6451: p_x_line_rec.source_type_code := FND_API.G_MISS_CHAR;
6447: p_x_line_rec.source_document_type_id := FND_API.G_MISS_NUM;
6448: END IF;
6449:
6450: IF p_x_line_rec.source_type_code IS NULL THEN
6451: p_x_line_rec.source_type_code := FND_API.G_MISS_CHAR;
6452: END IF;
6453: IF p_x_line_rec.split_from_line_id IS NULL THEN
6454: p_x_line_rec.split_from_line_id := FND_API.G_MISS_NUM;
6455: END IF;
6450: IF p_x_line_rec.source_type_code IS NULL THEN
6451: p_x_line_rec.source_type_code := FND_API.G_MISS_CHAR;
6452: END IF;
6453: IF p_x_line_rec.split_from_line_id IS NULL THEN
6454: p_x_line_rec.split_from_line_id := FND_API.G_MISS_NUM;
6455: END IF;
6456: IF p_x_line_rec.line_set_id IS NULL THEN
6457: p_x_line_rec.line_set_id := FND_API.G_MISS_NUM;
6458: END IF;
6453: IF p_x_line_rec.split_from_line_id IS NULL THEN
6454: p_x_line_rec.split_from_line_id := FND_API.G_MISS_NUM;
6455: END IF;
6456: IF p_x_line_rec.line_set_id IS NULL THEN
6457: p_x_line_rec.line_set_id := FND_API.G_MISS_NUM;
6458: END IF;
6459:
6460: IF p_x_line_rec.split_by IS NULL THEN
6461: p_x_line_rec.split_by := FND_API.G_MISS_CHAR;
6457: p_x_line_rec.line_set_id := FND_API.G_MISS_NUM;
6458: END IF;
6459:
6460: IF p_x_line_rec.split_by IS NULL THEN
6461: p_x_line_rec.split_by := FND_API.G_MISS_CHAR;
6462: END IF;
6463: IF p_x_line_rec.model_remnant_flag IS NULL THEN
6464: p_x_line_rec.model_remnant_flag := FND_API.G_MISS_CHAR;
6465: END IF;
6460: IF p_x_line_rec.split_by IS NULL THEN
6461: p_x_line_rec.split_by := FND_API.G_MISS_CHAR;
6462: END IF;
6463: IF p_x_line_rec.model_remnant_flag IS NULL THEN
6464: p_x_line_rec.model_remnant_flag := FND_API.G_MISS_CHAR;
6465: END IF;
6466: IF p_x_line_rec.task_id IS NULL THEN
6467: p_x_line_rec.task_id := FND_API.G_MISS_NUM;
6468: END IF;
6463: IF p_x_line_rec.model_remnant_flag IS NULL THEN
6464: p_x_line_rec.model_remnant_flag := FND_API.G_MISS_CHAR;
6465: END IF;
6466: IF p_x_line_rec.task_id IS NULL THEN
6467: p_x_line_rec.task_id := FND_API.G_MISS_NUM;
6468: END IF;
6469:
6470: IF p_x_line_rec.tax_code IS NULL THEN
6471: p_x_line_rec.tax_code := FND_API.G_MISS_CHAR;
6467: p_x_line_rec.task_id := FND_API.G_MISS_NUM;
6468: END IF;
6469:
6470: IF p_x_line_rec.tax_code IS NULL THEN
6471: p_x_line_rec.tax_code := FND_API.G_MISS_CHAR;
6472: END IF;
6473:
6474: IF p_x_line_rec.tax_date IS NULL THEN
6475: p_x_line_rec.tax_date := FND_API.G_MISS_DATE;
6471: p_x_line_rec.tax_code := FND_API.G_MISS_CHAR;
6472: END IF;
6473:
6474: IF p_x_line_rec.tax_date IS NULL THEN
6475: p_x_line_rec.tax_date := FND_API.G_MISS_DATE;
6476: END IF;
6477:
6478: IF p_x_line_rec.tax_exempt_flag IS NULL THEN
6479: oe_debug_pub.add('Tax Exempt is null');
6476: END IF;
6477:
6478: IF p_x_line_rec.tax_exempt_flag IS NULL THEN
6479: oe_debug_pub.add('Tax Exempt is null');
6480: p_x_line_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
6481: END IF;
6482:
6483: IF p_x_line_rec.tax_exempt_number IS NULL THEN
6484: p_x_line_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
6480: p_x_line_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
6481: END IF;
6482:
6483: IF p_x_line_rec.tax_exempt_number IS NULL THEN
6484: p_x_line_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
6485: END IF;
6486:
6487: IF p_x_line_rec.tax_exempt_reason_code IS NULL THEN
6488: p_x_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
6484: p_x_line_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
6485: END IF;
6486:
6487: IF p_x_line_rec.tax_exempt_reason_code IS NULL THEN
6488: p_x_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
6489: END IF;
6490:
6491: IF p_x_line_rec.tax_point_code IS NULL THEN
6492: p_x_line_rec.tax_point_code := FND_API.G_MISS_CHAR;
6488: p_x_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
6489: END IF;
6490:
6491: IF p_x_line_rec.tax_point_code IS NULL THEN
6492: p_x_line_rec.tax_point_code := FND_API.G_MISS_CHAR;
6493: END IF;
6494:
6495: IF p_x_line_rec.tax_rate IS NULL THEN
6496: p_x_line_rec.tax_rate := FND_API.G_MISS_NUM;
6492: p_x_line_rec.tax_point_code := FND_API.G_MISS_CHAR;
6493: END IF;
6494:
6495: IF p_x_line_rec.tax_rate IS NULL THEN
6496: p_x_line_rec.tax_rate := FND_API.G_MISS_NUM;
6497: END IF;
6498:
6499: IF p_x_line_rec.tax_value IS NULL THEN
6500: p_x_line_rec.tax_value := FND_API.G_MISS_NUM;
6496: p_x_line_rec.tax_rate := FND_API.G_MISS_NUM;
6497: END IF;
6498:
6499: IF p_x_line_rec.tax_value IS NULL THEN
6500: p_x_line_rec.tax_value := FND_API.G_MISS_NUM;
6501: END IF;
6502:
6503: IF p_x_line_rec.top_model_line_id IS NULL THEN
6504: p_x_line_rec.top_model_line_id := FND_API.G_MISS_NUM;
6500: p_x_line_rec.tax_value := FND_API.G_MISS_NUM;
6501: END IF;
6502:
6503: IF p_x_line_rec.top_model_line_id IS NULL THEN
6504: p_x_line_rec.top_model_line_id := FND_API.G_MISS_NUM;
6505: END IF;
6506:
6507: IF p_x_line_rec.unit_list_price IS NULL THEN
6508: p_x_line_rec.unit_list_price := FND_API.G_MISS_NUM;
6504: p_x_line_rec.top_model_line_id := FND_API.G_MISS_NUM;
6505: END IF;
6506:
6507: IF p_x_line_rec.unit_list_price IS NULL THEN
6508: p_x_line_rec.unit_list_price := FND_API.G_MISS_NUM;
6509: END IF;
6510:
6511: IF p_x_line_rec.unit_list_price_per_pqty IS NULL THEN
6512: p_x_line_rec.unit_list_price_per_pqty := FND_API.G_MISS_NUM;
6508: p_x_line_rec.unit_list_price := FND_API.G_MISS_NUM;
6509: END IF;
6510:
6511: IF p_x_line_rec.unit_list_price_per_pqty IS NULL THEN
6512: p_x_line_rec.unit_list_price_per_pqty := FND_API.G_MISS_NUM;
6513: END IF;
6514:
6515: IF p_x_line_rec.unit_selling_price IS NULL THEN
6516: p_x_line_rec.unit_selling_price := FND_API.G_MISS_NUM;
6512: p_x_line_rec.unit_list_price_per_pqty := FND_API.G_MISS_NUM;
6513: END IF;
6514:
6515: IF p_x_line_rec.unit_selling_price IS NULL THEN
6516: p_x_line_rec.unit_selling_price := FND_API.G_MISS_NUM;
6517: END IF;
6518:
6519: IF p_x_line_rec.unit_selling_price_per_pqty IS NULL THEN
6520: p_x_line_rec.unit_selling_price_per_pqty := FND_API.G_MISS_NUM;
6516: p_x_line_rec.unit_selling_price := FND_API.G_MISS_NUM;
6517: END IF;
6518:
6519: IF p_x_line_rec.unit_selling_price_per_pqty IS NULL THEN
6520: p_x_line_rec.unit_selling_price_per_pqty := FND_API.G_MISS_NUM;
6521: END IF;
6522:
6523:
6524: IF p_x_line_rec.visible_demand_flag IS NULL THEN
6521: END IF;
6522:
6523:
6524: IF p_x_line_rec.visible_demand_flag IS NULL THEN
6525: p_x_line_rec.visible_demand_flag := FND_API.G_MISS_CHAR;
6526: END IF;
6527: IF p_x_line_rec.veh_cus_item_cum_key_id IS NULL THEN
6528: p_x_line_rec.veh_cus_item_cum_key_id := FND_API.G_MISS_NUM;
6529: END IF;
6524: IF p_x_line_rec.visible_demand_flag IS NULL THEN
6525: p_x_line_rec.visible_demand_flag := FND_API.G_MISS_CHAR;
6526: END IF;
6527: IF p_x_line_rec.veh_cus_item_cum_key_id IS NULL THEN
6528: p_x_line_rec.veh_cus_item_cum_key_id := FND_API.G_MISS_NUM;
6529: END IF;
6530:
6531: IF p_x_line_rec.first_ack_code IS NULL THEN
6532: p_x_line_rec.first_ack_code := FND_API.G_MISS_CHAR;
6528: p_x_line_rec.veh_cus_item_cum_key_id := FND_API.G_MISS_NUM;
6529: END IF;
6530:
6531: IF p_x_line_rec.first_ack_code IS NULL THEN
6532: p_x_line_rec.first_ack_code := FND_API.G_MISS_CHAR;
6533: END IF;
6534:
6535: IF p_x_line_rec.first_ack_date IS NULL THEN
6536: p_x_line_rec.first_ack_date := FND_API.G_MISS_DATE;
6532: p_x_line_rec.first_ack_code := FND_API.G_MISS_CHAR;
6533: END IF;
6534:
6535: IF p_x_line_rec.first_ack_date IS NULL THEN
6536: p_x_line_rec.first_ack_date := FND_API.G_MISS_DATE;
6537: END IF;
6538:
6539: IF p_x_line_rec.last_ack_code IS NULL THEN
6540: p_x_line_rec.last_ack_code := FND_API.G_MISS_CHAR;
6536: p_x_line_rec.first_ack_date := FND_API.G_MISS_DATE;
6537: END IF;
6538:
6539: IF p_x_line_rec.last_ack_code IS NULL THEN
6540: p_x_line_rec.last_ack_code := FND_API.G_MISS_CHAR;
6541: END IF;
6542:
6543: IF p_x_line_rec.last_ack_date IS NULL THEN
6544: p_x_line_rec.last_ack_date := FND_API.G_MISS_DATE;
6540: p_x_line_rec.last_ack_code := FND_API.G_MISS_CHAR;
6541: END IF;
6542:
6543: IF p_x_line_rec.last_ack_date IS NULL THEN
6544: p_x_line_rec.last_ack_date := FND_API.G_MISS_DATE;
6545: END IF;
6546:
6547:
6548: IF p_x_line_rec.end_item_unit_number IS NULL THEN
6545: END IF;
6546:
6547:
6548: IF p_x_line_rec.end_item_unit_number IS NULL THEN
6549: p_x_line_rec.end_item_unit_number := FND_API.G_MISS_CHAR;
6550: END IF;
6551:
6552: IF p_x_line_rec.shipping_instructions IS NULL THEN
6553: p_x_line_rec.shipping_instructions := FND_API.G_MISS_CHAR;
6549: p_x_line_rec.end_item_unit_number := FND_API.G_MISS_CHAR;
6550: END IF;
6551:
6552: IF p_x_line_rec.shipping_instructions IS NULL THEN
6553: p_x_line_rec.shipping_instructions := FND_API.G_MISS_CHAR;
6554: END IF;
6555:
6556: IF p_x_line_rec.packing_instructions IS NULL THEN
6557: p_x_line_rec.packing_instructions := FND_API.G_MISS_CHAR;
6553: p_x_line_rec.shipping_instructions := FND_API.G_MISS_CHAR;
6554: END IF;
6555:
6556: IF p_x_line_rec.packing_instructions IS NULL THEN
6557: p_x_line_rec.packing_instructions := FND_API.G_MISS_CHAR;
6558: END IF;
6559:
6560: IF p_x_line_rec.service_txn_reason_code IS NULL THEN
6561: p_x_line_rec.service_txn_reason_code := FND_API.G_MISS_CHAR;
6557: p_x_line_rec.packing_instructions := FND_API.G_MISS_CHAR;
6558: END IF;
6559:
6560: IF p_x_line_rec.service_txn_reason_code IS NULL THEN
6561: p_x_line_rec.service_txn_reason_code := FND_API.G_MISS_CHAR;
6562: END IF;
6563:
6564: IF p_x_line_rec.service_txn_comments IS NULL THEN
6565: p_x_line_rec.service_txn_comments := FND_API.G_MISS_CHAR;
6561: p_x_line_rec.service_txn_reason_code := FND_API.G_MISS_CHAR;
6562: END IF;
6563:
6564: IF p_x_line_rec.service_txn_comments IS NULL THEN
6565: p_x_line_rec.service_txn_comments := FND_API.G_MISS_CHAR;
6566: END IF;
6567:
6568: IF p_x_line_rec.service_duration IS NULL THEN
6569: p_x_line_rec.service_duration := FND_API.G_MISS_NUM;
6565: p_x_line_rec.service_txn_comments := FND_API.G_MISS_CHAR;
6566: END IF;
6567:
6568: IF p_x_line_rec.service_duration IS NULL THEN
6569: p_x_line_rec.service_duration := FND_API.G_MISS_NUM;
6570: END IF;
6571:
6572: IF p_x_line_rec.service_period IS NULL THEN
6573: p_x_line_rec.service_period := FND_API.G_MISS_CHAR;
6569: p_x_line_rec.service_duration := FND_API.G_MISS_NUM;
6570: END IF;
6571:
6572: IF p_x_line_rec.service_period IS NULL THEN
6573: p_x_line_rec.service_period := FND_API.G_MISS_CHAR;
6574: END IF;
6575:
6576: IF p_x_line_rec.service_start_date IS NULL THEN
6577: p_x_line_rec.service_start_date := FND_API.G_MISS_DATE;
6573: p_x_line_rec.service_period := FND_API.G_MISS_CHAR;
6574: END IF;
6575:
6576: IF p_x_line_rec.service_start_date IS NULL THEN
6577: p_x_line_rec.service_start_date := FND_API.G_MISS_DATE;
6578: END IF;
6579:
6580: IF p_x_line_rec.service_end_date IS NULL THEN
6581: p_x_line_rec.service_end_date := FND_API.G_MISS_DATE;
6577: p_x_line_rec.service_start_date := FND_API.G_MISS_DATE;
6578: END IF;
6579:
6580: IF p_x_line_rec.service_end_date IS NULL THEN
6581: p_x_line_rec.service_end_date := FND_API.G_MISS_DATE;
6582: END IF;
6583:
6584: IF p_x_line_rec.service_coterminate_flag IS NULL THEN
6585: p_x_line_rec.service_coterminate_flag := FND_API.G_MISS_CHAR;
6581: p_x_line_rec.service_end_date := FND_API.G_MISS_DATE;
6582: END IF;
6583:
6584: IF p_x_line_rec.service_coterminate_flag IS NULL THEN
6585: p_x_line_rec.service_coterminate_flag := FND_API.G_MISS_CHAR;
6586: END IF;
6587:
6588:
6589: IF p_x_line_rec.unit_list_percent IS NULL THEN
6586: END IF;
6587:
6588:
6589: IF p_x_line_rec.unit_list_percent IS NULL THEN
6590: p_x_line_rec.unit_list_percent := FND_API.G_MISS_NUM;
6591: END IF;
6592:
6593: IF p_x_line_rec.unit_selling_percent IS NULL THEN
6594: p_x_line_rec.unit_selling_percent := FND_API.G_MISS_NUM;
6590: p_x_line_rec.unit_list_percent := FND_API.G_MISS_NUM;
6591: END IF;
6592:
6593: IF p_x_line_rec.unit_selling_percent IS NULL THEN
6594: p_x_line_rec.unit_selling_percent := FND_API.G_MISS_NUM;
6595: END IF;
6596:
6597: IF p_x_line_rec.unit_percent_base_price IS NULL THEN
6598: p_x_line_rec.unit_percent_base_price := FND_API.G_MISS_NUM;
6594: p_x_line_rec.unit_selling_percent := FND_API.G_MISS_NUM;
6595: END IF;
6596:
6597: IF p_x_line_rec.unit_percent_base_price IS NULL THEN
6598: p_x_line_rec.unit_percent_base_price := FND_API.G_MISS_NUM;
6599: END IF;
6600:
6601: IF p_x_line_rec.service_number IS NULL THEN
6602: p_x_line_rec.service_number := FND_API.G_MISS_NUM;
6598: p_x_line_rec.unit_percent_base_price := FND_API.G_MISS_NUM;
6599: END IF;
6600:
6601: IF p_x_line_rec.service_number IS NULL THEN
6602: p_x_line_rec.service_number := FND_API.G_MISS_NUM;
6603: END IF;
6604:
6605: IF p_x_line_rec.service_reference_type_code IS NULL THEN
6606: p_x_line_rec.service_reference_type_code := FND_API.G_MISS_CHAR;
6602: p_x_line_rec.service_number := FND_API.G_MISS_NUM;
6603: END IF;
6604:
6605: IF p_x_line_rec.service_reference_type_code IS NULL THEN
6606: p_x_line_rec.service_reference_type_code := FND_API.G_MISS_CHAR;
6607: END IF;
6608:
6609: IF p_x_line_rec.service_reference_line_id IS NULL THEN
6610: p_x_line_rec.service_reference_line_id := FND_API.G_MISS_NUM;
6606: p_x_line_rec.service_reference_type_code := FND_API.G_MISS_CHAR;
6607: END IF;
6608:
6609: IF p_x_line_rec.service_reference_line_id IS NULL THEN
6610: p_x_line_rec.service_reference_line_id := FND_API.G_MISS_NUM;
6611: END IF;
6612:
6613: IF p_x_line_rec.service_reference_system_id IS NULL THEN
6614: p_x_line_rec.service_reference_system_id := FND_API.G_MISS_NUM;
6610: p_x_line_rec.service_reference_line_id := FND_API.G_MISS_NUM;
6611: END IF;
6612:
6613: IF p_x_line_rec.service_reference_system_id IS NULL THEN
6614: p_x_line_rec.service_reference_system_id := FND_API.G_MISS_NUM;
6615: END IF;
6616:
6617: IF p_x_line_rec.marketing_source_code_id IS NULL THEN
6618: p_x_line_rec.marketing_source_code_id := FND_API.G_MISS_NUM;
6614: p_x_line_rec.service_reference_system_id := FND_API.G_MISS_NUM;
6615: END IF;
6616:
6617: IF p_x_line_rec.marketing_source_code_id IS NULL THEN
6618: p_x_line_rec.marketing_source_code_id := FND_API.G_MISS_NUM;
6619: END IF;
6620:
6621: IF p_x_line_rec.order_source_id IS NULL THEN
6622: p_x_line_rec.order_source_id := FND_API.G_MISS_NUM;
6618: p_x_line_rec.marketing_source_code_id := FND_API.G_MISS_NUM;
6619: END IF;
6620:
6621: IF p_x_line_rec.order_source_id IS NULL THEN
6622: p_x_line_rec.order_source_id := FND_API.G_MISS_NUM;
6623: END IF;
6624:
6625: IF p_x_line_rec.flow_status_code IS NULL THEN
6626: p_x_line_rec.flow_status_code := FND_API.G_MISS_CHAR;
6622: p_x_line_rec.order_source_id := FND_API.G_MISS_NUM;
6623: END IF;
6624:
6625: IF p_x_line_rec.flow_status_code IS NULL THEN
6626: p_x_line_rec.flow_status_code := FND_API.G_MISS_CHAR;
6627: END IF;
6628:
6629: IF p_x_line_rec.commitment_id IS NULL THEN
6630: p_x_line_rec.commitment_id := FND_API.G_MISS_NUM;
6626: p_x_line_rec.flow_status_code := FND_API.G_MISS_CHAR;
6627: END IF;
6628:
6629: IF p_x_line_rec.commitment_id IS NULL THEN
6630: p_x_line_rec.commitment_id := FND_API.G_MISS_NUM;
6631: END IF;
6632:
6633:
6634: IF p_x_line_rec.Original_Inventory_Item_Id IS NULL THEN
6631: END IF;
6632:
6633:
6634: IF p_x_line_rec.Original_Inventory_Item_Id IS NULL THEN
6635: p_x_line_rec.Original_Inventory_Item_Id := FND_API.G_MISS_NUM;
6636: END IF;
6637:
6638: IF p_x_line_rec.Original_item_identifier_Type IS NULL THEN
6639: p_x_line_rec.Original_item_identifier_Type := FND_API.G_MISS_CHAR;
6635: p_x_line_rec.Original_Inventory_Item_Id := FND_API.G_MISS_NUM;
6636: END IF;
6637:
6638: IF p_x_line_rec.Original_item_identifier_Type IS NULL THEN
6639: p_x_line_rec.Original_item_identifier_Type := FND_API.G_MISS_CHAR;
6640: END IF;
6641:
6642: IF p_x_line_rec.Original_ordered_item_id IS NULL THEN
6643: p_x_line_rec.Original_ordered_item_id := FND_API.G_MISS_NUM;
6639: p_x_line_rec.Original_item_identifier_Type := FND_API.G_MISS_CHAR;
6640: END IF;
6641:
6642: IF p_x_line_rec.Original_ordered_item_id IS NULL THEN
6643: p_x_line_rec.Original_ordered_item_id := FND_API.G_MISS_NUM;
6644: END IF;
6645:
6646: IF p_x_line_rec.Original_ordered_item IS NULL THEN
6647: p_x_line_rec.Original_ordered_item := FND_API.G_MISS_CHAR;
6643: p_x_line_rec.Original_ordered_item_id := FND_API.G_MISS_NUM;
6644: END IF;
6645:
6646: IF p_x_line_rec.Original_ordered_item IS NULL THEN
6647: p_x_line_rec.Original_ordered_item := FND_API.G_MISS_CHAR;
6648: END IF;
6649:
6650: IF p_x_line_rec.item_relationship_type IS NULL THEN
6651: p_x_line_rec.item_relationship_type := FND_API.G_MISS_NUM;
6647: p_x_line_rec.Original_ordered_item := FND_API.G_MISS_CHAR;
6648: END IF;
6649:
6650: IF p_x_line_rec.item_relationship_type IS NULL THEN
6651: p_x_line_rec.item_relationship_type := FND_API.G_MISS_NUM;
6652: END IF;
6653:
6654: IF p_x_line_rec.Item_substitution_type_code IS NULL THEN
6655: p_x_line_rec.Item_substitution_type_code := FND_API.G_MISS_CHAR;
6651: p_x_line_rec.item_relationship_type := FND_API.G_MISS_NUM;
6652: END IF;
6653:
6654: IF p_x_line_rec.Item_substitution_type_code IS NULL THEN
6655: p_x_line_rec.Item_substitution_type_code := FND_API.G_MISS_CHAR;
6656: END IF;
6657:
6658: IF p_x_line_rec.Late_Demand_Penalty_Factor IS NULL THEN
6659: p_x_line_rec.Late_Demand_Penalty_Factor := FND_API.G_MISS_NUM;
6655: p_x_line_rec.Item_substitution_type_code := FND_API.G_MISS_CHAR;
6656: END IF;
6657:
6658: IF p_x_line_rec.Late_Demand_Penalty_Factor IS NULL THEN
6659: p_x_line_rec.Late_Demand_Penalty_Factor := FND_API.G_MISS_NUM;
6660: END IF;
6661:
6662: IF p_x_line_rec.Override_atp_date_code IS NULL THEN
6663: p_x_line_rec.Override_atp_date_code := FND_API.G_MISS_CHAR;
6659: p_x_line_rec.Late_Demand_Penalty_Factor := FND_API.G_MISS_NUM;
6660: END IF;
6661:
6662: IF p_x_line_rec.Override_atp_date_code IS NULL THEN
6663: p_x_line_rec.Override_atp_date_code := FND_API.G_MISS_CHAR;
6664: END IF;
6665:
6666: IF p_x_line_rec.Blanket_Number IS NULL THEN
6667: p_x_line_rec.Blanket_Number := FND_API.G_MISS_NUM;
6663: p_x_line_rec.Override_atp_date_code := FND_API.G_MISS_CHAR;
6664: END IF;
6665:
6666: IF p_x_line_rec.Blanket_Number IS NULL THEN
6667: p_x_line_rec.Blanket_Number := FND_API.G_MISS_NUM;
6668: END IF;
6669:
6670: IF p_x_line_rec.Blanket_Line_Number IS NULL THEN
6671: p_x_line_rec.Blanket_Line_Number := FND_API.G_MISS_NUM;
6667: p_x_line_rec.Blanket_Number := FND_API.G_MISS_NUM;
6668: END IF;
6669:
6670: IF p_x_line_rec.Blanket_Line_Number IS NULL THEN
6671: p_x_line_rec.Blanket_Line_Number := FND_API.G_MISS_NUM;
6672: END IF;
6673:
6674: IF p_x_line_rec.Blanket_Version_Number IS NULL THEN
6675: p_x_line_rec.Blanket_Version_Number := FND_API.G_MISS_NUM;
6671: p_x_line_rec.Blanket_Line_Number := FND_API.G_MISS_NUM;
6672: END IF;
6673:
6674: IF p_x_line_rec.Blanket_Version_Number IS NULL THEN
6675: p_x_line_rec.Blanket_Version_Number := FND_API.G_MISS_NUM;
6676: END IF;
6677:
6678: IF p_x_line_rec.transaction_phase_code IS NULL THEN
6679: p_x_line_rec.transaction_phase_code := FND_API.G_MISS_CHAR;
6675: p_x_line_rec.Blanket_Version_Number := FND_API.G_MISS_NUM;
6676: END IF;
6677:
6678: IF p_x_line_rec.transaction_phase_code IS NULL THEN
6679: p_x_line_rec.transaction_phase_code := FND_API.G_MISS_CHAR;
6680: END IF;
6681:
6682: IF p_x_line_rec.source_document_version_number IS NULL THEN
6683: p_x_line_rec.source_document_version_number := FND_API.G_MISS_NUM;
6679: p_x_line_rec.transaction_phase_code := FND_API.G_MISS_CHAR;
6680: END IF;
6681:
6682: IF p_x_line_rec.source_document_version_number IS NULL THEN
6683: p_x_line_rec.source_document_version_number := FND_API.G_MISS_NUM;
6684: END IF;
6685:
6686: IF p_x_line_rec.Minisite_id IS NULL THEN
6687: p_x_line_rec.Minisite_id := FND_API.G_MISS_NUM;
6683: p_x_line_rec.source_document_version_number := FND_API.G_MISS_NUM;
6684: END IF;
6685:
6686: IF p_x_line_rec.Minisite_id IS NULL THEN
6687: p_x_line_rec.Minisite_id := FND_API.G_MISS_NUM;
6688: END IF;
6689:
6690: IF p_x_line_rec.End_customer_id IS NULL THEN
6691: p_x_line_rec.End_customer_id := FND_API.G_MISS_NUM;
6687: p_x_line_rec.Minisite_id := FND_API.G_MISS_NUM;
6688: END IF;
6689:
6690: IF p_x_line_rec.End_customer_id IS NULL THEN
6691: p_x_line_rec.End_customer_id := FND_API.G_MISS_NUM;
6692: END IF;
6693:
6694: IF p_x_line_rec.End_customer_contact_id IS NULL THEN
6695: p_x_line_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
6691: p_x_line_rec.End_customer_id := FND_API.G_MISS_NUM;
6692: END IF;
6693:
6694: IF p_x_line_rec.End_customer_contact_id IS NULL THEN
6695: p_x_line_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
6696: END IF;
6697:
6698: IF p_x_line_rec.End_customer_site_use_id IS NULL THEN
6699: p_x_line_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
6695: p_x_line_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
6696: END IF;
6697:
6698: IF p_x_line_rec.End_customer_site_use_id IS NULL THEN
6699: p_x_line_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
6700: END IF;
6701:
6702: IF p_x_line_rec.ib_owner IS NULL THEN
6703: p_x_line_rec.ib_owner := FND_API.G_MISS_CHAR;
6699: p_x_line_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
6700: END IF;
6701:
6702: IF p_x_line_rec.ib_owner IS NULL THEN
6703: p_x_line_rec.ib_owner := FND_API.G_MISS_CHAR;
6704: END IF;
6705:
6706: IF p_x_line_rec.ib_installed_at_location IS NULL THEN
6707: p_x_line_rec.ib_installed_at_location := FND_API.G_MISS_CHAR;
6703: p_x_line_rec.ib_owner := FND_API.G_MISS_CHAR;
6704: END IF;
6705:
6706: IF p_x_line_rec.ib_installed_at_location IS NULL THEN
6707: p_x_line_rec.ib_installed_at_location := FND_API.G_MISS_CHAR;
6708: END IF;
6709:
6710: IF p_x_line_rec.ib_current_location IS NULL THEN
6711: p_x_line_rec.ib_current_location := FND_API.G_MISS_CHAR;
6707: p_x_line_rec.ib_installed_at_location := FND_API.G_MISS_CHAR;
6708: END IF;
6709:
6710: IF p_x_line_rec.ib_current_location IS NULL THEN
6711: p_x_line_rec.ib_current_location := FND_API.G_MISS_CHAR;
6712: END IF;
6713:
6714: IF p_x_line_rec.retrobill_request_id IS NULL THEN
6715: p_x_line_rec.retrobill_request_id := FND_API.G_MISS_NUM;
6711: p_x_line_rec.ib_current_location := FND_API.G_MISS_CHAR;
6712: END IF;
6713:
6714: IF p_x_line_rec.retrobill_request_id IS NULL THEN
6715: p_x_line_rec.retrobill_request_id := FND_API.G_MISS_NUM;
6716: END IF;
6717:
6718: IF p_x_line_rec.firm_demand_flag IS NULL THEN
6719: p_x_line_rec.firm_demand_flag := FND_API.G_MISS_CHAR;
6715: p_x_line_rec.retrobill_request_id := FND_API.G_MISS_NUM;
6716: END IF;
6717:
6718: IF p_x_line_rec.firm_demand_flag IS NULL THEN
6719: p_x_line_rec.firm_demand_flag := FND_API.G_MISS_CHAR;
6720: END IF;
6721:
6722: IF p_x_line_rec.order_firmed_date IS NULL THEN
6723: p_x_line_rec.order_firmed_date := FND_API.G_MISS_DATE;
6719: p_x_line_rec.firm_demand_flag := FND_API.G_MISS_CHAR;
6720: END IF;
6721:
6722: IF p_x_line_rec.order_firmed_date IS NULL THEN
6723: p_x_line_rec.order_firmed_date := FND_API.G_MISS_DATE;
6724: END IF;
6725:
6726: IF p_x_line_rec.actual_fulfillment_date IS NULL THEN
6727: p_x_line_rec.actual_fulfillment_date := FND_API.G_MISS_DATE;
6723: p_x_line_rec.order_firmed_date := FND_API.G_MISS_DATE;
6724: END IF;
6725:
6726: IF p_x_line_rec.actual_fulfillment_date IS NULL THEN
6727: p_x_line_rec.actual_fulfillment_date := FND_API.G_MISS_DATE;
6728: END IF;
6729:
6730: oe_debug_pub.add('Exiting CONVERT_LINE_NULL_TO_MISS', 1);
6731: EXCEPTION
6730: oe_debug_pub.add('Exiting CONVERT_LINE_NULL_TO_MISS', 1);
6731: EXCEPTION
6732: WHEN OTHERS THEN
6733: oe_debug_pub.add('In Others CONVERT_LINE_NULL_TO_MISS', 1);
6734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6735: END Convert_Line_null_to_miss;
6736:
6737: PROCEDURE Convert_hdr_null_to_miss
6738: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type)
6740: BEGIN
6741: oe_debug_pub.add('Entering CONVERT_HDR_NULL_TO_MISS', 1);
6742:
6743: IF p_x_header_rec.accounting_rule_id IS NULL THEN
6744: p_x_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
6745: END IF;
6746:
6747: IF p_x_header_rec.accounting_rule_duration IS NULL THEN
6748: p_x_header_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
6744: p_x_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
6745: END IF;
6746:
6747: IF p_x_header_rec.accounting_rule_duration IS NULL THEN
6748: p_x_header_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
6749: END IF;
6750:
6751: IF p_x_header_rec.agreement_id IS NULL THEN
6752: p_x_header_rec.agreement_id := FND_API.G_MISS_NUM;
6748: p_x_header_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
6749: END IF;
6750:
6751: IF p_x_header_rec.agreement_id IS NULL THEN
6752: p_x_header_rec.agreement_id := FND_API.G_MISS_NUM;
6753: END IF;
6754:
6755: IF p_x_header_rec.blanket_number IS NULL THEN
6756: p_x_header_rec.blanket_number := FND_API.G_MISS_NUM;
6752: p_x_header_rec.agreement_id := FND_API.G_MISS_NUM;
6753: END IF;
6754:
6755: IF p_x_header_rec.blanket_number IS NULL THEN
6756: p_x_header_rec.blanket_number := FND_API.G_MISS_NUM;
6757: END IF;
6758:
6759: IF p_x_header_rec.booked_flag IS NULL THEN
6760: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
6756: p_x_header_rec.blanket_number := FND_API.G_MISS_NUM;
6757: END IF;
6758:
6759: IF p_x_header_rec.booked_flag IS NULL THEN
6760: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
6761: ELSIF p_x_header_rec.booked_flag IS not null then
6762: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
6763: END IF;
6764:
6758:
6759: IF p_x_header_rec.booked_flag IS NULL THEN
6760: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
6761: ELSIF p_x_header_rec.booked_flag IS not null then
6762: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
6763: END IF;
6764:
6765: IF p_x_header_rec.upgraded_flag IS NULL THEN
6766: p_x_header_rec.upgraded_flag := FND_API.G_MISS_CHAR;
6762: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
6763: END IF;
6764:
6765: IF p_x_header_rec.upgraded_flag IS NULL THEN
6766: p_x_header_rec.upgraded_flag := FND_API.G_MISS_CHAR;
6767: END IF;
6768:
6769: IF p_x_header_rec.booked_date IS NULL THEN
6770: p_x_header_rec.booked_date := FND_API.G_MISS_DATE;
6766: p_x_header_rec.upgraded_flag := FND_API.G_MISS_CHAR;
6767: END IF;
6768:
6769: IF p_x_header_rec.booked_date IS NULL THEN
6770: p_x_header_rec.booked_date := FND_API.G_MISS_DATE;
6771: END IF;
6772:
6773: IF p_x_header_rec.cancelled_flag IS NULL THEN
6774: p_x_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
6770: p_x_header_rec.booked_date := FND_API.G_MISS_DATE;
6771: END IF;
6772:
6773: IF p_x_header_rec.cancelled_flag IS NULL THEN
6774: p_x_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
6775: END IF;
6776:
6777: IF p_x_header_rec.attribute1 IS NULL THEN
6778: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
6774: p_x_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
6775: END IF;
6776:
6777: IF p_x_header_rec.attribute1 IS NULL THEN
6778: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
6779: END IF;
6780:
6781: IF p_x_header_rec.attribute10 IS NULL THEN
6782: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
6778: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
6779: END IF;
6780:
6781: IF p_x_header_rec.attribute10 IS NULL THEN
6782: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
6783: END IF;
6784:
6785: IF p_x_header_rec.attribute11 IS NULL THEN
6786: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
6782: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
6783: END IF;
6784:
6785: IF p_x_header_rec.attribute11 IS NULL THEN
6786: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
6787: END IF;
6788:
6789: IF p_x_header_rec.attribute12 IS NULL THEN
6790: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
6786: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
6787: END IF;
6788:
6789: IF p_x_header_rec.attribute12 IS NULL THEN
6790: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
6791: END IF;
6792:
6793: IF p_x_header_rec.attribute13 IS NULL THEN
6794: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
6790: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
6791: END IF;
6792:
6793: IF p_x_header_rec.attribute13 IS NULL THEN
6794: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
6795: END IF;
6796:
6797: IF p_x_header_rec.attribute14 IS NULL THEN
6798: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
6794: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
6795: END IF;
6796:
6797: IF p_x_header_rec.attribute14 IS NULL THEN
6798: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
6799: END IF;
6800:
6801: IF p_x_header_rec.attribute15 IS NULL THEN
6802: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
6798: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
6799: END IF;
6800:
6801: IF p_x_header_rec.attribute15 IS NULL THEN
6802: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
6803: END IF;
6804:
6805: IF p_x_header_rec.attribute16 IS NULL THEN --For bug 2184255
6806: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR;
6802: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
6803: END IF;
6804:
6805: IF p_x_header_rec.attribute16 IS NULL THEN --For bug 2184255
6806: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR;
6807: END IF;
6808:
6809: IF p_x_header_rec.attribute17 IS NULL THEN
6810: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
6806: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR;
6807: END IF;
6808:
6809: IF p_x_header_rec.attribute17 IS NULL THEN
6810: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
6811: END IF;
6812:
6813: IF p_x_header_rec.attribute18 IS NULL THEN
6814: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
6810: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
6811: END IF;
6812:
6813: IF p_x_header_rec.attribute18 IS NULL THEN
6814: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
6815: END IF;
6816:
6817: IF p_x_header_rec.attribute19 IS NULL THEN
6818: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
6814: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
6815: END IF;
6816:
6817: IF p_x_header_rec.attribute19 IS NULL THEN
6818: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
6819: END IF;
6820:
6821: IF p_x_header_rec.attribute2 IS NULL THEN
6822: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
6818: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
6819: END IF;
6820:
6821: IF p_x_header_rec.attribute2 IS NULL THEN
6822: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
6823: END IF;
6824:
6825: IF p_x_header_rec.attribute20 IS NULL THEN --For bug 2184255
6826: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
6822: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
6823: END IF;
6824:
6825: IF p_x_header_rec.attribute20 IS NULL THEN --For bug 2184255
6826: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
6827: END IF;
6828:
6829: IF p_x_header_rec.attribute3 IS NULL THEN
6830: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
6826: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
6827: END IF;
6828:
6829: IF p_x_header_rec.attribute3 IS NULL THEN
6830: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
6831: END IF;
6832:
6833: IF p_x_header_rec.attribute4 IS NULL THEN
6834: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
6830: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
6831: END IF;
6832:
6833: IF p_x_header_rec.attribute4 IS NULL THEN
6834: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
6835: END IF;
6836:
6837: IF p_x_header_rec.attribute5 IS NULL THEN
6838: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
6834: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
6835: END IF;
6836:
6837: IF p_x_header_rec.attribute5 IS NULL THEN
6838: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
6839: END IF;
6840:
6841: IF p_x_header_rec.attribute6 IS NULL THEN
6842: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
6838: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
6839: END IF;
6840:
6841: IF p_x_header_rec.attribute6 IS NULL THEN
6842: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
6843: END IF;
6844:
6845: IF p_x_header_rec.attribute7 IS NULL THEN
6846: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
6842: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
6843: END IF;
6844:
6845: IF p_x_header_rec.attribute7 IS NULL THEN
6846: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
6847: END IF;
6848:
6849: IF p_x_header_rec.attribute8 IS NULL THEN
6850: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
6846: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
6847: END IF;
6848:
6849: IF p_x_header_rec.attribute8 IS NULL THEN
6850: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
6851: END IF;
6852:
6853: IF p_x_header_rec.attribute9 IS NULL THEN
6854: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
6850: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
6851: END IF;
6852:
6853: IF p_x_header_rec.attribute9 IS NULL THEN
6854: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
6855: END IF;
6856:
6857: IF p_x_header_rec.context IS NULL THEN
6858: p_x_header_rec.context := FND_API.G_MISS_CHAR;
6854: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
6855: END IF;
6856:
6857: IF p_x_header_rec.context IS NULL THEN
6858: p_x_header_rec.context := FND_API.G_MISS_CHAR;
6859: END IF;
6860:
6861: IF p_x_header_rec.conversion_rate IS NULL THEN
6862: p_x_header_rec.conversion_rate := FND_API.G_MISS_NUM;
6858: p_x_header_rec.context := FND_API.G_MISS_CHAR;
6859: END IF;
6860:
6861: IF p_x_header_rec.conversion_rate IS NULL THEN
6862: p_x_header_rec.conversion_rate := FND_API.G_MISS_NUM;
6863: END IF;
6864:
6865: IF p_x_header_rec.conversion_rate_date IS NULL THEN
6866: p_x_header_rec.conversion_rate_date := FND_API.G_MISS_DATE;
6862: p_x_header_rec.conversion_rate := FND_API.G_MISS_NUM;
6863: END IF;
6864:
6865: IF p_x_header_rec.conversion_rate_date IS NULL THEN
6866: p_x_header_rec.conversion_rate_date := FND_API.G_MISS_DATE;
6867: END IF;
6868:
6869: IF p_x_header_rec.conversion_type_code IS NULL THEN
6870: p_x_header_rec.conversion_type_code := FND_API.G_MISS_CHAR;
6866: p_x_header_rec.conversion_rate_date := FND_API.G_MISS_DATE;
6867: END IF;
6868:
6869: IF p_x_header_rec.conversion_type_code IS NULL THEN
6870: p_x_header_rec.conversion_type_code := FND_API.G_MISS_CHAR;
6871: END IF;
6872:
6873: IF p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE IS NULL THEN
6874: p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := FND_API.G_MISS_CHAR;
6870: p_x_header_rec.conversion_type_code := FND_API.G_MISS_CHAR;
6871: END IF;
6872:
6873: IF p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE IS NULL THEN
6874: p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := FND_API.G_MISS_CHAR;
6875: END IF;
6876:
6877: IF p_x_header_rec.created_by IS NULL THEN
6878: p_x_header_rec.created_by := FND_API.G_MISS_NUM;
6874: p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := FND_API.G_MISS_CHAR;
6875: END IF;
6876:
6877: IF p_x_header_rec.created_by IS NULL THEN
6878: p_x_header_rec.created_by := FND_API.G_MISS_NUM;
6879: END IF;
6880:
6881: IF p_x_header_rec.creation_date IS NULL THEN
6882: p_x_header_rec.creation_date := FND_API.G_MISS_DATE;
6878: p_x_header_rec.created_by := FND_API.G_MISS_NUM;
6879: END IF;
6880:
6881: IF p_x_header_rec.creation_date IS NULL THEN
6882: p_x_header_rec.creation_date := FND_API.G_MISS_DATE;
6883: END IF;
6884:
6885: IF p_x_header_rec.cust_po_number IS NULL THEN
6886: p_x_header_rec.cust_po_number := FND_API.G_MISS_CHAR;
6882: p_x_header_rec.creation_date := FND_API.G_MISS_DATE;
6883: END IF;
6884:
6885: IF p_x_header_rec.cust_po_number IS NULL THEN
6886: p_x_header_rec.cust_po_number := FND_API.G_MISS_CHAR;
6887: END IF;
6888:
6889: IF p_x_header_rec.default_fulfillment_set IS NULL THEN
6890: p_x_header_rec.default_fulfillment_set := FND_API.G_MISS_CHAR;
6886: p_x_header_rec.cust_po_number := FND_API.G_MISS_CHAR;
6887: END IF;
6888:
6889: IF p_x_header_rec.default_fulfillment_set IS NULL THEN
6890: p_x_header_rec.default_fulfillment_set := FND_API.G_MISS_CHAR;
6891: END IF;
6892:
6893: IF p_x_header_rec.deliver_to_contact_id IS NULL THEN
6894: p_x_header_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
6890: p_x_header_rec.default_fulfillment_set := FND_API.G_MISS_CHAR;
6891: END IF;
6892:
6893: IF p_x_header_rec.deliver_to_contact_id IS NULL THEN
6894: p_x_header_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
6895: END IF;
6896:
6897: IF p_x_header_rec.deliver_to_org_id IS NULL THEN
6898: p_x_header_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
6894: p_x_header_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
6895: END IF;
6896:
6897: IF p_x_header_rec.deliver_to_org_id IS NULL THEN
6898: p_x_header_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
6899: END IF;
6900:
6901: IF p_x_header_rec.demand_class_code IS NULL THEN
6902: p_x_header_rec.demand_class_code := FND_API.G_MISS_CHAR;
6898: p_x_header_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
6899: END IF;
6900:
6901: IF p_x_header_rec.demand_class_code IS NULL THEN
6902: p_x_header_rec.demand_class_code := FND_API.G_MISS_CHAR;
6903: END IF;
6904:
6905: IF p_x_header_rec.expiration_date IS NULL THEN
6906: p_x_header_rec.expiration_date := FND_API.G_MISS_DATE;
6902: p_x_header_rec.demand_class_code := FND_API.G_MISS_CHAR;
6903: END IF;
6904:
6905: IF p_x_header_rec.expiration_date IS NULL THEN
6906: p_x_header_rec.expiration_date := FND_API.G_MISS_DATE;
6907: END IF;
6908:
6909: IF p_x_header_rec.earliest_schedule_limit IS NULL THEN
6910: p_x_header_rec.earliest_schedule_limit := FND_API.G_MISS_NUM;
6906: p_x_header_rec.expiration_date := FND_API.G_MISS_DATE;
6907: END IF;
6908:
6909: IF p_x_header_rec.earliest_schedule_limit IS NULL THEN
6910: p_x_header_rec.earliest_schedule_limit := FND_API.G_MISS_NUM;
6911: END IF;
6912:
6913: IF p_x_header_rec.fob_point_code IS NULL THEN
6914: p_x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
6910: p_x_header_rec.earliest_schedule_limit := FND_API.G_MISS_NUM;
6911: END IF;
6912:
6913: IF p_x_header_rec.fob_point_code IS NULL THEN
6914: p_x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
6915: END IF;
6916:
6917: IF p_x_header_rec.freight_carrier_code IS NULL THEN
6918: p_x_header_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
6914: p_x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
6915: END IF;
6916:
6917: IF p_x_header_rec.freight_carrier_code IS NULL THEN
6918: p_x_header_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
6919: END IF;
6920:
6921: IF p_x_header_rec.freight_terms_code IS NULL THEN
6922: p_x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
6918: p_x_header_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
6919: END IF;
6920:
6921: IF p_x_header_rec.freight_terms_code IS NULL THEN
6922: p_x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
6923: END IF;
6924:
6925: IF p_x_header_rec.fulfillment_set_name IS NULL THEN
6926: p_x_header_rec.fulfillment_set_name := FND_API.G_MISS_CHAR;
6922: p_x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
6923: END IF;
6924:
6925: IF p_x_header_rec.fulfillment_set_name IS NULL THEN
6926: p_x_header_rec.fulfillment_set_name := FND_API.G_MISS_CHAR;
6927: END IF;
6928:
6929: IF p_x_header_rec.global_attribute1 IS NULL THEN
6930: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
6926: p_x_header_rec.fulfillment_set_name := FND_API.G_MISS_CHAR;
6927: END IF;
6928:
6929: IF p_x_header_rec.global_attribute1 IS NULL THEN
6930: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
6931: END IF;
6932:
6933: IF p_x_header_rec.global_attribute10 IS NULL THEN
6934: p_x_header_rec.global_attribute10 := FND_API.G_MISS_CHAR;
6930: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
6931: END IF;
6932:
6933: IF p_x_header_rec.global_attribute10 IS NULL THEN
6934: p_x_header_rec.global_attribute10 := FND_API.G_MISS_CHAR;
6935: END IF;
6936:
6937: IF p_x_header_rec.global_attribute11 IS NULL THEN
6938: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
6934: p_x_header_rec.global_attribute10 := FND_API.G_MISS_CHAR;
6935: END IF;
6936:
6937: IF p_x_header_rec.global_attribute11 IS NULL THEN
6938: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
6939: END IF;
6940:
6941: IF p_x_header_rec.global_attribute12 IS NULL THEN
6942: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
6938: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
6939: END IF;
6940:
6941: IF p_x_header_rec.global_attribute12 IS NULL THEN
6942: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
6943: END IF;
6944:
6945: IF p_x_header_rec.global_attribute13 IS NULL THEN
6946: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
6942: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
6943: END IF;
6944:
6945: IF p_x_header_rec.global_attribute13 IS NULL THEN
6946: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
6947: END IF;
6948:
6949: IF p_x_header_rec.global_attribute14 IS NULL THEN
6950: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
6946: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
6947: END IF;
6948:
6949: IF p_x_header_rec.global_attribute14 IS NULL THEN
6950: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
6951: END IF;
6952:
6953: IF p_x_header_rec.global_attribute15 IS NULL THEN
6954: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
6950: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
6951: END IF;
6952:
6953: IF p_x_header_rec.global_attribute15 IS NULL THEN
6954: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
6955: END IF;
6956:
6957: IF p_x_header_rec.global_attribute16 IS NULL THEN
6958: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
6954: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
6955: END IF;
6956:
6957: IF p_x_header_rec.global_attribute16 IS NULL THEN
6958: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
6959: END IF;
6960:
6961: IF p_x_header_rec.global_attribute17 IS NULL THEN
6962: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
6958: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
6959: END IF;
6960:
6961: IF p_x_header_rec.global_attribute17 IS NULL THEN
6962: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
6963: END IF;
6964:
6965: IF p_x_header_rec.global_attribute18 IS NULL THEN
6966: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
6962: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
6963: END IF;
6964:
6965: IF p_x_header_rec.global_attribute18 IS NULL THEN
6966: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
6967: END IF;
6968:
6969: IF p_x_header_rec.global_attribute19 IS NULL THEN
6970: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
6966: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
6967: END IF;
6968:
6969: IF p_x_header_rec.global_attribute19 IS NULL THEN
6970: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
6971: END IF;
6972:
6973: IF p_x_header_rec.global_attribute2 IS NULL THEN
6974: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
6970: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
6971: END IF;
6972:
6973: IF p_x_header_rec.global_attribute2 IS NULL THEN
6974: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
6975: END IF;
6976:
6977: IF p_x_header_rec.global_attribute20 IS NULL THEN
6978: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
6974: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
6975: END IF;
6976:
6977: IF p_x_header_rec.global_attribute20 IS NULL THEN
6978: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
6979: END IF;
6980:
6981: IF p_x_header_rec.global_attribute3 IS NULL THEN
6982: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
6978: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
6979: END IF;
6980:
6981: IF p_x_header_rec.global_attribute3 IS NULL THEN
6982: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
6983: END IF;
6984:
6985: IF p_x_header_rec.global_attribute4 IS NULL THEN
6986: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
6982: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
6983: END IF;
6984:
6985: IF p_x_header_rec.global_attribute4 IS NULL THEN
6986: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
6987: END IF;
6988:
6989: IF p_x_header_rec.global_attribute5 IS NULL THEN
6990: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
6986: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
6987: END IF;
6988:
6989: IF p_x_header_rec.global_attribute5 IS NULL THEN
6990: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
6991: END IF;
6992:
6993: IF p_x_header_rec.global_attribute6 IS NULL THEN
6994: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
6990: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
6991: END IF;
6992:
6993: IF p_x_header_rec.global_attribute6 IS NULL THEN
6994: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
6995: END IF;
6996:
6997: IF p_x_header_rec.global_attribute7 IS NULL THEN
6998: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
6994: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
6995: END IF;
6996:
6997: IF p_x_header_rec.global_attribute7 IS NULL THEN
6998: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
6999: END IF;
7000:
7001: IF p_x_header_rec.global_attribute8 IS NULL THEN
7002: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
6998: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
6999: END IF;
7000:
7001: IF p_x_header_rec.global_attribute8 IS NULL THEN
7002: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
7003: END IF;
7004:
7005: IF p_x_header_rec.global_attribute9 IS NULL THEN
7006: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
7002: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
7003: END IF;
7004:
7005: IF p_x_header_rec.global_attribute9 IS NULL THEN
7006: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
7007: END IF;
7008:
7009: IF p_x_header_rec.global_attribute_category IS NULL THEN
7010: p_x_header_rec.global_attribute_category := FND_API.G_MISS_CHAR;
7006: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
7007: END IF;
7008:
7009: IF p_x_header_rec.global_attribute_category IS NULL THEN
7010: p_x_header_rec.global_attribute_category := FND_API.G_MISS_CHAR;
7011: END IF;
7012:
7013: IF p_x_header_rec.header_id IS NULL THEN
7014: p_x_header_rec.header_id := FND_API.G_MISS_NUM;
7010: p_x_header_rec.global_attribute_category := FND_API.G_MISS_CHAR;
7011: END IF;
7012:
7013: IF p_x_header_rec.header_id IS NULL THEN
7014: p_x_header_rec.header_id := FND_API.G_MISS_NUM;
7015: END IF;
7016:
7017: IF p_x_header_rec.invoice_to_contact_id IS NULL THEN
7018: p_x_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
7014: p_x_header_rec.header_id := FND_API.G_MISS_NUM;
7015: END IF;
7016:
7017: IF p_x_header_rec.invoice_to_contact_id IS NULL THEN
7018: p_x_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
7019: END IF;
7020:
7021: IF p_x_header_rec.invoice_to_org_id IS NULL THEN
7022: p_x_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
7018: p_x_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
7019: END IF;
7020:
7021: IF p_x_header_rec.invoice_to_org_id IS NULL THEN
7022: p_x_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
7023: END IF;
7024:
7025: IF p_x_header_rec.invoicing_rule_id IS NULL THEN
7026: p_x_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
7022: p_x_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
7023: END IF;
7024:
7025: IF p_x_header_rec.invoicing_rule_id IS NULL THEN
7026: p_x_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
7027: END IF;
7028:
7029: IF p_x_header_rec.last_updated_by IS NULL THEN
7030: p_x_header_rec.last_updated_by := FND_API.G_MISS_NUM;
7026: p_x_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
7027: END IF;
7028:
7029: IF p_x_header_rec.last_updated_by IS NULL THEN
7030: p_x_header_rec.last_updated_by := FND_API.G_MISS_NUM;
7031: END IF;
7032:
7033: IF p_x_header_rec.last_update_date IS NULL THEN
7034: p_x_header_rec.last_update_date := FND_API.G_MISS_DATE;
7030: p_x_header_rec.last_updated_by := FND_API.G_MISS_NUM;
7031: END IF;
7032:
7033: IF p_x_header_rec.last_update_date IS NULL THEN
7034: p_x_header_rec.last_update_date := FND_API.G_MISS_DATE;
7035: END IF;
7036:
7037: IF p_x_header_rec.last_update_login IS NULL THEN
7038: p_x_header_rec.last_update_login := FND_API.G_MISS_NUM;
7034: p_x_header_rec.last_update_date := FND_API.G_MISS_DATE;
7035: END IF;
7036:
7037: IF p_x_header_rec.last_update_login IS NULL THEN
7038: p_x_header_rec.last_update_login := FND_API.G_MISS_NUM;
7039: END IF;
7040:
7041:
7042: IF p_x_header_rec.latest_schedule_limit IS NULL THEN
7039: END IF;
7040:
7041:
7042: IF p_x_header_rec.latest_schedule_limit IS NULL THEN
7043: p_x_header_rec.latest_schedule_limit := FND_API.G_MISS_NUM;
7044: END IF;
7045:
7046: IF p_x_header_rec.line_set_name IS NULL THEN
7047: p_x_header_rec.line_set_name := FND_API.G_MISS_CHAR;
7043: p_x_header_rec.latest_schedule_limit := FND_API.G_MISS_NUM;
7044: END IF;
7045:
7046: IF p_x_header_rec.line_set_name IS NULL THEN
7047: p_x_header_rec.line_set_name := FND_API.G_MISS_CHAR;
7048: END IF;
7049:
7050: IF p_x_header_rec.open_flag IS NULL THEN
7051: p_x_header_rec.open_flag := FND_API.G_MISS_CHAR;
7047: p_x_header_rec.line_set_name := FND_API.G_MISS_CHAR;
7048: END IF;
7049:
7050: IF p_x_header_rec.open_flag IS NULL THEN
7051: p_x_header_rec.open_flag := FND_API.G_MISS_CHAR;
7052: END IF;
7053:
7054: IF p_x_header_rec.ordered_date IS NULL THEN
7055: p_x_header_rec.ordered_date := FND_API.G_MISS_DATE;
7051: p_x_header_rec.open_flag := FND_API.G_MISS_CHAR;
7052: END IF;
7053:
7054: IF p_x_header_rec.ordered_date IS NULL THEN
7055: p_x_header_rec.ordered_date := FND_API.G_MISS_DATE;
7056: END IF;
7057:
7058: IF p_x_header_rec.order_date_type_code IS NULL THEN
7059: p_x_header_rec.order_date_type_code := FND_API.G_MISS_CHAR;
7055: p_x_header_rec.ordered_date := FND_API.G_MISS_DATE;
7056: END IF;
7057:
7058: IF p_x_header_rec.order_date_type_code IS NULL THEN
7059: p_x_header_rec.order_date_type_code := FND_API.G_MISS_CHAR;
7060: END IF;
7061:
7062: IF p_x_header_rec.order_number IS NULL THEN
7063: p_x_header_rec.order_number := FND_API.G_MISS_NUM;
7059: p_x_header_rec.order_date_type_code := FND_API.G_MISS_CHAR;
7060: END IF;
7061:
7062: IF p_x_header_rec.order_number IS NULL THEN
7063: p_x_header_rec.order_number := FND_API.G_MISS_NUM;
7064: END IF;
7065:
7066: IF p_x_header_rec.order_source_id IS NULL THEN
7067: p_x_header_rec.order_source_id := FND_API.G_MISS_NUM;
7063: p_x_header_rec.order_number := FND_API.G_MISS_NUM;
7064: END IF;
7065:
7066: IF p_x_header_rec.order_source_id IS NULL THEN
7067: p_x_header_rec.order_source_id := FND_API.G_MISS_NUM;
7068: END IF;
7069:
7070: IF p_x_header_rec.order_type_id IS NULL THEN
7071: p_x_header_rec.order_type_id := FND_API.G_MISS_NUM;
7067: p_x_header_rec.order_source_id := FND_API.G_MISS_NUM;
7068: END IF;
7069:
7070: IF p_x_header_rec.order_type_id IS NULL THEN
7071: p_x_header_rec.order_type_id := FND_API.G_MISS_NUM;
7072: END IF;
7073: IF p_x_header_rec.order_category_code IS NULL THEN
7074: p_x_header_rec.order_category_code := FND_API.G_MISS_CHAR;
7075: END IF;
7070: IF p_x_header_rec.order_type_id IS NULL THEN
7071: p_x_header_rec.order_type_id := FND_API.G_MISS_NUM;
7072: END IF;
7073: IF p_x_header_rec.order_category_code IS NULL THEN
7074: p_x_header_rec.order_category_code := FND_API.G_MISS_CHAR;
7075: END IF;
7076:
7077: IF p_x_header_rec.org_id IS NULL THEN
7078: p_x_header_rec.org_id := FND_API.G_MISS_NUM;
7074: p_x_header_rec.order_category_code := FND_API.G_MISS_CHAR;
7075: END IF;
7076:
7077: IF p_x_header_rec.org_id IS NULL THEN
7078: p_x_header_rec.org_id := FND_API.G_MISS_NUM;
7079: END IF;
7080:
7081: IF p_x_header_rec.orig_sys_document_ref IS NULL THEN
7082: p_x_header_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
7078: p_x_header_rec.org_id := FND_API.G_MISS_NUM;
7079: END IF;
7080:
7081: IF p_x_header_rec.orig_sys_document_ref IS NULL THEN
7082: p_x_header_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
7083: END IF;
7084:
7085: IF p_x_header_rec.partial_shipments_allowed IS NULL THEN
7086: p_x_header_rec.partial_shipments_allowed := FND_API.G_MISS_CHAR;
7082: p_x_header_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
7083: END IF;
7084:
7085: IF p_x_header_rec.partial_shipments_allowed IS NULL THEN
7086: p_x_header_rec.partial_shipments_allowed := FND_API.G_MISS_CHAR;
7087: END IF;
7088:
7089: IF p_x_header_rec.payment_term_id IS NULL THEN
7090: p_x_header_rec.payment_term_id := FND_API.G_MISS_NUM;
7086: p_x_header_rec.partial_shipments_allowed := FND_API.G_MISS_CHAR;
7087: END IF;
7088:
7089: IF p_x_header_rec.payment_term_id IS NULL THEN
7090: p_x_header_rec.payment_term_id := FND_API.G_MISS_NUM;
7091: END IF;
7092:
7093: IF p_x_header_rec.price_list_id IS NULL THEN
7094: p_x_header_rec.price_list_id := FND_API.G_MISS_NUM;
7090: p_x_header_rec.payment_term_id := FND_API.G_MISS_NUM;
7091: END IF;
7092:
7093: IF p_x_header_rec.price_list_id IS NULL THEN
7094: p_x_header_rec.price_list_id := FND_API.G_MISS_NUM;
7095: END IF;
7096:
7097: IF p_x_header_rec.price_request_code IS NULL THEN -- PROMOTIONS SEP/01
7098: p_x_header_rec.price_request_code := FND_API.G_MISS_CHAR;
7094: p_x_header_rec.price_list_id := FND_API.G_MISS_NUM;
7095: END IF;
7096:
7097: IF p_x_header_rec.price_request_code IS NULL THEN -- PROMOTIONS SEP/01
7098: p_x_header_rec.price_request_code := FND_API.G_MISS_CHAR;
7099: END IF;
7100:
7101: IF p_x_header_rec.pricing_date IS NULL THEN
7102: p_x_header_rec.pricing_date := FND_API.G_MISS_DATE;
7098: p_x_header_rec.price_request_code := FND_API.G_MISS_CHAR;
7099: END IF;
7100:
7101: IF p_x_header_rec.pricing_date IS NULL THEN
7102: p_x_header_rec.pricing_date := FND_API.G_MISS_DATE;
7103: END IF;
7104:
7105: IF p_x_header_rec.program_application_id IS NULL THEN
7106: p_x_header_rec.program_application_id := FND_API.G_MISS_NUM;
7102: p_x_header_rec.pricing_date := FND_API.G_MISS_DATE;
7103: END IF;
7104:
7105: IF p_x_header_rec.program_application_id IS NULL THEN
7106: p_x_header_rec.program_application_id := FND_API.G_MISS_NUM;
7107: END IF;
7108:
7109: IF p_x_header_rec.program_id IS NULL THEN
7110: p_x_header_rec.program_id := FND_API.G_MISS_NUM;
7106: p_x_header_rec.program_application_id := FND_API.G_MISS_NUM;
7107: END IF;
7108:
7109: IF p_x_header_rec.program_id IS NULL THEN
7110: p_x_header_rec.program_id := FND_API.G_MISS_NUM;
7111: END IF;
7112:
7113: IF p_x_header_rec.program_update_date IS NULL THEN
7114: p_x_header_rec.program_update_date := FND_API.G_MISS_DATE;
7110: p_x_header_rec.program_id := FND_API.G_MISS_NUM;
7111: END IF;
7112:
7113: IF p_x_header_rec.program_update_date IS NULL THEN
7114: p_x_header_rec.program_update_date := FND_API.G_MISS_DATE;
7115: END IF;
7116:
7117: IF p_x_header_rec.request_date IS NULL THEN
7118: p_x_header_rec.request_date := FND_API.G_MISS_DATE;
7114: p_x_header_rec.program_update_date := FND_API.G_MISS_DATE;
7115: END IF;
7116:
7117: IF p_x_header_rec.request_date IS NULL THEN
7118: p_x_header_rec.request_date := FND_API.G_MISS_DATE;
7119: END IF;
7120:
7121: IF p_x_header_rec.request_id IS NULL THEN
7122: p_x_header_rec.request_id := FND_API.G_MISS_NUM;
7118: p_x_header_rec.request_date := FND_API.G_MISS_DATE;
7119: END IF;
7120:
7121: IF p_x_header_rec.request_id IS NULL THEN
7122: p_x_header_rec.request_id := FND_API.G_MISS_NUM;
7123: END IF;
7124:
7125: IF p_x_header_rec.return_reason_code IS NULL THEN
7126: p_x_header_rec.return_reason_code := FND_API.G_MISS_CHAR;
7122: p_x_header_rec.request_id := FND_API.G_MISS_NUM;
7123: END IF;
7124:
7125: IF p_x_header_rec.return_reason_code IS NULL THEN
7126: p_x_header_rec.return_reason_code := FND_API.G_MISS_CHAR;
7127: END IF;
7128:
7129: IF p_x_header_rec.salesrep_id IS NULL THEN
7130: p_x_header_rec.salesrep_id := FND_API.G_MISS_NUM;
7126: p_x_header_rec.return_reason_code := FND_API.G_MISS_CHAR;
7127: END IF;
7128:
7129: IF p_x_header_rec.salesrep_id IS NULL THEN
7130: p_x_header_rec.salesrep_id := FND_API.G_MISS_NUM;
7131: END IF;
7132:
7133: IF p_x_header_rec.sales_channel_code IS NULL THEN
7134: p_x_header_rec.sales_channel_code := FND_API.G_MISS_CHAR;
7130: p_x_header_rec.salesrep_id := FND_API.G_MISS_NUM;
7131: END IF;
7132:
7133: IF p_x_header_rec.sales_channel_code IS NULL THEN
7134: p_x_header_rec.sales_channel_code := FND_API.G_MISS_CHAR;
7135: END IF;
7136:
7137: IF p_x_header_rec.shipment_priority_code IS NULL THEN
7138: p_x_header_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
7134: p_x_header_rec.sales_channel_code := FND_API.G_MISS_CHAR;
7135: END IF;
7136:
7137: IF p_x_header_rec.shipment_priority_code IS NULL THEN
7138: p_x_header_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
7139: END IF;
7140:
7141: IF p_x_header_rec.shipping_method_code IS NULL THEN
7142: p_x_header_rec.shipping_method_code := FND_API.G_MISS_CHAR;
7138: p_x_header_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
7139: END IF;
7140:
7141: IF p_x_header_rec.shipping_method_code IS NULL THEN
7142: p_x_header_rec.shipping_method_code := FND_API.G_MISS_CHAR;
7143: END IF;
7144:
7145: IF p_x_header_rec.ship_from_org_id IS NULL THEN
7146: p_x_header_rec.ship_from_org_id := FND_API.G_MISS_NUM;
7142: p_x_header_rec.shipping_method_code := FND_API.G_MISS_CHAR;
7143: END IF;
7144:
7145: IF p_x_header_rec.ship_from_org_id IS NULL THEN
7146: p_x_header_rec.ship_from_org_id := FND_API.G_MISS_NUM;
7147: END IF;
7148:
7149: IF p_x_header_rec.ship_tolerance_above IS NULL THEN
7150: p_x_header_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
7146: p_x_header_rec.ship_from_org_id := FND_API.G_MISS_NUM;
7147: END IF;
7148:
7149: IF p_x_header_rec.ship_tolerance_above IS NULL THEN
7150: p_x_header_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
7151: END IF;
7152:
7153: IF p_x_header_rec.ship_tolerance_below IS NULL THEN
7154: p_x_header_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
7150: p_x_header_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
7151: END IF;
7152:
7153: IF p_x_header_rec.ship_tolerance_below IS NULL THEN
7154: p_x_header_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
7155: END IF;
7156:
7157: IF p_x_header_rec.ship_to_contact_id IS NULL THEN
7158: p_x_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
7154: p_x_header_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
7155: END IF;
7156:
7157: IF p_x_header_rec.ship_to_contact_id IS NULL THEN
7158: p_x_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
7159: END IF;
7160:
7161: IF p_x_header_rec.ship_to_org_id IS NULL THEN
7162: p_x_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
7158: p_x_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
7159: END IF;
7160:
7161: IF p_x_header_rec.ship_to_org_id IS NULL THEN
7162: p_x_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
7163: END IF;
7164:
7165: IF p_x_header_rec.sold_from_org_id IS NULL THEN
7166: p_x_header_rec.sold_from_org_id := FND_API.G_MISS_NUM;
7162: p_x_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
7163: END IF;
7164:
7165: IF p_x_header_rec.sold_from_org_id IS NULL THEN
7166: p_x_header_rec.sold_from_org_id := FND_API.G_MISS_NUM;
7167: END IF;
7168:
7169: IF p_x_header_rec.sold_to_contact_id IS NULL THEN
7170: p_x_header_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
7166: p_x_header_rec.sold_from_org_id := FND_API.G_MISS_NUM;
7167: END IF;
7168:
7169: IF p_x_header_rec.sold_to_contact_id IS NULL THEN
7170: p_x_header_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
7171: END IF;
7172:
7173: -- p_x_header_rec.sold_to_org_id := 1006; -- ZB
7174: oe_debug_pub.add('Sold to is = ' || p_x_header_rec.sold_to_org_id);
7173: -- p_x_header_rec.sold_to_org_id := 1006; -- ZB
7174: oe_debug_pub.add('Sold to is = ' || p_x_header_rec.sold_to_org_id);
7175: IF p_x_header_rec.sold_to_org_id IS NULL THEN
7176: oe_debug_pub.add('Sold to is null');
7177: p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
7178: END IF;
7179:
7180: IF p_x_header_rec.sold_to_phone_id IS NULL THEN
7181: p_x_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
7177: p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
7178: END IF;
7179:
7180: IF p_x_header_rec.sold_to_phone_id IS NULL THEN
7181: p_x_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
7182: END IF;
7183:
7184: IF p_x_header_rec.source_document_id IS NULL THEN
7185: p_x_header_rec.source_document_id := FND_API.G_MISS_NUM;
7181: p_x_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
7182: END IF;
7183:
7184: IF p_x_header_rec.source_document_id IS NULL THEN
7185: p_x_header_rec.source_document_id := FND_API.G_MISS_NUM;
7186: END IF;
7187:
7188: IF p_x_header_rec.source_document_type_id IS NULL THEN
7189: p_x_header_rec.source_document_type_id := FND_API.G_MISS_NUM;
7185: p_x_header_rec.source_document_id := FND_API.G_MISS_NUM;
7186: END IF;
7187:
7188: IF p_x_header_rec.source_document_type_id IS NULL THEN
7189: p_x_header_rec.source_document_type_id := FND_API.G_MISS_NUM;
7190: END IF;
7191:
7192: IF p_x_header_rec.tax_exempt_flag IS NULL THEN
7193: p_x_header_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
7189: p_x_header_rec.source_document_type_id := FND_API.G_MISS_NUM;
7190: END IF;
7191:
7192: IF p_x_header_rec.tax_exempt_flag IS NULL THEN
7193: p_x_header_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
7194: END IF;
7195:
7196: IF p_x_header_rec.tax_exempt_number IS NULL THEN
7197: p_x_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
7193: p_x_header_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
7194: END IF;
7195:
7196: IF p_x_header_rec.tax_exempt_number IS NULL THEN
7197: p_x_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
7198: END IF;
7199:
7200: IF p_x_header_rec.tax_exempt_reason_code IS NULL THEN
7201: p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
7197: p_x_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
7198: END IF;
7199:
7200: IF p_x_header_rec.tax_exempt_reason_code IS NULL THEN
7201: p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
7202: END IF;
7203:
7204: IF p_x_header_rec.tax_point_code IS NULL THEN
7205: p_x_header_rec.tax_point_code := FND_API.G_MISS_CHAR;
7201: p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
7202: END IF;
7203:
7204: IF p_x_header_rec.tax_point_code IS NULL THEN
7205: p_x_header_rec.tax_point_code := FND_API.G_MISS_CHAR;
7206: END IF;
7207:
7208: IF p_x_header_rec.transactional_curr_code IS NULL THEN
7209: p_x_header_rec.transactional_curr_code := FND_API.G_MISS_CHAR;
7205: p_x_header_rec.tax_point_code := FND_API.G_MISS_CHAR;
7206: END IF;
7207:
7208: IF p_x_header_rec.transactional_curr_code IS NULL THEN
7209: p_x_header_rec.transactional_curr_code := FND_API.G_MISS_CHAR;
7210: END IF;
7211:
7212: IF p_x_header_rec.version_number IS NULL THEN
7213: p_x_header_rec.version_number := FND_API.G_MISS_NUM;
7209: p_x_header_rec.transactional_curr_code := FND_API.G_MISS_CHAR;
7210: END IF;
7211:
7212: IF p_x_header_rec.version_number IS NULL THEN
7213: p_x_header_rec.version_number := FND_API.G_MISS_NUM;
7214: END IF;
7215:
7216: IF p_x_header_rec.payment_type_code IS NULL THEN
7217: p_x_header_rec.payment_type_code := FND_API.G_MISS_CHAR;
7213: p_x_header_rec.version_number := FND_API.G_MISS_NUM;
7214: END IF;
7215:
7216: IF p_x_header_rec.payment_type_code IS NULL THEN
7217: p_x_header_rec.payment_type_code := FND_API.G_MISS_CHAR;
7218: END IF;
7219:
7220: IF p_x_header_rec.payment_amount IS NULL THEN
7221: p_x_header_rec.payment_amount := FND_API.G_MISS_NUM;
7217: p_x_header_rec.payment_type_code := FND_API.G_MISS_CHAR;
7218: END IF;
7219:
7220: IF p_x_header_rec.payment_amount IS NULL THEN
7221: p_x_header_rec.payment_amount := FND_API.G_MISS_NUM;
7222: END IF;
7223:
7224: IF p_x_header_rec.check_number IS NULL THEN
7225: p_x_header_rec.check_number := FND_API.G_MISS_CHAR;
7221: p_x_header_rec.payment_amount := FND_API.G_MISS_NUM;
7222: END IF;
7223:
7224: IF p_x_header_rec.check_number IS NULL THEN
7225: p_x_header_rec.check_number := FND_API.G_MISS_CHAR;
7226: END IF;
7227:
7228: IF p_x_header_rec.credit_card_code IS NULL THEN
7229: p_x_header_rec.credit_card_code := FND_API.G_MISS_CHAR;
7225: p_x_header_rec.check_number := FND_API.G_MISS_CHAR;
7226: END IF;
7227:
7228: IF p_x_header_rec.credit_card_code IS NULL THEN
7229: p_x_header_rec.credit_card_code := FND_API.G_MISS_CHAR;
7230: END IF;
7231:
7232: IF p_x_header_rec.credit_card_holder_name IS NULL THEN
7233: p_x_header_rec.credit_card_holder_name := FND_API.G_MISS_CHAR;
7229: p_x_header_rec.credit_card_code := FND_API.G_MISS_CHAR;
7230: END IF;
7231:
7232: IF p_x_header_rec.credit_card_holder_name IS NULL THEN
7233: p_x_header_rec.credit_card_holder_name := FND_API.G_MISS_CHAR;
7234: END IF;
7235:
7236: IF p_x_header_rec.credit_card_number IS NULL THEN
7237: p_x_header_rec.credit_card_number := FND_API.G_MISS_CHAR;
7233: p_x_header_rec.credit_card_holder_name := FND_API.G_MISS_CHAR;
7234: END IF;
7235:
7236: IF p_x_header_rec.credit_card_number IS NULL THEN
7237: p_x_header_rec.credit_card_number := FND_API.G_MISS_CHAR;
7238: END IF;
7239:
7240: IF p_x_header_rec.credit_card_expiration_date IS NULL THEN
7241: p_x_header_rec.credit_card_expiration_date := FND_API.G_MISS_DATE;
7237: p_x_header_rec.credit_card_number := FND_API.G_MISS_CHAR;
7238: END IF;
7239:
7240: IF p_x_header_rec.credit_card_expiration_date IS NULL THEN
7241: p_x_header_rec.credit_card_expiration_date := FND_API.G_MISS_DATE;
7242: END IF;
7243:
7244: IF p_x_header_rec.credit_card_approval_date IS NULL THEN
7245: p_x_header_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
7241: p_x_header_rec.credit_card_expiration_date := FND_API.G_MISS_DATE;
7242: END IF;
7243:
7244: IF p_x_header_rec.credit_card_approval_date IS NULL THEN
7245: p_x_header_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
7246: END IF;
7247:
7248: IF p_x_header_rec.credit_card_approval_code IS NULL THEN
7249: p_x_header_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
7245: p_x_header_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
7246: END IF;
7247:
7248: IF p_x_header_rec.credit_card_approval_code IS NULL THEN
7249: p_x_header_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
7250: END IF;
7251:
7252: IF p_x_header_rec.first_ack_code IS NULL THEN
7253: p_x_header_rec.first_ack_code := FND_API.G_MISS_CHAR;
7249: p_x_header_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
7250: END IF;
7251:
7252: IF p_x_header_rec.first_ack_code IS NULL THEN
7253: p_x_header_rec.first_ack_code := FND_API.G_MISS_CHAR;
7254: END IF;
7255:
7256: IF p_x_header_rec.first_ack_date IS NULL THEN
7257: p_x_header_rec.first_ack_date := FND_API.G_MISS_DATE;
7253: p_x_header_rec.first_ack_code := FND_API.G_MISS_CHAR;
7254: END IF;
7255:
7256: IF p_x_header_rec.first_ack_date IS NULL THEN
7257: p_x_header_rec.first_ack_date := FND_API.G_MISS_DATE;
7258: END IF;
7259:
7260: IF p_x_header_rec.last_ack_code IS NULL THEN
7261: p_x_header_rec.last_ack_code := FND_API.G_MISS_CHAR;
7257: p_x_header_rec.first_ack_date := FND_API.G_MISS_DATE;
7258: END IF;
7259:
7260: IF p_x_header_rec.last_ack_code IS NULL THEN
7261: p_x_header_rec.last_ack_code := FND_API.G_MISS_CHAR;
7262: END IF;
7263:
7264: IF p_x_header_rec.last_ack_date IS NULL THEN
7265: p_x_header_rec.last_ack_date := FND_API.G_MISS_DATE;
7261: p_x_header_rec.last_ack_code := FND_API.G_MISS_CHAR;
7262: END IF;
7263:
7264: IF p_x_header_rec.last_ack_date IS NULL THEN
7265: p_x_header_rec.last_ack_date := FND_API.G_MISS_DATE;
7266: END IF;
7267:
7268: IF p_x_header_rec.shipping_instructions IS NULL THEN
7269: p_x_header_rec.shipping_instructions := FND_API.G_MISS_CHAR;
7265: p_x_header_rec.last_ack_date := FND_API.G_MISS_DATE;
7266: END IF;
7267:
7268: IF p_x_header_rec.shipping_instructions IS NULL THEN
7269: p_x_header_rec.shipping_instructions := FND_API.G_MISS_CHAR;
7270: END IF;
7271:
7272: IF p_x_header_rec.packing_instructions IS NULL THEN
7273: p_x_header_rec.packing_instructions := FND_API.G_MISS_CHAR;
7269: p_x_header_rec.shipping_instructions := FND_API.G_MISS_CHAR;
7270: END IF;
7271:
7272: IF p_x_header_rec.packing_instructions IS NULL THEN
7273: p_x_header_rec.packing_instructions := FND_API.G_MISS_CHAR;
7274: END IF;
7275:
7276: IF p_x_header_rec.flow_status_code IS NULL THEN
7277: p_x_header_rec.flow_status_code := FND_API.G_MISS_CHAR;
7273: p_x_header_rec.packing_instructions := FND_API.G_MISS_CHAR;
7274: END IF;
7275:
7276: IF p_x_header_rec.flow_status_code IS NULL THEN
7277: p_x_header_rec.flow_status_code := FND_API.G_MISS_CHAR;
7278: END IF;
7279:
7280: IF p_x_header_rec.marketing_source_code_id IS NULL THEN
7281: p_x_header_rec.marketing_source_code_id := FND_API.G_MISS_NUM;
7277: p_x_header_rec.flow_status_code := FND_API.G_MISS_CHAR;
7278: END IF;
7279:
7280: IF p_x_header_rec.marketing_source_code_id IS NULL THEN
7281: p_x_header_rec.marketing_source_code_id := FND_API.G_MISS_NUM;
7282: END IF;
7283:
7284: IF p_x_header_rec.change_sequence IS NULL THEN --2416561
7285: p_x_header_rec.change_sequence := FND_API.G_MISS_CHAR;
7281: p_x_header_rec.marketing_source_code_id := FND_API.G_MISS_NUM;
7282: END IF;
7283:
7284: IF p_x_header_rec.change_sequence IS NULL THEN --2416561
7285: p_x_header_rec.change_sequence := FND_API.G_MISS_CHAR;
7286: END IF;
7287:
7288: -- QUOTING changes
7289:
7287:
7288: -- QUOTING changes
7289:
7290: IF p_x_header_rec.quote_date IS NULL THEN
7291: p_x_header_rec.quote_date := FND_API.G_MISS_DATE;
7292: END IF;
7293:
7294: IF p_x_header_rec.quote_number IS NULL THEN
7295: p_x_header_rec.quote_number := FND_API.G_MISS_NUM;
7291: p_x_header_rec.quote_date := FND_API.G_MISS_DATE;
7292: END IF;
7293:
7294: IF p_x_header_rec.quote_number IS NULL THEN
7295: p_x_header_rec.quote_number := FND_API.G_MISS_NUM;
7296: END IF;
7297:
7298: IF p_x_header_rec.sales_document_name IS NULL THEN
7299: p_x_header_rec.sales_document_name := FND_API.G_MISS_CHAR;
7295: p_x_header_rec.quote_number := FND_API.G_MISS_NUM;
7296: END IF;
7297:
7298: IF p_x_header_rec.sales_document_name IS NULL THEN
7299: p_x_header_rec.sales_document_name := FND_API.G_MISS_CHAR;
7300: END IF;
7301:
7302: IF p_x_header_rec.transaction_phase_code IS NULL THEN
7303: p_x_header_rec.transaction_phase_code := FND_API.G_MISS_CHAR;
7299: p_x_header_rec.sales_document_name := FND_API.G_MISS_CHAR;
7300: END IF;
7301:
7302: IF p_x_header_rec.transaction_phase_code IS NULL THEN
7303: p_x_header_rec.transaction_phase_code := FND_API.G_MISS_CHAR;
7304: END IF;
7305:
7306: IF p_x_header_rec.user_status_code IS NULL THEN
7307: p_x_header_rec.user_status_code := FND_API.G_MISS_CHAR;
7303: p_x_header_rec.transaction_phase_code := FND_API.G_MISS_CHAR;
7304: END IF;
7305:
7306: IF p_x_header_rec.user_status_code IS NULL THEN
7307: p_x_header_rec.user_status_code := FND_API.G_MISS_CHAR;
7308: END IF;
7309:
7310: IF p_x_header_rec.draft_submitted_flag IS NULL THEN
7311: p_x_header_rec.draft_submitted_flag := FND_API.G_MISS_CHAR;
7307: p_x_header_rec.user_status_code := FND_API.G_MISS_CHAR;
7308: END IF;
7309:
7310: IF p_x_header_rec.draft_submitted_flag IS NULL THEN
7311: p_x_header_rec.draft_submitted_flag := FND_API.G_MISS_CHAR;
7312: END IF;
7313:
7314: IF p_x_header_rec.source_document_version_number IS NULL THEN
7315: p_x_header_rec.source_document_version_number := FND_API.G_MISS_NUM;
7311: p_x_header_rec.draft_submitted_flag := FND_API.G_MISS_CHAR;
7312: END IF;
7313:
7314: IF p_x_header_rec.source_document_version_number IS NULL THEN
7315: p_x_header_rec.source_document_version_number := FND_API.G_MISS_NUM;
7316: END IF;
7317:
7318: IF p_x_header_rec.sold_to_site_use_id IS NULL THEN
7319: p_x_header_rec.sold_to_site_use_id := FND_API.G_MISS_NUM;
7315: p_x_header_rec.source_document_version_number := FND_API.G_MISS_NUM;
7316: END IF;
7317:
7318: IF p_x_header_rec.sold_to_site_use_id IS NULL THEN
7319: p_x_header_rec.sold_to_site_use_id := FND_API.G_MISS_NUM;
7320: END IF;
7321:
7322: -- QUOTING changes END
7323:
7321:
7322: -- QUOTING changes END
7323:
7324: IF p_x_header_rec.Minisite_id IS NULL THEN
7325: p_x_header_rec.Minisite_id := FND_API.G_MISS_NUM;
7326: END IF;
7327:
7328: IF p_x_header_rec.End_customer_id IS NULL THEN
7329: p_x_header_rec.End_customer_id := FND_API.G_MISS_NUM;
7325: p_x_header_rec.Minisite_id := FND_API.G_MISS_NUM;
7326: END IF;
7327:
7328: IF p_x_header_rec.End_customer_id IS NULL THEN
7329: p_x_header_rec.End_customer_id := FND_API.G_MISS_NUM;
7330: END IF;
7331:
7332: IF p_x_header_rec.End_customer_contact_id IS NULL THEN
7333: p_x_header_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
7329: p_x_header_rec.End_customer_id := FND_API.G_MISS_NUM;
7330: END IF;
7331:
7332: IF p_x_header_rec.End_customer_contact_id IS NULL THEN
7333: p_x_header_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
7334: END IF;
7335:
7336: IF p_x_header_rec.End_customer_site_use_id IS NULL THEN
7337: p_x_header_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
7333: p_x_header_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
7334: END IF;
7335:
7336: IF p_x_header_rec.End_customer_site_use_id IS NULL THEN
7337: p_x_header_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
7338: END IF;
7339:
7340: IF p_x_header_rec.Ib_owner IS NULL THEN
7341: p_x_header_rec.Ib_owner := FND_API.G_MISS_CHAR;
7337: p_x_header_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
7338: END IF;
7339:
7340: IF p_x_header_rec.Ib_owner IS NULL THEN
7341: p_x_header_rec.Ib_owner := FND_API.G_MISS_CHAR;
7342: END IF;
7343:
7344: IF p_x_header_rec.Ib_installed_at_location IS NULL THEN
7345: p_x_header_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
7341: p_x_header_rec.Ib_owner := FND_API.G_MISS_CHAR;
7342: END IF;
7343:
7344: IF p_x_header_rec.Ib_installed_at_location IS NULL THEN
7345: p_x_header_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
7346: END IF;
7347:
7348: IF p_x_header_rec.Ib_current_location IS NULL THEN
7349: p_x_header_rec.Ib_current_location := FND_API.G_MISS_CHAR;
7345: p_x_header_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
7346: END IF;
7347:
7348: IF p_x_header_rec.Ib_current_location IS NULL THEN
7349: p_x_header_rec.Ib_current_location := FND_API.G_MISS_CHAR;
7350: END IF;
7351:
7352: IF p_x_header_rec.supplier_signature IS NULL THEN
7353: p_x_header_rec.supplier_signature := FND_API.G_MISS_CHAR;
7349: p_x_header_rec.Ib_current_location := FND_API.G_MISS_CHAR;
7350: END IF;
7351:
7352: IF p_x_header_rec.supplier_signature IS NULL THEN
7353: p_x_header_rec.supplier_signature := FND_API.G_MISS_CHAR;
7354: END IF;
7355:
7356: IF p_x_header_rec.supplier_signature_date IS NULL THEN
7357: p_x_header_rec.supplier_signature_date := FND_API.G_MISS_DATE;
7353: p_x_header_rec.supplier_signature := FND_API.G_MISS_CHAR;
7354: END IF;
7355:
7356: IF p_x_header_rec.supplier_signature_date IS NULL THEN
7357: p_x_header_rec.supplier_signature_date := FND_API.G_MISS_DATE;
7358: END IF;
7359:
7360: IF p_x_header_rec.customer_signature IS NULL THEN
7361: p_x_header_rec.customer_signature := FND_API.G_MISS_CHAR;
7357: p_x_header_rec.supplier_signature_date := FND_API.G_MISS_DATE;
7358: END IF;
7359:
7360: IF p_x_header_rec.customer_signature IS NULL THEN
7361: p_x_header_rec.customer_signature := FND_API.G_MISS_CHAR;
7362: END IF;
7363:
7364: IF p_x_header_rec.customer_signature_date IS NULL THEN
7365: p_x_header_rec.customer_signature_date := FND_API.G_MISS_DATE;
7361: p_x_header_rec.customer_signature := FND_API.G_MISS_CHAR;
7362: END IF;
7363:
7364: IF p_x_header_rec.customer_signature_date IS NULL THEN
7365: p_x_header_rec.customer_signature_date := FND_API.G_MISS_DATE;
7366: END IF;
7367:
7368: IF p_x_header_rec.contract_template_id IS NULL THEN
7369: p_x_header_rec.contract_template_id := FND_API.G_MISS_NUM;
7365: p_x_header_rec.customer_signature_date := FND_API.G_MISS_DATE;
7366: END IF;
7367:
7368: IF p_x_header_rec.contract_template_id IS NULL THEN
7369: p_x_header_rec.contract_template_id := FND_API.G_MISS_NUM;
7370: END IF;
7371:
7372: IF p_x_header_rec.contract_source_doc_type_code IS NULL THEN
7373: p_x_header_rec.contract_source_doc_type_code := FND_API.G_MISS_CHAR;
7369: p_x_header_rec.contract_template_id := FND_API.G_MISS_NUM;
7370: END IF;
7371:
7372: IF p_x_header_rec.contract_source_doc_type_code IS NULL THEN
7373: p_x_header_rec.contract_source_doc_type_code := FND_API.G_MISS_CHAR;
7374: END IF;
7375:
7376: IF p_x_header_rec.contract_source_document_id IS NULL THEN
7377: p_x_header_rec.contract_source_document_id := FND_API.G_MISS_NUM;
7373: p_x_header_rec.contract_source_doc_type_code := FND_API.G_MISS_CHAR;
7374: END IF;
7375:
7376: IF p_x_header_rec.contract_source_document_id IS NULL THEN
7377: p_x_header_rec.contract_source_document_id := FND_API.G_MISS_NUM;
7378: END IF;
7379:
7380: IF p_x_header_rec.order_firmed_date IS NULL THEN
7381: p_x_header_rec.order_firmed_date := FND_API.G_MISS_DATE;
7377: p_x_header_rec.contract_source_document_id := FND_API.G_MISS_NUM;
7378: END IF;
7379:
7380: IF p_x_header_rec.order_firmed_date IS NULL THEN
7381: p_x_header_rec.order_firmed_date := FND_API.G_MISS_DATE;
7382: END IF;
7383:
7384: oe_debug_pub.add('Exiting CONVERTHDR__NULL_TO_MISS', 1);
7385: EXCEPTION
7384: oe_debug_pub.add('Exiting CONVERTHDR__NULL_TO_MISS', 1);
7385: EXCEPTION
7386: WHEN OTHERS THEN
7387: oe_debug_pub.add('In Others Convert_hdr_null_to_miss', 1);
7388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7389:
7390: END Convert_hdr_null_to_miss;
7391:
7392: -------------------------