185: END IF;
186:
187:
188: -- Invoke table handler(PV_PROCESS_RULES_B_PKG.Insert_Row)
189: PV_PROCESS_RULES_PKG.Insert_Row(
190: px_PROCESS_RULE_ID => x_PROCESS_RULE_ID
191: ,p_PARENT_RULE_ID => p_PROCESS_RULE_rec.PARENT_RULE_ID
192: ,p_LAST_UPDATE_DATE => SYSDATE
193: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
487: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
488: END IF;
489:
490: -- Invoke table handler(PV_PROCESS_RULES_B_PKG.Update_Row)
491: PV_PROCESS_RULES_PKG.Update_Row(
492: p_PROCESS_RULE_ID => p_PROCESS_RULE_rec.PROCESS_RULE_ID
493: ,p_LAST_UPDATE_DATE => SYSDATE
494: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
495: ,p_CREATION_DATE => FND_API.G_MISS_DATE
906:
907: -- Debug Message
908: IF (AS_DEBUG_HIGH_ON) THEN
909:
910: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: PV_PROCESS_RULES_PKG.Delete_Row');
911: END IF;
912:
913: -- Invoke table handler(PV_PROCESS_RULES_B_PKG.Delete_Row)
914: PV_PROCESS_RULES_PKG.Delete_Row(
910: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: PV_PROCESS_RULES_PKG.Delete_Row');
911: END IF;
912:
913: -- Invoke table handler(PV_PROCESS_RULES_B_PKG.Delete_Row)
914: PV_PROCESS_RULES_PKG.Delete_Row(
915: p_PROCESS_RULE_ID => p_PROCESS_RULE_rec.PROCESS_RULE_ID);
916: --
917: -- End of API body
918: --
927: loop
928: fetch lc_get_parent_rule_id into l_process_rule_id;
929: exit when lc_get_parent_rule_id%notfound;
930:
931: PV_PROCESS_RULES_PKG.Delete_Row(
932: p_PROCESS_RULE_ID => l_process_rule_id);
933:
934: -- Check return status from the above procedure call
935: IF x_return_status = FND_API.G_RET_STS_ERROR then