DBA Data[Home] [Help]

APPS.AR_BUS_EVENT_SUB_PVT dependencies on AR_REVENUE_MANAGEMENT_PVT

Line 6896: l_item_key := ar_revenue_management_pvt.c_revenue_deferral_event ||

6892: END IF;
6893: -- This function simply raises revenue related business events.
6894:
6895:
6896: l_item_key := ar_revenue_management_pvt.c_revenue_deferral_event ||
6897: '_'||
6898: to_char(p_customer_trx_line_id) || '_'||
6899: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS');
6900:

Line 6918: p_event_name => ar_revenue_management_pvt.c_revenue_deferral_event,

6914: p_value => p_acctd_amount,
6915: p_parameterlist => l_parameter_list);
6916:
6917: wf_event.raise(
6918: p_event_name => ar_revenue_management_pvt.c_revenue_deferral_event,
6919: p_event_key => l_item_key,
6920: p_parameters => l_parameter_list);
6921:
6922:

Line 6988: l_rowid_table ar_revenue_management_pvt.varchar_table;

6984:
6985: l_request_id NUMBER;
6986: l_last_fetch BOOLEAN;
6987: l_item_key wf_items.ITEM_KEY%TYPE;
6988: l_rowid_table ar_revenue_management_pvt.varchar_table;
6989: l_customer_trx_id_table ar_revenue_management_pvt.number_table;
6990: l_customer_trx_line_id_table ar_revenue_management_pvt.number_table;
6991: l_line_collectible_table ar_revenue_management_pvt.varchar_table;
6992: l_amount_due_original_table ar_revenue_management_pvt.number_table;

Line 6989: l_customer_trx_id_table ar_revenue_management_pvt.number_table;

6985: l_request_id NUMBER;
6986: l_last_fetch BOOLEAN;
6987: l_item_key wf_items.ITEM_KEY%TYPE;
6988: l_rowid_table ar_revenue_management_pvt.varchar_table;
6989: l_customer_trx_id_table ar_revenue_management_pvt.number_table;
6990: l_customer_trx_line_id_table ar_revenue_management_pvt.number_table;
6991: l_line_collectible_table ar_revenue_management_pvt.varchar_table;
6992: l_amount_due_original_table ar_revenue_management_pvt.number_table;
6993: l_acctd_amount_due_orig_table ar_revenue_management_pvt.number_table;

Line 6990: l_customer_trx_line_id_table ar_revenue_management_pvt.number_table;

6986: l_last_fetch BOOLEAN;
6987: l_item_key wf_items.ITEM_KEY%TYPE;
6988: l_rowid_table ar_revenue_management_pvt.varchar_table;
6989: l_customer_trx_id_table ar_revenue_management_pvt.number_table;
6990: l_customer_trx_line_id_table ar_revenue_management_pvt.number_table;
6991: l_line_collectible_table ar_revenue_management_pvt.varchar_table;
6992: l_amount_due_original_table ar_revenue_management_pvt.number_table;
6993: l_acctd_amount_due_orig_table ar_revenue_management_pvt.number_table;
6994: l_acctd_amount_pending_table ar_revenue_management_pvt.number_table;

Line 6991: l_line_collectible_table ar_revenue_management_pvt.varchar_table;

6987: l_item_key wf_items.ITEM_KEY%TYPE;
6988: l_rowid_table ar_revenue_management_pvt.varchar_table;
6989: l_customer_trx_id_table ar_revenue_management_pvt.number_table;
6990: l_customer_trx_line_id_table ar_revenue_management_pvt.number_table;
6991: l_line_collectible_table ar_revenue_management_pvt.varchar_table;
6992: l_amount_due_original_table ar_revenue_management_pvt.number_table;
6993: l_acctd_amount_due_orig_table ar_revenue_management_pvt.number_table;
6994: l_acctd_amount_pending_table ar_revenue_management_pvt.number_table;
6995:

Line 6992: l_amount_due_original_table ar_revenue_management_pvt.number_table;

6988: l_rowid_table ar_revenue_management_pvt.varchar_table;
6989: l_customer_trx_id_table ar_revenue_management_pvt.number_table;
6990: l_customer_trx_line_id_table ar_revenue_management_pvt.number_table;
6991: l_line_collectible_table ar_revenue_management_pvt.varchar_table;
6992: l_amount_due_original_table ar_revenue_management_pvt.number_table;
6993: l_acctd_amount_due_orig_table ar_revenue_management_pvt.number_table;
6994: l_acctd_amount_pending_table ar_revenue_management_pvt.number_table;
6995:
6996: BEGIN

Line 6993: l_acctd_amount_due_orig_table ar_revenue_management_pvt.number_table;

6989: l_customer_trx_id_table ar_revenue_management_pvt.number_table;
6990: l_customer_trx_line_id_table ar_revenue_management_pvt.number_table;
6991: l_line_collectible_table ar_revenue_management_pvt.varchar_table;
6992: l_amount_due_original_table ar_revenue_management_pvt.number_table;
6993: l_acctd_amount_due_orig_table ar_revenue_management_pvt.number_table;
6994: l_acctd_amount_pending_table ar_revenue_management_pvt.number_table;
6995:
6996: BEGIN
6997:

Line 6994: l_acctd_amount_pending_table ar_revenue_management_pvt.number_table;

6990: l_customer_trx_line_id_table ar_revenue_management_pvt.number_table;
6991: l_line_collectible_table ar_revenue_management_pvt.varchar_table;
6992: l_amount_due_original_table ar_revenue_management_pvt.number_table;
6993: l_acctd_amount_due_orig_table ar_revenue_management_pvt.number_table;
6994: l_acctd_amount_pending_table ar_revenue_management_pvt.number_table;
6995:
6996: BEGIN
6997:
6998: IF pg_debug = 'Y'

Line 7023: LIMIT ar_revenue_management_pvt.c_max_bulk_fetch_size;

7019: l_customer_trx_id_table,
7020: l_customer_trx_line_id_table,
7021: l_amount_due_original_table,
7022: l_acctd_amount_due_orig_table
7023: LIMIT ar_revenue_management_pvt.c_max_bulk_fetch_size;
7024:
7025: IF lines%NOTFOUND THEN
7026: fnd_file.put_line(fnd_file.log, 'last fetch');
7027: l_last_fetch := TRUE;

Line 7065: 'ar_revenue_management_pvt',

7061: EXCEPTION
7062:
7063: WHEN OTHERS THEN
7064: WF_CORE.CONTEXT(
7065: 'ar_revenue_management_pvt',
7066: 'events_manager',
7067: p_event.getEventName( ),
7068: p_subscription_guid);
7069: WF_EVENT.setErrorInfo(p_event, 'ERROR');