1 PACKAGE jai_ap_tds_pop_rpst_pkg AS
2 /* $Header: jai_ap_tds_pop_rpst.pls 120.0.12020000.3 2013/03/30 05:36:37 cholei noship $ */
3
4 /*----------------------------------------------------------------------------------------------------------------
5
6 Filename: jai_ap_tds_pop_rpst.pls
7
8 Change History:
9
10 Date Remarks
11 ---------------------------------------------------------------------------------------------------------
12 08-Jun-2005 Provid functions and procedures acessing eTDS repository.
13
14 ---------------------------------------------------------------------------------------------------------*/
15
16 /*----------------------------------------------------------------------------------------------------------
17 --Procedure to populate eTDS repository table when.
18 -- Validation
19 -- Threshold Transition
20 -- Threshold Rollback
21 -- Preypayment Application/Unapplication
22 */
23 PROCEDURE populate_repository(pn_source_invoice_id in number default null
24 ,pn_invoice_id in number default null
25 ,pv_event in varchar2
26 ,pv_section_type in varchar2
27 ,pv_section_code in varchar2
28 ,pn_threshold_grp_id in number
29 ,pn_threshold_hdr_id in number default null
30 ,pn_threshold_type_id in number default null
31 ,pn_threshold_slab_id in number default null
32 ,pn_invoice_distribution_id in number default null
33 ,pn_prepay_distribution_id in number default null
34 ,Pn_tax_category_id in number default null
35 );
36
37
38 /*----------------------------------------------------------------------------------------------------------
39 --After cancel source invoice, update repository as invoice_deleted_flag='Y'.
40 */
41 PROCEDURE process_cancellation(pn_source_invoice_id IN NUMBER);
42
43
44 /*----------------------------------------------------------------------------------------------------------
45 --This procedure should be invoked whenever surcharge calculation TDS invoice created or surcharge rollback.
46 --Splite surcharge amount into repository lines when surcharge calculation
47 --Cancel surcharge lines when surcharge rollback
48 */
49 PROCEDURE process_surcharge(pn_source_invoice_id IN NUMBER
50 ,pv_event IN VARCHAR2
51 ,pn_taxable_amount IN NUMBER
52 ,pn_tax_amount IN NUMBER
53 ,pn_threshold_grp_id IN NUMBER
54 ,pn_surcharge_tax_id IN NUMBER
55 );
56
57
58 /*----------------------------------------------------------------------------------------------------------
59 --When Given challan info in TDS challan detail UI, populdate information into repository.
60 */
61 PROCEDURE populate_challan_info(pn_invoice_id IN NUMBER
62 ,pn_challan_no IN NUMBER
63 ,pd_check_date IN DATE
64 ,pd_check_deposit_date IN DATE
65 ,pv_bsr_code IN VARCHAR2
66 ,pv_payment_reference_id IN VARCHAR2
67 );
68
69 /*----------------------------------------------------------------------------------------------------------
70 --Process eTDS migration.
71 */
72 PROCEDURE process_etds_migration;
73
74 /*----------------------------------------------------------------------------------------------------------
75 --Procedure to insert one line into jai_ap_tds_repository table.
76 */
77 PROCEDURE insert_jai_tds_repository(pr_jai_ap_tds_repository IN jai_ap_tds_repository%rowtype);
78
79
80
81 /*----------------------------------------------------------------------------------------------------------
82 --Procedure to insert one line into jai_ap_tds_repo_lines table.
83 */
84 PROCEDURE insert_jai_ap_tds_repo_lines(pr_jai_ap_tds_repo_lines IN jai_ap_tds_repo_lines%rowtype);
85
86
87 end jai_ap_tds_pop_rpst_pkg;