APPS.AME_ATTRIBUTES_API dependencies on AME_ITEM_CLASSES

Line 73: from AME_ITEM_CLASSES AIC

69: begin
70: X_LINE_ITEM := null;
71: select AIC.ITEM_CLASS_ID
72: into X_ITEM_CLASS_ID
73: from AME_ITEM_CLASSES AIC
74: where AIC.NAME = 'line item'
75: and sysdate between AIC.START_DATE and nvl(AIC.END_DATE - (1/86400),sysdate);
76: exception
77: when no_data_found then

Line 85: from AME_ITEM_CLASSES AIC

81: begin
82: X_LINE_ITEM := null;
83: select AIC.ITEM_CLASS_ID
84: into X_ITEM_CLASS_ID
85: from AME_ITEM_CLASSES AIC
86: where AIC.NAME = 'header'
87: and sysdate between AIC.START_DATE and nvl(AIC.END_DATE - (1/86400),sysdate);
88: exception
89: when no_data_found then

Line 98: from AME_ITEM_CLASSES AIC

94: begin
95: X_LINE_ITEM := null;
96: select AIC.ITEM_CLASS_ID
97: into X_ITEM_CLASS_ID
98: from AME_ITEM_CLASSES AIC
99: where AIC.NAME = X_ITEM_CLASS_NAME
100: and sysdate between AIC.START_DATE and nvl(AIC.END_DATE - (1/86400),sysdate);
101: exception
102: when no_data_found then

Line 401: L_ITEM_CLASS_NAME AME_ITEM_CLASSES.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;
405: L_OWNER varchar2(100);