APPS.AME_PRODUCTION_ACTIONS_API dependencies on AME_ACTIONS_TL

Line 88: insert into AME_ACTIONS_TL

84: if not AME_SEED_UTILITY.MLS_ENABLED then
85: return;
86: end if;
87:
88: insert into AME_ACTIONS_TL
89: (ACTION_ID
90: ,DESCRIPTION
91: ,CREATED_BY
92: ,CREATION_DATE

Line 110: from AME_ACTIONS_TL T

106: userenv('LANG')
107: from FND_LANGUAGES L
108: where L.INSTALLED_FLAG in ('I', 'B')
109: and not exists (select null
110: from AME_ACTIONS_TL T
111: where T.ACTION_ID = X_ACTION_ID
112: and T.LANGUAGE = L.LANGUAGE_CODE);
113:
114: end INSERT_ROW;

Line 184: update AME_ACTIONS_TL

180: if not AME_SEED_UTILITY.MLS_ENABLED then
181: return;
182: end if;
183:
184: update AME_ACTIONS_TL
185: set DESCRIPTION = X_DESCRIPTION,
186: SOURCE_LANG = userenv('LANG'),
187: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
188: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 235: L_DESCRIPTION AME_ACTIONS_TL.DESCRIPTION%TYPE;

231: L_ACTION_ID number;
232: L_END_DATE date;
233: L_PARAMETER AME_ACTIONS.PARAMETER%TYPE;
234: L_PARAMETER_TWO AME_ACTIONS.PARAMETER_TWO%TYPE;
235: L_DESCRIPTION AME_ACTIONS_TL.DESCRIPTION%TYPE;
236: L_ACTION_TYPE_NAME AME_ACTION_TYPES.NAME%TYPE;
237: L_OWNER varchar2(100);
238: L_LAST_UPDATE_DATE varchar2(19);
239: L_OBJECT_VERSION_NUMBER number;

Line 332: L_DESCRIPTION AME_ACTIONS_TL.DESCRIPTION%TYPE;

328: L_ACTION_TYPE_ID number;
329: L_ACTION_ID number;
330: L_PARAMETER AME_ACTIONS.PARAMETER%TYPE;
331: L_PARAMETER_TWO AME_ACTIONS.PARAMETER_TWO%TYPE;
332: L_DESCRIPTION AME_ACTIONS_TL.DESCRIPTION%TYPE;
333: L_ACTION_TYPE_NAME AME_ACTION_TYPES.NAME%TYPE;
334: L_OWNER varchar2(100);
335: L_LAST_UPDATE_DATE varchar2(19);
336: begin

Line 359: from AME_ACTIONS_TL ACTTL,

355:
356: begin
357: select ACT.ACTION_ID
358: into L_ACTION_ID
359: from AME_ACTIONS_TL ACTTL,
360: AME_ACTIONS ACT
361: where ACT.ACTION_TYPE_ID = L_ACTION_TYPE_ID
362: and ACT.ACTION_ID = ACTTL.ACTION_ID
363: and ACT.PARAMETER = L_PARAMETER

Line 368: update AME_ACTIONS_TL ACTTL

364: and ACT.PARAMETER_TWO = L_PARAMETER_TWO
365: and ACTTL.LANGUAGE = userenv('LANG')
366: and sysdate between ACT.START_DATE and nvl(ACT.END_DATE - (1/86400),sysdate);
367:
368: update AME_ACTIONS_TL ACTTL
369: set DESCRIPTION = nvl(L_DESCRIPTION,DESCRIPTION),
370: SOURCE_LANG = userenv('LANG'),
371: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE),
372: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER),

Line 403: from AME_ACTIONS_TL ACTTL,

399: AME_SEED_UTILITY.OWNER_AS_STRING(ACTTL.CREATED_BY)
400: into X_CURRENT_OWNER,
401: X_CURRENT_LAST_UPDATE_DATE,
402: X_CREATED_BY
403: from AME_ACTIONS_TL ACTTL,
404: AME_ACTIONS ACT,
405: AME_ACTION_TYPES AAT
406: where ACT.ACTION_TYPE_ID = AAT.ACTION_TYPE_ID
407: and ACTTL.ACTION_ID = ACT.ACTION_ID

Line 511: delete from AME_ACTIONS_TL

507: (X_ACTION_ID in number
508: ) as
509: begin
510: if AME_SEED_UTILITY.MLS_ENABLED then
511: delete from AME_ACTIONS_TL
512: where ACTION_ID = X_ACTION_ID;
513: end if;
514: delete from AME_ACTIONS
515: where ACTION_ID = X_ACTION_ID;