[Home] [Help]
1: PACKAGE BODY pa_project_assets_pub AS
2: /*$Header: PAPMPAPB.pls 120.3 2005/12/19 12:07:14 dlanka noship $*/
3:
4: --Global constants to be used in error messages
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECT_ASSETS_PUB';
1: PACKAGE BODY pa_project_assets_pub AS
2: /*$Header: PAPMPAPB.pls 120.3 2005/12/19 12:07:14 dlanka noship $*/
3:
4: --Global constants to be used in error messages
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECT_ASSETS_PUB';
6: G_ASSET_CODE CONSTANT VARCHAR2(5) := 'ASSET';
7:
8: --Global constants to be used in inserts and updates
9: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
87: ,p_pm_asset_reference_out OUT NOCOPY VARCHAR2) IS
88:
89:
90:
91: l_asset_in_rec PA_PROJECT_ASSETS_PUB.asset_in_rec_type;
92:
93:
94: --Used to get the project number for AMG messages
95: CURSOR l_amg_project_csr(x_project_id NUMBER) IS
97: FROM pa_projects p
98: WHERE p.project_id = x_project_id;
99:
100: l_amg_project_number pa_projects_all.segment1%TYPE;
101: l_amg_pa_asset_name pa_project_assets_all.asset_name%TYPE;
102:
103:
104: --Used to determine if the project is CAPITAL
105: CURSOR capital_project_cur(x_project_id NUMBER) IS
115:
116: --Used to determine if asset ref is unique within project
117: CURSOR unique_ref_cur(x_project_id NUMBER) IS
118: SELECT 'Asset Ref Exists'
119: FROM pa_project_assets_all
120: WHERE project_id = x_project_id
121: AND pm_asset_reference = l_asset_in_rec.pm_asset_reference;
122:
123: unique_ref_rec unique_ref_cur%ROWTYPE;
125:
126: --Used to determine if asset name is unique within project
127: CURSOR unique_name_cur(x_project_id NUMBER) IS
128: SELECT 'Asset Name Exists'
129: FROM pa_project_assets_all
130: WHERE project_id = x_project_id
131: AND asset_name = l_asset_in_rec.pa_asset_name;
132:
133: unique_name_rec unique_name_cur%ROWTYPE;
135:
136: --Used to determine if asset number is unique
137: CURSOR unique_number_cur IS
138: SELECT 'Asset Number Exists'
139: FROM pa_project_assets_all
140: WHERE asset_number = p_asset_number;
141:
142: unique_number_rec unique_number_cur%ROWTYPE;
143:
258:
259: --Used to determine if Tag Number is unique in Oracle Projects
260: CURSOR unique_tag_number_pa_cur IS
261: SELECT 'Tag Number Exists'
262: FROM pa_project_assets_all
263: WHERE tag_number = p_tag_number;
264:
265: unique_tag_number_pa_rec unique_tag_number_pa_cur%ROWTYPE;
266:
1496: END IF; --AS-BUILT asset with Complete Asset Info required
1497:
1498:
1499:
1500: --Validations are complete. Begin INSERT logic for new PA_PROJECT_ASSETS_ALL row.
1501:
1502:
1503: --NULL out any unspecified fields
1504: IF l_asset_in_rec.pa_asset_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1662: END IF;
1663:
1664:
1665: --Get next project_asset_id sequence value
1666: SELECT pa_project_assets_s.NEXTVAL
1667: INTO l_asset_in_rec.pa_project_asset_id
1668: FROM SYS.DUAL;
1669:
1670:
1668: FROM SYS.DUAL;
1669:
1670:
1671: --Insert new project asset, since all validations have passed
1672: INSERT INTO pa_project_assets_all(
1673: project_asset_id,
1674: project_id,
1675: asset_number,
1676: asset_name,
1894:
1895: --Used to get the asset number for AMG messages
1896: CURSOR l_amg_asset_csr(x_project_asset_id NUMBER) IS
1897: SELECT asset_name
1898: FROM pa_project_assets p
1899: WHERE p.project_asset_id = x_project_asset_id;
1900:
1901: l_amg_pa_asset_name pa_project_assets_all.asset_name%TYPE;
1902:
1897: SELECT asset_name
1898: FROM pa_project_assets p
1899: WHERE p.project_asset_id = x_project_asset_id;
1900:
1901: l_amg_pa_asset_name pa_project_assets_all.asset_name%TYPE;
1902:
1903:
1904: --Used to determine if the project is CAPITAL
1905: CURSOR capital_project_cur(x_project_id NUMBER) IS
2293: l_project_asset_id := 0;
2294:
2295: ELSE
2296: --Get project asset id based on PM Asset Reference
2297: PA_PROJECT_ASSETS_PUB.convert_pm_assetref_to_id (
2298: p_pa_project_id => l_project_id,
2299: p_pa_project_asset_id => p_pa_project_asset_id,
2300: p_pm_asset_reference => p_pm_asset_reference,
2301: p_out_project_asset_id => l_project_asset_id,
2860:
2861: --Used to get the asset number for AMG messages
2862: CURSOR l_amg_asset_csr(x_project_asset_id NUMBER) IS
2863: SELECT asset_name
2864: FROM pa_project_assets p
2865: WHERE p.project_asset_id = x_project_asset_id;
2866:
2867: l_amg_pa_asset_name pa_project_assets_all.asset_name%TYPE;
2868:
2863: SELECT asset_name
2864: FROM pa_project_assets p
2865: WHERE p.project_asset_id = x_project_asset_id;
2866:
2867: l_amg_pa_asset_name pa_project_assets_all.asset_name%TYPE;
2868:
2869:
2870: --Used to determine if the project is CAPITAL
2871: CURSOR capital_project_cur(x_project_id NUMBER) IS
2880:
2881:
2882: CURSOR l_lock_rows_csr( x_project_asset_id NUMBER) IS
2883: SELECT 'x'
2884: FROM pa_project_assets_all
2885: WHERE project_asset_id = x_project_asset_id
2886: FOR UPDATE NOWAIT;
2887:
2888:
2887:
2888:
2889: CURSOR l_asset_cur (x_project_id NUMBER, x_project_asset_id NUMBER) IS
2890: SELECT *
2891: FROM pa_project_assets_all
2892: WHERE project_id = x_project_id
2893: AND project_asset_id = x_project_asset_id;
2894:
2895: l_asset_rec l_asset_cur%ROWTYPE;
2906:
2907: --Used to determine if asset ref is unique within project
2908: CURSOR unique_ref_cur(x_project_id NUMBER) IS
2909: SELECT 'Asset Ref Exists'
2910: FROM pa_project_assets_all
2911: WHERE project_id = x_project_id
2912: AND pm_asset_reference = p_pm_asset_reference;
2913:
2914: unique_ref_rec unique_ref_cur%ROWTYPE;
2916:
2917: --Used to determine if asset name is unique within project
2918: CURSOR unique_name_cur(x_project_id NUMBER) IS
2919: SELECT 'Asset Name Exists'
2920: FROM pa_project_assets_all
2921: WHERE project_id = x_project_id
2922: AND asset_name = p_pa_asset_name;
2923:
2924: unique_name_rec unique_name_cur%ROWTYPE;
2926:
2927: --Used to determine if asset number is unique
2928: CURSOR unique_number_cur IS
2929: SELECT 'Asset Number Exists'
2930: FROM pa_project_assets_all
2931: WHERE asset_number = p_asset_number;
2932:
2933: unique_number_rec unique_number_cur%ROWTYPE;
2934:
2944:
2945: --Used to determine if Tag Number is unique in Oracle Projects
2946: CURSOR unique_tag_number_pa_cur IS
2947: SELECT 'Tag Number Exists'
2948: FROM pa_project_assets_all
2949: WHERE tag_number = p_tag_number;
2950:
2951: unique_tag_number_pa_rec unique_tag_number_pa_cur%ROWTYPE;
2952:
3106: l_statement VARCHAR2(2000);
3107: l_cursor INTEGER;
3108: l_rows INTEGER;
3109: l_project_asset_id NUMBER := 0;
3110: l_pm_asset_reference PA_PROJECT_ASSETS_ALL.pm_asset_reference%TYPE;
3111: l_project_id NUMBER;
3112: l_return_status VARCHAR2(1);
3113: l_function_allowed VARCHAR2(1);
3114: l_resp_id NUMBER := 0;
3134: segtype FND_FLEX_KEY_API.SEGMENT_TYPE;
3135: segname FND_ID_FLEX_SEGMENTS.SEGMENT_NAME%TYPE;
3136:
3137: --Variables used as Bind Parameters for the Dynamic SQL Construct
3138: b_pm_asset_reference PA_PROJECT_ASSETS_ALL.pm_asset_reference%TYPE;
3139: b_pa_asset_name PA_PROJECT_ASSETS_ALL.asset_name%TYPE;
3140: b_asset_description PA_PROJECT_ASSETS_ALL.asset_description%TYPE;
3141: b_date_placed_in_service PA_PROJECT_ASSETS_ALL.date_placed_in_service%TYPE;
3142: b_project_asset_type PA_PROJECT_ASSETS_ALL.project_asset_type%TYPE;
3135: segname FND_ID_FLEX_SEGMENTS.SEGMENT_NAME%TYPE;
3136:
3137: --Variables used as Bind Parameters for the Dynamic SQL Construct
3138: b_pm_asset_reference PA_PROJECT_ASSETS_ALL.pm_asset_reference%TYPE;
3139: b_pa_asset_name PA_PROJECT_ASSETS_ALL.asset_name%TYPE;
3140: b_asset_description PA_PROJECT_ASSETS_ALL.asset_description%TYPE;
3141: b_date_placed_in_service PA_PROJECT_ASSETS_ALL.date_placed_in_service%TYPE;
3142: b_project_asset_type PA_PROJECT_ASSETS_ALL.project_asset_type%TYPE;
3143: b_asset_number PA_PROJECT_ASSETS_ALL.asset_number%TYPE;
3136:
3137: --Variables used as Bind Parameters for the Dynamic SQL Construct
3138: b_pm_asset_reference PA_PROJECT_ASSETS_ALL.pm_asset_reference%TYPE;
3139: b_pa_asset_name PA_PROJECT_ASSETS_ALL.asset_name%TYPE;
3140: b_asset_description PA_PROJECT_ASSETS_ALL.asset_description%TYPE;
3141: b_date_placed_in_service PA_PROJECT_ASSETS_ALL.date_placed_in_service%TYPE;
3142: b_project_asset_type PA_PROJECT_ASSETS_ALL.project_asset_type%TYPE;
3143: b_asset_number PA_PROJECT_ASSETS_ALL.asset_number%TYPE;
3144: b_location_id PA_PROJECT_ASSETS_ALL.location_id%TYPE;
3137: --Variables used as Bind Parameters for the Dynamic SQL Construct
3138: b_pm_asset_reference PA_PROJECT_ASSETS_ALL.pm_asset_reference%TYPE;
3139: b_pa_asset_name PA_PROJECT_ASSETS_ALL.asset_name%TYPE;
3140: b_asset_description PA_PROJECT_ASSETS_ALL.asset_description%TYPE;
3141: b_date_placed_in_service PA_PROJECT_ASSETS_ALL.date_placed_in_service%TYPE;
3142: b_project_asset_type PA_PROJECT_ASSETS_ALL.project_asset_type%TYPE;
3143: b_asset_number PA_PROJECT_ASSETS_ALL.asset_number%TYPE;
3144: b_location_id PA_PROJECT_ASSETS_ALL.location_id%TYPE;
3145: b_assigned_to_person_id PA_PROJECT_ASSETS_ALL.assigned_to_person_id%TYPE;
3138: b_pm_asset_reference PA_PROJECT_ASSETS_ALL.pm_asset_reference%TYPE;
3139: b_pa_asset_name PA_PROJECT_ASSETS_ALL.asset_name%TYPE;
3140: b_asset_description PA_PROJECT_ASSETS_ALL.asset_description%TYPE;
3141: b_date_placed_in_service PA_PROJECT_ASSETS_ALL.date_placed_in_service%TYPE;
3142: b_project_asset_type PA_PROJECT_ASSETS_ALL.project_asset_type%TYPE;
3143: b_asset_number PA_PROJECT_ASSETS_ALL.asset_number%TYPE;
3144: b_location_id PA_PROJECT_ASSETS_ALL.location_id%TYPE;
3145: b_assigned_to_person_id PA_PROJECT_ASSETS_ALL.assigned_to_person_id%TYPE;
3146: b_book_type_code PA_PROJECT_ASSETS_ALL.book_type_code%TYPE;
3139: b_pa_asset_name PA_PROJECT_ASSETS_ALL.asset_name%TYPE;
3140: b_asset_description PA_PROJECT_ASSETS_ALL.asset_description%TYPE;
3141: b_date_placed_in_service PA_PROJECT_ASSETS_ALL.date_placed_in_service%TYPE;
3142: b_project_asset_type PA_PROJECT_ASSETS_ALL.project_asset_type%TYPE;
3143: b_asset_number PA_PROJECT_ASSETS_ALL.asset_number%TYPE;
3144: b_location_id PA_PROJECT_ASSETS_ALL.location_id%TYPE;
3145: b_assigned_to_person_id PA_PROJECT_ASSETS_ALL.assigned_to_person_id%TYPE;
3146: b_book_type_code PA_PROJECT_ASSETS_ALL.book_type_code%TYPE;
3147: b_parent_asset_id PA_PROJECT_ASSETS_ALL.parent_asset_id%TYPE;
3140: b_asset_description PA_PROJECT_ASSETS_ALL.asset_description%TYPE;
3141: b_date_placed_in_service PA_PROJECT_ASSETS_ALL.date_placed_in_service%TYPE;
3142: b_project_asset_type PA_PROJECT_ASSETS_ALL.project_asset_type%TYPE;
3143: b_asset_number PA_PROJECT_ASSETS_ALL.asset_number%TYPE;
3144: b_location_id PA_PROJECT_ASSETS_ALL.location_id%TYPE;
3145: b_assigned_to_person_id PA_PROJECT_ASSETS_ALL.assigned_to_person_id%TYPE;
3146: b_book_type_code PA_PROJECT_ASSETS_ALL.book_type_code%TYPE;
3147: b_parent_asset_id PA_PROJECT_ASSETS_ALL.parent_asset_id%TYPE;
3148: b_asset_category_id PA_PROJECT_ASSETS_ALL.asset_category_id%TYPE;
3141: b_date_placed_in_service PA_PROJECT_ASSETS_ALL.date_placed_in_service%TYPE;
3142: b_project_asset_type PA_PROJECT_ASSETS_ALL.project_asset_type%TYPE;
3143: b_asset_number PA_PROJECT_ASSETS_ALL.asset_number%TYPE;
3144: b_location_id PA_PROJECT_ASSETS_ALL.location_id%TYPE;
3145: b_assigned_to_person_id PA_PROJECT_ASSETS_ALL.assigned_to_person_id%TYPE;
3146: b_book_type_code PA_PROJECT_ASSETS_ALL.book_type_code%TYPE;
3147: b_parent_asset_id PA_PROJECT_ASSETS_ALL.parent_asset_id%TYPE;
3148: b_asset_category_id PA_PROJECT_ASSETS_ALL.asset_category_id%TYPE;
3149: b_amortize_flag PA_PROJECT_ASSETS_ALL.amortize_flag%TYPE;
3142: b_project_asset_type PA_PROJECT_ASSETS_ALL.project_asset_type%TYPE;
3143: b_asset_number PA_PROJECT_ASSETS_ALL.asset_number%TYPE;
3144: b_location_id PA_PROJECT_ASSETS_ALL.location_id%TYPE;
3145: b_assigned_to_person_id PA_PROJECT_ASSETS_ALL.assigned_to_person_id%TYPE;
3146: b_book_type_code PA_PROJECT_ASSETS_ALL.book_type_code%TYPE;
3147: b_parent_asset_id PA_PROJECT_ASSETS_ALL.parent_asset_id%TYPE;
3148: b_asset_category_id PA_PROJECT_ASSETS_ALL.asset_category_id%TYPE;
3149: b_amortize_flag PA_PROJECT_ASSETS_ALL.amortize_flag%TYPE;
3150: b_depreciate_flag PA_PROJECT_ASSETS_ALL.depreciate_flag%TYPE;
3143: b_asset_number PA_PROJECT_ASSETS_ALL.asset_number%TYPE;
3144: b_location_id PA_PROJECT_ASSETS_ALL.location_id%TYPE;
3145: b_assigned_to_person_id PA_PROJECT_ASSETS_ALL.assigned_to_person_id%TYPE;
3146: b_book_type_code PA_PROJECT_ASSETS_ALL.book_type_code%TYPE;
3147: b_parent_asset_id PA_PROJECT_ASSETS_ALL.parent_asset_id%TYPE;
3148: b_asset_category_id PA_PROJECT_ASSETS_ALL.asset_category_id%TYPE;
3149: b_amortize_flag PA_PROJECT_ASSETS_ALL.amortize_flag%TYPE;
3150: b_depreciate_flag PA_PROJECT_ASSETS_ALL.depreciate_flag%TYPE;
3151: b_depreciation_expense_ccid PA_PROJECT_ASSETS_ALL.depreciation_expense_ccid%TYPE;
3144: b_location_id PA_PROJECT_ASSETS_ALL.location_id%TYPE;
3145: b_assigned_to_person_id PA_PROJECT_ASSETS_ALL.assigned_to_person_id%TYPE;
3146: b_book_type_code PA_PROJECT_ASSETS_ALL.book_type_code%TYPE;
3147: b_parent_asset_id PA_PROJECT_ASSETS_ALL.parent_asset_id%TYPE;
3148: b_asset_category_id PA_PROJECT_ASSETS_ALL.asset_category_id%TYPE;
3149: b_amortize_flag PA_PROJECT_ASSETS_ALL.amortize_flag%TYPE;
3150: b_depreciate_flag PA_PROJECT_ASSETS_ALL.depreciate_flag%TYPE;
3151: b_depreciation_expense_ccid PA_PROJECT_ASSETS_ALL.depreciation_expense_ccid%TYPE;
3152: b_asset_key_ccid PA_PROJECT_ASSETS_ALL.asset_key_ccid%TYPE;
3145: b_assigned_to_person_id PA_PROJECT_ASSETS_ALL.assigned_to_person_id%TYPE;
3146: b_book_type_code PA_PROJECT_ASSETS_ALL.book_type_code%TYPE;
3147: b_parent_asset_id PA_PROJECT_ASSETS_ALL.parent_asset_id%TYPE;
3148: b_asset_category_id PA_PROJECT_ASSETS_ALL.asset_category_id%TYPE;
3149: b_amortize_flag PA_PROJECT_ASSETS_ALL.amortize_flag%TYPE;
3150: b_depreciate_flag PA_PROJECT_ASSETS_ALL.depreciate_flag%TYPE;
3151: b_depreciation_expense_ccid PA_PROJECT_ASSETS_ALL.depreciation_expense_ccid%TYPE;
3152: b_asset_key_ccid PA_PROJECT_ASSETS_ALL.asset_key_ccid%TYPE;
3153: b_ret_target_asset_id PA_PROJECT_ASSETS_ALL.ret_target_asset_id%TYPE;
3146: b_book_type_code PA_PROJECT_ASSETS_ALL.book_type_code%TYPE;
3147: b_parent_asset_id PA_PROJECT_ASSETS_ALL.parent_asset_id%TYPE;
3148: b_asset_category_id PA_PROJECT_ASSETS_ALL.asset_category_id%TYPE;
3149: b_amortize_flag PA_PROJECT_ASSETS_ALL.amortize_flag%TYPE;
3150: b_depreciate_flag PA_PROJECT_ASSETS_ALL.depreciate_flag%TYPE;
3151: b_depreciation_expense_ccid PA_PROJECT_ASSETS_ALL.depreciation_expense_ccid%TYPE;
3152: b_asset_key_ccid PA_PROJECT_ASSETS_ALL.asset_key_ccid%TYPE;
3153: b_ret_target_asset_id PA_PROJECT_ASSETS_ALL.ret_target_asset_id%TYPE;
3154: b_asset_units PA_PROJECT_ASSETS_ALL.asset_units%TYPE;
3147: b_parent_asset_id PA_PROJECT_ASSETS_ALL.parent_asset_id%TYPE;
3148: b_asset_category_id PA_PROJECT_ASSETS_ALL.asset_category_id%TYPE;
3149: b_amortize_flag PA_PROJECT_ASSETS_ALL.amortize_flag%TYPE;
3150: b_depreciate_flag PA_PROJECT_ASSETS_ALL.depreciate_flag%TYPE;
3151: b_depreciation_expense_ccid PA_PROJECT_ASSETS_ALL.depreciation_expense_ccid%TYPE;
3152: b_asset_key_ccid PA_PROJECT_ASSETS_ALL.asset_key_ccid%TYPE;
3153: b_ret_target_asset_id PA_PROJECT_ASSETS_ALL.ret_target_asset_id%TYPE;
3154: b_asset_units PA_PROJECT_ASSETS_ALL.asset_units%TYPE;
3155: b_estimated_asset_units PA_PROJECT_ASSETS_ALL.estimated_asset_units%TYPE;
3148: b_asset_category_id PA_PROJECT_ASSETS_ALL.asset_category_id%TYPE;
3149: b_amortize_flag PA_PROJECT_ASSETS_ALL.amortize_flag%TYPE;
3150: b_depreciate_flag PA_PROJECT_ASSETS_ALL.depreciate_flag%TYPE;
3151: b_depreciation_expense_ccid PA_PROJECT_ASSETS_ALL.depreciation_expense_ccid%TYPE;
3152: b_asset_key_ccid PA_PROJECT_ASSETS_ALL.asset_key_ccid%TYPE;
3153: b_ret_target_asset_id PA_PROJECT_ASSETS_ALL.ret_target_asset_id%TYPE;
3154: b_asset_units PA_PROJECT_ASSETS_ALL.asset_units%TYPE;
3155: b_estimated_asset_units PA_PROJECT_ASSETS_ALL.estimated_asset_units%TYPE;
3156: b_estimated_cost PA_PROJECT_ASSETS_ALL.estimated_cost%TYPE;
3149: b_amortize_flag PA_PROJECT_ASSETS_ALL.amortize_flag%TYPE;
3150: b_depreciate_flag PA_PROJECT_ASSETS_ALL.depreciate_flag%TYPE;
3151: b_depreciation_expense_ccid PA_PROJECT_ASSETS_ALL.depreciation_expense_ccid%TYPE;
3152: b_asset_key_ccid PA_PROJECT_ASSETS_ALL.asset_key_ccid%TYPE;
3153: b_ret_target_asset_id PA_PROJECT_ASSETS_ALL.ret_target_asset_id%TYPE;
3154: b_asset_units PA_PROJECT_ASSETS_ALL.asset_units%TYPE;
3155: b_estimated_asset_units PA_PROJECT_ASSETS_ALL.estimated_asset_units%TYPE;
3156: b_estimated_cost PA_PROJECT_ASSETS_ALL.estimated_cost%TYPE;
3157: b_estimated_in_service_date PA_PROJECT_ASSETS_ALL.estimated_in_service_date%TYPE; --Added for bug 4744574
3150: b_depreciate_flag PA_PROJECT_ASSETS_ALL.depreciate_flag%TYPE;
3151: b_depreciation_expense_ccid PA_PROJECT_ASSETS_ALL.depreciation_expense_ccid%TYPE;
3152: b_asset_key_ccid PA_PROJECT_ASSETS_ALL.asset_key_ccid%TYPE;
3153: b_ret_target_asset_id PA_PROJECT_ASSETS_ALL.ret_target_asset_id%TYPE;
3154: b_asset_units PA_PROJECT_ASSETS_ALL.asset_units%TYPE;
3155: b_estimated_asset_units PA_PROJECT_ASSETS_ALL.estimated_asset_units%TYPE;
3156: b_estimated_cost PA_PROJECT_ASSETS_ALL.estimated_cost%TYPE;
3157: b_estimated_in_service_date PA_PROJECT_ASSETS_ALL.estimated_in_service_date%TYPE; --Added for bug 4744574
3158: b_manufacturer_name PA_PROJECT_ASSETS_ALL.manufacturer_name%TYPE;
3151: b_depreciation_expense_ccid PA_PROJECT_ASSETS_ALL.depreciation_expense_ccid%TYPE;
3152: b_asset_key_ccid PA_PROJECT_ASSETS_ALL.asset_key_ccid%TYPE;
3153: b_ret_target_asset_id PA_PROJECT_ASSETS_ALL.ret_target_asset_id%TYPE;
3154: b_asset_units PA_PROJECT_ASSETS_ALL.asset_units%TYPE;
3155: b_estimated_asset_units PA_PROJECT_ASSETS_ALL.estimated_asset_units%TYPE;
3156: b_estimated_cost PA_PROJECT_ASSETS_ALL.estimated_cost%TYPE;
3157: b_estimated_in_service_date PA_PROJECT_ASSETS_ALL.estimated_in_service_date%TYPE; --Added for bug 4744574
3158: b_manufacturer_name PA_PROJECT_ASSETS_ALL.manufacturer_name%TYPE;
3159: b_model_number PA_PROJECT_ASSETS_ALL.model_number%TYPE;
3152: b_asset_key_ccid PA_PROJECT_ASSETS_ALL.asset_key_ccid%TYPE;
3153: b_ret_target_asset_id PA_PROJECT_ASSETS_ALL.ret_target_asset_id%TYPE;
3154: b_asset_units PA_PROJECT_ASSETS_ALL.asset_units%TYPE;
3155: b_estimated_asset_units PA_PROJECT_ASSETS_ALL.estimated_asset_units%TYPE;
3156: b_estimated_cost PA_PROJECT_ASSETS_ALL.estimated_cost%TYPE;
3157: b_estimated_in_service_date PA_PROJECT_ASSETS_ALL.estimated_in_service_date%TYPE; --Added for bug 4744574
3158: b_manufacturer_name PA_PROJECT_ASSETS_ALL.manufacturer_name%TYPE;
3159: b_model_number PA_PROJECT_ASSETS_ALL.model_number%TYPE;
3160: b_tag_number PA_PROJECT_ASSETS_ALL.tag_number%TYPE;
3153: b_ret_target_asset_id PA_PROJECT_ASSETS_ALL.ret_target_asset_id%TYPE;
3154: b_asset_units PA_PROJECT_ASSETS_ALL.asset_units%TYPE;
3155: b_estimated_asset_units PA_PROJECT_ASSETS_ALL.estimated_asset_units%TYPE;
3156: b_estimated_cost PA_PROJECT_ASSETS_ALL.estimated_cost%TYPE;
3157: b_estimated_in_service_date PA_PROJECT_ASSETS_ALL.estimated_in_service_date%TYPE; --Added for bug 4744574
3158: b_manufacturer_name PA_PROJECT_ASSETS_ALL.manufacturer_name%TYPE;
3159: b_model_number PA_PROJECT_ASSETS_ALL.model_number%TYPE;
3160: b_tag_number PA_PROJECT_ASSETS_ALL.tag_number%TYPE;
3161: b_serial_number PA_PROJECT_ASSETS_ALL.serial_number%TYPE;
3154: b_asset_units PA_PROJECT_ASSETS_ALL.asset_units%TYPE;
3155: b_estimated_asset_units PA_PROJECT_ASSETS_ALL.estimated_asset_units%TYPE;
3156: b_estimated_cost PA_PROJECT_ASSETS_ALL.estimated_cost%TYPE;
3157: b_estimated_in_service_date PA_PROJECT_ASSETS_ALL.estimated_in_service_date%TYPE; --Added for bug 4744574
3158: b_manufacturer_name PA_PROJECT_ASSETS_ALL.manufacturer_name%TYPE;
3159: b_model_number PA_PROJECT_ASSETS_ALL.model_number%TYPE;
3160: b_tag_number PA_PROJECT_ASSETS_ALL.tag_number%TYPE;
3161: b_serial_number PA_PROJECT_ASSETS_ALL.serial_number%TYPE;
3162: b_attribute_category PA_PROJECT_ASSETS_ALL.attribute_category%TYPE;
3155: b_estimated_asset_units PA_PROJECT_ASSETS_ALL.estimated_asset_units%TYPE;
3156: b_estimated_cost PA_PROJECT_ASSETS_ALL.estimated_cost%TYPE;
3157: b_estimated_in_service_date PA_PROJECT_ASSETS_ALL.estimated_in_service_date%TYPE; --Added for bug 4744574
3158: b_manufacturer_name PA_PROJECT_ASSETS_ALL.manufacturer_name%TYPE;
3159: b_model_number PA_PROJECT_ASSETS_ALL.model_number%TYPE;
3160: b_tag_number PA_PROJECT_ASSETS_ALL.tag_number%TYPE;
3161: b_serial_number PA_PROJECT_ASSETS_ALL.serial_number%TYPE;
3162: b_attribute_category PA_PROJECT_ASSETS_ALL.attribute_category%TYPE;
3163: b_attribute1 PA_PROJECT_ASSETS_ALL.attribute1%TYPE;
3156: b_estimated_cost PA_PROJECT_ASSETS_ALL.estimated_cost%TYPE;
3157: b_estimated_in_service_date PA_PROJECT_ASSETS_ALL.estimated_in_service_date%TYPE; --Added for bug 4744574
3158: b_manufacturer_name PA_PROJECT_ASSETS_ALL.manufacturer_name%TYPE;
3159: b_model_number PA_PROJECT_ASSETS_ALL.model_number%TYPE;
3160: b_tag_number PA_PROJECT_ASSETS_ALL.tag_number%TYPE;
3161: b_serial_number PA_PROJECT_ASSETS_ALL.serial_number%TYPE;
3162: b_attribute_category PA_PROJECT_ASSETS_ALL.attribute_category%TYPE;
3163: b_attribute1 PA_PROJECT_ASSETS_ALL.attribute1%TYPE;
3164: b_attribute2 PA_PROJECT_ASSETS_ALL.attribute2%TYPE;
3157: b_estimated_in_service_date PA_PROJECT_ASSETS_ALL.estimated_in_service_date%TYPE; --Added for bug 4744574
3158: b_manufacturer_name PA_PROJECT_ASSETS_ALL.manufacturer_name%TYPE;
3159: b_model_number PA_PROJECT_ASSETS_ALL.model_number%TYPE;
3160: b_tag_number PA_PROJECT_ASSETS_ALL.tag_number%TYPE;
3161: b_serial_number PA_PROJECT_ASSETS_ALL.serial_number%TYPE;
3162: b_attribute_category PA_PROJECT_ASSETS_ALL.attribute_category%TYPE;
3163: b_attribute1 PA_PROJECT_ASSETS_ALL.attribute1%TYPE;
3164: b_attribute2 PA_PROJECT_ASSETS_ALL.attribute2%TYPE;
3165: b_attribute3 PA_PROJECT_ASSETS_ALL.attribute3%TYPE;
3158: b_manufacturer_name PA_PROJECT_ASSETS_ALL.manufacturer_name%TYPE;
3159: b_model_number PA_PROJECT_ASSETS_ALL.model_number%TYPE;
3160: b_tag_number PA_PROJECT_ASSETS_ALL.tag_number%TYPE;
3161: b_serial_number PA_PROJECT_ASSETS_ALL.serial_number%TYPE;
3162: b_attribute_category PA_PROJECT_ASSETS_ALL.attribute_category%TYPE;
3163: b_attribute1 PA_PROJECT_ASSETS_ALL.attribute1%TYPE;
3164: b_attribute2 PA_PROJECT_ASSETS_ALL.attribute2%TYPE;
3165: b_attribute3 PA_PROJECT_ASSETS_ALL.attribute3%TYPE;
3166: b_attribute4 PA_PROJECT_ASSETS_ALL.attribute4%TYPE;
3159: b_model_number PA_PROJECT_ASSETS_ALL.model_number%TYPE;
3160: b_tag_number PA_PROJECT_ASSETS_ALL.tag_number%TYPE;
3161: b_serial_number PA_PROJECT_ASSETS_ALL.serial_number%TYPE;
3162: b_attribute_category PA_PROJECT_ASSETS_ALL.attribute_category%TYPE;
3163: b_attribute1 PA_PROJECT_ASSETS_ALL.attribute1%TYPE;
3164: b_attribute2 PA_PROJECT_ASSETS_ALL.attribute2%TYPE;
3165: b_attribute3 PA_PROJECT_ASSETS_ALL.attribute3%TYPE;
3166: b_attribute4 PA_PROJECT_ASSETS_ALL.attribute4%TYPE;
3167: b_attribute5 PA_PROJECT_ASSETS_ALL.attribute5%TYPE;
3160: b_tag_number PA_PROJECT_ASSETS_ALL.tag_number%TYPE;
3161: b_serial_number PA_PROJECT_ASSETS_ALL.serial_number%TYPE;
3162: b_attribute_category PA_PROJECT_ASSETS_ALL.attribute_category%TYPE;
3163: b_attribute1 PA_PROJECT_ASSETS_ALL.attribute1%TYPE;
3164: b_attribute2 PA_PROJECT_ASSETS_ALL.attribute2%TYPE;
3165: b_attribute3 PA_PROJECT_ASSETS_ALL.attribute3%TYPE;
3166: b_attribute4 PA_PROJECT_ASSETS_ALL.attribute4%TYPE;
3167: b_attribute5 PA_PROJECT_ASSETS_ALL.attribute5%TYPE;
3168: b_attribute6 PA_PROJECT_ASSETS_ALL.attribute6%TYPE;
3161: b_serial_number PA_PROJECT_ASSETS_ALL.serial_number%TYPE;
3162: b_attribute_category PA_PROJECT_ASSETS_ALL.attribute_category%TYPE;
3163: b_attribute1 PA_PROJECT_ASSETS_ALL.attribute1%TYPE;
3164: b_attribute2 PA_PROJECT_ASSETS_ALL.attribute2%TYPE;
3165: b_attribute3 PA_PROJECT_ASSETS_ALL.attribute3%TYPE;
3166: b_attribute4 PA_PROJECT_ASSETS_ALL.attribute4%TYPE;
3167: b_attribute5 PA_PROJECT_ASSETS_ALL.attribute5%TYPE;
3168: b_attribute6 PA_PROJECT_ASSETS_ALL.attribute6%TYPE;
3169: b_attribute7 PA_PROJECT_ASSETS_ALL.attribute7%TYPE;
3162: b_attribute_category PA_PROJECT_ASSETS_ALL.attribute_category%TYPE;
3163: b_attribute1 PA_PROJECT_ASSETS_ALL.attribute1%TYPE;
3164: b_attribute2 PA_PROJECT_ASSETS_ALL.attribute2%TYPE;
3165: b_attribute3 PA_PROJECT_ASSETS_ALL.attribute3%TYPE;
3166: b_attribute4 PA_PROJECT_ASSETS_ALL.attribute4%TYPE;
3167: b_attribute5 PA_PROJECT_ASSETS_ALL.attribute5%TYPE;
3168: b_attribute6 PA_PROJECT_ASSETS_ALL.attribute6%TYPE;
3169: b_attribute7 PA_PROJECT_ASSETS_ALL.attribute7%TYPE;
3170: b_attribute8 PA_PROJECT_ASSETS_ALL.attribute8%TYPE;
3163: b_attribute1 PA_PROJECT_ASSETS_ALL.attribute1%TYPE;
3164: b_attribute2 PA_PROJECT_ASSETS_ALL.attribute2%TYPE;
3165: b_attribute3 PA_PROJECT_ASSETS_ALL.attribute3%TYPE;
3166: b_attribute4 PA_PROJECT_ASSETS_ALL.attribute4%TYPE;
3167: b_attribute5 PA_PROJECT_ASSETS_ALL.attribute5%TYPE;
3168: b_attribute6 PA_PROJECT_ASSETS_ALL.attribute6%TYPE;
3169: b_attribute7 PA_PROJECT_ASSETS_ALL.attribute7%TYPE;
3170: b_attribute8 PA_PROJECT_ASSETS_ALL.attribute8%TYPE;
3171: b_attribute9 PA_PROJECT_ASSETS_ALL.attribute9%TYPE;
3164: b_attribute2 PA_PROJECT_ASSETS_ALL.attribute2%TYPE;
3165: b_attribute3 PA_PROJECT_ASSETS_ALL.attribute3%TYPE;
3166: b_attribute4 PA_PROJECT_ASSETS_ALL.attribute4%TYPE;
3167: b_attribute5 PA_PROJECT_ASSETS_ALL.attribute5%TYPE;
3168: b_attribute6 PA_PROJECT_ASSETS_ALL.attribute6%TYPE;
3169: b_attribute7 PA_PROJECT_ASSETS_ALL.attribute7%TYPE;
3170: b_attribute8 PA_PROJECT_ASSETS_ALL.attribute8%TYPE;
3171: b_attribute9 PA_PROJECT_ASSETS_ALL.attribute9%TYPE;
3172: b_attribute10 PA_PROJECT_ASSETS_ALL.attribute10%TYPE;
3165: b_attribute3 PA_PROJECT_ASSETS_ALL.attribute3%TYPE;
3166: b_attribute4 PA_PROJECT_ASSETS_ALL.attribute4%TYPE;
3167: b_attribute5 PA_PROJECT_ASSETS_ALL.attribute5%TYPE;
3168: b_attribute6 PA_PROJECT_ASSETS_ALL.attribute6%TYPE;
3169: b_attribute7 PA_PROJECT_ASSETS_ALL.attribute7%TYPE;
3170: b_attribute8 PA_PROJECT_ASSETS_ALL.attribute8%TYPE;
3171: b_attribute9 PA_PROJECT_ASSETS_ALL.attribute9%TYPE;
3172: b_attribute10 PA_PROJECT_ASSETS_ALL.attribute10%TYPE;
3173: b_attribute11 PA_PROJECT_ASSETS_ALL.attribute11%TYPE;
3166: b_attribute4 PA_PROJECT_ASSETS_ALL.attribute4%TYPE;
3167: b_attribute5 PA_PROJECT_ASSETS_ALL.attribute5%TYPE;
3168: b_attribute6 PA_PROJECT_ASSETS_ALL.attribute6%TYPE;
3169: b_attribute7 PA_PROJECT_ASSETS_ALL.attribute7%TYPE;
3170: b_attribute8 PA_PROJECT_ASSETS_ALL.attribute8%TYPE;
3171: b_attribute9 PA_PROJECT_ASSETS_ALL.attribute9%TYPE;
3172: b_attribute10 PA_PROJECT_ASSETS_ALL.attribute10%TYPE;
3173: b_attribute11 PA_PROJECT_ASSETS_ALL.attribute11%TYPE;
3174: b_attribute12 PA_PROJECT_ASSETS_ALL.attribute12%TYPE;
3167: b_attribute5 PA_PROJECT_ASSETS_ALL.attribute5%TYPE;
3168: b_attribute6 PA_PROJECT_ASSETS_ALL.attribute6%TYPE;
3169: b_attribute7 PA_PROJECT_ASSETS_ALL.attribute7%TYPE;
3170: b_attribute8 PA_PROJECT_ASSETS_ALL.attribute8%TYPE;
3171: b_attribute9 PA_PROJECT_ASSETS_ALL.attribute9%TYPE;
3172: b_attribute10 PA_PROJECT_ASSETS_ALL.attribute10%TYPE;
3173: b_attribute11 PA_PROJECT_ASSETS_ALL.attribute11%TYPE;
3174: b_attribute12 PA_PROJECT_ASSETS_ALL.attribute12%TYPE;
3175: b_attribute13 PA_PROJECT_ASSETS_ALL.attribute13%TYPE;
3168: b_attribute6 PA_PROJECT_ASSETS_ALL.attribute6%TYPE;
3169: b_attribute7 PA_PROJECT_ASSETS_ALL.attribute7%TYPE;
3170: b_attribute8 PA_PROJECT_ASSETS_ALL.attribute8%TYPE;
3171: b_attribute9 PA_PROJECT_ASSETS_ALL.attribute9%TYPE;
3172: b_attribute10 PA_PROJECT_ASSETS_ALL.attribute10%TYPE;
3173: b_attribute11 PA_PROJECT_ASSETS_ALL.attribute11%TYPE;
3174: b_attribute12 PA_PROJECT_ASSETS_ALL.attribute12%TYPE;
3175: b_attribute13 PA_PROJECT_ASSETS_ALL.attribute13%TYPE;
3176: b_attribute14 PA_PROJECT_ASSETS_ALL.attribute14%TYPE;
3169: b_attribute7 PA_PROJECT_ASSETS_ALL.attribute7%TYPE;
3170: b_attribute8 PA_PROJECT_ASSETS_ALL.attribute8%TYPE;
3171: b_attribute9 PA_PROJECT_ASSETS_ALL.attribute9%TYPE;
3172: b_attribute10 PA_PROJECT_ASSETS_ALL.attribute10%TYPE;
3173: b_attribute11 PA_PROJECT_ASSETS_ALL.attribute11%TYPE;
3174: b_attribute12 PA_PROJECT_ASSETS_ALL.attribute12%TYPE;
3175: b_attribute13 PA_PROJECT_ASSETS_ALL.attribute13%TYPE;
3176: b_attribute14 PA_PROJECT_ASSETS_ALL.attribute14%TYPE;
3177: b_attribute15 PA_PROJECT_ASSETS_ALL.attribute15%TYPE;
3170: b_attribute8 PA_PROJECT_ASSETS_ALL.attribute8%TYPE;
3171: b_attribute9 PA_PROJECT_ASSETS_ALL.attribute9%TYPE;
3172: b_attribute10 PA_PROJECT_ASSETS_ALL.attribute10%TYPE;
3173: b_attribute11 PA_PROJECT_ASSETS_ALL.attribute11%TYPE;
3174: b_attribute12 PA_PROJECT_ASSETS_ALL.attribute12%TYPE;
3175: b_attribute13 PA_PROJECT_ASSETS_ALL.attribute13%TYPE;
3176: b_attribute14 PA_PROJECT_ASSETS_ALL.attribute14%TYPE;
3177: b_attribute15 PA_PROJECT_ASSETS_ALL.attribute15%TYPE;
3178:
3171: b_attribute9 PA_PROJECT_ASSETS_ALL.attribute9%TYPE;
3172: b_attribute10 PA_PROJECT_ASSETS_ALL.attribute10%TYPE;
3173: b_attribute11 PA_PROJECT_ASSETS_ALL.attribute11%TYPE;
3174: b_attribute12 PA_PROJECT_ASSETS_ALL.attribute12%TYPE;
3175: b_attribute13 PA_PROJECT_ASSETS_ALL.attribute13%TYPE;
3176: b_attribute14 PA_PROJECT_ASSETS_ALL.attribute14%TYPE;
3177: b_attribute15 PA_PROJECT_ASSETS_ALL.attribute15%TYPE;
3178:
3179:
3172: b_attribute10 PA_PROJECT_ASSETS_ALL.attribute10%TYPE;
3173: b_attribute11 PA_PROJECT_ASSETS_ALL.attribute11%TYPE;
3174: b_attribute12 PA_PROJECT_ASSETS_ALL.attribute12%TYPE;
3175: b_attribute13 PA_PROJECT_ASSETS_ALL.attribute13%TYPE;
3176: b_attribute14 PA_PROJECT_ASSETS_ALL.attribute14%TYPE;
3177: b_attribute15 PA_PROJECT_ASSETS_ALL.attribute15%TYPE;
3178:
3179:
3180: BEGIN
3173: b_attribute11 PA_PROJECT_ASSETS_ALL.attribute11%TYPE;
3174: b_attribute12 PA_PROJECT_ASSETS_ALL.attribute12%TYPE;
3175: b_attribute13 PA_PROJECT_ASSETS_ALL.attribute13%TYPE;
3176: b_attribute14 PA_PROJECT_ASSETS_ALL.attribute14%TYPE;
3177: b_attribute15 PA_PROJECT_ASSETS_ALL.attribute15%TYPE;
3178:
3179:
3180: BEGIN
3181:
3371: END IF;
3372:
3373:
3374: --Get project asset id based on PM Asset Reference
3375: PA_PROJECT_ASSETS_PUB.convert_pm_assetref_to_id (
3376: p_pa_project_id => l_project_id,
3377: p_pa_project_asset_id => p_pa_project_asset_id,
3378: p_pm_asset_reference => p_pm_asset_reference,
3379: p_out_project_asset_id => l_project_asset_id,
3407:
3408:
3409: --Initialize update variables
3410: l_update_yes_flag := 'N';
3411: l_statement := 'UPDATE PA_PROJECT_ASSETS SET ';
3412:
3413: --Set the date variables which are used in processing and cursors
3414: l_date_placed_in_service := NVL(p_date_placed_in_service, l_asset_rec.date_placed_in_service);
3415: l_estimated_in_service_date := NVL(p_estimated_in_service_date, l_asset_rec.estimated_in_service_date);
5572:
5573: CURSOR l_project_asset_id_csr
5574: IS
5575: SELECT 'X'
5576: FROM pa_project_assets
5577: WHERE project_asset_id = p_pa_project_asset_id
5578: AND project_id = p_pa_project_id;
5579:
5580:
5579:
5580:
5581: CURSOR l_asset_csr IS
5582: SELECT project_asset_id
5583: FROM pa_project_assets_all
5584: WHERE project_id = p_pa_project_id
5585: AND pm_asset_reference = p_pm_asset_reference;
5586:
5587: l_asset_rec l_asset_csr%ROWTYPE;
5777: IS
5778:
5779: CURSOR c_asset_csr IS
5780: SELECT project_asset_id
5781: FROM pa_project_assets
5782: WHERE project_id = p_pa_project_id
5783: AND pm_asset_reference = p_pm_asset_reference;
5784:
5785: l_asset_rec c_asset_csr%ROWTYPE;
6144: --Used to get the asset number for output parameter
6145: CURSOR l_amg_asset_csr(x_project_asset_id NUMBER,
6146: x_project_id NUMBER) IS
6147: SELECT asset_name
6148: FROM pa_project_assets p
6149: WHERE p.project_asset_id = x_project_asset_id
6150: AND p.project_id = x_project_id;
6151:
6152: l_amg_pa_asset_name pa_project_assets_all.asset_name%TYPE;
6148: FROM pa_project_assets p
6149: WHERE p.project_asset_id = x_project_asset_id
6150: AND p.project_id = x_project_id;
6151:
6152: l_amg_pa_asset_name pa_project_assets_all.asset_name%TYPE;
6153:
6154:
6155: --Used to get the Task number for output parameter
6156: CURSOR l_amg_task_csr (l_project_id NUMBER ,l_task_id NUMBER) IS
6170:
6171: l_project_asset_id NUMBER;
6172: l_project_id NUMBER;
6173: l_task_id NUMBER;
6174: l_pm_asset_reference PA_PROJECT_ASSETS_ALL.pm_asset_reference%TYPE;
6175: l_project_number PA_PROJECTS_ALL.segment1%TYPE;
6176: l_msg_data VARCHAR2(2000);
6177: v_assignment_count NUMBER := 0;
6178:
6700:
6701: --Used to get the asset number for AMG messages
6702: CURSOR l_amg_asset_csr(x_project_asset_id NUMBER) IS
6703: SELECT asset_name
6704: FROM pa_project_assets p
6705: WHERE p.project_asset_id = x_project_asset_id;
6706:
6707: l_amg_pa_asset_name pa_project_assets_all.asset_name%TYPE;
6708:
6703: SELECT asset_name
6704: FROM pa_project_assets p
6705: WHERE p.project_asset_id = x_project_asset_id;
6706:
6707: l_amg_pa_asset_name pa_project_assets_all.asset_name%TYPE;
6708:
6709:
6710: --Used to determine if the project is CAPITAL
6711: CURSOR capital_project_cur(x_project_id NUMBER) IS
6732: --Used to determine if the new assignment already exists
6733: CURSOR lock_asset_cur (x_project_id NUMBER,
6734: x_project_asset_id NUMBER) IS
6735: SELECT 'x'
6736: FROM pa_project_assets
6737: WHERE project_id = x_project_id
6738: AND project_asset_id = x_project_asset_id
6739: FOR UPDATE NOWAIT;
6740:
6968: RAISE FND_API.G_EXC_ERROR;
6969:
6970: ELSE
6971: --Get project asset id based on PM Asset Reference
6972: PA_PROJECT_ASSETS_PUB.convert_pm_assetref_to_id (
6973: p_pa_project_id => l_project_id,
6974: p_pa_project_asset_id => p_pa_project_asset_id,
6975: p_pm_asset_reference => p_pm_asset_reference,
6976: p_out_project_asset_id => l_project_asset_id,
7031: OPEN lock_asset_cur(l_project_id, l_project_asset_id);
7032: CLOSE lock_asset_cur;
7033:
7034:
7035: DELETE pa_project_assets
7036: WHERE project_id = l_project_id
7037: AND project_asset_id = l_project_asset_id;
7038:
7039: END IF;
7387: l_project_asset_id := 0;
7388:
7389: ELSE
7390: --Get project asset id based on PM Asset Reference
7391: PA_PROJECT_ASSETS_PUB.convert_pm_assetref_to_id (
7392: p_pa_project_id => l_project_id,
7393: p_pa_project_asset_id => p_pa_project_asset_id,
7394: p_pm_asset_reference => p_pm_asset_reference,
7395: p_out_project_asset_id => l_project_asset_id,
7490: --JPULTORAK Project Asset Creation
7491:
7492: --------------------------------------------------------------------------------
7493:
7494: END PA_PROJECT_ASSETS_PUB;