APPS.PA_CREATE_RESOURCE dependencies on PA_RESOURCE_LIST_TBL_PKG

Line 4235: PA_Resource_List_tbl_Pkg.Insert_Row(

4231:
4232: -- hr_utility.trace('BG insert');
4233:
4234: --Call Insert_row which inserts a row into PA_RESOURCE_LISTS_ALL_BG table
4235: PA_Resource_List_tbl_Pkg.Insert_Row(
4236: p_name,
4237: p_description,
4238: p_public_flag,
4239: p_group_resource_type_id,

Line 4956: --If we call PA_Resource_List_tbl_Pkg.Update_Row and then call PA_Resource_List_tbl_Pkg.Insert_Row

4952: */
4953: --End of Commenting for Bug#5094347
4954:
4955: /*Bug 4202015 - Changes Start*/
4956: --If we call PA_Resource_List_tbl_Pkg.Update_Row and then call PA_Resource_List_tbl_Pkg.Insert_Row
4957: --in case no_data_found exception is returned by previous API, then we get
4958: --unique constraint (PA.PA_RESOURCE_LISTS_U2) violation error in case table pa_resource_lists_tl
4959: --is empty. This is due to the fact that although no_data_found has been raised while updating
4960: --record in table pa_resource_lists_tl, we try to insert the same record in table

Line 4961: --PA_RESOURCE_LISTS_ALL_BG in call to PA_Resource_List_tbl_Pkg.Insert_Row.

4957: --in case no_data_found exception is returned by previous API, then we get
4958: --unique constraint (PA.PA_RESOURCE_LISTS_U2) violation error in case table pa_resource_lists_tl
4959: --is empty. This is due to the fact that although no_data_found has been raised while updating
4960: --record in table pa_resource_lists_tl, we try to insert the same record in table
4961: --PA_RESOURCE_LISTS_ALL_BG in call to PA_Resource_List_tbl_Pkg.Insert_Row.
4962: --Hence we have coded this API to update the records directly in _BG and _TL tables
4963: --and in case of no_data_found exception we insert records in respective tables.
4964:
4965: Update PA_RESOURCE_LISTS_ALL_BG

Line 5083: /*PA_Resource_List_tbl_Pkg.Update_Row(

5079:
5080: /*Bug 4202015 - Changes End*/
5081:
5082: --Commented the following code for Bug 4202015
5083: /*PA_Resource_List_tbl_Pkg.Update_Row(
5084: X_ROW_ID => l_row_id ,
5085: X_RESOURCE_LIST_ID => P_RESOURCE_LIST_ID ,
5086: X_NAME => P_NAME ,
5087: X_DESCRIPTION => P_DESCRIPTION ,

Line 5102: PA_Resource_List_tbl_Pkg.Insert_row(

5098: X_LAST_UPDATE_LOGIN => 0 );
5099:
5100: EXCEPTION
5101: WHEN no_data_found then
5102: PA_Resource_List_tbl_Pkg.Insert_row(
5103: X_ROW_ID => l_row_id ,
5104: X_RESOURCE_LIST_ID => L_RESOURCE_LIST_ID ,
5105: X_NAME => P_NAME ,
5106: X_DESCRIPTION => P_DESCRIPTION ,