[Home] [Help]
PACKAGE: APPS.JAI_TRX_REPO_EXTRACT_PKG
Source
1 package jai_trx_repo_extract_pkg as
2 /*$Header: jai_trx_repo_ext.pls 120.1.12000000.1 2007/07/24 06:56:20 rallamse noship $ */
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
10 --------------------------------------------------------------------------------------------------------------*/
11
12 procedure get_document_details
13 ( p_document_id in number
14 , p_document_line_id in number
15 , p_document_source in varchar2
16 , p_called_from in varchar2 default null
17 , p_process_message out nocopy varchar2
18 , p_process_flag out nocopy varchar2
19 , p_trx_repo_extract in out nocopy jai_trx_repo_extract_gt%rowtype
20 );
21 procedure extract_rgm_trxs
22 ( p_regime_code jai_rgm_trx_records.regime_code%type
23 , p_organization_id jai_rgm_trx_records.organization_id%type default null
24 , p_location_id jai_rgm_trx_records.location_id%type default null
25 , p_from_trx_date date default null
26 , p_to_trx_date date default null
27 , p_source jai_rgm_trx_records.source%type default null
28 , p_query_settled_flag varchar2 default 'N'
29 , p_query_only_null_srvtype varchar2 default 'N'
30 , p_process_message out nocopy varchar
31 , p_process_flag out nocopy varchar2
32 );
33
34 procedure get_doc_from_reference
35 ( p_reference_id in number
36 , p_trx_repo_extract_rec out nocopy jai_trx_repo_extract_gt%rowtype
37 , p_process_flag out nocopy varchar2
38 , p_process_message out nocopy varchar2
39 );
40
41 procedure get_doc_from_reference
42 ( p_reference_id in number
43 , p_organization_id out nocopy number
44 , p_location_id out nocopy number
45 , p_service_type_code out nocopy varchar2
46 , p_process_flag out nocopy varchar2
47 , p_process_message out nocopy varchar2
48 );
49
50 procedure update_service_type
51 ( p_process_flag out nocopy varchar2
52 , p_process_message out nocopy varchar2
53 );
54
55 procedure derrive_doc_from_ref
56 ( p_reference_source in jai_rgm_trx_refs.source%type
57 , p_reference_invoice_id in jai_rgm_trx_refs.invoice_id%type
58 , p_reference_item_line_id in jai_rgm_trx_refs.item_line_id%type
59 , p_trx_repo_extract_rec out nocopy jai_trx_repo_extract_gt%rowtype
60 , p_process_message out nocopy varchar2
61 , p_process_flag out nocopy varchar2
62 );
63 function get_service_type_from_ref (p_reference_id in jai_rgm_trx_refs.reference_id%type
64 )
65 return varchar2;
66
67
68 end jai_trx_repo_extract_pkg;