DBA Data[Home] [Help]

APPS.PA_RESOURCE_LIST_TBL_PKG dependencies on PA_RESOURCE_LISTS_TL

Line 196: insert into pa_resource_lists_tl (

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

Line 222: from pa_resource_lists_tl T

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

Line 288: update pa_resource_lists_tl set

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

Line 377: delete from pa_resource_lists_tl

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