APPS.ARP_PROCESS_HEADER dependencies on ARPT_SQL_FUNC_UTIL

Line 1459: arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,

1455: THEN
1456: /* 5633334/5637907 - also reverse for CMs that have not
1457: been through Rev Rec yet */
1458: IF (p_trx_rec.previous_customer_trx_id IS NULL AND
1459: arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,
1460: p_trx_rec.invoicing_rule_id) = 'Y')
1461: OR (p_trx_rec.previous_customer_trx_id IS NOT NULL AND
1462: pg_use_inv_acctg = 'N' AND
1463: arpt_sql_func_util.get_revenue_recog_run_flag(

Line 1463: arpt_sql_func_util.get_revenue_recog_run_flag(

1459: arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,
1460: p_trx_rec.invoicing_rule_id) = 'Y')
1461: OR (p_trx_rec.previous_customer_trx_id IS NOT NULL AND
1462: pg_use_inv_acctg = 'N' AND
1463: arpt_sql_func_util.get_revenue_recog_run_flag(
1464: p_trx_rec.previous_customer_trx_id,
1465: p_trx_rec.invoicing_rule_id) = 'Y')
1466: THEN
1467: reverse_revrec_effect(p_customer_trx_id);

Line 2725: arpt_sql_func_util.get_reference(l_ct_prev_rowid);

2721: and ct.reason_code = al_cm_reason.lookup_code(+);
2722:
2723:
2724: l_ct_prev_trx_reference :=
2725: arpt_sql_func_util.get_reference(l_ct_prev_rowid);
2726:
2727: l_prev_trx_balance :=
2728: arp_bal_util.get_trx_balance( p_previous_customer_trx_id,
2729: NULL);