DBA Data[Home] [Help]

APPS.AME_ENGINE dependencies on AME_TRANS_APPROVAL_HISTORY_S

Line 487: ,statusIn ame_trans_approval_history.status%type

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

Line 9317: ,statusIn ame_trans_approval_history.status%type

9313: ,itemClassIn ame_trans_approval_history.item_class%type
9314: ,itemIdIn ame_trans_approval_history.item_id%type
9315: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
9316: ,authorityIn ame_trans_approval_history.authority%type
9317: ,statusIn ame_trans_approval_history.status%type
9318: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
9319: ,occurrenceIn ame_trans_approval_history.occurrence%type
9320: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
9321: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type

Line 9351: select ame_trans_approval_history_s.nextval

9347: and approvers(i).group_or_chain_id = grpOrChainIdIn
9348: and approvers(i).approver_category = ame_util.approvalApproverCategory
9349: and approvers(i).approval_status = ame_util.notifiedStatus
9350: then
9351: select ame_trans_approval_history_s.nextval
9352: into tempTransHistoryId
9353: from dual;
9354: insert into AME_TRANS_APPROVAL_HISTORY
9355: (TRANS_HISTORY_ID

Line 9409: select ame_trans_approval_history_s.nextval

9405: and approvers(i).group_or_chain_id = grpOrChainIdIn
9406: and approvers(i).approver_category = ame_util.approvalApproverCategory
9407: -- and approvers(i).approval_status = ame_util.notifiedStatus
9408: then
9409: select ame_trans_approval_history_s.nextval
9410: into tempTransHistoryId
9411: from dual;
9412: insert into AME_TRANS_APPROVAL_HISTORY
9413: (TRANS_HISTORY_ID

Line 9456: select ame_trans_approval_history_s.nextval

9452: end if;
9453: end loop;
9454: return;
9455: end if;
9456: select ame_trans_approval_history_s.nextval
9457: into tempTransHistoryId
9458: from dual;
9459: if historyTypeIn = 'APPROVERPRESENT' then
9460: insert into AME_TRANS_APPROVAL_HISTORY