DBA Data[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;