DBA Data[Home] [Help]

APPS.FV_APPLY_CASH_RECEIPT dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 1583: --* : table ar_cash_receipt_history_all, so that it simulates the current *--

1579: --* Type : Procedure *--
1580: --* Purpose : Currenty the APIs for Receipt process does not have an option to *--
1581: --* : receive batch_id, hence the fv_ar_batch details are entered into the *--
1582: --* : table ar_batches and the batch_id obtained is used to update the *--
1583: --* : table ar_cash_receipt_history_all, so that it simulates the current *--
1584: --* : process of entering the receipt details through batch *--
1585: --* Parameters : p_BatchId IN The batch Id *--
1586: --* : p_CashReceiptId IN The Cash Receipt Id *--
1587: --* : p_ErrorCode OUT The Error Code *--

Line 1597: --* Tables Used : ar_cash_receipt_history_all UPDATE *--

1593: --* : debug_init *--
1594: --* : debug_exit *--
1595: --* : error *--
1596: --* : log_msg *--
1597: --* Tables Used : ar_cash_receipt_history_all UPDATE *--
1598: --* Logic : UPDATE ar_cash_receipt_history_all with value p_BatchId for the *--
1599: --* : receipt id p_CashReceiptId *--
1600: --****************************************************************************************--
1601: PROCEDURE update_cash_receipt_hist

Line 1598: --* Logic : UPDATE ar_cash_receipt_history_all with value p_BatchId for the *--

1594: --* : debug_exit *--
1595: --* : error *--
1596: --* : log_msg *--
1597: --* Tables Used : ar_cash_receipt_history_all UPDATE *--
1598: --* Logic : UPDATE ar_cash_receipt_history_all with value p_BatchId for the *--
1599: --* : receipt id p_CashReceiptId *--
1600: --****************************************************************************************--
1601: PROCEDURE update_cash_receipt_hist
1602: (

Line 1625: -- Update the table ar_cash_receipt_history_all to link it with the --

1621: log_msg (l_module_name,'Updating Cash Receipt History');
1622:
1623: BEGIN
1624: ----------------------------------------------------------------------
1625: -- Update the table ar_cash_receipt_history_all to link it with the --
1626: -- table ar_batches --
1627: ----------------------------------------------------------------------
1628: UPDATE ar_cash_receipt_history_all
1629: SET batch_id = p_BatchId

Line 1628: UPDATE ar_cash_receipt_history_all

1624: ----------------------------------------------------------------------
1625: -- Update the table ar_cash_receipt_history_all to link it with the --
1626: -- table ar_batches --
1627: ----------------------------------------------------------------------
1628: UPDATE ar_cash_receipt_history_all
1629: SET batch_id = p_BatchId
1630: WHERE cash_receipt_id = p_CashReceiptId;
1631:
1632: log_msg (l_module_name,'Successfully Updated Cash Receipt History');

Line 1638: p_ErrorLoc := 'UPDATE ar_cash_receipt_history_all';

1634: EXCEPTION
1635: WHEN OTHERS THEN
1636: p_ErrorCode := g_FAILURE;
1637: p_ErrorDesc := SQLERRM;
1638: p_ErrorLoc := 'UPDATE ar_cash_receipt_history_all';
1639: error
1640: (
1641: p_error_type => p_ErrorCode,
1642: p_pgm => l_module_name,