DBA Data[Home] [Help]

APPS.AR_BUS_EVENT_SUB_PVT dependencies on AR_REVENUE_MANAGEMENT_PVT

Line 6941: l_item_key := ar_revenue_management_pvt.c_revenue_deferral_event ||

6937: END IF;
6938: -- This function simply raises revenue related business events.
6939:
6940:
6941: l_item_key := ar_revenue_management_pvt.c_revenue_deferral_event ||
6942: '_'||
6943: to_char(p_customer_trx_line_id) || '_'||
6944: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS');
6945:

Line 6963: p_event_name => ar_revenue_management_pvt.c_revenue_deferral_event,

6959: p_value => p_acctd_amount,
6960: p_parameterlist => l_parameter_list);
6961:
6962: wf_event.raise(
6963: p_event_name => ar_revenue_management_pvt.c_revenue_deferral_event,
6964: p_event_key => l_item_key,
6965: p_parameters => l_parameter_list);
6966:
6967:

Line 7033: l_rowid_table ar_revenue_management_pvt.varchar_table;

7029:
7030: l_request_id NUMBER;
7031: l_last_fetch BOOLEAN;
7032: l_item_key wf_items.ITEM_KEY%TYPE;
7033: l_rowid_table ar_revenue_management_pvt.varchar_table;
7034: l_customer_trx_id_table ar_revenue_management_pvt.number_table;
7035: l_customer_trx_line_id_table ar_revenue_management_pvt.number_table;
7036: l_line_collectible_table ar_revenue_management_pvt.varchar_table;
7037: l_amount_due_original_table ar_revenue_management_pvt.number_table;

Line 7034: l_customer_trx_id_table ar_revenue_management_pvt.number_table;

7030: l_request_id NUMBER;
7031: l_last_fetch BOOLEAN;
7032: l_item_key wf_items.ITEM_KEY%TYPE;
7033: l_rowid_table ar_revenue_management_pvt.varchar_table;
7034: l_customer_trx_id_table ar_revenue_management_pvt.number_table;
7035: l_customer_trx_line_id_table ar_revenue_management_pvt.number_table;
7036: l_line_collectible_table ar_revenue_management_pvt.varchar_table;
7037: l_amount_due_original_table ar_revenue_management_pvt.number_table;
7038: l_acctd_amount_due_orig_table ar_revenue_management_pvt.number_table;

Line 7035: l_customer_trx_line_id_table ar_revenue_management_pvt.number_table;

7031: l_last_fetch BOOLEAN;
7032: l_item_key wf_items.ITEM_KEY%TYPE;
7033: l_rowid_table ar_revenue_management_pvt.varchar_table;
7034: l_customer_trx_id_table ar_revenue_management_pvt.number_table;
7035: l_customer_trx_line_id_table ar_revenue_management_pvt.number_table;
7036: l_line_collectible_table ar_revenue_management_pvt.varchar_table;
7037: l_amount_due_original_table ar_revenue_management_pvt.number_table;
7038: l_acctd_amount_due_orig_table ar_revenue_management_pvt.number_table;
7039: l_acctd_amount_pending_table ar_revenue_management_pvt.number_table;

Line 7036: l_line_collectible_table ar_revenue_management_pvt.varchar_table;

7032: l_item_key wf_items.ITEM_KEY%TYPE;
7033: l_rowid_table ar_revenue_management_pvt.varchar_table;
7034: l_customer_trx_id_table ar_revenue_management_pvt.number_table;
7035: l_customer_trx_line_id_table ar_revenue_management_pvt.number_table;
7036: l_line_collectible_table ar_revenue_management_pvt.varchar_table;
7037: l_amount_due_original_table ar_revenue_management_pvt.number_table;
7038: l_acctd_amount_due_orig_table ar_revenue_management_pvt.number_table;
7039: l_acctd_amount_pending_table ar_revenue_management_pvt.number_table;
7040:

Line 7037: l_amount_due_original_table ar_revenue_management_pvt.number_table;

7033: l_rowid_table ar_revenue_management_pvt.varchar_table;
7034: l_customer_trx_id_table ar_revenue_management_pvt.number_table;
7035: l_customer_trx_line_id_table ar_revenue_management_pvt.number_table;
7036: l_line_collectible_table ar_revenue_management_pvt.varchar_table;
7037: l_amount_due_original_table ar_revenue_management_pvt.number_table;
7038: l_acctd_amount_due_orig_table ar_revenue_management_pvt.number_table;
7039: l_acctd_amount_pending_table ar_revenue_management_pvt.number_table;
7040:
7041: BEGIN

Line 7038: l_acctd_amount_due_orig_table ar_revenue_management_pvt.number_table;

7034: l_customer_trx_id_table ar_revenue_management_pvt.number_table;
7035: l_customer_trx_line_id_table ar_revenue_management_pvt.number_table;
7036: l_line_collectible_table ar_revenue_management_pvt.varchar_table;
7037: l_amount_due_original_table ar_revenue_management_pvt.number_table;
7038: l_acctd_amount_due_orig_table ar_revenue_management_pvt.number_table;
7039: l_acctd_amount_pending_table ar_revenue_management_pvt.number_table;
7040:
7041: BEGIN
7042:

Line 7039: l_acctd_amount_pending_table ar_revenue_management_pvt.number_table;

7035: l_customer_trx_line_id_table ar_revenue_management_pvt.number_table;
7036: l_line_collectible_table ar_revenue_management_pvt.varchar_table;
7037: l_amount_due_original_table ar_revenue_management_pvt.number_table;
7038: l_acctd_amount_due_orig_table ar_revenue_management_pvt.number_table;
7039: l_acctd_amount_pending_table ar_revenue_management_pvt.number_table;
7040:
7041: BEGIN
7042:
7043: IF pg_debug = 'Y'

Line 7068: LIMIT ar_revenue_management_pvt.c_max_bulk_fetch_size;

7064: l_customer_trx_id_table,
7065: l_customer_trx_line_id_table,
7066: l_amount_due_original_table,
7067: l_acctd_amount_due_orig_table
7068: LIMIT ar_revenue_management_pvt.c_max_bulk_fetch_size;
7069:
7070: IF lines%NOTFOUND THEN
7071: fnd_file.put_line(fnd_file.log, 'last fetch');
7072: l_last_fetch := TRUE;

Line 7110: 'ar_revenue_management_pvt',

7106: EXCEPTION
7107:
7108: WHEN OTHERS THEN
7109: WF_CORE.CONTEXT(
7110: 'ar_revenue_management_pvt',
7111: 'events_manager',
7112: p_event.getEventName( ),
7113: p_subscription_guid);
7114: WF_EVENT.setErrorInfo(p_event, 'ERROR');