APPS.PV_PRGM_BENEFITS_PVT dependencies on PV_PROGRAM_BENEFITS

Line 56: -- Cursor to get the sequence for pv_program_benefits_id

52:
53: l_object_version_number NUMBER := 1;
54: l_uniqueness_check VARCHAR2(1);
55:
56: -- Cursor to get the sequence for pv_program_benefits_id
57: CURSOR c_program_benefits_id_seq IS
58: SELECT PV_PROGRAM_BENEFITS_S.NEXTVAL
59: FROM dual;
60:

Line 58: SELECT PV_PROGRAM_BENEFITS_S.NEXTVAL

54: l_uniqueness_check VARCHAR2(1);
55:
56: -- Cursor to get the sequence for pv_program_benefits_id
57: CURSOR c_program_benefits_id_seq IS
58: SELECT PV_PROGRAM_BENEFITS_S.NEXTVAL
59: FROM dual;
60:
61:
62: -- Cursor to validate the uniqueness

Line 65: FROM PV_PROGRAM_BENEFITS

61:
62: -- Cursor to validate the uniqueness
63: CURSOR c_prgm_benefits_id_seq_exists (l_id IN NUMBER) IS
64: SELECT 'X'
65: FROM PV_PROGRAM_BENEFITS
66: WHERE PROGRAM_BENEFITS_ID = l_id;
67:
68: BEGIN
69: ---------------Initialize --------------------

Line 289: FROM PV_PROGRAM_BENEFITS

285: IS
286:
287: CURSOR c_get_prgm_benefits(cv_program_benefits_id NUMBER) IS
288: SELECT *
289: FROM PV_PROGRAM_BENEFITS
290: WHERE PROGRAM_BENEFITS_ID = cv_program_benefits_id;
291:
292: l_api_name CONSTANT VARCHAR2(30) := 'Update_Prgm_Benefits';
293: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 610: FROM PV_PROGRAM_BENEFITS

606: l_program_benefits_id NUMBER;
607:
608: CURSOR c_Prgm_Benefits IS
609: SELECT program_benefits_id
610: FROM PV_PROGRAM_BENEFITS
611: WHERE program_benefits_id = px_program_benefits_id
612: AND object_version_number = p_object_version
613: FOR UPDATE NOWAIT;
614:

Line 741: 'PV_PROGRAM_BENEFITS',

737: x_return_status := FND_API.g_ret_sts_success;
738: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
739:
740: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
741: 'PV_PROGRAM_BENEFITS',
742: 'program_benefits_id = ''' || p_prgm_benefits_rec.program_benefits_id ||''''
743: );
744:
745: IF l_valid_flag = FND_API.g_false THEN

Line 1020: 'PV_PROGRAM_BENEFITS', -- Lookup Type

1016: IF p_prgm_benefits_rec.Benefit_Code <> FND_API.g_miss_char THEN
1017:
1018: IF PVX_Utility_PVT.check_lookup_exists(
1019: 'FND_LOOKUP_VALUES', -- Look up Table Name
1020: 'PV_PROGRAM_BENEFITS', -- Lookup Type
1021: p_prgm_benefits_rec.Benefit_Code -- Lookup Code
1022: ) = FND_API.g_false
1023: THEN
1024: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1162: FROM pv_program_benefits

1158: IS
1159:
1160: CURSOR c_complete IS
1161: SELECT *
1162: FROM pv_program_benefits
1163: WHERE program_benefits_id = p_prgm_benefits_rec.program_benefits_id;
1164:
1165: l_prgm_benefits_rec c_complete%ROWTYPE;
1166: