1 PACKAGE jai_po_cmn_pkg AUTHID CURRENT_USER AS
2 /* $Header: jai_po_cmn.pls 120.4 2008/01/21 10:58:06 rchandan ship $ */
3
4 /* PROCEDURE insert_accrual_reconcile
5 (p_transaction_id number,
6 p_po_line_location_id number,
7 p_po_distribution_id number,
8 p_shipment_line_id number,
9 p_organization_id number,
10 p_transaction_date date,
11 p_transaction_amount number,
12 p_accrual_account_id number
13 );*/
14
15 PROCEDURE insert_line
16 ( v_code IN VARCHAR2,
17 v_line_loc_id IN NUMBER,
18 v_po_hdr_id IN NUMBER,
19 v_po_line_id IN NUMBER,
20 v_cre_dt IN DATE,
21 v_cre_by IN NUMBER,
22 v_last_upd_dt IN DATE,
23 v_last_upd_by IN NUMBER,
24 v_last_upd_login IN NUMBER,
25 flag IN VARCHAR2
26 , v_service_type_code IN VARCHAR2 DEFAULT NULL);
27
28 FUNCTION Ja_In_Po_Get_Func_Curr( p_po_header_id IN NUMBER ) RETURN VARCHAR2; -- Used to get Functional Currency.
29
30 FUNCTION Ja_In_Po_Assessable_Val_Conv( p_po_header_id IN NUMBER,
31 p_assessable_val IN NUMBER,
32 p_func_curr IN VARCHAR2,
33 p_doc_curr IN VARCHAR2,
34 /* Bug 5096787. Added by Lakshmi Gopalsami */
35 p_rate IN NUMBER DEFAULT NULL,
36 p_rate_date IN DATE DEFAULT NULL,
37 p_rate_type IN VARCHAR2 DEFAULT NULL
38 )
39 RETURN NUMBER; -- Used to calculate the assessable value in the document currency.
40
41 PROCEDURE Ja_In_Po_Func_Curr( p_po_header_id IN NUMBER,
42 p_assessable_val IN OUT NOCOPY NUMBER,
43 p_doc_curr IN VARCHAR2,
44 p_conv_rate IN OUT NOCOPY NUMBER, -- Used to integrate the above functions to get assessable value in doc. currency
45 /* Bug 5096787. Added by Lakshmi Gopalsami */
46 p_rate IN NUMBER DEFAULT NULL,
47 p_rate_date IN DATE DEFAULT NULL,
48 p_rate_type IN VARCHAR2 DEFAULT NULL
49 );
50
51 PROCEDURE locate_source_line
52 (
53 p_header_id IN NUMBER,
54 p_line_num IN NUMBER,
55 p_line_quantity IN NUMBER,
56 p_po_line_id OUT NOCOPY NUMBER,
57 p_line_location_id OUT NOCOPY NUMBER,
58 p_line_id NUMBER DEFAULT NULL
59 );
60
61 PROCEDURE process_release_shipment
62 (
63 v_shipment_type IN VARCHAR2,
64 v_src_ship_id IN NUMBER,
65 v_line_loc_id IN NUMBER,
66 v_po_line_id IN NUMBER,
67 v_po_hdr_id IN NUMBER,
68 v_qty IN NUMBER,
69 v_po_rel_id IN NUMBER,
70 v_cre_dt IN DATE,
71 v_cre_by IN NUMBER,
72 v_last_upd_dt IN DATE,
73 v_last_upd_by IN NUMBER,
74 v_last_upd_login IN NUMBER,
75 flag IN VARCHAR2 DEFAULT NULL
76 ,pv_retroprice_changed IN VARCHAR2 DEFAULT 'N' --Added by Kevin Cheng for Retroactive Price 2008/01/11
77 );
78
79 PROCEDURE get_functional_curr
80 ( v_ship_to_loc_id IN NUMBER, v_po_org_id IN NUMBER, v_inv_org_id IN NUMBER,
81 v_doc_curr IN VARCHAR2, v_assessable_value IN OUT NOCOPY NUMBER,
82 v_rate IN OUT NOCOPY NUMBER, v_rate_type IN VARCHAR2, v_rate_date IN DATE,
83 v_func_currency IN OUT NOCOPY VARCHAR2
84 );
85
86 END jai_po_cmn_pkg;