DBA Data[Home] [Help]

APPS.PV_PARTNER_PROGRAM_PVT dependencies on PV_PARTNER_PROGRAM_PVT

Line 1: PACKAGE BODY PV_PARTNER_PROGRAM_PVT as

1: PACKAGE BODY PV_PARTNER_PROGRAM_PVT as
2: /* $Header: pvxvprgb.pls 120.12 2006/07/25 17:30:57 dgottlie ship $ */
3: -- Start of Comments
4: -- Package name: PV_PARTNER_PROGRAM_PVT
5: -- Purpose :

Line 4: -- Package name: PV_PARTNER_PROGRAM_PVT

1: PACKAGE BODY PV_PARTNER_PROGRAM_PVT as
2: /* $Header: pvxvprgb.pls 120.12 2006/07/25 17:30:57 dgottlie ship $ */
3: -- Start of Comments
4: -- Package name: PV_PARTNER_PROGRAM_PVT
5: -- Purpose :
6: -- History : 28-FEB-2002 Ravi.Mikkilineni Created
7: -- 1-APR-2002 Peter.Nixon Modified
8: -- - MEMBERSHIP columns (4) made nullable

Line 68: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PV_PARTNER_PROGRAM_PVT';

64: -- All rights reserved.
65: -- End of Comments
66:
67:
68: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PV_PARTNER_PROGRAM_PVT';
69: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvprgb.pls';
70: l_msg_count NUMBER;
71: l_msg VARCHAR2(2000);
72: l_msg_data VARCHAR2(2000);

Line 1744: l_tar_ptr_prgm_rec PV_PARTNER_PROGRAM_PVT.ptr_prgm_rec_type := p_ptr_prgm_rec;

1740: l_api_version_number CONSTANT NUMBER := 1.0;
1741:
1742: -- Local Variables
1743: l_ref_ptr_prgm_rec c_get_Partner_Program%ROWTYPE ;
1744: l_tar_ptr_prgm_rec PV_PARTNER_PROGRAM_PVT.ptr_prgm_rec_type := p_ptr_prgm_rec;
1745: l_tar_ptr_prgm_update_rec PV_PARTNER_PROGRAM_PVT.ptr_prgm_rec_type := p_ptr_prgm_rec;
1746: l_enrollment_valid boolean :=false;
1747: l_valid_approvers boolean :=false;
1748: l_start_end_date_within_range boolean :=false;

Line 1745: l_tar_ptr_prgm_update_rec PV_PARTNER_PROGRAM_PVT.ptr_prgm_rec_type := p_ptr_prgm_rec;

1741:
1742: -- Local Variables
1743: l_ref_ptr_prgm_rec c_get_Partner_Program%ROWTYPE ;
1744: l_tar_ptr_prgm_rec PV_PARTNER_PROGRAM_PVT.ptr_prgm_rec_type := p_ptr_prgm_rec;
1745: l_tar_ptr_prgm_update_rec PV_PARTNER_PROGRAM_PVT.ptr_prgm_rec_type := p_ptr_prgm_rec;
1746: l_enrollment_valid boolean :=false;
1747: l_valid_approvers boolean :=false;
1748: l_start_end_date_within_range boolean :=false;
1749: l_activatable boolean :=false;

Line 2263: l_tar_ptr_prgm_rec PV_Partner_Program_PVT.ptr_prgm_rec_type;

2259: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Partner_Program';
2260: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2261: l_api_version_number CONSTANT NUMBER := 1.0;
2262:
2263: l_tar_ptr_prgm_rec PV_Partner_Program_PVT.ptr_prgm_rec_type;
2264: l_ref_ptr_prgm_rec c_get_partner_program_rec%ROWTYPE;
2265: l_program_id NUMBER;
2266: l_return_status VARCHAR2(1);
2267: l_msg_count NUMBER;

Line 3607: l_ptr_prgm_rec PV_Partner_Program_PVT.ptr_prgm_rec_type;

3603: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Partner_Program';
3604: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
3605: l_api_version_number CONSTANT NUMBER := 1.0;
3606: l_object_version_number NUMBER;
3607: l_ptr_prgm_rec PV_Partner_Program_PVT.ptr_prgm_rec_type;
3608:
3609: BEGIN
3610:
3611: -- Standard Start of API savepoint

Line 3843: l_ptr_prgm_rec PV_PARTNER_PROGRAM_PVT.ptr_prgm_rec_type ;

3839: WHERE system_status_type like 'PV_PROGRAM_STATUS'
3840: AND system_status_code = 'CLOSED'
3841: AND enabled_flag = 'Y';
3842:
3843: l_ptr_prgm_rec PV_PARTNER_PROGRAM_PVT.ptr_prgm_rec_type ;
3844: l_return_status VARCHAR2(1);
3845: l_msg_count NUMBER;
3846: l_msg_data VARCHAR2(240);
3847: l_user_status_id NUMBER := NULL;

