APPS.AME_CALLING_APPS_API dependencies on AME_ITEM_CLASS_USAGES

Line 61: from AME_ITEM_CLASS_USAGES

57: nvl(OBJECT_VERSION_NUMBER,1),
58: LAST_UPDATED_BY,
59: to_char(LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
60: ITEM_ID_QUERY
61: from AME_ITEM_CLASS_USAGES
62: where APPLICATION_ID = X_APPLICATION_ID
63: and ITEM_CLASS_ID = 2
64: and sysdate between START_DATE
65: and nvl(END_DATE - (1/86400), sysdate);

Line 107: -- get current item class usage from ame_item_class_usages, if AME11510

103: X_CALLING_APPS_ROWID:= null;
104: end if;
105: close CSR_GET_CURRENT_CALLING_APP;
106: --
107: -- get current item class usage from ame_item_class_usages, if AME11510
108: -- patch is already applied
109: --
110: if(X_AME_INSTALLATION_LEVEL is not null and applicationId is not null) then
111: open CSR_GET_CURRENT_USAGE(applicationId);

Line 263: insert into AME_ITEM_CLASS_USAGES

259: --do not populate usage row if AME11510 full patch has not been applied
260: if X_AME_INSTALLATION_LEVEL IS NULL then
261: return;
262: end if;
263: insert into AME_ITEM_CLASS_USAGES
264: (
265: APPLICATION_ID,
266: ITEM_CLASS_ID,
267: ITEM_ID_QUERY,

Line 312: update AME_ITEM_CLASS_USAGES

308: X_END_DATE in DATE,
309: X_OBJECT_VERSION_NUMBER in NUMBER
310: ) is
311: begin
312: update AME_ITEM_CLASS_USAGES
313: set ITEM_ID_QUERY = X_ITEM_ID_QUERY,
314: ITEM_CLASS_ORDER_NUMBER = X_ITEM_CLASS_ORDER_NUMBER,
315: ITEM_CLASS_PAR_MODE = X_ITEM_CLASS_PAR_MODE,
316: ITEM_CLASS_SUBLIST_MODE = X_ITEM_CLASS_SUBLIST_MODE,

Line 430: update AME_ITEM_CLASS_USAGES

426: --do not populate usage row if AME11510 full patch has not been applied
427: if X_AME_INSTALLATION_LEVEL IS NULL then
428: return;
429: end if;
430: update AME_ITEM_CLASS_USAGES
431: set END_DATE = X_END_DATE
432: where ROWID = X_USAGE_ROWID;
433: end UPDATE_USAGE_ROW;
434:

Line 798: X_CURRENT_ITEM_ID_QUERY ame_item_class_usages.item_id_query%type;

794: is
795: X_APPLICATION_ID NUMBER;
796: X_CALLING_APPS_ROWID ROWID;
797: X_CREATED_BY NUMBER;
798: X_CURRENT_ITEM_ID_QUERY ame_item_class_usages.item_id_query%type;
799: X_CURRENT_LAST_UPDATE_DATE VARCHAR2(19);
800: X_CURRENT_OWNER NUMBER;
801: X_CURRENT_USAGE_OWNER NUMBER;
802: X_CURRENT_USAGE_LUD VARCHAR2(19);

Line 888: -- insert new row for ame_item_class_usages header

884: X_LAST_UPDATED_BY,
885: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
886: X_LAST_UPDATE_LOGIN
887: );
888: -- insert new row for ame_item_class_usages header
889: INSERT_USAGE_ROW (
890: X_APPLICATION_ID,
891: 1,
892: 'select :transactionId from dual',

Line 904: -- insert new row for ame_item_class_usages header

900: X_LAST_UPDATE_LOGIN,
901: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
902: 1);
903: if X_LINE_ITEM_ID_QUERY is not null then
904: -- insert new row for ame_item_class_usages header
905: INSERT_USAGE_ROW (
906: X_APPLICATION_ID,
907: 2,
908: X_LINE_ITEM_ID_QUERY,