APPS.PV_SELATTVAL_PVT dependencies on PV_SELECTED_ATTR_VALUES

Line 115: -- Invoke table handler(PV_SELECTED_ATTR_VALUES_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_SELECTED_ATTR_VALUES_PKG.Insert_Row)
116: PV_SELECTED_ATTR_VALUES_PKG.Insert_Row(
117: px_ATTR_VALUE_ID => x_ATTR_VALUE_ID
118: ,p_LAST_UPDATE_DATE => SYSDATE
119: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

Line 116: PV_SELECTED_ATTR_VALUES_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_SELECTED_ATTR_VALUES_PKG.Insert_Row)
116: PV_SELECTED_ATTR_VALUES_PKG.Insert_Row(
117: px_ATTR_VALUE_ID => x_ATTR_VALUE_ID
118: ,p_LAST_UPDATE_DATE => SYSDATE
119: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
120: ,p_CREATION_DATE => SYSDATE

Line 231: From PV_SELECTED_ATTR_VALUES

227: IS
228:
229: Cursor C_Get_selattval(pc_ATTR_VALUE_ID Number) IS
230: Select object_version_number
231: From PV_SELECTED_ATTR_VALUES
232: where attr_value_id = pc_attr_value_id
233: For Update NOWAIT;
234:
235: l_api_name CONSTANT VARCHAR2(30) := 'Update_selattval';

Line 353: -- Invoke table handler(PV_SELECTED_ATTR_VALUES_PKG.Update_Row)

349:
350: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
351: END IF;
352:
353: -- Invoke table handler(PV_SELECTED_ATTR_VALUES_PKG.Update_Row)
354: PV_SELECTED_ATTR_VALUES_PKG.Update_Row(
355: p_ATTR_VALUE_ID => p_SELATTVAL_rec.ATTR_VALUE_ID
356: ,p_LAST_UPDATE_DATE => SYSDATE
357: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

Line 354: PV_SELECTED_ATTR_VALUES_PKG.Update_Row(

350: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
351: END IF;
352:
353: -- Invoke table handler(PV_SELECTED_ATTR_VALUES_PKG.Update_Row)
354: PV_SELECTED_ATTR_VALUES_PKG.Update_Row(
355: p_ATTR_VALUE_ID => p_SELATTVAL_rec.ATTR_VALUE_ID
356: ,p_LAST_UPDATE_DATE => SYSDATE
357: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
358: ,p_CREATION_DATE => FND_API.G_MISS_DATE

Line 504: -- Invoke table handler(PV_SELECTED_ATTR_VALUES_PKG.Delete_Row)

500:
501: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
502: END IF;
503:
504: -- Invoke table handler(PV_SELECTED_ATTR_VALUES_PKG.Delete_Row)
505: PV_SELECTED_ATTR_VALUES_PKG.Delete_Row(
506: p_ATTR_VALUE_ID => p_SELATTVAL_rec.ATTR_VALUE_ID);
507: --
508: -- End of API body

Line 505: PV_SELECTED_ATTR_VALUES_PKG.Delete_Row(

501: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
502: END IF;
503:
504: -- Invoke table handler(PV_SELECTED_ATTR_VALUES_PKG.Delete_Row)
505: PV_SELECTED_ATTR_VALUES_PKG.Delete_Row(
506: p_ATTR_VALUE_ID => p_SELATTVAL_rec.ATTR_VALUE_ID);
507: --
508: -- End of API body
509: --

Line 578: FROM pv_selected_attr_values

574: )
575: IS
576: CURSOR C_attr_value_Id_Exists (pc_attr_value_id NUMBER) IS
577: SELECT 'X'
578: FROM pv_selected_attr_values
579: WHERE attr_value_id = pc_attr_value_id;
580:
581: l_val VARCHAR2(1);
582: BEGIN

Line 726: pv_selected_attr_values sav, pv_enty_select_criteria esc

722: --ryellapu duplicated check for criterian
723: cursor lc_criterion_dup_values_check (pc_rule_id number,pc_attribute_id number,pc_attribute_value varchar2,pc_selection_type_code varchar2) is
724: select attribute_value
725: from
726: pv_selected_attr_values sav, pv_enty_select_criteria esc
727: where
728: sav.selection_criteria_id = esc.selection_criteria_id and
729: esc.process_rule_id = pc_rule_id and
730: esc.attribute_id = pc_attribute_id and