[Home] [Help]
PACKAGE: APPS.JAI_RETRO_PRC_PKG
Source
1 PACKAGE JAI_RETRO_PRC_PKG AS
2 --$Header: jai_retro_prc.pls 120.0 2008/01/21 10:58:36 rchandan noship $
3 --==========================================================================
4 -- PROCEDURE NAME:
5 --
6 -- Process_Retroactive_Update Public
7 --
8 -- DESCRIPTION:
9 --
10 -- This procedure is used to do the Costing for DELIEVR transaction and also
11 -- when user choses to UNCLAIM.
12 --
13 --
14 -- PARAMETERS:
15 -- In: pn_vendor_id identifier of vendor
16 -- pn_vendor_site_id identifier of vendor site
17 -- pn_po_header_id identifier of po header
18 -- pd_from_eff_date effective date
19 -- pv_cenvat_action 'CLAIM' OR 'UNCLAIM'
20 -- pv_supp_exc_inv_no excise invoice number
21 -- pv_supp_exc_inv_date excise invoice date
22 -- pv_vat_action 'CLAIM' OR 'UNCLAIM'
23 -- pv_supp_vat_inv_no vat invoice number
24 -- pv_supp_vat_inv_date vat invoice date
25 -- pv_process_downward price downward processing flag
26 -- Out :
27 -- errbuf concurrent return message
28 -- retcode concurrent return code
29 --
30 --
31 -- DESIGN REFERENCES:
32 -- JAI_Retroprice_TDD.doc
33 --
34 -- CHANGE HISTORY:
35 --
36 -- 14-JAN-2008 Eric Ma created
37 --==========================================================================
38 GV_MODULE_PREFIX VARCHAR2(50) := 'jai.plsql.JAI_RETRO_PRC_PKG';
39
40 lc_rec PO_LINE_LOCATIONS_ALL%ROWTYPE;
41
42 PROCEDURE Process_Retroactive_Update
43 ( errbuf OUT NOCOPY VARCHAR2
44 , retcode OUT NOCOPY VARCHAR2
45 , pn_vendor_id IN NUMBER
46 , pn_vendor_site_id IN NUMBER DEFAULT NULL
47 , pn_po_header_id IN NUMBER DEFAULT NULL
48 , pv_from_eff_date IN VARCHAR2 DEFAULT NULL
49 , pv_cenvat_action IN VARCHAR2 DEFAULT NULL
50 , pv_supp_exc_inv_no IN VARCHAR2 DEFAULT NULL
51 , pv_supp_exc_inv_date IN VARCHAR2 DEFAULT NULL
52 , pv_vat_action IN VARCHAR2 DEFAULT NULL
53 , pv_supp_vat_inv_no IN VARCHAR2 DEFAULT NULL
54 , pv_supp_vat_inv_date IN VARCHAR2 DEFAULT NULL
55 , pv_process_downward IN VARCHAR2 DEFAULT NULL
56 );
57
58 --==========================================================================
59 -- PROCEDURE NAME:
60 --
61 -- Insert_Price_Changes Public
62 --
63 -- DESCRIPTION:
64 --
65 -- This procedure is used to insert location line history changes
66 -- when doing retroactive price update.
67 --
68 -- PARAMETERS:
69 -- In: pr_old lc_rec%TYPE old line record
70 -- pr_new lc_rec%TYPE new line record
71 -- Out: pv_process_flag VARCHAR2 return flag
72 -- pv_process_message VARCHAR2 return message
73 --
74 --
75 -- DESIGN REFERENCES:
76 -- JAI_Retroprice_TDD.doc
77 --
78 -- CHANGE HISTORY:
79 --
80 -- 14-JAN-2008 Kevin Cheng Created
81 --==========================================================================
82 PROCEDURE Insert_Price_Changes
83 ( pr_old IN lc_rec%TYPE
84 , pr_new IN lc_rec%TYPE
85 , pv_process_flag OUT NOCOPY VARCHAR2
86 , pv_process_message OUT NOCOPY VARCHAR2
87 );
88
89 --==========================================================================
90 -- PROCEDURE NAME:
91 --
92 -- Update_Price_Changes Public
93 --
94 -- DESCRIPTION:
95 --
96 -- This procedure is used to update tax amount in tax line changes table
97 -- when doing retroactive price update.
98 --
99 -- PARAMETERS:
100 -- In: pn_tax_amt NUMBER updated tax amount
101 -- pn_line_no NUMBER tax line number
102 -- pn_line_loc_id NUMBER line location id
103 -- Out: pv_process_flag VARCHAR2 return flag
104 -- pv_process_message VARCHAR2 return message
105 --
106 --
107 -- DESIGN REFERENCES:
108 -- JAI_Retroprice_TDD.doc
109 --
110 -- CHANGE HISTORY:
111 --
112 -- 14-JAN-2008 Kevin Cheng Created
113 --==========================================================================
114 PROCEDURE Update_Price_Changes
115 ( pn_tax_amt IN NUMBER
116 , pn_line_no IN NUMBER
117 , pn_line_loc_id IN NUMBER
118 , pv_process_flag OUT NOCOPY VARCHAR2
119 , pv_process_message OUT NOCOPY VARCHAR2
120 );
121
122 END JAI_RETRO_PRC_PKG ;