DBA Data[Home] [Help]

APPS.PV_PARTNER_PROGRAM_PVT dependencies on AMS_CPYUTILITY_PVT

Line 4044: ,p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type

4040: ,x_msg_count OUT NOCOPY NUMBER
4041: ,x_msg_data OUT NOCOPY VARCHAR2
4042: ,p_source_object_id IN NUMBER
4043: --,p_identity_resource_id IN NUMBER
4044: ,p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type
4045: ,p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type
4046: ,x_new_object_id OUT NOCOPY NUMBER
4047: ,x_custom_setup_id OUT NOCOPY NUMBER
4048: )

Line 4045: ,p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type

4041: ,x_msg_data OUT NOCOPY VARCHAR2
4042: ,p_source_object_id IN NUMBER
4043: --,p_identity_resource_id IN NUMBER
4044: ,p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type
4045: ,p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type
4046: ,x_new_object_id OUT NOCOPY NUMBER
4047: ,x_custom_setup_id OUT NOCOPY NUMBER
4048: )
4049: IS

Line 4143: AMS_CpyUtility_PVT.get_column_value('newObjName', p_copy_columns_table, l_new_ptr_pgrm_rec.program_name);

4139: l_new_ptr_pgrm_rec.submit_child_nodes := 'N';
4140: l_new_ptr_pgrm_rec.enabled_flag := 'Y';
4141:
4142: -- Mandatory columns. From user input.
4143: AMS_CpyUtility_PVT.get_column_value('newObjName', p_copy_columns_table, l_new_ptr_pgrm_rec.program_name);
4144: AMS_CpyUtility_PVT.get_column_value('prmOwnerResID', p_copy_columns_table, l_new_ptr_pgrm_rec.program_owner_resource_id);
4145: AMS_CpyUtility_PVT.get_column_value('programStartDate', p_copy_columns_table, l_new_ptr_pgrm_rec.program_start_date);
4146: AMS_CpyUtility_PVT.get_column_value('programEndDate', p_copy_columns_table, l_new_ptr_pgrm_rec.program_end_date);
4147:

Line 4144: AMS_CpyUtility_PVT.get_column_value('prmOwnerResID', p_copy_columns_table, l_new_ptr_pgrm_rec.program_owner_resource_id);

4140: l_new_ptr_pgrm_rec.enabled_flag := 'Y';
4141:
4142: -- Mandatory columns. From user input.
4143: AMS_CpyUtility_PVT.get_column_value('newObjName', p_copy_columns_table, l_new_ptr_pgrm_rec.program_name);
4144: AMS_CpyUtility_PVT.get_column_value('prmOwnerResID', p_copy_columns_table, l_new_ptr_pgrm_rec.program_owner_resource_id);
4145: AMS_CpyUtility_PVT.get_column_value('programStartDate', p_copy_columns_table, l_new_ptr_pgrm_rec.program_start_date);
4146: AMS_CpyUtility_PVT.get_column_value('programEndDate', p_copy_columns_table, l_new_ptr_pgrm_rec.program_end_date);
4147:
4148: -- Mandatory columns. If not shown on the copy screen, get from the source object.

Line 4145: AMS_CpyUtility_PVT.get_column_value('programStartDate', p_copy_columns_table, l_new_ptr_pgrm_rec.program_start_date);

4141:
4142: -- Mandatory columns. From user input.
4143: AMS_CpyUtility_PVT.get_column_value('newObjName', p_copy_columns_table, l_new_ptr_pgrm_rec.program_name);
4144: AMS_CpyUtility_PVT.get_column_value('prmOwnerResID', p_copy_columns_table, l_new_ptr_pgrm_rec.program_owner_resource_id);
4145: AMS_CpyUtility_PVT.get_column_value('programStartDate', p_copy_columns_table, l_new_ptr_pgrm_rec.program_start_date);
4146: AMS_CpyUtility_PVT.get_column_value('programEndDate', p_copy_columns_table, l_new_ptr_pgrm_rec.program_end_date);
4147:
4148: -- Mandatory columns. If not shown on the copy screen, get from the source object.
4149: AMS_CpyUtility_PVT.get_column_value ('noFeesFlag', p_copy_columns_table, l_new_ptr_pgrm_rec.no_fee_flag);

Line 4146: AMS_CpyUtility_PVT.get_column_value('programEndDate', p_copy_columns_table, l_new_ptr_pgrm_rec.program_end_date);

