DBA Data[Home] [Help]

PACKAGE: APPS.JL_ZZ_AP_MONOTRIB_AWT_PKG

Source


1 PACKAGE JL_ZZ_AP_MONOTRIB_AWT_PKG AUTHID CURRENT_USER AS
2 /* $Header: jlarmtbs.pls 120.2.12020000.1 2012/06/27 09:32:02 appldev ship $ */
3 
4 P_SOB_ID          NUMBER;
5 P_ORG_ID          NUMBER;
6 P_REPORT_MODE     VARCHAR2(10);
7 P_SUPPLIER_NAME   VARCHAR2(240);
8 P_SUPPLIER_ID     NUMBER;
9 P_TAXPAYER_ID     VARCHAR2(30);
10 P_REPORT_DATE     DATE;
11 P_GOODS_SUPP_THLD NUMBER DEFAULT 0;
12 P_SERVICE_SUPP_THLD NUMBER DEFAULT 0;
13 P_DEBUG_LOG   VARCHAR2(1);
14 P_LEGAL_ENTITY_ID NUMBER;
15 
16 FUNCTION BeforeReport
17         RETURN BOOLEAN;
18 
19 FUNCTION AfterReport
20         RETURN BOOLEAN;
21 
22 PROCEDURE Insert_temp_data(P_SUPPLIER_NAME             IN VARCHAR2,
23                            P_SUPPLIER_ID               IN NUMBER,
24                            P_TAXPAYER_ID               IN VARCHAR2,
25                            P_SIMPLIF_REGIME_CONT_TYPE  IN VARCHAR2,
26                            P_supp_monotrib_status      IN VARCHAR2,
27                            P_supp_update_status        IN VARCHAR2,
28                            P_threshold_amt             IN NUMBER,
29                            P_INVOICE_ID                IN NUMBER,
30                            P_INVOICE_NUM               IN VARCHAR2,
31                            P_INVOICE_DATE              IN DATE,
32                            P_INVOICE_STATUS            IN VARCHAR2,
33                            P_DGI_TYPE                  IN VARCHAR2,
34                            P_INV_AMOUNT                IN NUMBER,
35                            P_INV_AMT_WOUT_TAX          IN NUMBER,
36                            P_threshold_Met             IN VARCHAR2 );
37 
38 PROCEDURE Update_Supplier_Applicability (P_Supplier_Id IN po_vendors.vendor_id%Type ,
39                                          Applicability_Chngd_flag OUT NOCOPY Varchar2 );
40 
41 PROCEDURE Update_Monotrib_Inv_Distrib_Wh (P_Invoice_Id IN ap_invoices_all.invoice_id%TYPE ,
42                                           P_vendor_id  IN po_vendors.vendor_id%Type );
43 
44 PROCEDURE Monotrib_Wh_Def_Line (  p_invoice_id    NUMBER,
45                                   p_inv_dist_id   NUMBER,
46                                   p_tax_payer_id  ap_invoice_distributions_all.global_attribute2%TYPE,
47                                   p_ship_to_loc   VARCHAR2,
48                                   p_line_type     VARCHAR2,
49                                   p_vendor_id     NUMBER
50 								) ;
51 
52 END JL_ZZ_AP_MONOTRIB_AWT_PKG;
53