DBA Data[Home] [Help]

APPS.WSH_TRANSACTIONS_HISTORY_PKG dependencies on DUAL

Line 203: FROM dual;

199: -- ctd.. transaction_status, document_type
200:
201: SELECT WSH_TRANSACTION_S.nextval
202: INTO x_transaction_id
203: FROM dual;
204:
205: INSERT INTO wsh_transactions_history(
206: TRANSACTION_ID,
207: DOCUMENT_TYPE,

Line 506: parameters, we need this wrapper. This takes in the individual columns,

502: PROCEDURE : Create_Txns_History
503: PARAMETERS :
504: DESCRIPTION : This procedure is written for use by the inbound mapping.
505: Since XML gateway does not support calls to procedures with record types as
506: parameters, we need this wrapper. This takes in the individual columns,
507: creates a txns-history record and calls the create_update_txns_history
508: procedure with that record
509: -----------------------------------------------------------------------------
510: */