1 PACKAGE JL_ZZ_PO_LIBRARY_1_PKG AS
2 /* $Header: jlzzul1s.pls 120.1.12010000.2 2008/08/25 06:44:49 vspuli ship $ */
3
4
5 PROCEDURE get_fcc_code (fcc_code_type IN VARCHAR2,
6 tran_nat_type IN VARCHAR2,
7 so_org_id IN VARCHAR2,
8 inv_item_id IN NUMBER,
9 fcc_code IN OUT NOCOPY VARCHAR2,
10 tran_nat IN OUT NOCOPY VARCHAR2,
11 row_number IN NUMBER,
12 Errcd IN OUT NOCOPY NUMBER);
13
14 PROCEDURE get_total_tax (po_header_id IN NUMBER,
15 total_tax IN OUT NOCOPY VARCHAR2,
16 row_number IN NUMBER,
17 Errcd IN OUT NOCOPY NUMBER);
18
19 PROCEDURE get_fc_code (form_org_id IN NUMBER,
20 form_item_id IN NUMBER,
21 fc_code IN OUT NOCOPY VARCHAR2,
22 row_number IN NUMBER,
23 Errcd IN OUT NOCOPY NUMBER);
24
25 PROCEDURE get_global_attributes (form_line_loca_id IN NUMBER,
26 ga1 IN OUT NOCOPY VARCHAR2,
27 ga2 IN OUT NOCOPY VARCHAR2,
28 ga3 IN OUT NOCOPY VARCHAR2,
29 ga4 IN OUT NOCOPY VARCHAR2,
30 ga5 IN OUT NOCOPY VARCHAR2,
31 ga6 IN OUT NOCOPY VARCHAR2,
32 row_number IN NUMBER,
33 Errcd IN OUT NOCOPY NUMBER);
34
35 PROCEDURE get_total_tax_for_release (po_header_id2 IN NUMBER,
36 po_release_id2 IN NUMBER,
37 total_tax IN OUT NOCOPY VARCHAR2,
38 row_number IN NUMBER,
39 Errcd IN OUT NOCOPY NUMBER);
40
41 PROCEDURE get_context_name3 (global_description IN OUT NOCOPY VARCHAR2,
42 row_number IN NUMBER,
43 Errcd IN OUT NOCOPY NUMBER);
44
45 PROCEDURE get_trx_reason1 (org_id IN NUMBER,
46 item_id IN NUMBER,
47 trx_reason IN OUT NOCOPY VARCHAR2,
48 fcc IN OUT NOCOPY VARCHAR2,
49 row_number IN NUMBER,
50 Errcd IN OUT NOCOPY NUMBER);
51
52 PROCEDURE get_trx_reason2 (trx_reason IN OUT NOCOPY VARCHAR2,
53 row_number IN NUMBER,
54 Errcd IN OUT NOCOPY NUMBER);
55
56 PROCEDURE get_displayed_field (tran_code IN VARCHAR2,
57 disp_field IN OUT NOCOPY VARCHAR2,
58 row_number IN NUMBER,
59 Errcd IN OUT NOCOPY NUMBER);
60
61 PROCEDURE get_trx_reason_cd_per_req_line(
62 p_master_inv_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
63 , p_inventory_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
64 , p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
65 , p_org_id IN PO_REQUISITION_LINES.ORG_ID%TYPE
66 , x_trx_reason_code OUT NOCOPY PO_REQUISITION_LINES.TRANSACTION_REASON_CODE%TYPE
67 , x_error_code OUT NOCOPY NUMBER);
68
69 END JL_ZZ_PO_LIBRARY_1_PKG;