APPS.PA_RESOURCE_LIST_TBL_PKG dependencies on PA_RESOURCE_LISTS_TL

Line 193: insert into pa_resource_lists_tl (

189: 'Y',
190: 'N', -- open issue
191: NULL);
192:
193: insert into pa_resource_lists_tl (
194: LAST_UPDATE_LOGIN,
195: CREATION_DATE,
196: CREATED_BY,
197: LAST_UPDATE_DATE,

Line 219: from pa_resource_lists_tl T

215: from FND_LANGUAGES L
216: where L.INSTALLED_FLAG in ('I', 'B')
217: and not exists
218: (select NULL
219: from pa_resource_lists_tl T
220: where T.RESOURCE_LIST_ID = X_RESOURCE_LIST_ID
221: and T.LANGUAGE = L.LANGUAGE_CODE);
222:
223: Open Res_Cur;

Line 285: update pa_resource_lists_tl set

281: If SQL%NOTFOUND Then
282: Raise NO_DATA_FOUND;
283: End If;
284:
285: update pa_resource_lists_tl set
286: NAME = X_NAME,
287: DESCRIPTION = X_DESCRIPTION,
288: LAST_UPDATE_DATE = sysdate,
289: LAST_UPDATED_BY = fnd_global.user_id,

Line 374: delete from pa_resource_lists_tl

370:
371: Procedure Delete_Row (X_ROW_ID IN VARCHAR2) Is
372: Begin
373:
374: delete from pa_resource_lists_tl
375: where resource_list_id in (select resource_list_id
376: from PA_RESOURCE_LISTS_ALL_BG
377: Where RowId = X_Row_Id);
378: