[Home] [Help]
184: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
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
307: IS
308:
309: Cursor C_Get_process_rule(pc_PROCESS_RULE_ID Number) IS
310: Select OBJECT_VERSION_NUMBER
311: From PV_PROCESS_RULES_B
312: where process_rule_id = pc_process_rule_id
313: For Update NOWAIT;
314:
315: l_api_name CONSTANT VARCHAR2(30) := 'Update_process_rule';
486:
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
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(
915: p_PROCESS_RULE_ID => p_PROCESS_RULE_rec.PROCESS_RULE_ID);
916: --
917: -- End of API body
917: -- End of API body
918: --
919:
920: -- Code change by ryellapu to delete the child rules when parent rule is deleted
921: -- Invoke table handler(PV_PROCESS_RULES_B_PKG.Delete_Row) to DELETE the child rows
922:
923: -- BEGIN OF CHILD RULE DELETION
924:
925: begin
1029: RLSB.PROGRAM_UPDATE_DATE, PROCESS_RULE_NAME, PARENT_RULE_ID, PROCESS_TYPE , RANK, STATUS_CODE, START_DATE, END_DATE,
1030: ACTION, ACTION_VALUE, OWNER_RESOURCE_ID, CURRENCY_CODE, LANGUAGE, SOURCE_LANG ,DESCRIPTION, ATTRIBUTE_CATEGORY,
1031: ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9,
1032: ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15
1033: From PV_PROCESS_RULES_B RLSB,PV_PROCESS_RULES_TL RLST
1034: where RLSB.process_rule_id = RLST.process_rule_id and
1035: (RLSB.parent_rule_id = pc_process_rule_id or RLSB.process_rule_id = pc_process_rule_id) and
1036: RLST.language = USERENV('LANG') order by parent_rule_id desc;
1037:
1358: )
1359: IS
1360: CURSOR C_Process_Rule_Id_Exists (c_process_rule_id NUMBER) IS
1361: SELECT 'X'
1362: FROM pv_process_rules_b
1363: WHERE process_rule_id = c_process_rule_id;
1364:
1365: l_val VARCHAR2(1);
1366:
1789: -- --------------------------------------------------------------
1790: -- Check the database for the "before" image. We need to compare
1791: -- the before image to the after image.
1792: -- --------------------------------------------------------------
1793: FOR x IN (SELECT status_code FROM pv_process_rules_b
1794: WHERE process_rule_id = p_parent_rule_id)
1795: LOOP
1796: l_previous_status := x.status_code;
1797: END LOOP;
1875:
1876: PV_COMMON_CHECKS_PVT.Validate_Lookup(
1877: p_init_msg_list => FND_API.G_FALSE,
1878: p_validation_mode => p_validation_mode,
1879: p_TABLE_NAME => 'PV_PROCESS_RULES_B',
1880: p_COLUMN_NAME => 'PROCESS_TYPE',
1881: p_LOOKUP_TYPE => 'PV_PROCESS_TYPE',
1882: p_LOOKUP_CODE => P_PROCESS_RULE_Rec.PROCESS_TYPE,
1883: x_return_status => x_return_status,
1892:
1893: PV_COMMON_CHECKS_PVT.Validate_Lookup(
1894: p_init_msg_list => FND_API.G_FALSE,
1895: p_validation_mode => p_validation_mode,
1896: p_TABLE_NAME => 'PV_PROCESS_RULES_B',
1897: p_COLUMN_NAME => 'STATUS_CODE',
1898: p_LOOKUP_TYPE => 'PV_RULE_STATUS_CODE',
1899: p_LOOKUP_CODE => P_PROCESS_RULE_Rec.STATUS_CODE,
1900: x_return_status => x_return_status,