1 PACKAGE JMF_SHIKYU_GRP AUTHID CURRENT_USER as
2 --$Header: JMFGSHKS.pls 120.3 2007/12/28 09:17:00 kdevadas ship $
3 --+===========================================================================+
4 --| Copyright (c) 2005 Oracle Corporation |
5 --| Redwood Shores, California, USA |
6 --| All rights reserved. |
7 --+===========================================================================+
8 --| |
9 --| FILENAME : JMFGSHKS.pls |
10 --| |
11 --| DESCRIPTION: This is the group package for the Charge Based |
12 --| SHIKYU project. Other products such as CST, |
13 --| RCV, PO and Financials Globalization will be |
14 --| calling this package to support SHIKYU. |
15 --| |
16 --| HISTORY: |
17 --| 20-APR-2005 vchu Created. |
18 --| 19-Sep-2005 vchu Added Is_AP_Inv_Shikyu_Nettable_Func. |
19 --| 03-Oct-2007 kdevadas 12.1 Buy/Sell Subcontracting Changes |
20 --| Reference - GBL_BuySell_TDD.doc |
21 --| Reference - GBL_BuySell_FDD.doc |
22 --| 27-DEC-2007 kdevadas Bug: 6679369 - Get_shikyu_variance_account |
23 --| modified to pass the subcontracting type |
24 --| to Costing for OSA receipts in Std Cost orgs |
25 --+===========================================================================+
26
27 G_PKG_NAME CONSTANT VARCHAR2(30) := 'JMF_SHIKYU_GRP';
28
29 PROCEDURE Get_Shikyu_Variance_Account
30 ( p_api_version IN NUMBER
31 , p_init_msg_list IN VARCHAR2
32 , x_return_status OUT NOCOPY VARCHAR2
33 , x_msg_count OUT NOCOPY NUMBER
34 , x_msg_data OUT NOCOPY VARCHAR2
35 , p_po_shipment_id IN NUMBER
36 , x_variance_account OUT NOCOPY NUMBER
37 , x_subcontracting_type OUT NOCOPY NUMBER -- Bug 6679369
38 );
39
40 PROCEDURE Get_Po_Shipment_Osa_Flag
41 ( p_api_version IN NUMBER
42 , p_init_msg_list IN VARCHAR2
43 , x_return_status OUT NOCOPY VARCHAR2
44 , x_msg_count OUT NOCOPY NUMBER
45 , x_msg_data OUT NOCOPY VARCHAR2
46 , p_po_shipment_id IN NUMBER
47 , x_osa_flag OUT NOCOPY VARCHAR2
48 );
49
50 PROCEDURE Is_Tp_Organization
51 ( p_api_version IN NUMBER
52 , p_init_msg_list IN VARCHAR2
53 , x_return_status OUT NOCOPY VARCHAR2
54 , x_msg_count OUT NOCOPY NUMBER
55 , x_msg_data OUT NOCOPY VARCHAR2
56 , p_organization_id IN NUMBER
57 , x_is_tp_org_flag OUT NOCOPY VARCHAR2
58 );
59
60 PROCEDURE Is_AP_Invoice_Shikyu_Nettable
61 ( p_api_version IN NUMBER
62 , p_init_msg_list IN VARCHAR2
63 , x_return_status OUT NOCOPY VARCHAR2
64 , x_msg_count OUT NOCOPY NUMBER
65 , x_msg_data OUT NOCOPY VARCHAR2
66 , p_ap_invoice_id IN NUMBER
67 , x_nettable OUT NOCOPY VARCHAR2
68 );
69
70 FUNCTION Is_AP_Inv_Shikyu_Nettable_Func
71 ( p_ap_invoice_id IN NUMBER
72 )
73 RETURN VARCHAR2;
74
75 PROCEDURE Is_So_Line_Shikyu_Enabled
76 ( p_api_version IN NUMBER
77 , p_init_msg_list IN VARCHAR2
78 , x_return_status OUT NOCOPY VARCHAR2
79 , x_msg_count OUT NOCOPY NUMBER
80 , x_msg_data OUT NOCOPY VARCHAR2
81 , p_sales_order_line_id IN NUMBER
82 , x_is_enabled OUT NOCOPY VARCHAR2
83 );
84
85 PROCEDURE Validate_Osa_Flag
86 ( p_api_version IN NUMBER
87 , p_init_msg_list IN VARCHAR2
88 , x_return_status OUT NOCOPY VARCHAR2
89 , x_msg_count OUT NOCOPY NUMBER
90 , x_msg_data OUT NOCOPY VARCHAR2
91 , p_inventory_item_id IN NUMBER
92 , p_vendor_id IN NUMBER
93 , p_vendor_site_id IN NUMBER
94 , p_ship_to_organization_id IN NUMBER
95 , x_osa_flag OUT NOCOPY VARCHAR2
96 );
97
98 PROCEDURE Get_Shikyu_Attributes
99 ( p_api_version IN NUMBER
100 , p_init_msg_list IN VARCHAR2
101 , x_return_status OUT NOCOPY VARCHAR2
102 , x_msg_count OUT NOCOPY NUMBER
103 , x_msg_data OUT NOCOPY VARCHAR2
104 , p_organization_id IN NUMBER
105 , p_item_id IN NUMBER
106 , x_outsourced_assembly OUT NOCOPY NUMBER
107 , x_subcontracting_component OUT NOCOPY NUMBER
108 );
109
110 /* 12.1 Buy/Sell Subcontracting Changes */
111
112 FUNCTION Get_Subcontracting_TYpe
113 ( p_oem_org_id IN NUMBER
114 , p_mp_org_id IN NUMBER ) RETURN VARCHAR2;
115
116
117 END JMF_SHIKYU_GRP;