APPS.PV_PRGM_CONTRACTS_PVT dependencies on PV_PROGRAM_CONTRACTS

Line 76: -- Cursor to get the sequence for pv_program_contracts_id

72:
73: l_object_version_number NUMBER := 1;
74: l_uniqueness_check VARCHAR2(1);
75:
76: -- Cursor to get the sequence for pv_program_contracts_id
77: CURSOR c_prgm_contracts_id_seq IS
78: SELECT PV_PROGRAM_CONTRACTS_S.NEXTVAL
79: FROM dual;
80:

Line 78: SELECT PV_PROGRAM_CONTRACTS_S.NEXTVAL

74: l_uniqueness_check VARCHAR2(1);
75:
76: -- Cursor to get the sequence for pv_program_contracts_id
77: CURSOR c_prgm_contracts_id_seq IS
78: SELECT PV_PROGRAM_CONTRACTS_S.NEXTVAL
79: FROM dual;
80:
81:
82: -- Cursor to validate the uniqueness

Line 85: FROM PV_PROGRAM_CONTRACTS

81:
82: -- Cursor to validate the uniqueness
83: CURSOR c_prgm_cntrcts_id_seq_exists (l_id IN NUMBER) IS
84: SELECT 'X'
85: FROM PV_PROGRAM_CONTRACTS
86: WHERE program_contracts_id = l_id;
87:
88: BEGIN
89: ---------------Initialize --------------------

Line 307: FROM PV_PROGRAM_CONTRACTS

303: IS
304:
305: CURSOR c_get_Prgm_Contracts(cv_program_contracts_id NUMBER) IS
306: SELECT *
307: FROM PV_PROGRAM_CONTRACTS
308: WHERE program_contracts_id = cv_program_contracts_id;
309:
310: l_api_name CONSTANT VARCHAR2(30) := 'Update_Prgm_Contracts';
311: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 624: FROM PV_PROGRAM_CONTRACTS

620: l_program_contracts_id NUMBER;
621:
622: CURSOR c_Prgm_Contracts IS
623: SELECT program_contracts_id
624: FROM PV_PROGRAM_CONTRACTS
625: WHERE program_contracts_id = px_program_contracts_id
626: AND object_version_number = p_object_version
627: FOR UPDATE NOWAIT;
628:

Line 762: FROM pv_program_contracts

758: where LOCATION_HIERARCHY_ID = l_loc_hie_id;
759:
760: CURSOR c_get_program_contract_id (cv_program_id NUMBER, cv_geo_hierarchy_id NUMBER, cv_member_type_code VARCHAR2) IS
761: SELECT program_contracts_id
762: FROM pv_program_contracts
763: WHERE program_id = cv_program_id
764: and geo_hierarchy_id = cv_geo_hierarchy_id
765: and member_type_code = cv_member_type_code;
766:

Line 773: 'PV_PROGRAM_CONTRACTS'

769: x_return_status := FND_API.g_ret_sts_success;
770: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
771:
772: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
773: 'PV_PROGRAM_CONTRACTS'
774: ,'PROGRAM_CONTRACTS_ID = ''' || p_prgm_contracts_rec.program_contracts_id ||''''
775: );
776:
777: IF l_valid_flag = Fnd_Api.g_false THEN

Line 794: 'PV_PROGRAM_CONTRACTS'

790: PVX_UTILITY_PVT.debug_message('- In Check_UK_Items API Before PROGRAM_ID/GEO_HIERARCHY_ID combo check' );
791: END IF;
792:
793: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
794: 'PV_PROGRAM_CONTRACTS'
795: ,'PROGRAM_ID = ''' || p_prgm_contracts_rec.PROGRAM_ID ||''' AND GEO_HIERARCHY_ID = ''' || p_prgm_contracts_rec.GEO_HIERARCHY_ID || ''' AND MEMBER_TYPE_CODE = ''' || p_prgm_contracts_rec.member_type_code || ''''
796: );
797:
798:

Line 1106: -- No Lookup Items for PV_Program_Contracts Table

1102: BEGIN
1103:
1104: x_return_status := FND_API.g_ret_sts_success;
1105:
1106: -- No Lookup Items for PV_Program_Contracts Table
1107:
1108: END Check_Lookup_Items;
1109:
1110:

Line 1219: FROM PV_PROGRAM_CONTRACTS

1215: IS
1216:
1217: CURSOR c_complete IS
1218: SELECT *
1219: FROM PV_PROGRAM_CONTRACTS
1220: WHERE program_contracts_id = p_prgm_contracts_rec.program_contracts_id;
1221:
1222: l_prgm_contracts_rec c_complete%ROWTYPE;
1223: