eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DELIVERY_LEGS_GRP dependencies on FND_API

Line 152: IF NOT FND_API.compatible_api_call(l_api_version,p_api_version_number,l_api_name,G_PKG_NAME) THEN

148: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
149: l_ignore := NULL;
150: l_tms_interface_flag := NULL;
151:
152: IF NOT FND_API.compatible_api_call(l_api_version,p_api_version_number,l_api_name,G_PKG_NAME) THEN
153: IF l_debug_on THEN
154: WSH_DEBUG_SV.log(l_module_name,'Not comatible');
155: END IF;
156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

152: IF NOT FND_API.compatible_api_call(l_api_version,p_api_version_number,l_api_name,G_PKG_NAME) THEN
153: IF l_debug_on THEN
154: WSH_DEBUG_SV.log(l_module_name,'Not comatible');
155: END IF;
156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
157: END IF;
158:
159: IF FND_API.to_boolean(p_init_msg_list) THEN
160: FND_MSG_PUB.initialize;

Line 159: IF FND_API.to_boolean(p_init_msg_list) THEN

155: END IF;
156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
157: END IF;
158:
159: IF FND_API.to_boolean(p_init_msg_list) THEN
160: FND_MSG_PUB.initialize;
161: END IF;
162:
163: IF (p_action_prms.caller IS NULL) THEN

Line 167: raise fnd_api.g_exc_error;

163: IF (p_action_prms.caller IS NULL) THEN
164: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
165: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_action_prms.caller');
166: wsh_util_core.add_message(x_return_status,l_module_name);
167: raise fnd_api.g_exc_error;
168: END IF;
169: IF (p_action_prms.action_code IS NULL ) THEN
170: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
171: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_action_prms.action_code');

Line 173: raise fnd_api.g_exc_error;

169: IF (p_action_prms.action_code IS NULL ) THEN
170: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
171: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_action_prms.action_code');
172: wsh_util_core.add_message(x_return_status,l_module_name);
173: raise fnd_api.g_exc_error;
174: END IF;
175:
176: IF (nvl(p_action_prms.phase,1) < 1) THEN
177: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

Line 180: raise fnd_api.g_exc_error;

176: IF (nvl(p_action_prms.phase,1) < 1) THEN
177: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
178: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_action_prms.phase');
179: wsh_util_core.add_message(x_return_status,l_module_name);
180: raise fnd_api.g_exc_error;
181: END IF;
182:
183: IF (x_action_out_rec.x_delivery_id IS NULL) THEN
184: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

Line 187: raise fnd_api.g_exc_error;

183: IF (x_action_out_rec.x_delivery_id IS NULL) THEN
184: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
185: FND_MESSAGE.SET_TOKEN('FIELD_NAME','x_action_out_rec.x_delivery_id');
186: wsh_util_core.add_message(x_return_status,l_module_name);
187: raise fnd_api.g_exc_error;
188: END IF;
189:
190: IF (x_action_out_rec.x_trip_id IS NULL) THEN
191: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

Line 194: raise fnd_api.g_exc_error;

190: IF (x_action_out_rec.x_trip_id IS NULL) THEN
191: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
192: FND_MESSAGE.SET_TOKEN('FIELD_NAME','x_action_out_rec.x_trip_id');
193: wsh_util_core.add_message(x_return_status,l_module_name);
194: raise fnd_api.g_exc_error;
195: END IF;
196:
197: IF ( p_rec_attr_tab.count < 0 ) THEN
198: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

Line 201: raise fnd_api.g_exc_error;

197: IF ( p_rec_attr_tab.count < 0 ) THEN
198: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
199: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_rec_attr_tab.count');
200: wsh_util_core.add_message(x_return_status,l_module_name);
201: raise fnd_api.g_exc_error;
202: END IF;
203:
204: WSH_ACTIONS_LEVELS.set_validation_level (
205: p_entity => 'DLEG',

Line 493: p_init_msg_list => FND_API.G_FALSE,

489: l_action_out_rec.x_delivery_id := x_action_out_rec.x_delivery_id;
490:
491: WSH_DELIVERY_LEGS_GRP.DELIVERY_LEG_ACTION(
492: p_api_version_number => p_api_version_number,
493: p_init_msg_list => FND_API.G_FALSE,
494: p_commit => FND_API.G_FALSE,
495: p_rec_attr_tab => p_rec_attr_tab,
496: p_action_prms => l_action_prms,
497: x_action_out_rec => l_action_out_rec,

Line 494: p_commit => FND_API.G_FALSE,

490:
491: WSH_DELIVERY_LEGS_GRP.DELIVERY_LEG_ACTION(
492: p_api_version_number => p_api_version_number,
493: p_init_msg_list => FND_API.G_FALSE,
494: p_commit => FND_API.G_FALSE,
495: p_rec_attr_tab => p_rec_attr_tab,
496: p_action_prms => l_action_prms,
497: x_action_out_rec => l_action_out_rec,
498: x_return_status => l_return_status,

Line 589: WHEN fnd_api.g_exc_error THEN

585: END IF;
586:
587: RETURN;
588:
589: WHEN fnd_api.g_exc_error THEN
590: -- OTM R12, glog proj, close all cursors
591: IF get_trip_ship_method%ISOPEN THEN
592: CLOSE get_trip_ship_method;
593: END IF;

Line 613: WHEN fnd_api.g_exc_unexpected_error THEN

609: ELSIF p_action_prms.action_code = 'PRINT-BOL' THEN
610: ROLLBACK TO action_prnbol_sp;
611: END IF;
612:
613: WHEN fnd_api.g_exc_unexpected_error THEN
614: -- OTM R12, glog proj, close all cursors
615: IF get_trip_ship_method%ISOPEN THEN
616: CLOSE get_trip_ship_method;
617: END IF;

Line 660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

656: ROLLBACK TO action_genbol_sp;
657: ELSIF p_action_prms.action_code = 'PRINT-BOL' THEN
658: ROLLBACK TO action_prnbol_sp;
659: END IF;
660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661:
662:
663: END;
664: l_index := p_rec_attr_tab.NEXT(l_index);

Line 668: raise FND_API.G_EXC_ERROR;

664: l_index := p_rec_attr_tab.NEXT(l_index);
665: END LOOP;
666:
667: IF (l_num_errors = p_rec_attr_tab.count ) THEN
668: raise FND_API.G_EXC_ERROR;
669: ELSIF (l_num_errors > 0 ) THEN
670: raise WSH_UTIL_CORE.G_EXC_WARNING;
671: ELSIF (l_num_warnings > 0 ) THEN
672: raise WSH_UTIL_CORE.G_EXC_WARNING;

Line 678: IF FND_API.To_Boolean( p_commit ) THEN

674: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
675: END IF;
676:
677:
678: IF FND_API.To_Boolean( p_commit ) THEN
679: COMMIT WORK;
680: END IF;
681:
682: FND_MSG_PUB.Count_And_Get

Line 685: p_encoded => FND_API.G_FALSE

681:
682: FND_MSG_PUB.Count_And_Get
683: ( p_count => x_msg_count,
684: p_data => x_msg_data,
685: p_encoded => FND_API.G_FALSE
686: );
687:
688:
689: IF l_debug_on THEN

Line 701: p_encoded => FND_API.G_FALSE);

697: wsh_util_core.add_message(x_return_status,l_module_name);
698: FND_MSG_PUB.Count_And_Get (
699: p_count => x_msg_count,
700: p_data => x_msg_data,
701: p_encoded => FND_API.G_FALSE);
702: IF l_debug_on THEN
703: WSH_DEBUG_SV.log(l_module_name,'Message Count',x_msg_count);
704: WSH_DEBUG_SV.log(l_module_name,'Message Data', x_msg_data);
705: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 710: WHEN FND_API.G_EXC_ERROR THEN

706: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
707: END IF;
708:
709:
710: WHEN FND_API.G_EXC_ERROR THEN
711: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
712: FND_MSG_PUB.Count_And_Get (
713: p_count => x_msg_count,
714: p_data => x_msg_data,

Line 715: p_encoded => FND_API.G_FALSE);

711: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
712: FND_MSG_PUB.Count_And_Get (
713: p_count => x_msg_count,
714: p_data => x_msg_data,
715: p_encoded => FND_API.G_FALSE);
716: IF l_debug_on THEN
717: WSH_DEBUG_SV.log(l_module_name,'Message Count',x_msg_count);
718: WSH_DEBUG_SV.log(l_module_name,'Message Data', x_msg_data);
719: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 719: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

715: p_encoded => FND_API.G_FALSE);
716: IF l_debug_on THEN
717: WSH_DEBUG_SV.log(l_module_name,'Message Count',x_msg_count);
718: WSH_DEBUG_SV.log(l_module_name,'Message Data', x_msg_data);
719: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
720: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
721: END IF;
722:
723:

Line 720: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

716: IF l_debug_on THEN
717: WSH_DEBUG_SV.log(l_module_name,'Message Count',x_msg_count);
718: WSH_DEBUG_SV.log(l_module_name,'Message Data', x_msg_data);
719: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
720: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
721: END IF;
722:
723:
724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

720: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
721: END IF;
722:
723:
724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
725: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
726: FND_MSG_PUB.Count_And_Get (
727: p_count => x_msg_count,
728: p_data => x_msg_data,

Line 729: p_encoded => FND_API.G_FALSE);

725: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
726: FND_MSG_PUB.Count_And_Get (
727: p_count => x_msg_count,
728: p_data => x_msg_data,
729: p_encoded => FND_API.G_FALSE);
730: IF l_debug_on THEN
731: WSH_DEBUG_SV.log(l_module_name,'Message Count',x_msg_count);
732: WSH_DEBUG_SV.log(l_module_name,'Message Data', x_msg_data);
733: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 733: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

729: p_encoded => FND_API.G_FALSE);
730: IF l_debug_on THEN
731: WSH_DEBUG_SV.log(l_module_name,'Message Count',x_msg_count);
732: WSH_DEBUG_SV.log(l_module_name,'Message Data', x_msg_data);
733: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
734: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
735: END IF;
736:
737:

