APPS.AME_ATTRIBUTES_API dependencies on AME_APPROVER_TYPES

Line 23: L_ORIG_SYSTEM AME_APPROVER_TYPES.ORIG_SYSTEM%TYPE;

19: ,X_LINE_ITEM in out nocopy varchar2
20: ,X_APPROVER_TYPE_ID out nocopy number
21: ,X_ITEM_CLASS_ID out nocopy number
22: ) as
23: L_ORIG_SYSTEM AME_APPROVER_TYPES.ORIG_SYSTEM%TYPE;
24: begin
25: if AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is null then
26: X_APPROVER_TYPE_ID := null;
27: X_ITEM_CLASS_ID := 0;

Line 59: from AME_APPROVER_TYPES AAT

55: else
56: begin
57: select AAT.APPROVER_TYPE_ID
58: into X_APPROVER_TYPE_ID
59: from AME_APPROVER_TYPES AAT
60: where AAT.ORIG_SYSTEM = L_ORIG_SYSTEM
61: and sysdate between AAT.START_DATE and nvl(AAT.END_DATE - (1/86400),sysdate);
62: exception
63: when no_data_found then

Line 400: L_ORIG_SYSTEM AME_APPROVER_TYPES.ORIG_SYSTEM%TYPE;

396: L_ATTRIBUTE_NAME AME_ATTRIBUTES.NAME%TYPE;
397: L_ATTRIBUTE_TYPE AME_ATTRIBUTES.ATTRIBUTE_TYPE%TYPE;
398: L_DESCRIPTION AME_ATTRIBUTES_TL.DESCRIPTION%TYPE;
399: L_LINE_ITEM AME_ATTRIBUTES.LINE_ITEM%TYPE;
400: L_ORIG_SYSTEM AME_APPROVER_TYPES.ORIG_SYSTEM%TYPE;
401: L_ITEM_CLASS_NAME AME_ITEM_CLASSES.NAME%TYPE;
402: L_ITEM_CLASS_ID number;
403: L_APPROVER_TYPE_ID number;
404: L_ATTRIBUTE_ID number;