4142: -- Mandatory columns. From user input.
4143: AMS_CpyUtility_PVT.get_column_value('newObjName', p_copy_columns_table, l_new_ptr_pgrm_rec.program_name);
4144: AMS_CpyUtility_PVT.get_column_value('prmOwnerResID', p_copy_columns_table, l_new_ptr_pgrm_rec.program_owner_resource_id);
4145: AMS_CpyUtility_PVT.get_column_value('programStartDate', p_copy_columns_table, l_new_ptr_pgrm_rec.program_start_date);
4146: AMS_CpyUtility_PVT.get_column_value('programEndDate', p_copy_columns_table, l_new_ptr_pgrm_rec.program_end_date);
4147:
4148: -- Mandatory columns. If not shown on the copy screen, get from the source object.
4149: AMS_CpyUtility_PVT.get_column_value ('noFeesFlag', p_copy_columns_table, l_new_ptr_pgrm_rec.no_fee_flag);
4150: l_new_ptr_pgrm_rec.no_fee_flag := NVL (l_new_ptr_pgrm_rec.no_fee_flag, l_src_ptr_pgrm_rec.no_fee_flag);

Line 4149: AMS_CpyUtility_PVT.get_column_value ('noFeesFlag', p_copy_columns_table, l_new_ptr_pgrm_rec.no_fee_flag);

4145: AMS_CpyUtility_PVT.get_column_value('programStartDate', p_copy_columns_table, l_new_ptr_pgrm_rec.program_start_date);
4146: AMS_CpyUtility_PVT.get_column_value('programEndDate', p_copy_columns_table, l_new_ptr_pgrm_rec.program_end_date);
4147:
4148: -- Mandatory columns. If not shown on the copy screen, get from the source object.
4149: AMS_CpyUtility_PVT.get_column_value ('noFeesFlag', p_copy_columns_table, l_new_ptr_pgrm_rec.no_fee_flag);
4150: l_new_ptr_pgrm_rec.no_fee_flag := NVL (l_new_ptr_pgrm_rec.no_fee_flag, l_src_ptr_pgrm_rec.no_fee_flag);
4151:
4152: AMS_CpyUtility_PVT.get_column_value ('membPeriodUnit', p_copy_columns_table, l_new_ptr_pgrm_rec.membership_period_unit);
4153: l_new_ptr_pgrm_rec.membership_period_unit := NVL (l_new_ptr_pgrm_rec.membership_period_unit, l_src_ptr_pgrm_rec.membership_period_unit);

Line 4152: AMS_CpyUtility_PVT.get_column_value ('membPeriodUnit', p_copy_columns_table, l_new_ptr_pgrm_rec.membership_period_unit);

4148: -- Mandatory columns. If not shown on the copy screen, get from the source object.
4149: AMS_CpyUtility_PVT.get_column_value ('noFeesFlag', p_copy_columns_table, l_new_ptr_pgrm_rec.no_fee_flag);
4150: l_new_ptr_pgrm_rec.no_fee_flag := NVL (l_new_ptr_pgrm_rec.no_fee_flag, l_src_ptr_pgrm_rec.no_fee_flag);
4151:
4152: AMS_CpyUtility_PVT.get_column_value ('membPeriodUnit', p_copy_columns_table, l_new_ptr_pgrm_rec.membership_period_unit);
4153: l_new_ptr_pgrm_rec.membership_period_unit := NVL (l_new_ptr_pgrm_rec.membership_period_unit, l_src_ptr_pgrm_rec.membership_period_unit);
4154:
4155: AMS_CpyUtility_PVT.get_column_value ('membValidPeriod', p_copy_columns_table, l_new_ptr_pgrm_rec.membership_valid_period);
4156: l_new_ptr_pgrm_rec.membership_valid_period := NVL (l_new_ptr_pgrm_rec.membership_valid_period, l_src_ptr_pgrm_rec.membership_valid_period);

Line 4155: AMS_CpyUtility_PVT.get_column_value ('membValidPeriod', p_copy_columns_table, l_new_ptr_pgrm_rec.membership_valid_period);

4151:
4152: AMS_CpyUtility_PVT.get_column_value ('membPeriodUnit', p_copy_columns_table, l_new_ptr_pgrm_rec.membership_period_unit);
4153: l_new_ptr_pgrm_rec.membership_period_unit := NVL (l_new_ptr_pgrm_rec.membership_period_unit, l_src_ptr_pgrm_rec.membership_period_unit);
4154:
4155: AMS_CpyUtility_PVT.get_column_value ('membValidPeriod', p_copy_columns_table, l_new_ptr_pgrm_rec.membership_valid_period);
4156: l_new_ptr_pgrm_rec.membership_valid_period := NVL (l_new_ptr_pgrm_rec.membership_valid_period, l_src_ptr_pgrm_rec.membership_valid_period);
4157:
4158: AMS_CpyUtility_PVT.get_column_value ('allowEnrlUntillDate', p_copy_columns_table, l_new_ptr_pgrm_rec.allow_enrl_until_date);
4159: l_new_ptr_pgrm_rec.allow_enrl_until_date := NVL (l_new_ptr_pgrm_rec.allow_enrl_until_date, l_src_ptr_pgrm_rec.allow_enrl_until_date);

