DBA Data[Home] [Help]

APPS.OZF_FUNDS_PVT dependencies on AMS_CPYUTILITY_PVT

Line 5353: -- p_attributes_table: AMS_CpyUtility_PVT.copy_attributes_table_type,

5349: -- leave the field as null if it isn't passed in
5350: -- - copy all attributes passed in from the UI
5351: -- PARAMETERS
5352: -- p_source_object_id: Original object id,
5353: -- p_attributes_table: AMS_CpyUtility_PVT.copy_attributes_table_type,
5354: -- p_copy_columns_table: AMS_CpyUtility_PVT.copy_columns_table_type,
5355: -- x_new_object_id: New object Id.
5356: -- x_custom_setup_id: custom_setup_id.
5357: ---------------------------------------------------------------------

Line 5354: -- p_copy_columns_table: AMS_CpyUtility_PVT.copy_columns_table_type,

5350: -- - copy all attributes passed in from the UI
5351: -- PARAMETERS
5352: -- p_source_object_id: Original object id,
5353: -- p_attributes_table: AMS_CpyUtility_PVT.copy_attributes_table_type,
5354: -- p_copy_columns_table: AMS_CpyUtility_PVT.copy_columns_table_type,
5355: -- x_new_object_id: New object Id.
5356: -- x_custom_setup_id: custom_setup_id.
5357: ---------------------------------------------------------------------
5358: PROCEDURE copy_fund (

Line 5367: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,

5363: x_return_status OUT NOCOPY VARCHAR2,
5364: x_msg_count OUT NOCOPY NUMBER,
5365: x_msg_data OUT NOCOPY VARCHAR2,
5366: p_source_object_id IN NUMBER,
5367: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
5368: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
5369: x_new_object_id OUT NOCOPY NUMBER,
5370: x_custom_setup_id OUT NOCOPY NUMBER
5371: )

Line 5368: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,

5364: x_msg_count OUT NOCOPY NUMBER,
5365: x_msg_data OUT NOCOPY VARCHAR2,
5366: p_source_object_id IN NUMBER,
5367: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
5368: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
5369: x_new_object_id OUT NOCOPY NUMBER,
5370: x_custom_setup_id OUT NOCOPY NUMBER
5371: )
5372: IS

Line 5405: l_attr_table AMS_CpyUtility_PVT.copy_attributes_table_type;

5401: l_reference_rec c_fund%ROWTYPE;
5402: l_new_fund_rec c_fund%ROWTYPE;
5403: l_offer_custsetup NUMBER;
5404: l_plan_id NUMBER;
5405: l_attr_table AMS_CpyUtility_PVT.copy_attributes_table_type;
5406: l_copy_columns_table AMS_CpyUtility_PVT.copy_columns_table_type;
5407:
5408: -- julou: get custom_setup_id for FAB offer. bug fix for copy offer enhancement
5409: CURSOR c_custom_setup_id(p_obj_id NUMBER) IS

Line 5406: l_copy_columns_table AMS_CpyUtility_PVT.copy_columns_table_type;

5402: l_new_fund_rec c_fund%ROWTYPE;
5403: l_offer_custsetup NUMBER;
5404: l_plan_id NUMBER;
5405: l_attr_table AMS_CpyUtility_PVT.copy_attributes_table_type;
5406: l_copy_columns_table AMS_CpyUtility_PVT.copy_columns_table_type;
5407:
5408: -- julou: get custom_setup_id for FAB offer. bug fix for copy offer enhancement
5409: CURSOR c_custom_setup_id(p_obj_id NUMBER) IS
5410: SELECT custom_setup_id

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

5440: --
5441: -- Start of API body.
5442: --
5443: -- Initialize the new fund record
5444: -- use ams_cpyutility_pvt.get_column_value to fetch a value
5445: -- to replace the reference column value with a new value
5446: -- passed in from the UI through p_copy_columns_table.
5447: OPEN c_fund (p_source_object_id);
5448: FETCH c_fund INTO l_reference_rec;

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

5531: l_fund_rec.currency_code_tc := l_reference_rec.currency_code_tc;
5532:
5533: -- if field is not passed in from copy_columns_table
5534: -- copy from the base object
5535: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_fund_rec.owner);
5536: l_fund_rec.owner := NVL (l_fund_rec.owner, l_reference_rec.owner);
5537:
5538: AMS_CpyUtility_PVT.get_column_value ('startDate', p_copy_columns_table, l_fund_rec.start_date_active);
5539: l_fund_rec.start_date_active := NVL (l_fund_rec.start_date_active, l_reference_rec.start_date_active);

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

5534: -- copy from the base object
5535: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_fund_rec.owner);
5536: l_fund_rec.owner := NVL (l_fund_rec.owner, l_reference_rec.owner);
5537:
5538: AMS_CpyUtility_PVT.get_column_value ('startDate', p_copy_columns_table, l_fund_rec.start_date_active);
5539: l_fund_rec.start_date_active := NVL (l_fund_rec.start_date_active, l_reference_rec.start_date_active);
5540:
5541: -- if field is not passed in from copy_columns_table
5542: -- don't copy

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

5539: l_fund_rec.start_date_active := NVL (l_fund_rec.start_date_active, l_reference_rec.start_date_active);
5540:
5541: -- if field is not passed in from copy_columns_table
5542: -- don't copy
5543: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_fund_rec.short_name);
5544:
5545: IF l_fund_rec.fund_type = 'FULLY_ACCRUED' THEN
5546: -- to fix bug 3240787
5547: IF l_fund_rec.parent_fund_id IS NULL THEN

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

5651:
5652: -- copy market_segments
5653:
5654:
5655: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_TRUE THEN
5656:
5657: AMS_CopyElements_PVT.copy_act_market_segments (
5658: p_src_act_type => L_OBJECT_TYPE_FUND,
5659: p_new_act_type => L_OBJECT_TYPE_FUND,

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

5668: END IF;
5669: END IF;
5670:
5671: -- copy product
5672: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_CopyElements_PVT.G_ATTRIBUTE_PROD, p_attributes_table) = FND_API.G_TRUE THEN
5673: AMS_CopyElements_PVT.copy_act_prod(
5674: p_src_act_type => L_OBJECT_TYPE_FUND,
5675: p_new_act_type => L_OBJECT_TYPE_FUND,
5676: p_src_act_id => p_source_object_id,