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,
1134: END delete_adjustments;
1135:
1136: ----------------------------------------------------------------------------
1137: PROCEDURE reverse_adjustments(
1138: p_system_info IN arp_trx_global.system_info_rec_type,
1139: p_profile_info IN arp_trx_global.profile_rec_type,
1140: p_customer_trx_id IN BINARY_INTEGER,
1141: p_subsequent_trx_id IN BINARY_INTEGER
1142: ) IS
1135:
1136: ----------------------------------------------------------------------------
1137: PROCEDURE reverse_adjustments(
1138: p_system_info IN arp_trx_global.system_info_rec_type,
1139: p_profile_info IN arp_trx_global.profile_rec_type,
1140: p_customer_trx_id IN BINARY_INTEGER,
1141: p_subsequent_trx_id IN BINARY_INTEGER
1142: ) IS
1143: /* VAT changes */
1314:
1315:
1316: ----------------------------------------------------------------------------
1317: PROCEDURE reverse_cm_effect(
1318: p_system_info IN arp_trx_global.system_info_rec_type,
1319: p_profile_info IN arp_trx_global.profile_rec_type,
1320: p_customer_trx_id IN BINARY_INTEGER
1321: ) IS
1322:
1315:
1316: ----------------------------------------------------------------------------
1317: PROCEDURE reverse_cm_effect(
1318: p_system_info IN arp_trx_global.system_info_rec_type,
1319: p_profile_info IN arp_trx_global.profile_rec_type,
1320: p_customer_trx_id IN BINARY_INTEGER
1321: ) IS
1322:
1323: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1449:
1450:
1451: ----------------------------------------------------------------------------
1452: PROCEDURE update_payment_schedule(
1453: p_system_info IN arp_trx_global.system_info_rec_type,
1454: p_profile_info IN arp_trx_global.profile_rec_type,
1455: p_control IN control_rec_type
1456: ) IS
1457:
1450:
1451: ----------------------------------------------------------------------------
1452: PROCEDURE update_payment_schedule(
1453: p_system_info IN arp_trx_global.system_info_rec_type,
1454: p_profile_info IN arp_trx_global.profile_rec_type,
1455: p_control IN control_rec_type
1456: ) IS
1457:
1458: --BUG#5324129
2100:
2101:
2102: ----------------------------------------------------------------------------
2103: PROCEDURE update_adjustments(
2104: p_system_info IN arp_trx_global.system_info_rec_type,
2105: p_profile_info IN arp_trx_global.profile_rec_type,
2106: p_control IN control_rec_type
2107: ) IS
2108:
2101:
2102: ----------------------------------------------------------------------------
2103: PROCEDURE update_adjustments(
2104: p_system_info IN arp_trx_global.system_info_rec_type,
2105: p_profile_info IN arp_trx_global.profile_rec_type,
2106: p_control IN control_rec_type
2107: ) IS
2108:
2109: CURSOR del_app IS