DBA Data[Home] [Help]

APPS.FV_APPLY_CASH_RECEIPT dependencies on FV_AR_BATCHES_ALL

Line 1670: --* : fv_ar_batches_all.

1666: --****************************************************************************************--
1667: --* Name : update_fv_batch_status *--
1668: --* Type : Procedure *--
1669: --* Purpose : This procedure is used to update the status of the table *--
1670: --* : fv_ar_batches_all.
1671: --* Parameters : p_BatchId IN The batch Id *--
1672: --* : p_Status IN The Status to which the table to be updated *--
1673: --* : p_ErrorCode OUT The Error Code *--
1674: --* : p_ErrorDesc OUT The Error Description *--

Line 1681: --* Tables Used : fv_ar_batches_all UPDATE *--

1677: --* Called from : main *--
1678: --* Calls : debug_msg *--
1679: --* : debug_init *--
1680: --* : debug_exit *--
1681: --* Tables Used : fv_ar_batches_all UPDATE *--
1682: --* Logic : Update the table fv_ar_batches_all with the status p_Status for the *--
1683: --* : batch_id p_BatchId *--
1684: --****************************************************************************************--
1685: PROCEDURE update_fv_batch_status

Line 1682: --* Logic : Update the table fv_ar_batches_all with the status p_Status for the *--

1678: --* Calls : debug_msg *--
1679: --* : debug_init *--
1680: --* : debug_exit *--
1681: --* Tables Used : fv_ar_batches_all UPDATE *--
1682: --* Logic : Update the table fv_ar_batches_all with the status p_Status for the *--
1683: --* : batch_id p_BatchId *--
1684: --****************************************************************************************--
1685: PROCEDURE update_fv_batch_status
1686: (

Line 1706: debug_msg (l_module_name, 'Updating table fv_ar_batches_all');

1702: debug_msg (l_module_name, 'p_BatchId = '||p_BatchId);
1703: debug_msg (l_module_name, 'p_Status = '||p_Status);
1704:
1705: BEGIN
1706: debug_msg (l_module_name, 'Updating table fv_ar_batches_all');
1707:
1708: ----------------------------------------------------------------------
1709: -- Update the table fv_ar_batches_all to the status p_Status for --
1710: -- batch_id p_BatchId --

Line 1709: -- Update the table fv_ar_batches_all to the status p_Status for --

1705: BEGIN
1706: debug_msg (l_module_name, 'Updating table fv_ar_batches_all');
1707:
1708: ----------------------------------------------------------------------
1709: -- Update the table fv_ar_batches_all to the status p_Status for --
1710: -- batch_id p_BatchId --
1711: ----------------------------------------------------------------------
1712: UPDATE fv_ar_batches_all
1713: SET transfer_status = p_status

Line 1712: UPDATE fv_ar_batches_all

1708: ----------------------------------------------------------------------
1709: -- Update the table fv_ar_batches_all to the status p_Status for --
1710: -- batch_id p_BatchId --
1711: ----------------------------------------------------------------------
1712: UPDATE fv_ar_batches_all
1713: SET transfer_status = p_status
1714: WHERE batch_id = p_BatchId;
1715:
1716: debug_msg (l_module_name, 'Updated '||SQL%ROWCOUNT||' rows.');

Line 1722: p_ErrorLoc := 'UPDATE fv_ar_batches_all';

1718: EXCEPTION
1719: WHEN OTHERS THEN
1720: p_ErrorCode := g_FAILURE;
1721: p_ErrorDesc := SQLERRM;
1722: p_ErrorLoc := 'UPDATE fv_ar_batches_all';
1723: error
1724: (
1725: p_error_type => p_ErrorCode,
1726: p_pgm => l_module_name,