Line 734: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

730: IF l_debug_on THEN
731: WSH_DEBUG_SV.log(l_module_name,'Message Count',x_msg_count);
732: WSH_DEBUG_SV.log(l_module_name,'Message Data', x_msg_data);
733: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
734: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
735: END IF;
736:
737:
738: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 743: p_encoded => FND_API.G_FALSE);

739: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
740: FND_MSG_PUB.Count_And_Get (
741: p_count => x_msg_count,
742: p_data => x_msg_data,
743: p_encoded => FND_API.G_FALSE);
744: IF l_debug_on THEN
745: WSH_DEBUG_SV.log(l_module_name,'Message Count',x_msg_count);
746: WSH_DEBUG_SV.log(l_module_name,'Message Data', x_msg_data);
747: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 758: p_encoded => FND_API.G_FALSE);

754: wsh_util_core.default_handler ('WSH_DELIVERY_LEGS_GRP.DELIVERY_LEG_ACTION');
755: FND_MSG_PUB.Count_And_Get (
756: p_count => x_msg_count,
757: p_data => x_msg_data,
758: p_encoded => FND_API.G_FALSE);
759: IF l_debug_on THEN
760: WSH_DEBUG_SV.log(l_module_name,'Message Count',x_msg_count);
761: WSH_DEBUG_SV.log(l_module_name,'Message Data', x_msg_data);
762: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

Line 773: -- p_init_msg_list FND_API.G_TRUE to reset list

769: --========================================================================
770: -- PROCEDURE : Update_Delivery_Leg Wrapper API PUBLIC
771: --
772: -- PARAMETERS: p_api_version_number known api version error buffer
773: -- p_init_msg_list FND_API.G_TRUE to reset list
774: -- x_return_status return status
775: -- x_msg_count number of messages in the list
776: -- x_msg_data text of messages
777: -- p_in_rec Record for caller, phase

Line 786: -- fnd_api.g_miss_(num/char/date) value for that field. If a field

