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_PEC_RULES_PVT dependencies on PV_PEC_RULES_PKG

Line 330: -- Invoke table handler(Pv_Pec_Rules_Pkg.Insert_Row)

326:
327:
328:
329:
330: -- Invoke table handler(Pv_Pec_Rules_Pkg.Insert_Row)
331: Pv_Pec_Rules_Pkg.Insert_Row(
332: px_enrl_change_rule_id => l_pec_rules_rec.enrl_change_rule_id,
333: px_object_version_number => l_object_version_number,
334: p_change_from_program_id => l_pec_rules_rec.change_from_program_id,

Line 331: Pv_Pec_Rules_Pkg.Insert_Row(

327:
328:
329:
330: -- Invoke table handler(Pv_Pec_Rules_Pkg.Insert_Row)
331: Pv_Pec_Rules_Pkg.Insert_Row(
332: px_enrl_change_rule_id => l_pec_rules_rec.enrl_change_rule_id,
333: px_object_version_number => l_object_version_number,
334: p_change_from_program_id => l_pec_rules_rec.change_from_program_id,
335: p_change_to_program_id => l_pec_rules_rec.change_to_program_id,

Line 350: -- Invoke table handler(Pv_Pec_Rules_Pkg.Insert_Row) to insert a second row with reverse Direction Code

346:
347: x_enrl_change_rule_id := l_enrl_change_rule_id;
348:
349: IF l_pec_rules_rec.change_direction_code='UPGRADE' THEN
350: -- Invoke table handler(Pv_Pec_Rules_Pkg.Insert_Row) to insert a second row with reverse Direction Code
351: l_change_direction_code := 'DOWNGRADE';
352: l_enrl_change_from_id_rev := l_pec_rules_rec.change_to_program_id;
353: l_enrl_change_to_id_rev := l_pec_rules_rec.change_from_program_id;
354: OPEN c_id;

Line 358: Pv_Pec_Rules_Pkg.Insert_Row(

354: OPEN c_id;
355: FETCH c_id INTO l_pec_rules_rec.enrl_change_rule_id;
356: CLOSE c_id;
357:
358: Pv_Pec_Rules_Pkg.Insert_Row(
359: px_enrl_change_rule_id => l_pec_rules_rec.enrl_change_rule_id ,
360: px_object_version_number => l_object_version_number,
361: p_change_from_program_id => l_enrl_change_from_id_rev,
362: p_change_to_program_id => l_enrl_change_to_id_rev,

Line 632: -- Invoke table handler(Pv_Pec_Rules_Pkg.Update_Row)

628: --IF (PV_DEBUG_HIGH_ON) THENPVX_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;
629:
630: l_object_version_number := p_pec_rules_rec.object_version_number;
631:
632: -- Invoke table handler(Pv_Pec_Rules_Pkg.Update_Row)
633: Pv_Pec_Rules_Pkg.Update_Row(
634: p_enrl_change_rule_id => p_pec_rules_rec.enrl_change_rule_id,
635: px_object_version_number => l_object_version_number,
636: p_change_from_program_id => p_pec_rules_rec.change_from_program_id,

Line 633: Pv_Pec_Rules_Pkg.Update_Row(

629:
630: l_object_version_number := p_pec_rules_rec.object_version_number;
631:
632: -- Invoke table handler(Pv_Pec_Rules_Pkg.Update_Row)
633: Pv_Pec_Rules_Pkg.Update_Row(
634: p_enrl_change_rule_id => p_pec_rules_rec.enrl_change_rule_id,
635: px_object_version_number => l_object_version_number,
636: p_change_from_program_id => p_pec_rules_rec.change_from_program_id,
637: p_change_to_program_id => p_pec_rules_rec.change_to_program_id,

Line 655: Pv_Pec_Rules_Pkg.Update_Row(

651: to_id_rev := p_pec_rules_rec.change_from_program_id ;
652:
653: --
654: for downg in c_get_pec_rec_down(from_id_rev, to_id_rev) LOOP
655: Pv_Pec_Rules_Pkg.Update_Row(
656: p_enrl_change_rule_id => downg.enrl_change_rule_id,
657: px_object_version_number => downg.object_version_number,
658: p_change_from_program_id => downg.change_from_program_id,
659: p_change_to_program_id => downg.change_to_program_id,

Line 846: -- Invoke table handler(Pv_Pec_Rules_Pkg.Delete_Row)

842:
843: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
844: END IF;
845:
846: -- Invoke table handler(Pv_Pec_Rules_Pkg.Delete_Row)
847: --Pv_Pec_Rules_Pkg.Delete_Row(
848: -- p_enrl_change_rule_id => p_enrl_change_rule_id,
849: -- p_object_version_number => p_object_version_number );
850: --

Line 847: --Pv_Pec_Rules_Pkg.Delete_Row(

843: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
844: END IF;
845:
846: -- Invoke table handler(Pv_Pec_Rules_Pkg.Delete_Row)
847: --Pv_Pec_Rules_Pkg.Delete_Row(
848: -- p_enrl_change_rule_id => p_enrl_change_rule_id,
849: -- p_object_version_number => p_object_version_number );
850: --
851: -- End of API body

Line 853: --Pv_Pec_Rules_Pkg.Delete_Row(

849: -- p_object_version_number => p_object_version_number );
850: --
851: -- End of API body
852: --
853: --Pv_Pec_Rules_Pkg.Delete_Row(
854: --p_enrl_change_rule_id => l_enrl_change_rule_id,
855: --p_object_version_number => p_object_version_number );
856:
857: -- Debug Message

Line 883: -- Invoke table handler(Pv_Pec_Rules_Pkg.Update_Row)

879:
880: l_object_version_number := p_object_version_number;
881:
882: -- Make the record end dated when it is deleted.
883: -- Invoke table handler(Pv_Pec_Rules_Pkg.Update_Row)
884: Pv_Pec_Rules_Pkg.Update_Row(
885: p_enrl_change_rule_id => p_enrl_change_rule_id,
886: px_object_version_number => l_object_version_number,
887: p_change_from_program_id => l_ref_pec_rules_rec.change_from_program_id,

Line 884: Pv_Pec_Rules_Pkg.Update_Row(

880: l_object_version_number := p_object_version_number;
881:
882: -- Make the record end dated when it is deleted.
883: -- Invoke table handler(Pv_Pec_Rules_Pkg.Update_Row)
884: Pv_Pec_Rules_Pkg.Update_Row(
885: p_enrl_change_rule_id => p_enrl_change_rule_id,
886: px_object_version_number => l_object_version_number,
887: p_change_from_program_id => l_ref_pec_rules_rec.change_from_program_id,
888: p_change_to_program_id => l_ref_pec_rules_rec.change_to_program_id,

Line 903: -- Invoke table handler(Pv_Pec_Rules_Pkg.Update_Row)

899: --
900: -- End of API body.
901:
902: -- Make the corresponding DOWNGRADE record also end dated when it is deleted.
903: -- Invoke table handler(Pv_Pec_Rules_Pkg.Update_Row)
904: IF l_ref_pec_rules_rec.change_direction_code='UPGRADE' THEN
905: from_id_rev := l_ref_pec_rules_rec.change_to_program_id;
906: to_id_rev := l_ref_pec_rules_rec.change_from_program_id ;
907: -- Debug Message

Line 935: Pv_Pec_Rules_Pkg.Update_Row(

931: END IF;
932: CLOSE c_get_pec_rec_down;
933:
934: for downg in c_get_pec_rec_down(from_id_rev, to_id_rev) LOOP
935: Pv_Pec_Rules_Pkg.Update_Row(
936: p_enrl_change_rule_id => downg.enrl_change_rule_id,
937: px_object_version_number => downg.object_version_number,
938: p_change_from_program_id => downg.change_from_program_id,
939: p_change_to_program_id => downg.change_to_program_id,

Line 1098: Pv_Pec_Rules_Pkg.Lock_Row(l_enrl_change_rule_id,p_object_version);

1094: x_return_status := FND_API.G_RET_STS_SUCCESS;
1095:
1096:
1097: ------------------------ lock -------------------------
1098: Pv_Pec_Rules_Pkg.Lock_Row(l_enrl_change_rule_id,p_object_version);
1099:
1100:
1101: -------------------- finish --------------------------
1102: FND_MSG_PUB.count_and_get(