[Home] [Help]
PACKAGE: APPS.JAI_AP_DTC_DEFAULTATION_PKG
Source
1 package jai_ap_dtc_defaultation_pkg as
2 /* $Header: jai_ap_dtc_dflt.pls 120.8.12020000.3 2013/03/18 12:22:33 vkaranam noship $ */
3
4
5 TYPE AIDA_RECORD IS RECORD (
6 INVOICE_ID NUMBER,
7 INVOICE_LINE_NUMBER NUMBER,
8 DISTRIBUTION_LINE_NUMBER NUMBER,
9 INVOICE_DISTRIBUTION_ID NUMBER,
10 DIST_CODE_COMBINATION_ID NUMBER,
11 AMOUNT NUMBER,
12 DESCRIPTION VARCHAR2(240),
13 MATCH_STATUS_FLAG VARCHAR2(1),
14 LINE_TYPE_LOOKUP_CODE VARCHAR2(25),
15 ACCOUNTING_DATE DATE
16 );
17 TYPE AIDA_TYPE IS TABLE OF AIDA_RECORD;
18
19 la_aida_tab AIDA_TYPE := AIDA_TYPE();
20
21 procedure default_tds_from_setup(p_inv_id IN number,
22 p_redefault_tax_category IN varchar2 default 'N',
23 p_redefault_section_code IN varchar2 default 'N',
24 p_process_flag OUT NOCOPY varchar2,
25 p_process_message OUT NOCOPY varchar2,
26 p_call_from IN varchar2 default 'VALIDATION'); --Added by Chong for Bug#13802244 2012/09/17
27
28 procedure p_get_inv_dist (cp_inv_id IN number);
29
30 procedure p_get_standalone_dist_id (cp_inv_id IN number, cp_inv_line_number IN number, cp_inv_dist_id OUT NOCOPY number);
31
32 procedure p_get_accounting_date (cp_inv_id IN number, cp_max_date OUT NOCOPY date, cp_min_date OUT NOCOPY date);
33
34 procedure p_get_dist_ccid (cp_inv_id IN number, cp_inv_dist_id IN number, cp_parent_dist_ccid OUT NOCOPY number);
35
36 end jai_ap_dtc_defaultation_pkg;