782: -- initial version 1.0
783: -- COMMENT : Updates a record in wsh_delivery_legs table with information
784: -- specified in p_delivery_leg_tab. Please note that as per perfomance
785: -- standards, if you need to update a field to null, then use the
786: -- fnd_api.g_miss_(num/char/date) value for that field. If a field
787: -- has a null value, it will not be updated.
788:
789: PROCEDURE Update_Delivery_Leg(
790: p_api_version_number IN NUMBER,

Line 846: AND p_delivery_leg_tab(l_index).POD_DATE <> FND_API.G_MISS_DATE THEN

842:
843: IF p_in_rec.caller like 'FTE%' THEN
844:
845: IF p_delivery_leg_tab(l_index).POD_DATE is NOT NULL
846: AND p_delivery_leg_tab(l_index).POD_DATE <> FND_API.G_MISS_DATE THEN
847:
848:
849: -- See if the delivery leg is the last on the delivery.
850:

Line 1062: IF p_del_leg_rec.DELIVERY_ID = FND_API.G_MISS_NUM THEN

1058: end if;
1059: CLOSE c_get_leg_record;
1060:
1061:
1062: IF p_del_leg_rec.DELIVERY_ID = FND_API.G_MISS_NUM THEN
1063: l_dleg_rec.DELIVERY_ID := NULL;
1064: ELSIF p_del_leg_rec.DELIVERY_ID IS NOT NULL THEN
1065: l_dleg_rec.DELIVERY_ID := p_del_leg_rec.DELIVERY_ID;
1066: END IF;

Line 1067: IF p_del_leg_rec.SEQUENCE_NUMBER = FND_API.G_MISS_NUM THEN

1063: l_dleg_rec.DELIVERY_ID := NULL;
1064: ELSIF p_del_leg_rec.DELIVERY_ID IS NOT NULL THEN
1065: l_dleg_rec.DELIVERY_ID := p_del_leg_rec.DELIVERY_ID;
1066: END IF;
1067: IF p_del_leg_rec.SEQUENCE_NUMBER = FND_API.G_MISS_NUM THEN
1068: l_dleg_rec.SEQUENCE_NUMBER := NULL;
1069: ELSIF p_del_leg_rec.SEQUENCE_NUMBER IS NOT NULL THEN
1070: l_dleg_rec.SEQUENCE_NUMBER := p_del_leg_rec.SEQUENCE_NUMBER;
1071: END IF;

Line 1072: IF p_del_leg_rec.LOADING_ORDER_FLAG = FND_API.G_MISS_CHAR THEN

1068: l_dleg_rec.SEQUENCE_NUMBER := NULL;
1069: ELSIF p_del_leg_rec.SEQUENCE_NUMBER IS NOT NULL THEN
1070: l_dleg_rec.SEQUENCE_NUMBER := p_del_leg_rec.SEQUENCE_NUMBER;
1071: END IF;
1072: IF p_del_leg_rec.LOADING_ORDER_FLAG = FND_API.G_MISS_CHAR THEN
1073: l_dleg_rec.LOADING_ORDER_FLAG := NULL;
1074: ELSIF p_del_leg_rec.LOADING_ORDER_FLAG IS NOT NULL THEN
1075: l_dleg_rec.LOADING_ORDER_FLAG := p_del_leg_rec.LOADING_ORDER_FLAG;
1076: END IF;

Line 1077: IF p_del_leg_rec.PICK_UP_STOP_ID = FND_API.G_MISS_NUM THEN

1073: l_dleg_rec.LOADING_ORDER_FLAG := NULL;
1074: ELSIF p_del_leg_rec.LOADING_ORDER_FLAG IS NOT NULL THEN
1075: l_dleg_rec.LOADING_ORDER_FLAG := p_del_leg_rec.LOADING_ORDER_FLAG;
1076: END IF;
1077: IF p_del_leg_rec.PICK_UP_STOP_ID = FND_API.G_MISS_NUM THEN
1078: l_dleg_rec.PICK_UP_STOP_ID := NULL;
1079: ELSIF p_del_leg_rec.PICK_UP_STOP_ID IS NOT NULL THEN
1080: l_dleg_rec.PICK_UP_STOP_ID := p_del_leg_rec.PICK_UP_STOP_ID;
1081: END IF;

Line 1082: IF p_del_leg_rec.DROP_OFF_STOP_ID = FND_API.G_MISS_NUM THEN

1078: l_dleg_rec.PICK_UP_STOP_ID := NULL;
1079: ELSIF p_del_leg_rec.PICK_UP_STOP_ID IS NOT NULL THEN
1080: l_dleg_rec.PICK_UP_STOP_ID := p_del_leg_rec.PICK_UP_STOP_ID;
1081: END IF;
1082: IF p_del_leg_rec.DROP_OFF_STOP_ID = FND_API.G_MISS_NUM THEN
1083: l_dleg_rec.DROP_OFF_STOP_ID := NULL;
1084: ELSIF p_del_leg_rec.DROP_OFF_STOP_ID IS NOT NULL THEN
1085: l_dleg_rec.DROP_OFF_STOP_ID := p_del_leg_rec.DROP_OFF_STOP_ID;
1086: END IF;

Line 1087: IF p_del_leg_rec.GROSS_WEIGHT = FND_API.G_MISS_NUM THEN

1083: l_dleg_rec.DROP_OFF_STOP_ID := NULL;
1084: ELSIF p_del_leg_rec.DROP_OFF_STOP_ID IS NOT NULL THEN
1085: l_dleg_rec.DROP_OFF_STOP_ID := p_del_leg_rec.DROP_OFF_STOP_ID;
1086: END IF;
1087: IF p_del_leg_rec.GROSS_WEIGHT = FND_API.G_MISS_NUM THEN
1088: l_dleg_rec.GROSS_WEIGHT := NULL;
1089: ELSIF p_del_leg_rec.GROSS_WEIGHT IS NOT NULL THEN
1090: l_dleg_rec.GROSS_WEIGHT := p_del_leg_rec.GROSS_WEIGHT;
1091: END IF;

Line 1092: IF p_del_leg_rec.NET_WEIGHT = FND_API.G_MISS_NUM THEN

1088: l_dleg_rec.GROSS_WEIGHT := NULL;
1089: ELSIF p_del_leg_rec.GROSS_WEIGHT IS NOT NULL THEN
1090: l_dleg_rec.GROSS_WEIGHT := p_del_leg_rec.GROSS_WEIGHT;
1091: END IF;
1092: IF p_del_leg_rec.NET_WEIGHT = FND_API.G_MISS_NUM THEN
1093: l_dleg_rec.NET_WEIGHT := NULL;
1094: ELSIF p_del_leg_rec.NET_WEIGHT IS NOT NULL THEN
1095: l_dleg_rec.NET_WEIGHT := p_del_leg_rec.NET_WEIGHT;
1096: END IF;

Line 1097: IF p_del_leg_rec.WEIGHT_UOM_CODE = FND_API.G_MISS_CHAR THEN

1093: l_dleg_rec.NET_WEIGHT := NULL;
1094: ELSIF p_del_leg_rec.NET_WEIGHT IS NOT NULL THEN
1095: l_dleg_rec.NET_WEIGHT := p_del_leg_rec.NET_WEIGHT;
1096: END IF;
1097: IF p_del_leg_rec.WEIGHT_UOM_CODE = FND_API.G_MISS_CHAR THEN
1098: l_dleg_rec.WEIGHT_UOM_CODE := NULL;
1099: ELSIF p_del_leg_rec.WEIGHT_UOM_CODE IS NOT NULL THEN
1100: l_dleg_rec.WEIGHT_UOM_CODE := p_del_leg_rec.WEIGHT_UOM_CODE;
1101: END IF;

Line 1102: IF p_del_leg_rec.VOLUME = FND_API.G_MISS_NUM THEN

1098: l_dleg_rec.WEIGHT_UOM_CODE := NULL;
1099: ELSIF p_del_leg_rec.WEIGHT_UOM_CODE IS NOT NULL THEN
1100: l_dleg_rec.WEIGHT_UOM_CODE := p_del_leg_rec.WEIGHT_UOM_CODE;
1101: END IF;
1102: IF p_del_leg_rec.VOLUME = FND_API.G_MISS_NUM THEN
1103: l_dleg_rec.VOLUME := NULL;
1104: ELSIF p_del_leg_rec.VOLUME IS NOT NULL THEN
1105: l_dleg_rec.VOLUME := p_del_leg_rec.VOLUME;
1106: END IF;

Line 1107: IF p_del_leg_rec.VOLUME_UOM_CODE = FND_API.G_MISS_CHAR THEN

1103: l_dleg_rec.VOLUME := NULL;
1104: ELSIF p_del_leg_rec.VOLUME IS NOT NULL THEN
1105: l_dleg_rec.VOLUME := p_del_leg_rec.VOLUME;
1106: END IF;
1107: IF p_del_leg_rec.VOLUME_UOM_CODE = FND_API.G_MISS_CHAR THEN
1108: l_dleg_rec.VOLUME_UOM_CODE := NULL;
1109: ELSIF p_del_leg_rec.VOLUME_UOM_CODE IS NOT NULL THEN
1110: l_dleg_rec.VOLUME_UOM_CODE := p_del_leg_rec.VOLUME_UOM_CODE;
1111: END IF;

Line 1112: IF p_del_leg_rec.VOLUME_UOM_CODE = FND_API.G_MISS_NUM THEN

1108: l_dleg_rec.VOLUME_UOM_CODE := NULL;
1109: ELSIF p_del_leg_rec.VOLUME_UOM_CODE IS NOT NULL THEN
1110: l_dleg_rec.VOLUME_UOM_CODE := p_del_leg_rec.VOLUME_UOM_CODE;
1111: END IF;
1112: IF p_del_leg_rec.VOLUME_UOM_CODE = FND_API.G_MISS_NUM THEN
1113: l_dleg_rec.VOLUME_UOM_CODE := NULL;
1114: ELSIF p_del_leg_rec.VOLUME_UOM_CODE IS NOT NULL THEN
1115: l_dleg_rec.VOLUME_UOM_CODE := p_del_leg_rec.VOLUME_UOM_CODE;
1116: END IF;

Line 1117: IF p_del_leg_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN

1113: l_dleg_rec.VOLUME_UOM_CODE := NULL;
1114: ELSIF p_del_leg_rec.VOLUME_UOM_CODE IS NOT NULL THEN
1115: l_dleg_rec.VOLUME_UOM_CODE := p_del_leg_rec.VOLUME_UOM_CODE;
1116: END IF;
1117: IF p_del_leg_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
1118: l_dleg_rec.LAST_UPDATE_DATE := NULL;
1119: ELSIF p_del_leg_rec.LAST_UPDATE_DATE IS NOT NULL THEN
1120: l_dleg_rec.LAST_UPDATE_DATE := p_del_leg_rec.LAST_UPDATE_DATE;
1121: END IF;

Line 1122: IF p_del_leg_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN

1118: l_dleg_rec.LAST_UPDATE_DATE := NULL;
1119: ELSIF p_del_leg_rec.LAST_UPDATE_DATE IS NOT NULL THEN
1120: l_dleg_rec.LAST_UPDATE_DATE := p_del_leg_rec.LAST_UPDATE_DATE;
1121: END IF;
1122: IF p_del_leg_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
1123: l_dleg_rec.LAST_UPDATED_BY := NULL;
1124: ELSIF p_del_leg_rec.LAST_UPDATED_BY IS NOT NULL THEN
1125: l_dleg_rec.LAST_UPDATED_BY := p_del_leg_rec.LAST_UPDATED_BY;
1126: END IF;

Line 1127: IF p_del_leg_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN

1123: l_dleg_rec.LAST_UPDATED_BY := NULL;
1124: ELSIF p_del_leg_rec.LAST_UPDATED_BY IS NOT NULL THEN
1125: l_dleg_rec.LAST_UPDATED_BY := p_del_leg_rec.LAST_UPDATED_BY;
1126: END IF;
1127: IF p_del_leg_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
1128: l_dleg_rec.LAST_UPDATE_LOGIN := NULL;
1129: ELSIF p_del_leg_rec.LAST_UPDATE_LOGIN IS NOT NULL THEN
1130: l_dleg_rec.LAST_UPDATE_LOGIN := p_del_leg_rec.LAST_UPDATE_LOGIN;
1131: END IF;

Line 1132: IF p_del_leg_rec.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM THEN

1128: l_dleg_rec.LAST_UPDATE_LOGIN := NULL;
1129: ELSIF p_del_leg_rec.LAST_UPDATE_LOGIN IS NOT NULL THEN
1130: l_dleg_rec.LAST_UPDATE_LOGIN := p_del_leg_rec.LAST_UPDATE_LOGIN;
1131: END IF;
1132: IF p_del_leg_rec.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM THEN
1133: l_dleg_rec.PROGRAM_APPLICATION_ID := NULL;
1134: ELSIF p_del_leg_rec.PROGRAM_APPLICATION_ID IS NOT NULL THEN
1135: l_dleg_rec.PROGRAM_APPLICATION_ID := p_del_leg_rec.PROGRAM_APPLICATION_ID;
1136: END IF;

Line 1137: IF p_del_leg_rec.PROGRAM_ID = FND_API.G_MISS_NUM THEN

1133: l_dleg_rec.PROGRAM_APPLICATION_ID := NULL;
1134: ELSIF p_del_leg_rec.PROGRAM_APPLICATION_ID IS NOT NULL THEN
1135: l_dleg_rec.PROGRAM_APPLICATION_ID := p_del_leg_rec.PROGRAM_APPLICATION_ID;
1136: END IF;
1137: IF p_del_leg_rec.PROGRAM_ID = FND_API.G_MISS_NUM THEN
1138: l_dleg_rec.PROGRAM_ID := NULL;
1139: ELSIF p_del_leg_rec.PROGRAM_ID IS NOT NULL THEN
1140: l_dleg_rec.PROGRAM_ID := p_del_leg_rec.PROGRAM_ID;
1141: END IF;

Line 1142: IF p_del_leg_rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN

1138: l_dleg_rec.PROGRAM_ID := NULL;
1139: ELSIF p_del_leg_rec.PROGRAM_ID IS NOT NULL THEN
1140: l_dleg_rec.PROGRAM_ID := p_del_leg_rec.PROGRAM_ID;
1141: END IF;
1142: IF p_del_leg_rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN
1143: l_dleg_rec.PROGRAM_UPDATE_DATE := NULL;
1144: ELSIF p_del_leg_rec.PROGRAM_UPDATE_DATE IS NOT NULL THEN
1145: l_dleg_rec.PROGRAM_UPDATE_DATE := p_del_leg_rec.PROGRAM_UPDATE_DATE;
1146: END IF;

Line 1147: IF p_del_leg_rec.REQUEST_ID = FND_API.G_MISS_NUM THEN

1143: l_dleg_rec.PROGRAM_UPDATE_DATE := NULL;
1144: ELSIF p_del_leg_rec.PROGRAM_UPDATE_DATE IS NOT NULL THEN
1145: l_dleg_rec.PROGRAM_UPDATE_DATE := p_del_leg_rec.PROGRAM_UPDATE_DATE;
1146: END IF;
1147: IF p_del_leg_rec.REQUEST_ID = FND_API.G_MISS_NUM THEN
1148: l_dleg_rec.REQUEST_ID := NULL;
1149: ELSIF p_del_leg_rec.REQUEST_ID IS NOT NULL THEN
1150: l_dleg_rec.REQUEST_ID := p_del_leg_rec.REQUEST_ID;
1151: END IF;

Line 1152: IF p_del_leg_rec.LOAD_TENDER_STATUS = FND_API.G_MISS_CHAR THEN

1148: l_dleg_rec.REQUEST_ID := NULL;
1149: ELSIF p_del_leg_rec.REQUEST_ID IS NOT NULL THEN
1150: l_dleg_rec.REQUEST_ID := p_del_leg_rec.REQUEST_ID;
1151: END IF;
1152: IF p_del_leg_rec.LOAD_TENDER_STATUS = FND_API.G_MISS_CHAR THEN
1153: l_dleg_rec.LOAD_TENDER_STATUS := NULL;
1154: ELSIF p_del_leg_rec.LOAD_TENDER_STATUS IS NOT NULL THEN
1155: l_dleg_rec.LOAD_TENDER_STATUS := p_del_leg_rec.LOAD_TENDER_STATUS;
1156: END IF;

Line 1157: IF p_del_leg_rec.SHIPPER_TITLE = FND_API.G_MISS_CHAR THEN

1153: l_dleg_rec.LOAD_TENDER_STATUS := NULL;
1154: ELSIF p_del_leg_rec.LOAD_TENDER_STATUS IS NOT NULL THEN
1155: l_dleg_rec.LOAD_TENDER_STATUS := p_del_leg_rec.LOAD_TENDER_STATUS;
1156: END IF;
1157: IF p_del_leg_rec.SHIPPER_TITLE = FND_API.G_MISS_CHAR THEN
1158: l_dleg_rec.SHIPPER_TITLE := NULL;
1159: ELSIF p_del_leg_rec.SHIPPER_TITLE IS NOT NULL THEN
1160: l_dleg_rec.SHIPPER_TITLE := p_del_leg_rec.SHIPPER_TITLE;
1161: END IF;

Line 1162: IF p_del_leg_rec.SHIPPER_PHONE = FND_API.G_MISS_CHAR THEN

1158: l_dleg_rec.SHIPPER_TITLE := NULL;
1159: ELSIF p_del_leg_rec.SHIPPER_TITLE IS NOT NULL THEN
1160: l_dleg_rec.SHIPPER_TITLE := p_del_leg_rec.SHIPPER_TITLE;
1161: END IF;
1162: IF p_del_leg_rec.SHIPPER_PHONE = FND_API.G_MISS_CHAR THEN
1163: l_dleg_rec.SHIPPER_PHONE := NULL;
1164: ELSIF p_del_leg_rec.SHIPPER_PHONE IS NOT NULL THEN
1165: l_dleg_rec.SHIPPER_PHONE := p_del_leg_rec.SHIPPER_PHONE;
1166: END IF;

Line 1167: IF p_del_leg_rec.POD_FLAG = FND_API.G_MISS_CHAR THEN

1163: l_dleg_rec.SHIPPER_PHONE := NULL;
1164: ELSIF p_del_leg_rec.SHIPPER_PHONE IS NOT NULL THEN
1165: l_dleg_rec.SHIPPER_PHONE := p_del_leg_rec.SHIPPER_PHONE;
1166: END IF;
1167: IF p_del_leg_rec.POD_FLAG = FND_API.G_MISS_CHAR THEN
1168: l_dleg_rec.POD_FLAG := NULL;
1169: ELSIF p_del_leg_rec.POD_FLAG IS NOT NULL THEN
1170: l_dleg_rec.POD_FLAG := p_del_leg_rec.POD_FLAG;
1171: END IF;

Line 1172: IF p_del_leg_rec.POD_BY = FND_API.G_MISS_CHAR THEN

1168: l_dleg_rec.POD_FLAG := NULL;
1169: ELSIF p_del_leg_rec.POD_FLAG IS NOT NULL THEN
1170: l_dleg_rec.POD_FLAG := p_del_leg_rec.POD_FLAG;
1171: END IF;
1172: IF p_del_leg_rec.POD_BY = FND_API.G_MISS_CHAR THEN
1173: l_dleg_rec.POD_BY := NULL;
1174: ELSIF p_del_leg_rec.POD_BY IS NOT NULL THEN
1175: l_dleg_rec.POD_BY := p_del_leg_rec.POD_BY;
1176: END IF;

Line 1177: IF p_del_leg_rec.POD_DATE = FND_API.G_MISS_DATE THEN

1173: l_dleg_rec.POD_BY := NULL;
1174: ELSIF p_del_leg_rec.POD_BY IS NOT NULL THEN
1175: l_dleg_rec.POD_BY := p_del_leg_rec.POD_BY;
1176: END IF;
1177: IF p_del_leg_rec.POD_DATE = FND_API.G_MISS_DATE THEN
1178: l_dleg_rec.POD_DATE := NULL;
1179: ELSIF p_del_leg_rec.POD_DATE IS NOT NULL THEN
1180: l_dleg_rec.POD_DATE := p_del_leg_rec.POD_DATE;
1181: END IF;

Line 1182: IF p_del_leg_rec.EXPECTED_POD_DATE = FND_API.G_MISS_DATE THEN

1178: l_dleg_rec.POD_DATE := NULL;
1179: ELSIF p_del_leg_rec.POD_DATE IS NOT NULL THEN
1180: l_dleg_rec.POD_DATE := p_del_leg_rec.POD_DATE;
1181: END IF;
1182: IF p_del_leg_rec.EXPECTED_POD_DATE = FND_API.G_MISS_DATE THEN
1183: l_dleg_rec.EXPECTED_POD_DATE := NULL;
1184: ELSIF p_del_leg_rec.EXPECTED_POD_DATE IS NOT NULL THEN
1185: l_dleg_rec.EXPECTED_POD_DATE := p_del_leg_rec.EXPECTED_POD_DATE;
1186: END IF;

Line 1187: IF p_del_leg_rec.BOOKING_OFFICE = FND_API.G_MISS_CHAR THEN

1183: l_dleg_rec.EXPECTED_POD_DATE := NULL;
1184: ELSIF p_del_leg_rec.EXPECTED_POD_DATE IS NOT NULL THEN
1185: l_dleg_rec.EXPECTED_POD_DATE := p_del_leg_rec.EXPECTED_POD_DATE;
1186: END IF;
1187: IF p_del_leg_rec.BOOKING_OFFICE = FND_API.G_MISS_CHAR THEN
1188: l_dleg_rec.BOOKING_OFFICE := NULL;
1189: ELSIF p_del_leg_rec.BOOKING_OFFICE IS NOT NULL THEN
1190: l_dleg_rec.BOOKING_OFFICE := p_del_leg_rec.BOOKING_OFFICE;
1191: END IF;

Line 1192: IF p_del_leg_rec.SHIPPER_EXPORT_REF = FND_API.G_MISS_CHAR THEN

1188: l_dleg_rec.BOOKING_OFFICE := NULL;
1189: ELSIF p_del_leg_rec.BOOKING_OFFICE IS NOT NULL THEN
1190: l_dleg_rec.BOOKING_OFFICE := p_del_leg_rec.BOOKING_OFFICE;
1191: END IF;
1192: IF p_del_leg_rec.SHIPPER_EXPORT_REF = FND_API.G_MISS_CHAR THEN
1193: l_dleg_rec.SHIPPER_EXPORT_REF := NULL;
1194: ELSIF p_del_leg_rec.SHIPPER_EXPORT_REF IS NOT NULL THEN
1195: l_dleg_rec.SHIPPER_EXPORT_REF := p_del_leg_rec.SHIPPER_EXPORT_REF;
1196: END IF;

Line 1197: IF p_del_leg_rec.CARRIER_EXPORT_REF = FND_API.G_MISS_CHAR THEN

1193: l_dleg_rec.SHIPPER_EXPORT_REF := NULL;
1194: ELSIF p_del_leg_rec.SHIPPER_EXPORT_REF IS NOT NULL THEN
1195: l_dleg_rec.SHIPPER_EXPORT_REF := p_del_leg_rec.SHIPPER_EXPORT_REF;
1196: END IF;
1197: IF p_del_leg_rec.CARRIER_EXPORT_REF = FND_API.G_MISS_CHAR THEN
1198: l_dleg_rec.CARRIER_EXPORT_REF := NULL;
1199: ELSIF p_del_leg_rec.CARRIER_EXPORT_REF IS NOT NULL THEN
1200: l_dleg_rec.CARRIER_EXPORT_REF := p_del_leg_rec.CARRIER_EXPORT_REF;
1201: END IF;

Line 1202: IF p_del_leg_rec.DOC_NOTIFY_PARTY = FND_API.G_MISS_CHAR THEN

1198: l_dleg_rec.CARRIER_EXPORT_REF := NULL;
1199: ELSIF p_del_leg_rec.CARRIER_EXPORT_REF IS NOT NULL THEN
1200: l_dleg_rec.CARRIER_EXPORT_REF := p_del_leg_rec.CARRIER_EXPORT_REF;
1201: END IF;
1202: IF p_del_leg_rec.DOC_NOTIFY_PARTY = FND_API.G_MISS_CHAR THEN
1203: l_dleg_rec.DOC_NOTIFY_PARTY := NULL;
1204: ELSIF p_del_leg_rec.DOC_NOTIFY_PARTY IS NOT NULL THEN
1205: l_dleg_rec.DOC_NOTIFY_PARTY := p_del_leg_rec.DOC_NOTIFY_PARTY;
1206: END IF;

Line 1207: IF p_del_leg_rec.AETC_NUMBER = FND_API.G_MISS_CHAR THEN

1203: l_dleg_rec.DOC_NOTIFY_PARTY := NULL;
1204: ELSIF p_del_leg_rec.DOC_NOTIFY_PARTY IS NOT NULL THEN
1205: l_dleg_rec.DOC_NOTIFY_PARTY := p_del_leg_rec.DOC_NOTIFY_PARTY;
1206: END IF;
1207: IF p_del_leg_rec.AETC_NUMBER = FND_API.G_MISS_CHAR THEN
1208: l_dleg_rec.AETC_NUMBER := NULL;
1209: ELSIF p_del_leg_rec.AETC_NUMBER IS NOT NULL THEN
1210: l_dleg_rec.AETC_NUMBER := p_del_leg_rec.AETC_NUMBER;
1211: END IF;

Line 1212: IF p_del_leg_rec.SHIPPER_SIGNED_BY = FND_API.G_MISS_CHAR THEN

1208: l_dleg_rec.AETC_NUMBER := NULL;
1209: ELSIF p_del_leg_rec.AETC_NUMBER IS NOT NULL THEN
1210: l_dleg_rec.AETC_NUMBER := p_del_leg_rec.AETC_NUMBER;
1211: END IF;
1212: IF p_del_leg_rec.SHIPPER_SIGNED_BY = FND_API.G_MISS_CHAR THEN
1213: l_dleg_rec.SHIPPER_SIGNED_BY := NULL;
1214: ELSIF p_del_leg_rec.SHIPPER_SIGNED_BY IS NOT NULL THEN
1215: l_dleg_rec.SHIPPER_SIGNED_BY := p_del_leg_rec.SHIPPER_SIGNED_BY;
1216: END IF;

Line 1217: IF p_del_leg_rec.SHIPPER_DATE = FND_API.G_MISS_DATE THEN

1213: l_dleg_rec.SHIPPER_SIGNED_BY := NULL;
1214: ELSIF p_del_leg_rec.SHIPPER_SIGNED_BY IS NOT NULL THEN
1215: l_dleg_rec.SHIPPER_SIGNED_BY := p_del_leg_rec.SHIPPER_SIGNED_BY;
1216: END IF;
1217: IF p_del_leg_rec.SHIPPER_DATE = FND_API.G_MISS_DATE THEN
1218: l_dleg_rec.SHIPPER_DATE := NULL;
1219: ELSIF p_del_leg_rec.SHIPPER_DATE IS NOT NULL THEN
1220: l_dleg_rec.SHIPPER_DATE := p_del_leg_rec.SHIPPER_DATE;
1221: END IF;

Line 1222: IF p_del_leg_rec.CARRIER_SIGNED_BY = FND_API.G_MISS_CHAR THEN

1218: l_dleg_rec.SHIPPER_DATE := NULL;
1219: ELSIF p_del_leg_rec.SHIPPER_DATE IS NOT NULL THEN
1220: l_dleg_rec.SHIPPER_DATE := p_del_leg_rec.SHIPPER_DATE;
1221: END IF;
1222: IF p_del_leg_rec.CARRIER_SIGNED_BY = FND_API.G_MISS_CHAR THEN
1223: l_dleg_rec.CARRIER_SIGNED_BY := NULL;
1224: ELSIF p_del_leg_rec.CARRIER_SIGNED_BY IS NOT NULL THEN
1225: l_dleg_rec.CARRIER_SIGNED_BY := p_del_leg_rec.CARRIER_SIGNED_BY;
1226: END IF;

Line 1227: IF p_del_leg_rec.CARRIER_DATE = FND_API.G_MISS_DATE THEN

1223: l_dleg_rec.CARRIER_SIGNED_BY := NULL;
1224: ELSIF p_del_leg_rec.CARRIER_SIGNED_BY IS NOT NULL THEN
1225: l_dleg_rec.CARRIER_SIGNED_BY := p_del_leg_rec.CARRIER_SIGNED_BY;
1226: END IF;
1227: IF p_del_leg_rec.CARRIER_DATE = FND_API.G_MISS_DATE THEN
1228: l_dleg_rec.CARRIER_DATE := NULL;
1229: ELSIF p_del_leg_rec.CARRIER_DATE IS NOT NULL THEN
1230: l_dleg_rec.CARRIER_DATE := p_del_leg_rec.CARRIER_DATE;
1231: END IF;

Line 1232: IF p_del_leg_rec.DOC_ISSUE_OFFICE = FND_API.G_MISS_CHAR THEN

1228: l_dleg_rec.CARRIER_DATE := NULL;
1229: ELSIF p_del_leg_rec.CARRIER_DATE IS NOT NULL THEN
1230: l_dleg_rec.CARRIER_DATE := p_del_leg_rec.CARRIER_DATE;
1231: END IF;
1232: IF p_del_leg_rec.DOC_ISSUE_OFFICE = FND_API.G_MISS_CHAR THEN
1233: l_dleg_rec.DOC_ISSUE_OFFICE := NULL;
1234: ELSIF p_del_leg_rec.DOC_ISSUE_OFFICE IS NOT NULL THEN
1235: l_dleg_rec.DOC_ISSUE_OFFICE := p_del_leg_rec.DOC_ISSUE_OFFICE;
1236: END IF;

Line 1237: IF p_del_leg_rec.DOC_ISSUED_BY = FND_API.G_MISS_CHAR THEN

1233: l_dleg_rec.DOC_ISSUE_OFFICE := NULL;
1234: ELSIF p_del_leg_rec.DOC_ISSUE_OFFICE IS NOT NULL THEN
1235: l_dleg_rec.DOC_ISSUE_OFFICE := p_del_leg_rec.DOC_ISSUE_OFFICE;
1236: END IF;
1237: IF p_del_leg_rec.DOC_ISSUED_BY = FND_API.G_MISS_CHAR THEN
1238: l_dleg_rec.DOC_ISSUED_BY := NULL;
1239: ELSIF p_del_leg_rec.DOC_ISSUED_BY IS NOT NULL THEN
1240: l_dleg_rec.DOC_ISSUED_BY := p_del_leg_rec.DOC_ISSUED_BY;
1241: END IF;

Line 1242: IF p_del_leg_rec.DOC_DATE_ISSUED = FND_API.G_MISS_DATE THEN

1238: l_dleg_rec.DOC_ISSUED_BY := NULL;
1239: ELSIF p_del_leg_rec.DOC_ISSUED_BY IS NOT NULL THEN
1240: l_dleg_rec.DOC_ISSUED_BY := p_del_leg_rec.DOC_ISSUED_BY;
1241: END IF;
1242: IF p_del_leg_rec.DOC_DATE_ISSUED = FND_API.G_MISS_DATE THEN
1243: l_dleg_rec.DOC_DATE_ISSUED := NULL;
1244: ELSIF p_del_leg_rec.DOC_DATE_ISSUED IS NOT NULL THEN
1245: l_dleg_rec.DOC_DATE_ISSUED := p_del_leg_rec.DOC_ISSUED_BY;
1246: END IF;

Line 1247: IF p_del_leg_rec.SHIPPER_HM_BY = FND_API.G_MISS_CHAR THEN

1243: l_dleg_rec.DOC_DATE_ISSUED := NULL;
1244: ELSIF p_del_leg_rec.DOC_DATE_ISSUED IS NOT NULL THEN
1245: l_dleg_rec.DOC_DATE_ISSUED := p_del_leg_rec.DOC_ISSUED_BY;
1246: END IF;
1247: IF p_del_leg_rec.SHIPPER_HM_BY = FND_API.G_MISS_CHAR THEN
1248: l_dleg_rec.SHIPPER_HM_BY := NULL;
1249: ELSIF p_del_leg_rec.SHIPPER_HM_BY IS NOT NULL THEN
1250: l_dleg_rec.SHIPPER_HM_BY := p_del_leg_rec.SHIPPER_HM_BY;
1251: END IF;

Line 1252: IF p_del_leg_rec.SHIPPER_HM_DATE = FND_API.G_MISS_DATE THEN

1248: l_dleg_rec.SHIPPER_HM_BY := NULL;
1249: ELSIF p_del_leg_rec.SHIPPER_HM_BY IS NOT NULL THEN
1250: l_dleg_rec.SHIPPER_HM_BY := p_del_leg_rec.SHIPPER_HM_BY;
1251: END IF;
1252: IF p_del_leg_rec.SHIPPER_HM_DATE = FND_API.G_MISS_DATE THEN
1253: l_dleg_rec.SHIPPER_HM_DATE := NULL;
1254: ELSIF p_del_leg_rec.SHIPPER_HM_DATE IS NOT NULL THEN
1255: l_dleg_rec.SHIPPER_HM_DATE := p_del_leg_rec.SHIPPER_HM_DATE;
1256: END IF;

Line 1257: IF p_del_leg_rec.CARRIER_HM_BY = FND_API.G_MISS_CHAR THEN

1253: l_dleg_rec.SHIPPER_HM_DATE := NULL;
1254: ELSIF p_del_leg_rec.SHIPPER_HM_DATE IS NOT NULL THEN
1255: l_dleg_rec.SHIPPER_HM_DATE := p_del_leg_rec.SHIPPER_HM_DATE;
1256: END IF;
1257: IF p_del_leg_rec.CARRIER_HM_BY = FND_API.G_MISS_CHAR THEN
1258: l_dleg_rec.CARRIER_HM_BY := NULL;
1259: ELSIF p_del_leg_rec.CARRIER_HM_BY IS NOT NULL THEN
1260: l_dleg_rec.CARRIER_HM_BY := p_del_leg_rec.CARRIER_HM_BY;
1261: END IF;

Line 1262: IF p_del_leg_rec.CARRIER_HM_DATE = FND_API.G_MISS_DATE THEN

1258: l_dleg_rec.CARRIER_HM_BY := NULL;
1259: ELSIF p_del_leg_rec.CARRIER_HM_BY IS NOT NULL THEN
1260: l_dleg_rec.CARRIER_HM_BY := p_del_leg_rec.CARRIER_HM_BY;
1261: END IF;
1262: IF p_del_leg_rec.CARRIER_HM_DATE = FND_API.G_MISS_DATE THEN
1263: l_dleg_rec.CARRIER_HM_DATE := NULL;
1264: ELSIF p_del_leg_rec.CARRIER_HM_DATE IS NOT NULL THEN
1265: l_dleg_rec.CARRIER_HM_DATE := p_del_leg_rec.CARRIER_HM_DATE;
1266: END IF;

Line 1267: IF p_del_leg_rec.BOOKING_NUMBER = FND_API.G_MISS_CHAR THEN

1263: l_dleg_rec.CARRIER_HM_DATE := NULL;
1264: ELSIF p_del_leg_rec.CARRIER_HM_DATE IS NOT NULL THEN
1265: l_dleg_rec.CARRIER_HM_DATE := p_del_leg_rec.CARRIER_HM_DATE;
1266: END IF;
1267: IF p_del_leg_rec.BOOKING_NUMBER = FND_API.G_MISS_CHAR THEN
1268: l_dleg_rec.BOOKING_NUMBER := NULL;
1269: ELSIF p_del_leg_rec.BOOKING_NUMBER IS NOT NULL THEN
1270: l_dleg_rec.BOOKING_NUMBER := p_del_leg_rec.BOOKING_NUMBER;
1271: END IF;

Line 1272: IF p_del_leg_rec.PORT_OF_LOADING = FND_API.G_MISS_CHAR THEN

1268: l_dleg_rec.BOOKING_NUMBER := NULL;
1269: ELSIF p_del_leg_rec.BOOKING_NUMBER IS NOT NULL THEN
1270: l_dleg_rec.BOOKING_NUMBER := p_del_leg_rec.BOOKING_NUMBER;
1271: END IF;
1272: IF p_del_leg_rec.PORT_OF_LOADING = FND_API.G_MISS_CHAR THEN
1273: l_dleg_rec.PORT_OF_LOADING := NULL;
1274: ELSIF p_del_leg_rec.PORT_OF_LOADING IS NOT NULL THEN
1275: l_dleg_rec.PORT_OF_LOADING := p_del_leg_rec.PORT_OF_LOADING;
1276: END IF;

Line 1277: IF p_del_leg_rec.PORT_OF_DISCHARGE = FND_API.G_MISS_CHAR THEN

1273: l_dleg_rec.PORT_OF_LOADING := NULL;
1274: ELSIF p_del_leg_rec.PORT_OF_LOADING IS NOT NULL THEN
1275: l_dleg_rec.PORT_OF_LOADING := p_del_leg_rec.PORT_OF_LOADING;
1276: END IF;
1277: IF p_del_leg_rec.PORT_OF_DISCHARGE = FND_API.G_MISS_CHAR THEN
1278: l_dleg_rec.PORT_OF_DISCHARGE := NULL;
1279: ELSIF p_del_leg_rec.PORT_OF_DISCHARGE IS NOT NULL THEN
1280: l_dleg_rec.PORT_OF_DISCHARGE := p_del_leg_rec.PORT_OF_DISCHARGE;
1281: END IF;

Line 1282: IF p_del_leg_rec.SERVICE_CONTRACT = FND_API.G_MISS_CHAR THEN

1278: l_dleg_rec.PORT_OF_DISCHARGE := NULL;
1279: ELSIF p_del_leg_rec.PORT_OF_DISCHARGE IS NOT NULL THEN
1280: l_dleg_rec.PORT_OF_DISCHARGE := p_del_leg_rec.PORT_OF_DISCHARGE;
1281: END IF;
1282: IF p_del_leg_rec.SERVICE_CONTRACT = FND_API.G_MISS_CHAR THEN
1283: l_dleg_rec.SERVICE_CONTRACT := NULL;
1284: ELSIF p_del_leg_rec.SERVICE_CONTRACT IS NOT NULL THEN
1285: l_dleg_rec.SERVICE_CONTRACT := p_del_leg_rec.SERVICE_CONTRACT;
1286: END IF;

Line 1287: IF p_del_leg_rec.BILL_FREIGHT_TO = FND_API.G_MISS_CHAR THEN

1283: l_dleg_rec.SERVICE_CONTRACT := NULL;
1284: ELSIF p_del_leg_rec.SERVICE_CONTRACT IS NOT NULL THEN
1285: l_dleg_rec.SERVICE_CONTRACT := p_del_leg_rec.SERVICE_CONTRACT;
1286: END IF;
1287: IF p_del_leg_rec.BILL_FREIGHT_TO = FND_API.G_MISS_CHAR THEN
1288: l_dleg_rec.BILL_FREIGHT_TO := NULL;
1289: ELSIF p_del_leg_rec.BILL_FREIGHT_TO IS NOT NULL THEN
1290: l_dleg_rec.BILL_FREIGHT_TO := p_del_leg_rec.BILL_FREIGHT_TO;
1291: END IF;

Line 1292: IF p_del_leg_rec.FTE_TRIP_ID = FND_API.G_MISS_NUM THEN

1288: l_dleg_rec.BILL_FREIGHT_TO := NULL;
1289: ELSIF p_del_leg_rec.BILL_FREIGHT_TO IS NOT NULL THEN
1290: l_dleg_rec.BILL_FREIGHT_TO := p_del_leg_rec.BILL_FREIGHT_TO;
1291: END IF;
1292: IF p_del_leg_rec.FTE_TRIP_ID = FND_API.G_MISS_NUM THEN
1293: l_dleg_rec.FTE_TRIP_ID := NULL;
1294: ELSIF p_del_leg_rec.FTE_TRIP_ID IS NOT NULL THEN
1295: l_dleg_rec.FTE_TRIP_ID := p_del_leg_rec.FTE_TRIP_ID;
1296: END IF;

Line 1297: IF p_del_leg_rec.REPRICE_REQUIRED = FND_API.G_MISS_CHAR THEN

1293: l_dleg_rec.FTE_TRIP_ID := NULL;
1294: ELSIF p_del_leg_rec.FTE_TRIP_ID IS NOT NULL THEN
1295: l_dleg_rec.FTE_TRIP_ID := p_del_leg_rec.FTE_TRIP_ID;
1296: END IF;
1297: IF p_del_leg_rec.REPRICE_REQUIRED = FND_API.G_MISS_CHAR THEN
1298: l_dleg_rec.REPRICE_REQUIRED := NULL;
1299: ELSIF p_del_leg_rec.REPRICE_REQUIRED IS NOT NULL THEN
1300: l_dleg_rec.REPRICE_REQUIRED := p_del_leg_rec.REPRICE_REQUIRED;
1301: END IF;

Line 1302: IF p_del_leg_rec.ACTUAL_ARRIVAL_DATE = FND_API.G_MISS_DATE THEN

1298: l_dleg_rec.REPRICE_REQUIRED := NULL;
1299: ELSIF p_del_leg_rec.REPRICE_REQUIRED IS NOT NULL THEN
1300: l_dleg_rec.REPRICE_REQUIRED := p_del_leg_rec.REPRICE_REQUIRED;
1301: END IF;
1302: IF p_del_leg_rec.ACTUAL_ARRIVAL_DATE = FND_API.G_MISS_DATE THEN
1303: l_dleg_rec.ACTUAL_ARRIVAL_DATE := NULL;
1304: ELSIF p_del_leg_rec.ACTUAL_ARRIVAL_DATE IS NOT NULL THEN
1305: l_dleg_rec.ACTUAL_ARRIVAL_DATE := p_del_leg_rec.ACTUAL_ARRIVAL_DATE;
1306: END IF;

Line 1307: IF p_del_leg_rec.ACTUAL_DEPARTURE_DATE = FND_API.G_MISS_DATE THEN

1303: l_dleg_rec.ACTUAL_ARRIVAL_DATE := NULL;
1304: ELSIF p_del_leg_rec.ACTUAL_ARRIVAL_DATE IS NOT NULL THEN
1305: l_dleg_rec.ACTUAL_ARRIVAL_DATE := p_del_leg_rec.ACTUAL_ARRIVAL_DATE;
1306: END IF;
1307: IF p_del_leg_rec.ACTUAL_DEPARTURE_DATE = FND_API.G_MISS_DATE THEN
1308: l_dleg_rec.ACTUAL_DEPARTURE_DATE := NULL;
1309: ELSIF p_del_leg_rec.ACTUAL_DEPARTURE_DATE IS NOT NULL THEN
1310: l_dleg_rec.ACTUAL_DEPARTURE_DATE := p_del_leg_rec.ACTUAL_DEPARTURE_DATE;
1311: END IF;

Line 1312: IF p_del_leg_rec.ACTUAL_RECEIPT_DATE = FND_API.G_MISS_DATE THEN

1308: l_dleg_rec.ACTUAL_DEPARTURE_DATE := NULL;
1309: ELSIF p_del_leg_rec.ACTUAL_DEPARTURE_DATE IS NOT NULL THEN
1310: l_dleg_rec.ACTUAL_DEPARTURE_DATE := p_del_leg_rec.ACTUAL_DEPARTURE_DATE;
1311: END IF;
1312: IF p_del_leg_rec.ACTUAL_RECEIPT_DATE = FND_API.G_MISS_DATE THEN
1313: l_dleg_rec.ACTUAL_RECEIPT_DATE := NULL;
1314: ELSIF p_del_leg_rec.ACTUAL_RECEIPT_DATE IS NOT NULL THEN
1315: l_dleg_rec.ACTUAL_RECEIPT_DATE := p_del_leg_rec.ACTUAL_RECEIPT_DATE;
1316: END IF;

Line 1317: IF p_del_leg_rec.TRACKING_DRILLDOWN_FLAG = FND_API.G_MISS_CHAR THEN

1313: l_dleg_rec.ACTUAL_RECEIPT_DATE := NULL;
1314: ELSIF p_del_leg_rec.ACTUAL_RECEIPT_DATE IS NOT NULL THEN
1315: l_dleg_rec.ACTUAL_RECEIPT_DATE := p_del_leg_rec.ACTUAL_RECEIPT_DATE;
1316: END IF;
1317: IF p_del_leg_rec.TRACKING_DRILLDOWN_FLAG = FND_API.G_MISS_CHAR THEN
1318: l_dleg_rec.TRACKING_DRILLDOWN_FLAG := NULL;
1319: ELSIF p_del_leg_rec.TRACKING_DRILLDOWN_FLAG IS NOT NULL THEN
1320: l_dleg_rec.TRACKING_DRILLDOWN_FLAG := p_del_leg_rec.TRACKING_DRILLDOWN_FLAG;
1321: END IF;

Line 1322: IF p_del_leg_rec.STATUS_CODE = FND_API.G_MISS_CHAR THEN

1318: l_dleg_rec.TRACKING_DRILLDOWN_FLAG := NULL;
1319: ELSIF p_del_leg_rec.TRACKING_DRILLDOWN_FLAG IS NOT NULL THEN
1320: l_dleg_rec.TRACKING_DRILLDOWN_FLAG := p_del_leg_rec.TRACKING_DRILLDOWN_FLAG;
1321: END IF;
1322: IF p_del_leg_rec.STATUS_CODE = FND_API.G_MISS_CHAR THEN
1323: l_dleg_rec.STATUS_CODE := NULL;
1324: ELSIF p_del_leg_rec.STATUS_CODE IS NOT NULL THEN
1325: l_dleg_rec.STATUS_CODE := p_del_leg_rec.STATUS_CODE;
1326: END IF;

Line 1327: IF p_del_leg_rec.TRACKING_REMARKS = FND_API.G_MISS_CHAR THEN

1323: l_dleg_rec.STATUS_CODE := NULL;
1324: ELSIF p_del_leg_rec.STATUS_CODE IS NOT NULL THEN
1325: l_dleg_rec.STATUS_CODE := p_del_leg_rec.STATUS_CODE;
1326: END IF;
1327: IF p_del_leg_rec.TRACKING_REMARKS = FND_API.G_MISS_CHAR THEN
1328: l_dleg_rec.TRACKING_REMARKS := NULL;
1329: ELSIF p_del_leg_rec.TRACKING_REMARKS IS NOT NULL THEN
1330: l_dleg_rec.TRACKING_REMARKS := p_del_leg_rec.TRACKING_REMARKS;
1331: END IF;

Line 1332: IF p_del_leg_rec.CARRIER_EST_DEPARTURE_DATE = FND_API.G_MISS_DATE THEN

1328: l_dleg_rec.TRACKING_REMARKS := NULL;
1329: ELSIF p_del_leg_rec.TRACKING_REMARKS IS NOT NULL THEN
1330: l_dleg_rec.TRACKING_REMARKS := p_del_leg_rec.TRACKING_REMARKS;
1331: END IF;
1332: IF p_del_leg_rec.CARRIER_EST_DEPARTURE_DATE = FND_API.G_MISS_DATE THEN
1333: l_dleg_rec.CARRIER_EST_DEPARTURE_DATE := NULL;
1334: ELSIF p_del_leg_rec.CARRIER_EST_DEPARTURE_DATE IS NOT NULL THEN
1335: l_dleg_rec.CARRIER_EST_DEPARTURE_DATE := p_del_leg_rec.CARRIER_EST_DEPARTURE_DATE;
1336: END IF;

Line 1337: IF p_del_leg_rec.CARRIER_EST_ARRIVAL_DATE = FND_API.G_MISS_DATE THEN

1333: l_dleg_rec.CARRIER_EST_DEPARTURE_DATE := NULL;
1334: ELSIF p_del_leg_rec.CARRIER_EST_DEPARTURE_DATE IS NOT NULL THEN
1335: l_dleg_rec.CARRIER_EST_DEPARTURE_DATE := p_del_leg_rec.CARRIER_EST_DEPARTURE_DATE;
1336: END IF;
1337: IF p_del_leg_rec.CARRIER_EST_ARRIVAL_DATE = FND_API.G_MISS_DATE THEN
1338: l_dleg_rec.CARRIER_EST_ARRIVAL_DATE := NULL;
1339: ELSIF p_del_leg_rec.CARRIER_EST_ARRIVAL_DATE IS NOT NULL THEN
1340: l_dleg_rec.CARRIER_EST_ARRIVAL_DATE := p_del_leg_rec.CARRIER_EST_ARRIVAL_DATE;
1341: END IF;

Line 1342: IF p_del_leg_rec.LOADING_START_DATETIME = FND_API.G_MISS_DATE THEN

1338: l_dleg_rec.CARRIER_EST_ARRIVAL_DATE := NULL;
1339: ELSIF p_del_leg_rec.CARRIER_EST_ARRIVAL_DATE IS NOT NULL THEN
1340: l_dleg_rec.CARRIER_EST_ARRIVAL_DATE := p_del_leg_rec.CARRIER_EST_ARRIVAL_DATE;
1341: END IF;
1342: IF p_del_leg_rec.LOADING_START_DATETIME = FND_API.G_MISS_DATE THEN
1343: l_dleg_rec.LOADING_START_DATETIME := NULL;
1344: ELSIF p_del_leg_rec.LOADING_START_DATETIME IS NOT NULL THEN
1345: l_dleg_rec.LOADING_START_DATETIME := p_del_leg_rec.LOADING_START_DATETIME;
1346: END IF;

Line 1347: IF p_del_leg_rec.LOADING_END_DATETIME = FND_API.G_MISS_DATE THEN

1343: l_dleg_rec.LOADING_START_DATETIME := NULL;
1344: ELSIF p_del_leg_rec.LOADING_START_DATETIME IS NOT NULL THEN
1345: l_dleg_rec.LOADING_START_DATETIME := p_del_leg_rec.LOADING_START_DATETIME;
1346: END IF;
1347: IF p_del_leg_rec.LOADING_END_DATETIME = FND_API.G_MISS_DATE THEN
1348: l_dleg_rec.LOADING_END_DATETIME := NULL;
1349: ELSIF p_del_leg_rec.LOADING_END_DATETIME IS NOT NULL THEN
1350: l_dleg_rec.LOADING_END_DATETIME := p_del_leg_rec.LOADING_END_DATETIME;
1351: END IF;

Line 1352: IF p_del_leg_rec.UNLOADING_START_DATETIME = FND_API.G_MISS_DATE THEN

1348: l_dleg_rec.LOADING_END_DATETIME := NULL;
1349: ELSIF p_del_leg_rec.LOADING_END_DATETIME IS NOT NULL THEN
1350: l_dleg_rec.LOADING_END_DATETIME := p_del_leg_rec.LOADING_END_DATETIME;
1351: END IF;
1352: IF p_del_leg_rec.UNLOADING_START_DATETIME = FND_API.G_MISS_DATE THEN
1353: l_dleg_rec.UNLOADING_START_DATETIME := NULL;
1354: ELSIF p_del_leg_rec.UNLOADING_START_DATETIME IS NOT NULL THEN
1355: l_dleg_rec.UNLOADING_START_DATETIME := p_del_leg_rec.UNLOADING_START_DATETIME;
1356: END IF;

Line 1357: IF p_del_leg_rec.UNLOADING_END_DATETIME = FND_API.G_MISS_DATE THEN

1353: l_dleg_rec.UNLOADING_START_DATETIME := NULL;
1354: ELSIF p_del_leg_rec.UNLOADING_START_DATETIME IS NOT NULL THEN
1355: l_dleg_rec.UNLOADING_START_DATETIME := p_del_leg_rec.UNLOADING_START_DATETIME;
1356: END IF;
1357: IF p_del_leg_rec.UNLOADING_END_DATETIME = FND_API.G_MISS_DATE THEN
1358: l_dleg_rec.UNLOADING_END_DATETIME := NULL;
1359: ELSIF p_del_leg_rec.UNLOADING_END_DATETIME IS NOT NULL THEN
1360: l_dleg_rec.UNLOADING_END_DATETIME := p_del_leg_rec.UNLOADING_END_DATETIME;
1361: END IF;

Line 1362: IF p_del_leg_rec.DELIVERED_QUANTITY = FND_API.G_MISS_NUM THEN

1358: l_dleg_rec.UNLOADING_END_DATETIME := NULL;
1359: ELSIF p_del_leg_rec.UNLOADING_END_DATETIME IS NOT NULL THEN
1360: l_dleg_rec.UNLOADING_END_DATETIME := p_del_leg_rec.UNLOADING_END_DATETIME;
1361: END IF;
1362: IF p_del_leg_rec.DELIVERED_QUANTITY = FND_API.G_MISS_NUM THEN
1363: l_dleg_rec.DELIVERED_QUANTITY := NULL;
1364: ELSIF p_del_leg_rec.DELIVERED_QUANTITY IS NOT NULL THEN
1365: l_dleg_rec.DELIVERED_QUANTITY := p_del_leg_rec.DELIVERED_QUANTITY;
1366: END IF;

Line 1367: IF p_del_leg_rec.LOADED_QUANTITY = FND_API.G_MISS_NUM THEN

1363: l_dleg_rec.DELIVERED_QUANTITY := NULL;
1364: ELSIF p_del_leg_rec.DELIVERED_QUANTITY IS NOT NULL THEN
1365: l_dleg_rec.DELIVERED_QUANTITY := p_del_leg_rec.DELIVERED_QUANTITY;
1366: END IF;
1367: IF p_del_leg_rec.LOADED_QUANTITY = FND_API.G_MISS_NUM THEN
1368: l_dleg_rec.LOADED_QUANTITY := NULL;
1369: ELSIF p_del_leg_rec.LOADED_QUANTITY IS NOT NULL THEN
1370: l_dleg_rec.LOADED_QUANTITY := p_del_leg_rec.LOADED_QUANTITY;
1371: END IF;

Line 1372: IF p_del_leg_rec.RECEIVED_QUANTITY = FND_API.G_MISS_NUM THEN

1368: l_dleg_rec.LOADED_QUANTITY := NULL;
1369: ELSIF p_del_leg_rec.LOADED_QUANTITY IS NOT NULL THEN
1370: l_dleg_rec.LOADED_QUANTITY := p_del_leg_rec.LOADED_QUANTITY;
1371: END IF;
1372: IF p_del_leg_rec.RECEIVED_QUANTITY = FND_API.G_MISS_NUM THEN
1373: l_dleg_rec.RECEIVED_QUANTITY := NULL;
1374: ELSIF p_del_leg_rec.RECEIVED_QUANTITY IS NOT NULL THEN
1375: l_dleg_rec.RECEIVED_QUANTITY := p_del_leg_rec.RECEIVED_QUANTITY;
1376: END IF;

Line 1377: IF p_del_leg_rec.ORIGIN_STOP_ID = FND_API.G_MISS_NUM THEN

1373: l_dleg_rec.RECEIVED_QUANTITY := NULL;
1374: ELSIF p_del_leg_rec.RECEIVED_QUANTITY IS NOT NULL THEN
1375: l_dleg_rec.RECEIVED_QUANTITY := p_del_leg_rec.RECEIVED_QUANTITY;
1376: END IF;
1377: IF p_del_leg_rec.ORIGIN_STOP_ID = FND_API.G_MISS_NUM THEN
1378: l_dleg_rec.ORIGIN_STOP_ID := NULL;
1379: ELSIF p_del_leg_rec.ORIGIN_STOP_ID IS NOT NULL THEN
1380: l_dleg_rec.ORIGIN_STOP_ID := p_del_leg_rec.ORIGIN_STOP_ID;
1381: END IF;

Line 1382: IF p_del_leg_rec.DESTINATION_STOP_ID = FND_API.G_MISS_NUM THEN

1378: l_dleg_rec.ORIGIN_STOP_ID := NULL;
1379: ELSIF p_del_leg_rec.ORIGIN_STOP_ID IS NOT NULL THEN
1380: l_dleg_rec.ORIGIN_STOP_ID := p_del_leg_rec.ORIGIN_STOP_ID;
1381: END IF;
1382: IF p_del_leg_rec.DESTINATION_STOP_ID = FND_API.G_MISS_NUM THEN
1383: l_dleg_rec.DESTINATION_STOP_ID := NULL;
1384: ELSIF p_del_leg_rec.DESTINATION_STOP_ID IS NOT NULL THEN
1385: l_dleg_rec.DESTINATION_STOP_ID := p_del_leg_rec.DESTINATION_STOP_ID;
1386: END IF;

Line 1387: IF p_del_leg_rec.parent_delivery_leg_id = FND_API.G_MISS_NUM THEN

1383: l_dleg_rec.DESTINATION_STOP_ID := NULL;
1384: ELSIF p_del_leg_rec.DESTINATION_STOP_ID IS NOT NULL THEN
1385: l_dleg_rec.DESTINATION_STOP_ID := p_del_leg_rec.DESTINATION_STOP_ID;
1386: END IF;
1387: IF p_del_leg_rec.parent_delivery_leg_id = FND_API.G_MISS_NUM THEN
1388: l_dleg_rec.parent_delivery_leg_id := NULL;
1389: ELSIF p_del_leg_rec.parent_delivery_leg_id IS NOT NULL THEN
1390: l_dleg_rec.parent_delivery_leg_id := p_del_leg_rec.parent_delivery_leg_id;
1391: END IF;