eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_SELCRIT_PVT dependencies on PV_ENTY_SELECT_CRITERIA

Line 139: -- Invoke table handler(PV_ENTY_SELECT_CRITERIA_PKG.Insert_Row)

135:
136: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
137: END IF;
138:
139: -- Invoke table handler(PV_ENTY_SELECT_CRITERIA_PKG.Insert_Row)
140: PV_ENTY_SELECT_CRITERIA_PKG.Insert_Row(
141: px_SELECTION_CRITERIA_ID => x_SELECTION_CRITERIA_ID
142: ,p_LAST_UPDATE_DATE => SYSDATE
143: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

Line 140: PV_ENTY_SELECT_CRITERIA_PKG.Insert_Row(

136: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
137: END IF;
138:
139: -- Invoke table handler(PV_ENTY_SELECT_CRITERIA_PKG.Insert_Row)
140: PV_ENTY_SELECT_CRITERIA_PKG.Insert_Row(
141: px_SELECTION_CRITERIA_ID => x_SELECTION_CRITERIA_ID
142: ,p_LAST_UPDATE_DATE => SYSDATE
143: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
144: ,p_CREATION_DATE => SYSDATE

Line 256: From PV_ENTY_SELECT_CRITERIA

252: IS
253:
254: Cursor C_Get_selcrit(pc_SELECTION_CRITERIA_ID Number) IS
255: Select object_version_number
256: From PV_ENTY_SELECT_CRITERIA
257: where selection_criteria_id = pc_selection_criteria_id
258: For Update NOWAIT;
259:
260: l_api_name CONSTANT VARCHAR2(30) := 'Update_selcrit';

Line 404: -- Invoke table handler(PV_ENTY_SELECT_CRITERIA_PKG.Update_Row)

400:
401: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
402: END IF;
403:
404: -- Invoke table handler(PV_ENTY_SELECT_CRITERIA_PKG.Update_Row)
405: PV_ENTY_SELECT_CRITERIA_PKG.Update_Row(
406: p_SELECTION_CRITERIA_ID => p_SELCRIT_rec.SELECTION_CRITERIA_ID
407: ,p_LAST_UPDATE_DATE => SYSDATE
408: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

Line 405: PV_ENTY_SELECT_CRITERIA_PKG.Update_Row(

401: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
402: END IF;
403:
404: -- Invoke table handler(PV_ENTY_SELECT_CRITERIA_PKG.Update_Row)
405: PV_ENTY_SELECT_CRITERIA_PKG.Update_Row(
406: p_SELECTION_CRITERIA_ID => p_SELCRIT_rec.SELECTION_CRITERIA_ID
407: ,p_LAST_UPDATE_DATE => SYSDATE
408: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
409: ,p_CREATION_DATE => FND_API.G_MISS_DATE

Line 600: 'Private API: Calling PV_ENTY_SELECT_CRITERIA_PKG.Delete_Row');

596: -- Debug Message
597: IF (AS_DEBUG_HIGH_ON) THEN
598:
599: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
600: 'Private API: Calling PV_ENTY_SELECT_CRITERIA_PKG.Delete_Row');
601: END IF;
602:
603: PV_ENTY_SELECT_CRITERIA_PKG.Delete_Row(
604: p_SELECTION_CRITERIA_ID => p_SELCRIT_rec.SELECTION_CRITERIA_ID);

Line 603: PV_ENTY_SELECT_CRITERIA_PKG.Delete_Row(

599: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
600: 'Private API: Calling PV_ENTY_SELECT_CRITERIA_PKG.Delete_Row');
601: END IF;
602:
603: PV_ENTY_SELECT_CRITERIA_PKG.Delete_Row(
604: p_SELECTION_CRITERIA_ID => p_SELCRIT_rec.SELECTION_CRITERIA_ID);
605: --
606: -- End of API body
607: --

Line 676: FROM pv_enty_select_criteria

672: )
673: IS
674: CURSOR C_selection_criteria_id_exists (pc_selection_criteria_id NUMBER) IS
675: SELECT 'X'
676: FROM pv_enty_select_criteria
677: WHERE selection_criteria_id = pc_selection_criteria_id;
678:
679: l_val VARCHAR2(1);
680: BEGIN

Line 763: pv_process_rules_vl rule, pv_attributes_vl attr, pv_enty_select_criteria crit

759: -- ---------------------------------------------------------------------------
760: cursor lc_chk_input_filter_dups (pc_rule_id number, pc_attribute_id number) is
761: select rule.process_rule_name, attr.name
762: from
763: pv_process_rules_vl rule, pv_attributes_vl attr, pv_enty_select_criteria crit
764: where
765: crit.process_rule_id = pc_rule_id
766: and crit.attribute_id = pc_attribute_id
767: and crit.selection_type_code IN ('INPUT_FILTER', 'MONITOR_SCOPE')

Line 836: p_TABLE_NAME => 'PV_ENTY_SELECT_CRITERIA',

832:
833: pv_common_checks_pvt.Validate_Lookup(
834: p_init_msg_list => FND_API.G_FALSE,
835: p_validation_mode => p_validation_mode,
836: p_TABLE_NAME => 'PV_ENTY_SELECT_CRITERIA',
837: p_COLUMN_NAME => 'SELECTION_TYPE_CODE',
838: p_lookup_type => 'PV_SELECTION_TYPE_CODE',
839: p_lookup_code => P_SELCRIT_Rec.SELECTION_TYPE_CODE,
840: x_return_status => x_return_status,

Line 861: select rank into l_rank from pv_enty_select_criteria

857: x_return_status := FND_API.G_RET_STS_ERROR;
858: raise FND_API.G_EXC_ERROR;
859: end if;
860:
861: select rank into l_rank from pv_enty_select_criteria
862: where process_rule_id = p_SELCRIT_REC.process_rule_id and
863: rank = p_SELCRIT_REC.rank;
864:
865: if l_rank is not null then

Line 882: select attribute_id into l_attribute_id from pv_enty_select_criteria

878: end if;
879:
880: if p_SELCRIT_REC.SELECTION_TYPE_CODE = 'TIE_BREAKING' then
881: begin
882: select attribute_id into l_attribute_id from pv_enty_select_criteria
883: where process_rule_id = p_SELCRIT_REC.process_rule_id and
884: attribute_id = p_SELCRIT_REC.attribute_id;
885:
886: if (l_attribute_id is not null and p_validation_mode = AS_UTILITY_PVT.G_CREATE) then

Line 911: p_token1_value => 'PV_ENTY_SELECT_CRITERIA',

907: pv_common_checks_pvt.Set_Message(
908: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
909: p_msg_name => 'API_INVALID_CODE',
910: p_token1 => 'TABLE_NAME',
911: p_token1_value => 'PV_ENTY_SELECT_CRITERIA',
912: p_token2 => 'COLUMN_NAME',
913: p_token2_value => 'OPERATOR',
914: p_token3 => 'LOOKUP_TYPE',
915: p_token3_value => 'PV_TIE_BREAKING_OPERATOR',

Line 929: p_TABLE_NAME => 'PV_ENTY_SELECT_CRITERIA',

925:
926: pv_common_checks_pvt.Validate_OPERATOR(
927: p_init_msg_list => FND_API.G_FALSE,
928: p_validation_mode => p_validation_mode,
929: p_TABLE_NAME => 'PV_ENTY_SELECT_CRITERIA',
930: p_COLUMN_NAME => 'OPERATOR',
931: p_attribute_id => P_SELCRIT_REC.ATTRIBUTE_ID,
932: p_OPERATOR_CODE => P_SELCRIT_Rec.OPERATOR,
933: x_return_status => x_return_status,