APPS.PA_CREATE_RESOURCE dependencies on PA_RESOURCE_LIST_TBL_PKG

Line 4587: PA_Resource_List_tbl_Pkg.Insert_Row(

4583:
4584: -- hr_utility.trace('BG insert');
4585:
4586: --Call Insert_row which inserts a row into PA_RESOURCE_LISTS_ALL_BG table
4587: PA_Resource_List_tbl_Pkg.Insert_Row(
4588: p_name,
4589: p_description,
4590: p_public_flag,
4591: p_group_resource_type_id,

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

5307: */
5308: --End of Commenting for Bug#5094347
5309:
5310: /*Bug 4202015 - Changes Start*/
5311: --If we call PA_Resource_List_tbl_Pkg.Update_Row and then call PA_Resource_List_tbl_Pkg.Insert_Row
5312: --in case no_data_found exception is returned by previous API, then we get
5313: --unique constraint (PA.PA_RESOURCE_LISTS_U2) violation error in case table pa_resource_lists_tl
5314: --is empty. This is due to the fact that although no_data_found has been raised while updating
5315: --record in table pa_resource_lists_tl, we try to insert the same record in table

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

5312: --in case no_data_found exception is returned by previous API, then we get
5313: --unique constraint (PA.PA_RESOURCE_LISTS_U2) violation error in case table pa_resource_lists_tl
5314: --is empty. This is due to the fact that although no_data_found has been raised while updating
5315: --record in table pa_resource_lists_tl, we try to insert the same record in table
5316: --PA_RESOURCE_LISTS_ALL_BG in call to PA_Resource_List_tbl_Pkg.Insert_Row.
5317: --Hence we have coded this API to update the records directly in _BG and _TL tables
5318: --and in case of no_data_found exception we insert records in respective tables.
5319:
5320: Update PA_RESOURCE_LISTS_ALL_BG

Line 5438: /*PA_Resource_List_tbl_Pkg.Update_Row(

5434:
5435: /*Bug 4202015 - Changes End*/
5436:
5437: --Commented the following code for Bug 4202015
5438: /*PA_Resource_List_tbl_Pkg.Update_Row(
5439: X_ROW_ID => l_row_id ,
5440: X_RESOURCE_LIST_ID => P_RESOURCE_LIST_ID ,
5441: X_NAME => P_NAME ,
5442: X_DESCRIPTION => P_DESCRIPTION ,

Line 5457: PA_Resource_List_tbl_Pkg.Insert_row(

5453: X_LAST_UPDATE_LOGIN => 0 );
5454:
5455: EXCEPTION
5456: WHEN no_data_found then
5457: PA_Resource_List_tbl_Pkg.Insert_row(
5458: X_ROW_ID => l_row_id ,
5459: X_RESOURCE_LIST_ID => L_RESOURCE_LIST_ID ,
5460: X_NAME => P_NAME ,
5461: X_DESCRIPTION => P_DESCRIPTION ,