DBA Data[Home] [Help]

APPS.OZF_FUNDS_PVT dependencies on AMS_CPYUTILITY_PVT

Line 4951: -- p_attributes_table: AMS_CpyUtility_PVT.copy_attributes_table_type,

4947: -- leave the field as null if it isn't passed in
4948: -- - copy all attributes passed in from the UI
4949: -- PARAMETERS
4950: -- p_source_object_id: Original object id,
4951: -- p_attributes_table: AMS_CpyUtility_PVT.copy_attributes_table_type,
4952: -- p_copy_columns_table: AMS_CpyUtility_PVT.copy_columns_table_type,
4953: -- x_new_object_id: New object Id.
4954: -- x_custom_setup_id: custom_setup_id.
4955: ---------------------------------------------------------------------

Line 4952: -- p_copy_columns_table: AMS_CpyUtility_PVT.copy_columns_table_type,

4948: -- - copy all attributes passed in from the UI
4949: -- PARAMETERS
4950: -- p_source_object_id: Original object id,
4951: -- p_attributes_table: AMS_CpyUtility_PVT.copy_attributes_table_type,
4952: -- p_copy_columns_table: AMS_CpyUtility_PVT.copy_columns_table_type,
4953: -- x_new_object_id: New object Id.
4954: -- x_custom_setup_id: custom_setup_id.
4955: ---------------------------------------------------------------------
4956: PROCEDURE copy_fund (

Line 4965: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,

4961: x_return_status OUT NOCOPY VARCHAR2,
4962: x_msg_count OUT NOCOPY NUMBER,
4963: x_msg_data OUT NOCOPY VARCHAR2,
4964: p_source_object_id IN NUMBER,
4965: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
4966: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
4967: x_new_object_id OUT NOCOPY NUMBER,
4968: x_custom_setup_id OUT NOCOPY NUMBER
4969: )

Line 4966: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,

4962: x_msg_count OUT NOCOPY NUMBER,
4963: x_msg_data OUT NOCOPY VARCHAR2,
4964: p_source_object_id IN NUMBER,
4965: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
4966: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
4967: x_new_object_id OUT NOCOPY NUMBER,
4968: x_custom_setup_id OUT NOCOPY NUMBER
4969: )
4970: IS

Line 5003: l_attr_table AMS_CpyUtility_PVT.copy_attributes_table_type;

4999: l_reference_rec c_fund%ROWTYPE;
5000: l_new_fund_rec c_fund%ROWTYPE;
5001: l_offer_custsetup NUMBER;
5002: l_plan_id NUMBER;
5003: l_attr_table AMS_CpyUtility_PVT.copy_attributes_table_type;
5004: l_copy_columns_table AMS_CpyUtility_PVT.copy_columns_table_type;
5005:
5006: -- julou: get custom_setup_id for FAB offer. bug fix for copy offer enhancement
5007: CURSOR c_custom_setup_id(p_obj_id NUMBER) IS

Line 5004: l_copy_columns_table AMS_CpyUtility_PVT.copy_columns_table_type;

5000: l_new_fund_rec c_fund%ROWTYPE;
5001: l_offer_custsetup NUMBER;
5002: l_plan_id NUMBER;
5003: l_attr_table AMS_CpyUtility_PVT.copy_attributes_table_type;
5004: l_copy_columns_table AMS_CpyUtility_PVT.copy_columns_table_type;
5005:
5006: -- julou: get custom_setup_id for FAB offer. bug fix for copy offer enhancement
5007: CURSOR c_custom_setup_id(p_obj_id NUMBER) IS
5008: SELECT custom_setup_id

Line 5042: -- use ams_cpyutility_pvt.get_column_value to fetch a value

5038: --
5039: -- Start of API body.
5040: --
5041: -- Initialize the new fund record
5042: -- use ams_cpyutility_pvt.get_column_value to fetch a value
5043: -- to replace the reference column value with a new value
5044: -- passed in from the UI through p_copy_columns_table.
5045: OPEN c_fund (p_source_object_id);
5046: FETCH c_fund INTO l_reference_rec;

Line 5133: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_fund_rec.owner);

5129: l_fund_rec.currency_code_tc := l_reference_rec.currency_code_tc;
5130:
5131: -- if field is not passed in from copy_columns_table
5132: -- copy from the base object
5133: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_fund_rec.owner);
5134: l_fund_rec.owner := NVL (l_fund_rec.owner, l_reference_rec.owner);
5135:
5136: AMS_CpyUtility_PVT.get_column_value ('startDate', p_copy_columns_table, l_fund_rec.start_date_active);
5137: l_fund_rec.start_date_active := NVL (l_fund_rec.start_date_active, l_reference_rec.start_date_active);

Line 5136: AMS_CpyUtility_PVT.get_column_value ('startDate', p_copy_columns_table, l_fund_rec.start_date_active);

5132: -- copy from the base object
5133: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_fund_rec.owner);
5134: l_fund_rec.owner := NVL (l_fund_rec.owner, l_reference_rec.owner);
5135:
5136: AMS_CpyUtility_PVT.get_column_value ('startDate', p_copy_columns_table, l_fund_rec.start_date_active);
5137: l_fund_rec.start_date_active := NVL (l_fund_rec.start_date_active, l_reference_rec.start_date_active);
5138:
5139: -- if field is not passed in from copy_columns_table
5140: -- don't copy

Line 5141: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_fund_rec.short_name);

5137: l_fund_rec.start_date_active := NVL (l_fund_rec.start_date_active, l_reference_rec.start_date_active);
5138:
5139: -- if field is not passed in from copy_columns_table
5140: -- don't copy
5141: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_fund_rec.short_name);
5142:
5143: IF l_fund_rec.fund_type = 'FULLY_ACCRUED' THEN
5144: -- to fix bug 3240787
5145: IF l_fund_rec.parent_fund_id IS NULL THEN

Line 5227: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_TRUE THEN

5223:
5224: -- copy market_segments
5225:
5226:
5227: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_TRUE THEN
5228:
5229: AMS_CopyElements_PVT.copy_act_market_segments (
5230: p_src_act_type => L_OBJECT_TYPE_FUND,
5231: p_new_act_type => L_OBJECT_TYPE_FUND,

Line 5244: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_CopyElements_PVT.G_ATTRIBUTE_PROD, p_attributes_table) = FND_API.G_TRUE THEN

5240: END IF;
5241: END IF;
5242:
5243: -- copy product
5244: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_CopyElements_PVT.G_ATTRIBUTE_PROD, p_attributes_table) = FND_API.G_TRUE THEN
5245: AMS_CopyElements_PVT.copy_act_prod(
5246: p_src_act_type => L_OBJECT_TYPE_FUND,
5247: p_new_act_type => L_OBJECT_TYPE_FUND,
5248: p_src_act_id => p_source_object_id,