APPS.PV_ENTYRLS_PVT dependencies on PV_ENTITY_RULES_APPLIED

Line 115: -- Invoke table handler(PV_ENTITY_RULES_APPLIED_PKG.Insert_Row)

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

Line 116: PV_ENTITY_RULES_APPLIED_PKG.Insert_Row(

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

Line 236: From PV_ENTITY_RULES_APPLIED

232:
233: IS
234: Cursor C_Get_entyrls(pc_ENTITY_RULE_APPLIED_ID Number) IS
235: Select object_version_number
236: From PV_ENTITY_RULES_APPLIED
237: where entity_rule_applied_id = pc_entity_rule_applied_id
238: For Update NOWAIT;
239:
240: l_api_name CONSTANT VARCHAR2(30) := 'Update_entyrls';

Line 359: -- Invoke table handler(PV_ENTITY_RULES_APPLIED_PKG.Update_Row)

355:
356: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
357: END IF;
358:
359: -- Invoke table handler(PV_ENTITY_RULES_APPLIED_PKG.Update_Row)
360: PV_ENTITY_RULES_APPLIED_PKG.Update_Row(
361: p_ENTITY_RULE_APPLIED_ID => p_ENTYRLS_rec.ENTITY_RULE_APPLIED_ID
362: ,p_LAST_UPDATE_DATE => SYSDATE
363: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

Line 360: PV_ENTITY_RULES_APPLIED_PKG.Update_Row(

356: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
357: END IF;
358:
359: -- Invoke table handler(PV_ENTITY_RULES_APPLIED_PKG.Update_Row)
360: PV_ENTITY_RULES_APPLIED_PKG.Update_Row(
361: p_ENTITY_RULE_APPLIED_ID => p_ENTYRLS_rec.ENTITY_RULE_APPLIED_ID
362: ,p_LAST_UPDATE_DATE => SYSDATE
363: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
364: ,p_CREATION_DATE => FND_API.G_MISS_DATE

Line 515: -- Invoke table handler(PV_ENTITY_RULES_APPLIED_PKG.Delete_Row)

511:
512: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
513: END IF;
514:
515: -- Invoke table handler(PV_ENTITY_RULES_APPLIED_PKG.Delete_Row)
516: PV_ENTITY_RULES_APPLIED_PKG.Delete_Row(
517: p_ENTITY_RULE_APPLIED_ID => p_ENTYRLS_rec.ENTITY_RULE_APPLIED_ID);
518: --
519: -- End of API body

Line 516: PV_ENTITY_RULES_APPLIED_PKG.Delete_Row(

512: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
513: END IF;
514:
515: -- Invoke table handler(PV_ENTITY_RULES_APPLIED_PKG.Delete_Row)
516: PV_ENTITY_RULES_APPLIED_PKG.Delete_Row(
517: p_ENTITY_RULE_APPLIED_ID => p_ENTYRLS_rec.ENTITY_RULE_APPLIED_ID);
518: --
519: -- End of API body
520: --

Line 589: FROM pv_entity_rules_applied

585: )
586: IS
587: CURSOR C_entity_rule_applied_exists (pc_entity_rule_applied_id NUMBER) IS
588: SELECT 'X'
589: FROM pv_entity_rules_applied
590: WHERE entity_rule_applied_id = pc_entity_rule_applied_id;
591:
592: l_val VARCHAR2(1);
593: BEGIN

Line 711: p_TABLE_NAME => 'PV_ENTITY_RULES_APPLIED',

707:
708: pv_common_checks_pvt.Validate_Lookup(
709: p_init_msg_list => FND_API.G_FALSE,
710: p_validation_mode => p_validation_mode,
711: p_TABLE_NAME => 'PV_ENTITY_RULES_APPLIED',
712: p_COLUMN_NAME => 'ENTITY',
713: p_lookup_type => 'PV_RULE_APPLIED_ENTITY_TYPE',
714: p_lookup_code => P_ENTYRLS_Rec.ENTITY,
715: x_return_status => x_return_status,

Line 750: p_TABLE_NAME => 'PV_ENTITY_RULES_APPLIED',

746:
747: pv_common_checks_pvt.Validate_Lookup(
748: p_init_msg_list => FND_API.G_FALSE,
749: p_validation_mode => p_validation_mode,
750: p_TABLE_NAME => 'PV_ENTITY_RULES_APPLIED',
751: p_COLUMN_NAME => 'PROCESS_TYPE',
752: p_lookup_type => 'PV_PROCESS_TYPE',
753: p_lookup_code => P_ENTYRLS_Rec.PROCESS_TYPE,
754: x_return_status => x_return_status,

Line 789: p_TABLE_NAME => 'PV_ENTITY_RULES_APPLIED',

785:
786: pv_common_checks_pvt.Validate_Lookup(
787: p_init_msg_list => FND_API.G_FALSE,
788: p_validation_mode => p_validation_mode,
789: p_TABLE_NAME => 'PV_ENTITY_RULES_APPLIED',
790: p_COLUMN_NAME => 'PROCESS_STATUS',
791: p_lookup_type => 'PV_RULES_APPLIED_STATUS',
792: p_lookup_code => P_ENTYRLS_Rec.PROCESS_STATUS,
793: x_return_status => x_return_status,