726: l_carrier_ser_tab.ATTRIBUTE13 := p_rec_attr_tab.ATTRIBUTE13;
727: l_carrier_ser_tab.ATTRIBUTE14 := p_rec_attr_tab.ATTRIBUTE14;
728: l_carrier_ser_tab.ATTRIBUTE15 := p_rec_attr_tab.ATTRIBUTE15;
729: l_carrier_ser_tab.Creation_Date := SYSDATE;
730: l_carrier_ser_tab.Created_By := fnd_global.user_id;
731: l_carrier_ser_tab.Last_Update_Date := SYSDATE;
732: l_carrier_ser_tab.Last_Updated_By := fnd_global.user_id;
733:
734: -- Pack J
728: l_carrier_ser_tab.ATTRIBUTE15 := p_rec_attr_tab.ATTRIBUTE15;
729: l_carrier_ser_tab.Creation_Date := SYSDATE;
730: l_carrier_ser_tab.Created_By := fnd_global.user_id;
731: l_carrier_ser_tab.Last_Update_Date := SYSDATE;
732: l_carrier_ser_tab.Last_Updated_By := fnd_global.user_id;
733:
734: -- Pack J
735: l_carrier_ser_tab.MAX_NUM_STOPS_PERMITTED := p_rec_attr_tab.MAX_NUM_STOPS_PERMITTED;
736: l_carrier_ser_tab.MAX_TOTAL_DISTANCE := p_rec_attr_tab.MAX_TOTAL_DISTANCE;
1101: l_org_car_ser_tab.ATTRIBUTE13 := p_rec_org_car_ser_tab.ATTRIBUTE13;
1102: l_org_car_ser_tab.ATTRIBUTE14 := p_rec_org_car_ser_tab.ATTRIBUTE14;
1103: l_org_car_ser_tab.ATTRIBUTE15 := p_rec_org_car_ser_tab.ATTRIBUTE15;
1104: l_org_car_ser_tab.CREATION_DATE := SYSDATE;
1105: l_org_car_ser_tab.CREATED_BY := fnd_global.user_id;
1106: l_org_car_ser_tab.LAST_UPDATE_DATE := SYSDATE;
1107: l_org_car_ser_tab.LAST_UPDATED_BY := fnd_global.user_id;
1108:
1109: -- BugFix#3296461
1103: l_org_car_ser_tab.ATTRIBUTE15 := p_rec_org_car_ser_tab.ATTRIBUTE15;
1104: l_org_car_ser_tab.CREATION_DATE := SYSDATE;
1105: l_org_car_ser_tab.CREATED_BY := fnd_global.user_id;
1106: l_org_car_ser_tab.LAST_UPDATE_DATE := SYSDATE;
1107: l_org_car_ser_tab.LAST_UPDATED_BY := fnd_global.user_id;
1108:
1109: -- BugFix#3296461
1110: l_org_car_ser_tab.DISTRIBUTION_ACCOUNT := p_rec_org_car_ser_tab.DISTRIBUTION_ACCOUNT;
1111:
1127: l_car_info_tab.ATTRIBUTE13 := p_rec_car_dff_tab.ATTRIBUTE13;
1128: l_car_info_tab.ATTRIBUTE14 := p_rec_car_dff_tab.ATTRIBUTE14;
1129: l_car_info_tab.ATTRIBUTE15 := p_rec_car_dff_tab.ATTRIBUTE15;
1130: l_car_info_tab.CREATION_DATE := SYSDATE;
1131: l_car_info_tab.CREATED_BY := fnd_global.user_id;
1132: l_car_info_tab.LAST_UPDATE_DATE := SYSDATE;
1133: l_car_info_tab.LAST_UPDATED_BY := fnd_global.user_id;
1134:
1135:
1129: l_car_info_tab.ATTRIBUTE15 := p_rec_car_dff_tab.ATTRIBUTE15;
1130: l_car_info_tab.CREATION_DATE := SYSDATE;
1131: l_car_info_tab.CREATED_BY := fnd_global.user_id;
1132: l_car_info_tab.LAST_UPDATE_DATE := SYSDATE;
1133: l_car_info_tab.LAST_UPDATED_BY := fnd_global.user_id;
1134:
1135:
1136:
1137: l_shp_method_rec.Carrier_Id := l_carrier_id;
1155: l_shp_method_rec.ATTRIBUTE13 := p_shp_methods_dff.ATTRIBUTE13;
1156: l_shp_method_rec.ATTRIBUTE14 := p_shp_methods_dff.ATTRIBUTE14;
1157: l_shp_method_rec.ATTRIBUTE15 := p_shp_methods_dff.ATTRIBUTE15;
1158: l_shp_method_rec.CREATION_DATE := SYSDATE;
1159: l_shp_method_rec.CREATED_BY := fnd_global.user_id;
1160: l_shp_method_rec.LAST_UPDATE_DATE := SYSDATE;
1161: l_shp_method_rec.LAST_UPDATED_BY := fnd_global.user_id;
1162: IF p_action_code = 'ASSIGN' THEN
1163: l_shp_method_rec.Enabled_Flag := 'Y';
1157: l_shp_method_rec.ATTRIBUTE15 := p_shp_methods_dff.ATTRIBUTE15;
1158: l_shp_method_rec.CREATION_DATE := SYSDATE;
1159: l_shp_method_rec.CREATED_BY := fnd_global.user_id;
1160: l_shp_method_rec.LAST_UPDATE_DATE := SYSDATE;
1161: l_shp_method_rec.LAST_UPDATED_BY := fnd_global.user_id;
1162: IF p_action_code = 'ASSIGN' THEN
1163: l_shp_method_rec.Enabled_Flag := 'Y';
1164: l_org_car_ser_tab.ENABLED_FLAG := 'Y';
1165: ELSIF p_action_code = 'UNASSIGN' THEN
1389: p_rec_org_car_ser_tab.CARRIER_SERVICE_ID := l_carrier_service_id;
1390: p_rec_org_car_ser_tab.ORGANIZATION_ID := p_organization_id;
1391:
1392: p_rec_org_car_ser_tab.CREATION_DATE := SYSDATE;
1393: p_rec_org_car_ser_tab.CREATED_BY := fnd_global.user_id;
1394: p_rec_org_car_ser_tab.LAST_UPDATE_DATE := SYSDATE;
1395: p_rec_org_car_ser_tab.LAST_UPDATED_BY :=fnd_global.user_id;
1396:
1397: p_rec_car_info_tab.CREATION_DATE := SYSDATE;
1391:
1392: p_rec_org_car_ser_tab.CREATION_DATE := SYSDATE;
1393: p_rec_org_car_ser_tab.CREATED_BY := fnd_global.user_id;
1394: p_rec_org_car_ser_tab.LAST_UPDATE_DATE := SYSDATE;
1395: p_rec_org_car_ser_tab.LAST_UPDATED_BY :=fnd_global.user_id;
1396:
1397: p_rec_car_info_tab.CREATION_DATE := SYSDATE;
1398: p_rec_car_info_tab.CREATED_BY := fnd_global.user_id;
1399: p_rec_car_info_tab.LAST_UPDATE_DATE := SYSDATE;
1394: p_rec_org_car_ser_tab.LAST_UPDATE_DATE := SYSDATE;
1395: p_rec_org_car_ser_tab.LAST_UPDATED_BY :=fnd_global.user_id;
1396:
1397: p_rec_car_info_tab.CREATION_DATE := SYSDATE;
1398: p_rec_car_info_tab.CREATED_BY := fnd_global.user_id;
1399: p_rec_car_info_tab.LAST_UPDATE_DATE := SYSDATE;
1400: p_rec_car_info_tab.LAST_UPDATED_BY :=fnd_global.user_id;
1401:
1402: p_car_shp_methods.CREATION_DATE := SYSDATE;
1396:
1397: p_rec_car_info_tab.CREATION_DATE := SYSDATE;
1398: p_rec_car_info_tab.CREATED_BY := fnd_global.user_id;
1399: p_rec_car_info_tab.LAST_UPDATE_DATE := SYSDATE;
1400: p_rec_car_info_tab.LAST_UPDATED_BY :=fnd_global.user_id;
1401:
1402: p_car_shp_methods.CREATION_DATE := SYSDATE;
1403: p_car_shp_methods.CREATED_BY := fnd_global.user_id;
1404: p_car_shp_methods.LAST_UPDATE_DATE := SYSDATE;
1399: p_rec_car_info_tab.LAST_UPDATE_DATE := SYSDATE;
1400: p_rec_car_info_tab.LAST_UPDATED_BY :=fnd_global.user_id;
1401:
1402: p_car_shp_methods.CREATION_DATE := SYSDATE;
1403: p_car_shp_methods.CREATED_BY := fnd_global.user_id;
1404: p_car_shp_methods.LAST_UPDATE_DATE := SYSDATE;
1405: p_car_shp_methods.LAST_UPDATED_BY := fnd_global.user_id;
1406:
1407: Assign_Org_Carrier_Service(
1401:
1402: p_car_shp_methods.CREATION_DATE := SYSDATE;
1403: p_car_shp_methods.CREATED_BY := fnd_global.user_id;
1404: p_car_shp_methods.LAST_UPDATE_DATE := SYSDATE;
1405: p_car_shp_methods.LAST_UPDATED_BY := fnd_global.user_id;
1406:
1407: Assign_Org_Carrier_Service(
1408: p_action_code =>p_action_code,
1409: p_rec_org_car_ser_tab =>p_rec_org_car_ser_tab,