APPS.ARP_PROCESS_HEADER dependencies on ARPT_SQL_FUNC_UTIL

Line 1485: arpt_sql_func_util.get_nonmodal_row_exist_flag(

1481: IF (l_gl_date_changed_flag AND
1482: p_trx_rec.complete_flag = 'N' AND
1483: p_trx_rec.previous_customer_trx_id IS NOT Null AND
1484: p_trx_class = 'CM' AND
1485: arpt_sql_func_util.get_nonmodal_row_exist_flag(
1486: p_trx_rec.Customer_trx_id,
1487: p_trx_rec.invoicing_rule_id) = 'Y')
1488: THEN
1489: arp_util.debug('Calling reverse_revrec_effect to delete non modal row +');

Line 1539: arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,

1535: THEN
1536: /* 5633334/5637907 - also reverse for CMs that have not
1537: been through Rev Rec yet */
1538: IF (p_trx_rec.previous_customer_trx_id IS NULL AND
1539: arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,
1540: p_trx_rec.invoicing_rule_id) = 'Y')
1541: OR (p_trx_rec.previous_customer_trx_id IS NOT NULL AND
1542: pg_use_inv_acctg = 'N' AND
1543: arpt_sql_func_util.get_revenue_recog_run_flag(

Line 1543: arpt_sql_func_util.get_revenue_recog_run_flag(

1539: arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,
1540: p_trx_rec.invoicing_rule_id) = 'Y')
1541: OR (p_trx_rec.previous_customer_trx_id IS NOT NULL AND
1542: pg_use_inv_acctg = 'N' AND
1543: arpt_sql_func_util.get_revenue_recog_run_flag(
1544: p_trx_rec.previous_customer_trx_id,
1545: p_trx_rec.invoicing_rule_id) = 'Y')
1546: THEN
1547: reverse_revrec_effect(p_customer_trx_id);

Line 2805: arpt_sql_func_util.get_reference(l_ct_prev_rowid);

2801: and ct.reason_code = al_cm_reason.lookup_code(+);
2802:
2803:
2804: l_ct_prev_trx_reference :=
2805: arpt_sql_func_util.get_reference(l_ct_prev_rowid);
2806:
2807: l_prev_trx_balance :=
2808: arp_bal_util.get_trx_balance( p_previous_customer_trx_id,
2809: NULL);