DBA Data[Home] [Help]

APPS.AME_ENGINE dependencies on AME_TRANS_APPROVAL_HISTORY_S

Line 485: ,statusIn ame_trans_approval_history.status%type

481: ,itemClassIn ame_trans_approval_history.item_class%type
482: ,itemIdIn ame_trans_approval_history.item_id%type
483: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
484: ,authorityIn ame_trans_approval_history.authority%type
485: ,statusIn ame_trans_approval_history.status%type
486: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
487: ,occurrenceIn ame_trans_approval_history.occurrence%type
488: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
489: ,memberOrderNumberIn ame_trans_approval_history.member_order_number%type

Line 8971: ,statusIn ame_trans_approval_history.status%type

8967: ,itemClassIn ame_trans_approval_history.item_class%type
8968: ,itemIdIn ame_trans_approval_history.item_id%type
8969: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
8970: ,authorityIn ame_trans_approval_history.authority%type
8971: ,statusIn ame_trans_approval_history.status%type
8972: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
8973: ,occurrenceIn ame_trans_approval_history.occurrence%type
8974: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
8975: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type

Line 9005: select ame_trans_approval_history_s.nextval

9001: and approvers(i).group_or_chain_id = grpOrChainIdIn
9002: and approvers(i).approver_category = ame_util.approvalApproverCategory
9003: and approvers(i).approval_status = ame_util.notifiedStatus
9004: then
9005: select ame_trans_approval_history_s.nextval
9006: into tempTransHistoryId
9007: from dual;
9008: insert into AME_TRANS_APPROVAL_HISTORY
9009: (TRANS_HISTORY_ID

Line 9052: select ame_trans_approval_history_s.nextval

9048: end if;
9049: end loop;
9050: return;
9051: end if;
9052: select ame_trans_approval_history_s.nextval
9053: into tempTransHistoryId
9054: from dual;
9055: if historyTypeIn = 'APPROVERPRESENT' then
9056: insert into AME_TRANS_APPROVAL_HISTORY