APPS.PV_PARTNER_PROGRAM_PVT dependencies on PV_PARTNER_PROGRAM_VL

Line 3084: 'PV_PARTNER_PROGRAM_VL', -- Parent schema object having the primary key

3080: p_ptr_prgm_rec.PROGRAM_PARENT_ID IS NOT NULL ) THEN
3081:
3082:
3083: IF PVX_Utility_PVT.check_fk_exists(
3084: 'PV_PARTNER_PROGRAM_VL', -- Parent schema object having the primary key
3085: 'PROGRAM_ID', -- Column name in the parent object that maps to the fk value
3086: p_ptr_prgm_rec.PROGRAM_PARENT_ID, -- Value of fk to be validated against the parent object's pk column
3087: PVX_utility_PVT.g_number, -- datatype of fk
3088: ' ENABLED_FLAG = ''Y'''

Line 3304: FROM PV_PARTNER_PROGRAM_VL

3300: IS
3301:
3302: CURSOR c_complete IS
3303: SELECT *
3304: FROM PV_PARTNER_PROGRAM_VL
3305: WHERE PROGRAM_ID = p_ptr_prgm_rec.program_id;
3306:
3307: l_ptr_prgm_rec c_complete%ROWTYPE;
3308:

Line 3995: FROM pv_partner_program_vl

3991: ) AS
3992:
3993: CURSOR cur_get_prog_name(p_program_id IN NUMBER) IS
3994: SELECT program_name
3995: FROM pv_partner_program_vl
3996: WHERE program_id = p_program_id;
3997:
3998: l_api_name CONSTANT VARCHAR2(30) := 'GET_OBJECT_NAME';
3999:

Line 4052: FROM pv_partner_program_vl

4048: )
4049: IS
4050: CURSOR c_get_ptr_prgm_rec (cv_program_id IN NUMBER) IS
4051: SELECT *
4052: FROM pv_partner_program_vl
4053: WHERE program_id = cv_program_id;
4054:
4055: CURSOR c_get_user_status_id IS
4056: SELECT user_status_id

Line 4488: FROM PV_PARTNER_PROGRAM_VL

4484: WHERE PROCESS_RULE_ID = cv_process_rule_id;
4485:
4486: CURSOR c_get_program_name_rec (cv_program_id IN NUMBER) IS
4487: SELECT program_name
4488: FROM PV_PARTNER_PROGRAM_VL
4489: WHERE PROGRAM_ID = cv_program_id;
4490:
4491: /*
4492: CURSOR c_get_object_version_number (cv_program_id IN NUMBER) IS

Line 4912: FROM pv_partner_program_vl

4908: )
4909: IS
4910: CURSOR c_get_inventory_item_id (cv_program_id IN NUMBER) IS
4911: SELECT inventory_item_id
4912: FROM pv_partner_program_vl
4913: WHERE program_id = cv_program_id;
4914:
4915: l_org_inv_item_id NUMBER;
4916: l_new_inv_item_id OZF_PRICELIST_PVT.num_tbl_type;

Line 5579: FROM PV_PARTNER_PROGRAM_vl

5575:
5576: -- Cursor to validate the uniqueness
5577: CURSOR get_program_details(p_id IN NUMBER) IS
5578: SELECT program_name,program_description,object_version_number
5579: FROM PV_PARTNER_PROGRAM_vl
5580: WHERE PROGRAM_ID = p_id;
5581:
5582: CURSOR c_resource_id(p_user_id IN NUMBER) IS
5583: SELECT RESOURCE_ID

Line 5745: FROM pv_partner_program_vl

5741: l_ptr_prgm_rec ptr_prgm_rec_type;
5742:
5743: CURSOR c_get_program_info IS
5744: SELECT *
5745: FROM pv_partner_program_vl
5746: WHERE program_id = p_program_id;
5747:
5748: BEGIN
5749: IF (PV_DEBUG_HIGH_ON) THEN