43:
44: -- This record holds general information used by autoaccounting and
45: -- credit memo module. Passed as argument to most functions/procs.
46: --
47: system_info arp_trx_global.system_info_rec_type :=
48: arp_trx_global.system_info;
49:
50: --
51: -- This record holds profile information used by autoaccounting and
44: -- This record holds general information used by autoaccounting and
45: -- credit memo module. Passed as argument to most functions/procs.
46: --
47: system_info arp_trx_global.system_info_rec_type :=
48: arp_trx_global.system_info;
49:
50: --
51: -- This record holds profile information used by autoaccounting and
52: -- credit memo module. Passed as argument to most functions/procs.
50: --
51: -- This record holds profile information used by autoaccounting and
52: -- credit memo module. Passed as argument to most functions/procs.
53: --
54: profile_info arp_trx_global.profile_rec_type :=
55: arp_trx_global.profile_info;
56:
57:
58: TYPE control_rec_type IS RECORD
51: -- This record holds profile information used by autoaccounting and
52: -- credit memo module. Passed as argument to most functions/procs.
53: --
54: profile_info arp_trx_global.profile_rec_type :=
55: arp_trx_global.profile_info;
56:
57:
58: TYPE control_rec_type IS RECORD
59: (
403:
404:
405: ----------------------------------------------------------------------------
406: PROCEDURE build_doc_combo_sql(
407: p_system_info IN arp_trx_global.system_info_rec_type,
408: p_profile_info IN arp_trx_global.profile_rec_type,
409: p_select_c IN OUT NOCOPY INTEGER ) IS
410:
411: l_select_sql VARCHAR2(500);
404:
405: ----------------------------------------------------------------------------
406: PROCEDURE build_doc_combo_sql(
407: p_system_info IN arp_trx_global.system_info_rec_type,
408: p_profile_info IN arp_trx_global.profile_rec_type,
409: p_select_c IN OUT NOCOPY INTEGER ) IS
410:
411: l_select_sql VARCHAR2(500);
412:
459:
460:
461: ----------------------------------------------------------------------------
462: PROCEDURE build_doc_insert_audit_sql(
463: p_system_info IN arp_trx_global.system_info_rec_type,
464: p_profile_info IN arp_trx_global.profile_rec_type,
465: p_where_clause IN VARCHAR2,
466: p_insert_audit_c IN OUT NOCOPY INTEGER ) IS
467:
460:
461: ----------------------------------------------------------------------------
462: PROCEDURE build_doc_insert_audit_sql(
463: p_system_info IN arp_trx_global.system_info_rec_type,
464: p_profile_info IN arp_trx_global.profile_rec_type,
465: p_where_clause IN VARCHAR2,
466: p_insert_audit_c IN OUT NOCOPY INTEGER ) IS
467:
468: l_insert_audit_sql VARCHAR2(1000);
522:
523:
524: ----------------------------------------------------------------------------
525: PROCEDURE build_doc_update_adj_sql(
526: p_system_info IN arp_trx_global.system_info_rec_type,
527: p_profile_info IN arp_trx_global.profile_rec_type,
528: p_sequence_name IN VARCHAR2,
529: p_sequence_id IN BINARY_INTEGER,
530: p_where_clause IN VARCHAR2,
523:
524: ----------------------------------------------------------------------------
525: PROCEDURE build_doc_update_adj_sql(
526: p_system_info IN arp_trx_global.system_info_rec_type,
527: p_profile_info IN arp_trx_global.profile_rec_type,
528: p_sequence_name IN VARCHAR2,
529: p_sequence_id IN BINARY_INTEGER,
530: p_where_clause IN VARCHAR2,
531: p_update_adj_c IN OUT NOCOPY INTEGER ) IS
583:
584:
585: ----------------------------------------------------------------------------
586: PROCEDURE update_adj_document_number(
587: p_system_info IN arp_trx_global.system_info_rec_type,
588: p_profile_info IN arp_trx_global.profile_rec_type,
589: p_customer_trx_id BINARY_INTEGER,
590: p_bind1 BINARY_INTEGER,
591: p_bind2 BINARY_INTEGER,
584:
585: ----------------------------------------------------------------------------
586: PROCEDURE update_adj_document_number(
587: p_system_info IN arp_trx_global.system_info_rec_type,
588: p_profile_info IN arp_trx_global.profile_rec_type,
589: p_customer_trx_id BINARY_INTEGER,
590: p_bind1 BINARY_INTEGER,
591: p_bind2 BINARY_INTEGER,
592: p_bind3 BINARY_INTEGER,
1180: END delete_adjustments;
1181:
1182: ----------------------------------------------------------------------------
1183: PROCEDURE reverse_adjustments(
1184: p_system_info IN arp_trx_global.system_info_rec_type,
1185: p_profile_info IN arp_trx_global.profile_rec_type,
1186: p_customer_trx_id IN BINARY_INTEGER,
1187: p_subsequent_trx_id IN BINARY_INTEGER
1188: ) IS
1181:
1182: ----------------------------------------------------------------------------
1183: PROCEDURE reverse_adjustments(
1184: p_system_info IN arp_trx_global.system_info_rec_type,
1185: p_profile_info IN arp_trx_global.profile_rec_type,
1186: p_customer_trx_id IN BINARY_INTEGER,
1187: p_subsequent_trx_id IN BINARY_INTEGER
1188: ) IS
1189: /* VAT changes */
1362:
1363:
1364: ----------------------------------------------------------------------------
1365: PROCEDURE reverse_cm_effect(
1366: p_system_info IN arp_trx_global.system_info_rec_type,
1367: p_profile_info IN arp_trx_global.profile_rec_type,
1368: p_customer_trx_id IN BINARY_INTEGER
1369: ) IS
1370:
1363:
1364: ----------------------------------------------------------------------------
1365: PROCEDURE reverse_cm_effect(
1366: p_system_info IN arp_trx_global.system_info_rec_type,
1367: p_profile_info IN arp_trx_global.profile_rec_type,
1368: p_customer_trx_id IN BINARY_INTEGER
1369: ) IS
1370:
1371: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1497:
1498:
1499: ----------------------------------------------------------------------------
1500: PROCEDURE update_payment_schedule(
1501: p_system_info IN arp_trx_global.system_info_rec_type,
1502: p_profile_info IN arp_trx_global.profile_rec_type,
1503: p_control IN control_rec_type
1504: ) IS
1505:
1498:
1499: ----------------------------------------------------------------------------
1500: PROCEDURE update_payment_schedule(
1501: p_system_info IN arp_trx_global.system_info_rec_type,
1502: p_profile_info IN arp_trx_global.profile_rec_type,
1503: p_control IN control_rec_type
1504: ) IS
1505:
1506: --BUG#5324129
2148:
2149:
2150: ----------------------------------------------------------------------------
2151: PROCEDURE update_adjustments(
2152: p_system_info IN arp_trx_global.system_info_rec_type,
2153: p_profile_info IN arp_trx_global.profile_rec_type,
2154: p_control IN control_rec_type
2155: ) IS
2156:
2149:
2150: ----------------------------------------------------------------------------
2151: PROCEDURE update_adjustments(
2152: p_system_info IN arp_trx_global.system_info_rec_type,
2153: p_profile_info IN arp_trx_global.profile_rec_type,
2154: p_control IN control_rec_type
2155: ) IS
2156:
2157: CURSOR del_app IS