DBA Data[Home] [Help]

APPS.ARP_AUTO_RULE dependencies on GL_CA_UTILITY_PKG

Line 721: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;

717:
718: /* added for MRC Trigger Replacement */
719: l_rows NUMBER;
720: l_rows1 NUMBER;
721: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
722:
723: /* bug 3477990 */
724: l_return_status NUMBER;
725:

Line 1344: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr; /* mrc */

1340: RETURN NUMBER IS
1341:
1342: /* added for MRC Trigger Replacement */
1343: l_rows NUMBER;
1344: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr; /* mrc */
1345:
1346: /* bug 1947192 */
1347: cursor c_update_ps( l_trx_id NUMBER) is
1348: SELECT ps.payment_schedule_id ps_id,

Line 1557: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;

1553: RETURN NUMBER IS
1554:
1555: /* added for mrc */
1556: l_rows NUMBER;
1557: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1558:
1559: BEGIN
1560:
1561: IF PG_DEBUG in ('Y', 'C') THEN

Line 1729: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;

1725: l_ctt_type ra_cust_trx_types.type%TYPE;
1726: l_revrec_run_flag VARCHAR2(1);
1727: l_prev_cust_trx_id ra_customer_trx.customer_trx_id%TYPE;
1728:
1729: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1730:
1731: /*FP 5450534 for bug 5260489 take a dummy parameter to pass in call to rev. rec.*/
1732: l_request_id ra_customer_trx.request_id%type;
1733:

Line 2256: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;

2252: RETURN NUMBER IS
2253:
2254: /* added for mrc */
2255: l_rows NUMBER;
2256: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
2257: l_ignore_rule_flag VARCHAR2(1);
2258:
2259: BEGIN
2260:

Line 2469: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;

2465: RETURN NUMBER IS
2466:
2467: /* added for mrc */
2468: l_rows NUMBER;
2469: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
2470:
2471: BEGIN
2472:
2473: IF PG_DEBUG in ('Y', 'C') THEN