60:
61: -- This record holds general information used by autoaccounting and
62: -- credit memo module. Passed as argument to most functions/procs.
63: --
64: system_info arp_trx_global.system_info_rec_type :=
65: arp_trx_global.system_info;
66:
67: --
68: -- This record holds profile information used by autoaccounting and
61: -- This record holds general information used by autoaccounting and
62: -- credit memo module. Passed as argument to most functions/procs.
63: --
64: system_info arp_trx_global.system_info_rec_type :=
65: arp_trx_global.system_info;
66:
67: --
68: -- This record holds profile information used by autoaccounting and
69: -- credit memo module. Passed as argument to most functions/procs.
67: --
68: -- This record holds profile information used by autoaccounting and
69: -- credit memo module. Passed as argument to most functions/procs.
70: --
71: profile_info arp_trx_global.profile_rec_type :=
72: arp_trx_global.profile_info;
73:
74:
75: --
68: -- This record holds profile information used by autoaccounting and
69: -- credit memo module. Passed as argument to most functions/procs.
70: --
71: profile_info arp_trx_global.profile_rec_type :=
72: arp_trx_global.profile_info;
73:
74:
75: --
76: -- This record holds accounting flexfield information used by
76: -- This record holds accounting flexfield information used by
77: -- autoaccounting and the credit memo module. Passed as argument to
78: -- most functions/procs.
79: --
80: flex_info arp_trx_global.acct_flex_info_rec_type :=
81: arp_trx_global.flex_info;
82:
83: ------------------------------------------------------------------------
84: -- Data structs for net revenue schedule
77: -- autoaccounting and the credit memo module. Passed as argument to
78: -- most functions/procs.
79: --
80: flex_info arp_trx_global.acct_flex_info_rec_type :=
81: arp_trx_global.flex_info;
82:
83: ------------------------------------------------------------------------
84: -- Data structs for net revenue schedule
85: ------------------------------------------------------------------------
657: */
658:
659: ----------------------------------------------------------------------------
660: PROCEDURE build_nonrule_sql(
661: p_system_info IN arp_trx_global.system_info_rec_type,
662: p_profile_info IN arp_trx_global.profile_rec_type,
663: p_cm_control IN control_rec_type,
664: p_nonrule_insert_dist_c IN OUT NOCOPY INTEGER,
665: p_nonrule_update_lines_c IN OUT NOCOPY INTEGER,
658:
659: ----------------------------------------------------------------------------
660: PROCEDURE build_nonrule_sql(
661: p_system_info IN arp_trx_global.system_info_rec_type,
662: p_profile_info IN arp_trx_global.profile_rec_type,
663: p_cm_control IN control_rec_type,
664: p_nonrule_insert_dist_c IN OUT NOCOPY INTEGER,
665: p_nonrule_update_lines_c IN OUT NOCOPY INTEGER,
666: p_nonrule_update_dist_c IN OUT NOCOPY INTEGER,
1392: -- HISTORY:
1393: --
1394: ----------------------------------------------------------------------------
1395: PROCEDURE build_rule_sql(
1396: p_system_info IN arp_trx_global.system_info_rec_type,
1397: p_profile_info IN arp_trx_global.profile_rec_type,
1398: p_cm_control IN control_rec_type,
1399: p_rule_select_cm_lines_c IN OUT NOCOPY INTEGER,
1400: p_rule_update_cm_lines_c IN OUT NOCOPY INTEGER,
1393: --
1394: ----------------------------------------------------------------------------
1395: PROCEDURE build_rule_sql(
1396: p_system_info IN arp_trx_global.system_info_rec_type,
1397: p_profile_info IN arp_trx_global.profile_rec_type,
1398: p_cm_control IN control_rec_type,
1399: p_rule_select_cm_lines_c IN OUT NOCOPY INTEGER,
1400: p_rule_update_cm_lines_c IN OUT NOCOPY INTEGER,
1401: p_rule_insert_dist_c IN OUT NOCOPY INTEGER,
2109: -- HISTORY:
2110: --
2111: ----------------------------------------------------------------------------
2112: PROCEDURE build_net_revenue_sql(
2113: p_system_info IN arp_trx_global.system_info_rec_type,
2114: p_profile_info IN arp_trx_global.profile_rec_type,
2115: p_cm_control IN control_rec_type,
2116: p_net_revenue_line_c IN OUT NOCOPY INTEGER ) IS
2117:
2110: --
2111: ----------------------------------------------------------------------------
2112: PROCEDURE build_net_revenue_sql(
2113: p_system_info IN arp_trx_global.system_info_rec_type,
2114: p_profile_info IN arp_trx_global.profile_rec_type,
2115: p_cm_control IN control_rec_type,
2116: p_net_revenue_line_c IN OUT NOCOPY INTEGER ) IS
2117:
2118: l_net_revenue_line_sql VARCHAR2(2000);
2206: -- 16-SEP-05 M Raymond 4602892 - Removed fix for bug 642590 as we needed
2207: -- to preserve net rev arrays.
2208: ----------------------------------------------------------------------------
2209: PROCEDURE load_net_revenue_schedule(
2210: p_system_info IN arp_trx_global.system_info_rec_type,
2211: p_profile_info IN arp_trx_global.profile_rec_type,
2212: p_cm_control IN control_rec_type,
2213: p_prev_cust_trx_line_id IN BINARY_INTEGER ) IS
2214:
2207: -- to preserve net rev arrays.
2208: ----------------------------------------------------------------------------
2209: PROCEDURE load_net_revenue_schedule(
2210: p_system_info IN arp_trx_global.system_info_rec_type,
2211: p_profile_info IN arp_trx_global.profile_rec_type,
2212: p_cm_control IN control_rec_type,
2213: p_prev_cust_trx_line_id IN BINARY_INTEGER ) IS
2214:
2215:
2371: -- HISTORY:
2372: --
2373: ----------------------------------------------------------------------------
2374: PROCEDURE credit_nonrule_transactions(
2375: p_system_info IN arp_trx_global.system_info_rec_type,
2376: p_profile_info IN arp_trx_global.profile_rec_type,
2377: p_cm_control IN control_rec_type ) IS
2378:
2379: l_ignore INTEGER;
2372: --
2373: ----------------------------------------------------------------------------
2374: PROCEDURE credit_nonrule_transactions(
2375: p_system_info IN arp_trx_global.system_info_rec_type,
2376: p_profile_info IN arp_trx_global.profile_rec_type,
2377: p_cm_control IN control_rec_type ) IS
2378:
2379: l_ignore INTEGER;
2380:
4310: -- HISTORY:
4311: --
4312: ----------------------------------------------------------------------------
4313: PROCEDURE process_line(
4314: p_system_info IN arp_trx_global.system_info_rec_type,
4315: p_profile_info IN arp_trx_global.profile_rec_type,
4316: p_cm_control IN control_rec_type,
4317: p_select_rec IN OUT NOCOPY select_rec_type ) IS
4318:
4311: --
4312: ----------------------------------------------------------------------------
4313: PROCEDURE process_line(
4314: p_system_info IN arp_trx_global.system_info_rec_type,
4315: p_profile_info IN arp_trx_global.profile_rec_type,
4316: p_cm_control IN control_rec_type,
4317: p_select_rec IN OUT NOCOPY select_rec_type ) IS
4318:
4319: l_start_index BINARY_INTEGER;
4742: -- write_cm_sched and clear_cm_sched
4743: -- based on prev_ctlid
4744: ----------------------------------------------------------------------------
4745: PROCEDURE credit_rule_transactions(
4746: p_system_info IN arp_trx_global.system_info_rec_type,
4747: p_profile_info IN arp_trx_global.profile_rec_type,
4748: p_cm_control IN control_rec_type,
4749: p_failure_count IN OUT NOCOPY NUMBER,
4750: p_rule_start_date IN OUT NOCOPY DATE,
4743: -- based on prev_ctlid
4744: ----------------------------------------------------------------------------
4745: PROCEDURE credit_rule_transactions(
4746: p_system_info IN arp_trx_global.system_info_rec_type,
4747: p_profile_info IN arp_trx_global.profile_rec_type,
4748: p_cm_control IN control_rec_type,
4749: p_failure_count IN OUT NOCOPY NUMBER,
4750: p_rule_start_date IN OUT NOCOPY DATE,
4751: p_accounting_rule_duration IN OUT NOCOPY NUMBER ) IS