APPS.AME_ATTRIBUTE_USAGES_API dependencies on AME_CALLING_APPS

Line 432: from AME_CALLING_APPS

428: (
429: X_APPLICATION_NAME in VARCHAR2
430: ) is
431: select APPLICATION_ID, LINE_ITEM_ID_QUERY
432: from AME_CALLING_APPS
433: where APPLICATION_NAME = X_APPLICATION_NAME
434: and sysdate between START_DATE
435: and nvl(END_DATE - (1/86400), sysdate);
436:

Line 556: X_LINE_ITEM_QUERY ame_calling_apps.line_item_id_query%type;

552: ) is
553: X_BY_POSITION INTEGER;
554: X_ORDER_BY_POSITION INTEGER;
555: X_ORDER_POSITION INTEGER;
556: X_LINE_ITEM_QUERY ame_calling_apps.line_item_id_query%type;
557: X_TEMP_LINE_QUERY ame_calling_apps.line_item_id_query%type;
558: begin
559: /* remove the order by clause from the line_item_id_query before
560: replacing the place holder column :lineItemIdList with '('||X_LINE_ITEM_ID_QUERY||')'*/

Line 557: X_TEMP_LINE_QUERY ame_calling_apps.line_item_id_query%type;

553: X_BY_POSITION INTEGER;
554: X_ORDER_BY_POSITION INTEGER;
555: X_ORDER_POSITION INTEGER;
556: X_LINE_ITEM_QUERY ame_calling_apps.line_item_id_query%type;
557: X_TEMP_LINE_QUERY ame_calling_apps.line_item_id_query%type;
558: begin
559: /* remove the order by clause from the line_item_id_query before
560: replacing the place holder column :lineItemIdList with '('||X_LINE_ITEM_ID_QUERY||')'*/
561: X_TEMP_LINE_QUERY := upper(X_LINE_ITEM_ID_QUERY);