APPS.PV_ENTYROUT_PVT dependencies on PV_ENTITY_ROUTINGS

Line 114: -- Invoke table handler(PV_ENTITY_ROUTINGS_PKG.Insert_Row)

110:
111: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
112: END IF;
113:
114: -- Invoke table handler(PV_ENTITY_ROUTINGS_PKG.Insert_Row)
115: PV_ENTITY_ROUTINGS_PKG.Insert_Row(
116: px_ENTITY_ROUTING_ID => x_ENTITY_ROUTING_ID
117: ,p_LAST_UPDATE_DATE => SYSDATE
118: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

Line 115: PV_ENTITY_ROUTINGS_PKG.Insert_Row(

111: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
112: END IF;
113:
114: -- Invoke table handler(PV_ENTITY_ROUTINGS_PKG.Insert_Row)
115: PV_ENTITY_ROUTINGS_PKG.Insert_Row(
116: px_ENTITY_ROUTING_ID => x_ENTITY_ROUTING_ID
117: ,p_LAST_UPDATE_DATE => SYSDATE
118: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
119: ,p_CREATION_DATE => SYSDATE

Line 239: From PV_ENTITY_ROUTINGS

235:
236: Cursor C_Get_entyrout(pc_ENTITY_ROUTING_ID Number) IS
237: Select
238: object_version_number
239: From PV_ENTITY_ROUTINGS
240: where entity_routing_id = pc_entity_routing_id
241: For Update NOWAIT;
242:
243: l_api_name CONSTANT VARCHAR2(30) := 'Update_entyrout';

Line 362: -- Invoke table handler(PV_ENTITY_ROUTINGS_PKG.Update_Row)

358:
359: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
360: END IF;
361:
362: -- Invoke table handler(PV_ENTITY_ROUTINGS_PKG.Update_Row)
363: PV_ENTITY_ROUTINGS_PKG.Update_Row(
364: p_ENTITY_ROUTING_ID => p_ENTYROUT_rec.ENTITY_ROUTING_ID
365: ,p_LAST_UPDATE_DATE => SYSDATE
366: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

Line 363: PV_ENTITY_ROUTINGS_PKG.Update_Row(

359: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
360: END IF;
361:
362: -- Invoke table handler(PV_ENTITY_ROUTINGS_PKG.Update_Row)
363: PV_ENTITY_ROUTINGS_PKG.Update_Row(
364: p_ENTITY_ROUTING_ID => p_ENTYROUT_rec.ENTITY_ROUTING_ID
365: ,p_LAST_UPDATE_DATE => SYSDATE
366: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
367: ,p_CREATION_DATE => FND_API.G_MISS_DATE

Line 519: -- Invoke table handler(PV_ENTITY_ROUTINGS_PKG.Delete_Row)

515:
516: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
517: END IF;
518:
519: -- Invoke table handler(PV_ENTITY_ROUTINGS_PKG.Delete_Row)
520: PV_ENTITY_ROUTINGS_PKG.Delete_Row(
521: p_ENTITY_ROUTING_ID => p_ENTYROUT_rec.ENTITY_ROUTING_ID);
522: --
523: -- End of API body

Line 520: PV_ENTITY_ROUTINGS_PKG.Delete_Row(

516: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
517: END IF;
518:
519: -- Invoke table handler(PV_ENTITY_ROUTINGS_PKG.Delete_Row)
520: PV_ENTITY_ROUTINGS_PKG.Delete_Row(
521: p_ENTITY_ROUTING_ID => p_ENTYROUT_rec.ENTITY_ROUTING_ID);
522: --
523: -- End of API body
524: --

Line 593: FROM pv_entity_routings

589: )
590: IS
591: CURSOR C_entity_routing_id_exists (pc_entity_routing_id NUMBER) IS
592: SELECT 'X'
593: FROM pv_entity_routings
594: WHERE entity_routing_id = pc_entity_routing_id;
595:
596: l_val VARCHAR2(1);
597: BEGIN

Line 776: p_TABLE_NAME => 'PV_ENTITY_ROUTINGS',

772:
773: pv_common_checks_pvt.Validate_Lookup(
774: p_init_msg_list => FND_API.G_FALSE,
775: p_validation_mode => p_validation_mode,
776: p_TABLE_NAME => 'PV_ENTITY_ROUTINGS',
777: p_COLUMN_NAME => 'DISTANCE_UOM_CODE',
778: p_lookup_type => 'PV_DISTANCE_UOM',
779: p_lookup_code => P_ENTYROUT_Rec.DISTANCE_UOM_CODE,
780: x_return_status => x_return_status,

Line 796: p_TABLE_NAME => 'PV_ENTITY_ROUTINGS',

792:
793: pv_common_checks_pvt.Validate_Lookup(
794: p_init_msg_list => FND_API.G_FALSE,
795: p_validation_mode => p_validation_mode,
796: p_TABLE_NAME => 'PV_ENTITY_ROUTINGS',
797: p_COLUMN_NAME => 'ROUTING_TYPE',
798: p_lookup_type => 'PV_ASSIGNMENT_TYPE',
799: p_lookup_code => P_ENTYROUT_Rec.ROUTING_TYPE,
800: x_return_status => x_return_status,

Line 828: p_TABLE_NAME => 'PV_ENTITY_ROUTINGS',

824:
825: pv_common_checks_pvt.Validate_Lookup(
826: p_init_msg_list => FND_API.G_FALSE,
827: p_validation_mode => p_validation_mode,
828: p_TABLE_NAME => 'PV_ENTITY_ROUTINGS',
829: p_COLUMN_NAME => 'CM_TIMEOUT_UOM_CODE',
830: p_lookup_type => 'PV_TIMEOUT_UOM',
831: p_lookup_code => P_ENTYROUT_Rec.CM_TIMEOUT_UOM_CODE,
832: x_return_status => x_return_status,

Line 868: p_TABLE_NAME => 'PV_ENTITY_ROUTINGS',

864:
865: pv_common_checks_pvt.Validate_Lookup(
866: p_init_msg_list => FND_API.G_FALSE,
867: p_validation_mode => p_validation_mode,
868: p_TABLE_NAME => 'PV_ENTITY_ROUTINGS',
869: p_COLUMN_NAME => 'PARTNER_TIMEOUT_UOM_CODE',
870: p_lookup_type => 'PV_TIMEOUT_UOM',
871: p_lookup_code => P_ENTYROUT_Rec.PARTNER_TIMEOUT_UOM_CODE,
872: x_return_status => x_return_status,