DBA Data[Home] [Help]

APPS.AME_TEST_PKG dependencies on AME_ATTRIBUTES

Line 303: ame_attributes.attribute_id,

299: transactionIdIn in varchar2,
300: itemClassIdIn in integer,
301: itemIdIn in varchar2) is
302: select
303: ame_attributes.attribute_id,
304: ame_attributes.name,
305: ame_attributes.approver_type_id
306: from ame_test_trans_att_values,
307: ame_attributes

Line 304: ame_attributes.name,

300: itemClassIdIn in integer,
301: itemIdIn in varchar2) is
302: select
303: ame_attributes.attribute_id,
304: ame_attributes.name,
305: ame_attributes.approver_type_id
306: from ame_test_trans_att_values,
307: ame_attributes
308: where

Line 305: ame_attributes.approver_type_id

301: itemIdIn in varchar2) is
302: select
303: ame_attributes.attribute_id,
304: ame_attributes.name,
305: ame_attributes.approver_type_id
306: from ame_test_trans_att_values,
307: ame_attributes
308: where
309: ame_attributes.attribute_id = ame_test_trans_att_values.attribute_id and

Line 307: ame_attributes

303: ame_attributes.attribute_id,
304: ame_attributes.name,
305: ame_attributes.approver_type_id
306: from ame_test_trans_att_values,
307: ame_attributes
308: where
309: ame_attributes.attribute_id = ame_test_trans_att_values.attribute_id and
310: ame_attributes.item_class_id = itemClassIdIn and
311: ame_test_trans_att_values.item_id = itemIdIn and

Line 309: ame_attributes.attribute_id = ame_test_trans_att_values.attribute_id and

305: ame_attributes.approver_type_id
306: from ame_test_trans_att_values,
307: ame_attributes
308: where
309: ame_attributes.attribute_id = ame_test_trans_att_values.attribute_id and
310: ame_attributes.item_class_id = itemClassIdIn and
311: ame_test_trans_att_values.item_id = itemIdIn and
312: ame_test_trans_att_values.application_id = applicationIdIn and
313: ame_test_trans_att_values.transaction_id = transactionIdIn and

Line 310: ame_attributes.item_class_id = itemClassIdIn and

306: from ame_test_trans_att_values,
307: ame_attributes
308: where
309: ame_attributes.attribute_id = ame_test_trans_att_values.attribute_id and
310: ame_attributes.item_class_id = itemClassIdIn and
311: ame_test_trans_att_values.item_id = itemIdIn and
312: ame_test_trans_att_values.application_id = applicationIdIn and
313: ame_test_trans_att_values.transaction_id = transactionIdIn and
314: ame_attributes.approver_type_id is not null and

Line 314: ame_attributes.approver_type_id is not null and

310: ame_attributes.item_class_id = itemClassIdIn and
311: ame_test_trans_att_values.item_id = itemIdIn and
312: ame_test_trans_att_values.application_id = applicationIdIn and
313: ame_test_trans_att_values.transaction_id = transactionIdIn and
314: ame_attributes.approver_type_id is not null and
315: sysdate between ame_attributes.start_date and
316: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
317: order by ame_attributes.name;
318: begin

Line 315: sysdate between ame_attributes.start_date and

311: ame_test_trans_att_values.item_id = itemIdIn and
312: ame_test_trans_att_values.application_id = applicationIdIn and
313: ame_test_trans_att_values.transaction_id = transactionIdIn and
314: ame_attributes.approver_type_id is not null and
315: sysdate between ame_attributes.start_date and
316: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
317: order by ame_attributes.name;
318: begin
319: open attributeCursor(applicationIdIn => applicationIdIn,

Line 316: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)

312: ame_test_trans_att_values.application_id = applicationIdIn and
313: ame_test_trans_att_values.transaction_id = transactionIdIn and
314: ame_attributes.approver_type_id is not null and
315: sysdate between ame_attributes.start_date and
316: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
317: order by ame_attributes.name;
318: begin
319: open attributeCursor(applicationIdIn => applicationIdIn,
320: transactionIdIn => transactionIdIn,

Line 317: order by ame_attributes.name;

313: ame_test_trans_att_values.transaction_id = transactionIdIn and
314: ame_attributes.approver_type_id is not null and
315: sysdate between ame_attributes.start_date and
316: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
317: order by ame_attributes.name;
318: begin
319: open attributeCursor(applicationIdIn => applicationIdIn,
320: transactionIdIn => transactionIdIn,
321: itemClassIdIn => itemClassIdIn,

Line 706: attributeName ame_attributes.name%type;

702: attributeIdIn in integer,
703: attributeValue1In in varchar2,
704: attributeValue2In in varchar2 default null,
705: attributeValue3In in varchar2 default null) as
706: attributeName ame_attributes.name%type;
707: attributeType ame_attributes.attribute_Type%type;
708: isMandatory ame_test_trans_att_values.is_mandatory%type;
709: begin
710: delete from ame_test_trans_att_values

Line 707: attributeType ame_attributes.attribute_Type%type;

703: attributeValue1In in varchar2,
704: attributeValue2In in varchar2 default null,
705: attributeValue3In in varchar2 default null) as
706: attributeName ame_attributes.name%type;
707: attributeType ame_attributes.attribute_Type%type;
708: isMandatory ame_test_trans_att_values.is_mandatory%type;
709: begin
710: delete from ame_test_trans_att_values
711: where