Line 4158: AMS_CpyUtility_PVT.get_column_value ('allowEnrlUntillDate', p_copy_columns_table, l_new_ptr_pgrm_rec.allow_enrl_until_date);

4154:
4155: AMS_CpyUtility_PVT.get_column_value ('membValidPeriod', p_copy_columns_table, l_new_ptr_pgrm_rec.membership_valid_period);
4156: l_new_ptr_pgrm_rec.membership_valid_period := NVL (l_new_ptr_pgrm_rec.membership_valid_period, l_src_ptr_pgrm_rec.membership_valid_period);
4157:
4158: AMS_CpyUtility_PVT.get_column_value ('allowEnrlUntillDate', p_copy_columns_table, l_new_ptr_pgrm_rec.allow_enrl_until_date);
4159: l_new_ptr_pgrm_rec.allow_enrl_until_date := NVL (l_new_ptr_pgrm_rec.allow_enrl_until_date, l_src_ptr_pgrm_rec.allow_enrl_until_date);
4160:
4161: AMS_CpyUtility_PVT.get_column_value ('parentProgramId', p_copy_columns_table, l_new_ptr_pgrm_rec.program_parent_id);
4162: l_new_ptr_pgrm_rec.program_parent_id := NVL (l_new_ptr_pgrm_rec.program_parent_id, l_src_ptr_pgrm_rec.program_parent_id);

Line 4161: AMS_CpyUtility_PVT.get_column_value ('parentProgramId', p_copy_columns_table, l_new_ptr_pgrm_rec.program_parent_id);

4157:
4158: AMS_CpyUtility_PVT.get_column_value ('allowEnrlUntillDate', p_copy_columns_table, l_new_ptr_pgrm_rec.allow_enrl_until_date);
4159: l_new_ptr_pgrm_rec.allow_enrl_until_date := NVL (l_new_ptr_pgrm_rec.allow_enrl_until_date, l_src_ptr_pgrm_rec.allow_enrl_until_date);
4160:
4161: AMS_CpyUtility_PVT.get_column_value ('parentProgramId', p_copy_columns_table, l_new_ptr_pgrm_rec.program_parent_id);
4162: l_new_ptr_pgrm_rec.program_parent_id := NVL (l_new_ptr_pgrm_rec.program_parent_id, l_src_ptr_pgrm_rec.program_parent_id);
4163:
4164: -- Optional columns. From user input.
4165: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_new_ptr_pgrm_rec.program_description);

Line 4165: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_new_ptr_pgrm_rec.program_description);

4161: AMS_CpyUtility_PVT.get_column_value ('parentProgramId', p_copy_columns_table, l_new_ptr_pgrm_rec.program_parent_id);
4162: l_new_ptr_pgrm_rec.program_parent_id := NVL (l_new_ptr_pgrm_rec.program_parent_id, l_src_ptr_pgrm_rec.program_parent_id);
4163:
4164: -- Optional columns. From user input.
4165: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_new_ptr_pgrm_rec.program_description);
4166:
4167:
4168: -- add this for the questionnaire flag
4169: IF AMS_CpyUtility_PVT.is_copy_attribute ('QSNR', p_attributes_table) = FND_API.G_TRUE THEN

Line 4169: IF AMS_CpyUtility_PVT.is_copy_attribute ('QSNR', p_attributes_table) = FND_API.G_TRUE THEN

4165: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_new_ptr_pgrm_rec.program_description);
4166:
4167:
4168: -- add this for the questionnaire flag
4169: IF AMS_CpyUtility_PVT.is_copy_attribute ('QSNR', p_attributes_table) = FND_API.G_TRUE THEN
4170: IF (PV_DEBUG_HIGH_ON) THEN
4171: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'QSNR');
4172: END IF;
4173: l_new_ptr_pgrm_rec.QSNR_TTL_ALL_PAGE_DSP_FLAG := l_src_ptr_pgrm_rec.QSNR_TTL_ALL_PAGE_DSP_FLAG;

