1 PACKAGE jai_ar_validate_data_pkg
2 /* $Header: jai_ar_val_data.pls 120.1 2007/06/08 08:39:59 bgowrava ship $ */
3 AS
4 /*
5 CREATED BY : Bgowrava
6 CREATED DATE : 08-JUN-2007
7 BUG : 5484865
8 PURPOSE : package spec for datafix to fix data corruption issues in AR base tables.
9 */
10
11 /* START, Added by Bgowrava for Bug#5484865 */
12 CURSOR cur_curr_precision(cp_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE)
13 IS
14 SELECT NVL(minimum_accountable_unit,NVL(precision,2))
15 FROM fnd_currencies
16 WHERE currency_code IN
17 (
18 SELECT Currency_code
19 FROM gl_sets_of_books
20 WHERE set_of_books_id = cp_set_of_books_id
21 );
22 /* END, Added by Bgowrava for Bug#5484865 */
23
24 TYPE r_error_record IS RECORD
25 ( type_of_error VARCHAR2(20),
26 error_description VARCHAR2(200),
27 error_record_count NUMBER DEFAULT 0,
28 enable VARCHAR2(1) DEFAULT 'N');
29
30 TYPE t_error_table IS TABLE of r_error_record INDEX BY BINARY_INTEGER;
31
32 gn_bug_no NUMBER:= -4703909;
33
34 PROCEDURE pre_validation( p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
35 p_process_status OUT NOCOPY VARCHAR2,
36 p_process_message OUT NOCOPY VARCHAR2);
37
38 PROCEDURE post_validation(p_start_date IN DATE DEFAULT NULL,
39 p_end_date IN DATE DEFAULT NULL,
40 p_customer_trx_id IN NUMBER DEFAULT NULL,
41 p_validate_first IN VARCHAR2 DEFAULT 'N',
42 p_validate_all IN VARCHAR2 DEFAULT 'N',
43 p_generate_log IN VARCHAR2 DEFAULT 'N',
44 p_generate_detail_log IN VARCHAR2 DEFAULT 'N',
45 p_fix_data IN VARCHAR2 DEFAULT 'N',
46 p_commit IN VARCHAR2 DEFAULT 'N',
47 p_log_filename IN VARCHAR2 DEFAULT NULL,
48 p_debug IN VARCHAR2 DEFAULT 'N',
49 p_process_status OUT NOCOPY VARCHAR2,
50 p_process_message OUT NOCOPY VARCHAR2);
51
52 PROCEDURE populate_error_table (p_error_table OUT NOCOPY jai_ar_validate_data_pkg.t_error_table,
53 p_process_status OUT NOCOPY VARCHAR2,
54 p_process_message OUT NOCOPY VARCHAR2);
55
56 PROCEDURE display_error_summary(p_error_table IN jai_ar_validate_data_pkg.t_error_table,
57 p_total_count IN NUMBER,
58 p_filename IN VARCHAR2,
59 p_process_status OUT NOCOPY VARCHAR2,
60 p_process_message OUT NOCOPY VARCHAR2);
61
62 PROCEDURE calc_term_apportion_ratio( p_invoice_type IN ar_payment_schedules_all.class%TYPE,
63 p_term_id IN ar_payment_schedules_all.term_id%TYPE,
64 p_terms_sequence_number IN ar_payment_schedules_all.terms_sequence_number%TYPE,
65 p_apportion_ratio OUT NOCOPY NUMBER,
66 p_first_installment_code OUT NOCOPY ra_terms.first_installment_code%TYPE,
67 p_process_status OUT NOCOPY VARCHAR2,
68 p_process_message OUT NOCOPY VARCHAR2
69 );
70
71 PROCEDURE rectify_ar_pay_sch(
72 p_customer_trx_id IN ar_payment_schedules_all.customer_trx_id%TYPE,
73 p_gl_rec_amount IN NUMBER DEFAULT NULL,
74 p_gl_tax_amount IN NUMBER DEFAULT NULL,
75 p_gl_freight_amount IN NUMBER DEFAULT NULL,
76 p_datafix_filename IN VARCHAR2,
77 p_process_status OUT NOCOPY VARCHAR2,
78 p_process_message OUT NOCOPY VARCHAR2);
79
80 PROCEDURE rectify_ar_rec_appl(
81 p_customer_trx_id IN ar_payment_schedules_all.customer_trx_id%TYPE,
82 p_previous_trx_id IN ar_payment_schedules_all.customer_trx_id%TYPE,
83 p_arps_ado IN NUMBER DEFAULT NULL,
84 p_arps_to IN NUMBER DEFAULT NULL,
85 p_arps_fo IN NUMBER DEFAULT NULL,
86 p_datafix_filename IN VARCHAR2,
87 p_process_status OUT NOCOPY VARCHAR2,
88 p_process_message OUT NOCOPY VARCHAR2);
89
90
91 END jai_ar_validate_data_pkg;