Line 4186: PV_Partner_Program_PVT.Create_Partner_Program(

4182: END IF;
4183: l_new_ptr_pgrm_rec.allow_enrl_wout_chklst_flag := l_src_ptr_pgrm_rec.allow_enrl_wout_chklst_flag;
4184: END IF;
4185:
4186: PV_Partner_Program_PVT.Create_Partner_Program(
4187: p_api_version_number => 1.0
4188: ,p_init_msg_list => FND_API.G_FALSE
4189: ,p_commit => FND_API.G_FALSE
4190: ,p_validation_level => p_validation_level

Line 4212: PV_Partner_Program_PVT.Copy_Qualifications (

4208: IF (PV_DEBUG_HIGH_ON) THEN
4209: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'QUAL');
4210: END IF;
4211:
4212: PV_Partner_Program_PVT.Copy_Qualifications (
4213: p_api_version_number => 1.0,
4214: p_init_msg_list => FND_API.G_FALSE,
4215: p_commit => FND_API.G_FALSE,
4216: p_validation_level => p_validation_level,

Line 4234: PV_Partner_Program_PVT.Copy_Benefits (

4230: IF (PV_DEBUG_HIGH_ON) THEN
4231: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'BNFT');
4232: END IF;
4233:
4234: PV_Partner_Program_PVT.Copy_Benefits (
4235: p_api_version_number => 1.0,
4236: p_init_msg_list => FND_API.G_FALSE,
4237: p_commit => FND_API.G_FALSE,
4238: p_validation_level => p_validation_level,

Line 4257: PV_Partner_Program_PVT.Copy_payments (

4253: IF AMS_CpyUtility_PVT.is_copy_attribute ('PMNT', p_attributes_table) = FND_API.G_TRUE THEN
4254: IF (PV_DEBUG_HIGH_ON) THEN
4255: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'PMNT');
4256: END IF;
4257: PV_Partner_Program_PVT.Copy_payments (
4258: p_api_version_number => 1.0,
4259: p_init_msg_list => FND_API.G_FALSE,
4260: p_commit => FND_API.G_FALSE,
4261: p_validation_level => p_validation_level,

Line 4297: PV_Partner_Program_PVT.Copy_Legal_Terms (

4293: IF AMS_CpyUtility_PVT.is_copy_attribute ('LGLT', p_attributes_table) = FND_API.G_TRUE THEN
4294: IF (PV_DEBUG_HIGH_ON) THEN
4295: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'LGLT');
4296: END IF;
4297: PV_Partner_Program_PVT.Copy_Legal_Terms (
4298: p_api_version_number => 1.0,
4299: p_init_msg_list => FND_API.G_FALSE,
4300: p_commit => FND_API.G_FALSE,
4301: p_validation_level => p_validation_level,

Line 4319: PV_Partner_Program_PVT.Copy_Questionnaire (

4315: IF AMS_CpyUtility_PVT.is_copy_attribute ('QSNR', p_attributes_table) = FND_API.G_TRUE THEN
4316: IF (PV_DEBUG_HIGH_ON) THEN
4317: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'QUAL');
4318: END IF;
4319: PV_Partner_Program_PVT.Copy_Questionnaire (
4320: p_api_version_number => 1.0,
4321: p_init_msg_list => FND_API.G_FALSE,
4322: p_commit => FND_API.G_FALSE,
4323: p_validation_level => p_validation_level,

Line 4342: PV_Partner_Program_PVT.Copy_Checklist (

4338: IF AMS_CpyUtility_PVT.is_copy_attribute ('CHKLST', p_attributes_table) = FND_API.G_TRUE THEN
4339: IF (PV_DEBUG_HIGH_ON) THEN
4340: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'CHKLST');
4341: END IF;
4342: PV_Partner_Program_PVT.Copy_Checklist (
4343: p_api_version_number => 1.0,
4344: p_init_msg_list => FND_API.G_FALSE,
4345: p_commit => FND_API.G_FALSE,
4346: p_validation_level => p_validation_level,

Line 4366: PV_Partner_Program_PVT.Copy_Notif_Rules (

4362: IF (PV_DEBUG_HIGH_ON) THEN
4363: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'QUAL');
4364: END IF;
4365:
4366: PV_Partner_Program_PVT.Copy_Notif_Rules (
4367: p_api_version_number => 1.0,
4368: p_init_msg_list => FND_API.G_FALSE,
4369: p_commit => FND_API.G_FALSE,
4370: p_validation_level => p_validation_level,

Line 4511: l_tar_ptr_prgm_rec PV_Partner_Program_PVT.ptr_prgm_rec_type;

4507: l_enrl_change_rule_id NUMBER;
4508: l_src_process_rule_rec c_get_process_rule_rec%ROWTYPE;
4509: l_tar_process_rule_rec PV_RULE_RECTYPE_PUB.RULES_REC_TYPE;
4510: l_fake_process_rule_rec PV_RULE_RECTYPE_PUB.RULES_REC_TYPE;
4511: l_tar_ptr_prgm_rec PV_Partner_Program_PVT.ptr_prgm_rec_type;
4512: l_src_pec_rules_rec c_get_pec_rules_rec%ROWTYPE;
4513: l_tar_pec_rules_rec PV_Pec_Rules_PVT.pec_rules_rec_type;
4514: L_API_NAME CONSTANT VARCHAR2(30) := 'Copy_Qualifications';
4515: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 4636: PV_Partner_Program_PVT.Update_Partner_Program(

4632: FOR x IN c_get_object_version_number (p_tar_object_id) LOOP
4633: l_tar_ptr_prgm_rec.object_version_number := x.object_version_number;
4634: END LOOP;
4635: */
4636: PV_Partner_Program_PVT.Update_Partner_Program(
4637: p_api_version_number => 1.0
4638: ,p_init_msg_list => FND_API.G_FALSE
4639: ,p_commit => FND_API.G_FALSE
4640: ,p_validation_level => p_validation_level

Line 5858: END PV_Partner_Program_PVT;

5854: p_data => x_msg_data
5855: );
5856: END create_inv_item_if_not_exists;
5857:
5858: END PV_Partner_Program_PVT;