Line 4179: IF AMS_CpyUtility_PVT.is_copy_attribute ('CHKLST', p_attributes_table) = FND_API.G_TRUE THEN

4175: l_new_ptr_pgrm_rec.QSNR_FTR_ALL_PAGE_DSP_FLAG := l_src_ptr_pgrm_rec.QSNR_FTR_ALL_PAGE_DSP_FLAG;
4176: END IF;
4177:
4178: -- add this for the allow_enrl_wo_cl_flag flag
4179: IF AMS_CpyUtility_PVT.is_copy_attribute ('CHKLST', p_attributes_table) = FND_API.G_TRUE THEN
4180: IF (PV_DEBUG_HIGH_ON) THEN
4181: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'CHKLST');
4182: END IF;
4183: l_new_ptr_pgrm_rec.allow_enrl_wout_chklst_flag := l_src_ptr_pgrm_rec.allow_enrl_wout_chklst_flag;

Line 4207: IF AMS_CpyUtility_PVT.is_copy_attribute ('QUAL', p_attributes_table) = FND_API.G_TRUE THEN

4203: RAISE FND_API.G_EXC_ERROR;
4204: END IF;
4205:
4206: -- For requirements
4207: IF AMS_CpyUtility_PVT.is_copy_attribute ('QUAL', p_attributes_table) = FND_API.G_TRUE THEN
4208: IF (PV_DEBUG_HIGH_ON) THEN
4209: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'QUAL');
4210: END IF;
4211:

Line 4229: IF AMS_CpyUtility_PVT.is_copy_attribute ('BNFT', p_attributes_table) = FND_API.G_TRUE THEN

4225:
4226: END IF;
4227:
4228: -- For benefits
4229: IF AMS_CpyUtility_PVT.is_copy_attribute ('BNFT', p_attributes_table) = FND_API.G_TRUE THEN
4230: IF (PV_DEBUG_HIGH_ON) THEN
4231: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'BNFT');
4232: END IF;
4233:

Line 4253: IF AMS_CpyUtility_PVT.is_copy_attribute ('PMNT', p_attributes_table) = FND_API.G_TRUE THEN

4249: END IF;
4250: END IF;
4251:
4252: -- For pricing
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 (

Line 4272: IF AMS_CpyUtility_PVT.is_copy_attribute ('GEOG', p_attributes_table) = FND_API.G_TRUE THEN

4268: );
4269: END IF;
4270:
4271: -- For geography
4272: IF AMS_CpyUtility_PVT.is_copy_attribute ('GEOG', p_attributes_table) = FND_API.G_TRUE THEN
4273: IF (PV_DEBUG_HIGH_ON) THEN
4274: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'GEOG');
4275: END IF;
4276: AMS_COPYELEMENTS_PVT.copy_act_geo_areas (

Line 4293: IF AMS_CpyUtility_PVT.is_copy_attribute ('LGLT', p_attributes_table) = FND_API.G_TRUE THEN

4289:
4290: END IF;
4291:
4292: -- For 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 (

Line 4315: IF AMS_CpyUtility_PVT.is_copy_attribute ('QSNR', p_attributes_table) = FND_API.G_TRUE THEN

4311: END IF;
4312: END IF;
4313:
4314: -- For enrollment 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 (

Line 4338: IF AMS_CpyUtility_PVT.is_copy_attribute ('CHKLST', p_attributes_table) = FND_API.G_TRUE THEN

4334: END IF;
4335: END IF;
4336:
4337: -- For approval 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 (

Line 4361: IF AMS_CpyUtility_PVT.is_copy_attribute ('NOTIF', p_attributes_table) = FND_API.G_TRUE THEN

4357: END IF;
4358: END IF;
4359:
4360: -- For notification rules
4361: IF AMS_CpyUtility_PVT.is_copy_attribute ('NOTIF', p_attributes_table) = FND_API.G_TRUE THEN
4362: IF (PV_DEBUG_HIGH_ON) THEN
4363: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'QUAL');
4364: END IF;
4365:

Line 4385: IF AMS_CpyUtility_PVT.is_copy_attribute ('TEAM', p_attributes_table) = FND_API.G_TRUE THEN

4381: END IF;
4382: END IF;
4383:
4384: -- For team
4385: IF AMS_CpyUtility_PVT.is_copy_attribute ('TEAM', p_attributes_table) = FND_API.G_TRUE THEN
4386: IF (PV_DEBUG_HIGH_ON) THEN
4387: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'TEAM');
4388: END IF;
4389: AMS_COPYELEMENTS_PVT.copy_act_access (