[Home] [Help]
PACKAGE: APPS.JAI_TRX_REPO_EXTRACT_PKG
Source
1 package jai_trx_repo_extract_pkg AUTHID CURRENT_USER as
2 /*$Header: jai_trx_repo_ext.pls 120.5.12020000.2 2012/07/18 17:40:42 nkodakan ship $ */
3 /*------------------------------------------------------------------------------------------------------------
4 CHANGE HISTORY
5 ------------------------------------------------------------------------------------------------------------
6 Sl.No. Date Developer BugNo Version Remarks
7 ------------------------------------------------------------------------------------------------------------
8 1. 22-Dec-2005 brathod 5694855 115.1 Created the initial version
9 2. 29-oct-2010 vkaranam 10085619 : TAXES APPLIED IN PAYABLES ON THIRD PARTY INVOICES ARE NOT FLOWING TO SERVICE TAX REPOSITORY
10 fix: --added p_taxline_no for bug #10085619
11 , p_taxline_no in number default null
12
13 p_taxline_no refers to the line number of the miscellaneous line in tp /standalone invoice
14
15 --------------------------------------------------------------------------------------------------------------*/
16
17 procedure get_document_details
18 ( p_document_id in number
19 , p_document_line_id in number
20 , p_document_source in varchar2
21 , p_called_from in varchar2 default null
22 , p_source_trx_type in varchar2 default NULL --Add by Qiong for Advanced Receipts
23 , p_repository_id in varchar2 default NULL
24 , p_process_message out nocopy varchar2
25 , p_process_flag out nocopy varchar2
26 , p_trx_repo_extract in out nocopy jai_trx_repo_extract_gt%rowtype
27 --added p_taxline_no for bug #10085619
28 , p_taxline_no in number default null
29 );
30 procedure extract_rgm_trxs
31 ( p_regime_code jai_rgm_trx_records.regime_code%type
32 , p_organization_id jai_rgm_trx_records.organization_id%type default null
33 , p_location_id jai_rgm_trx_records.location_id%type default null
34 , p_from_trx_date date default null
35 , p_to_trx_date date default null
36 , p_source jai_rgm_trx_records.source%type default null
37 , p_query_settled_flag varchar2 default 'N'
38 , p_query_only_null_srvtype varchar2 default 'N'
39 , p_process_message out nocopy varchar
40 , p_process_flag out nocopy varchar2
41 );
42
43 procedure get_doc_from_reference
44 ( p_reference_id in number
45 , p_source_trx_type in varchar2 default NULL
46 , p_application_id in number default NULL
47 , p_trx_repo_extract_rec out nocopy jai_trx_repo_extract_gt%rowtype
48 , p_process_flag out nocopy varchar2
49 , p_process_message out nocopy varchar2
50 );
51
52 procedure get_doc_from_reference
53 ( p_reference_id in number
54 , p_source_trx_type in varchar2 default NULL
55 , p_application_id in number default NULL
56 , p_organization_id out nocopy number
57 , p_location_id out nocopy number
58 , p_service_type_code out nocopy varchar2
59 , p_process_flag out nocopy varchar2
60 , p_process_message out nocopy varchar2
61 );
62
63 procedure update_service_type
64 ( p_process_flag out nocopy varchar2
65 , p_process_message out nocopy varchar2
66 );
67
68 procedure derrive_doc_from_ref
69 ( p_reference_source in jai_rgm_trx_refs.source%type
70 , p_source_trx_type in jai_rgm_trx_records.source_trx_type%type default NULL
71 , p_reference_invoice_id in jai_rgm_trx_refs.invoice_id%type
72 , p_reference_item_line_id in jai_rgm_trx_refs.item_line_id%type
73 , p_trx_repo_extract_rec out nocopy jai_trx_repo_extract_gt%rowtype
74 , p_process_message out nocopy varchar2
75 , p_process_flag out nocopy varchar2
76 );
77 function get_service_type_from_ref (p_reference_id in jai_rgm_trx_refs.reference_id%type
78 )
79 return varchar2;
80
81 end jai_trx_repo_extract_pkg;