1 PACKAGE JMF_PROCESS_SHIKYU_RCV_TRX_PVT AUTHID CURRENT_USER AS
2 -- $Header: JMFVSKTS.pls 120.4 2006/03/20 04:41 vmutyala noship $
3
4 -- Global variables
5 G_TEAM_NAME CONSTANT VARCHAR2(3) := 'JMF';
6 G_PKG_NAME CONSTANT VARCHAR2(30) := 'JMF_PROCESS_SHIKYU_RCV_TRX_PVT';
7
8
9 --========================================================================
10 -- PROCEDURE : Process_Shikyu_Rcv_trx PUBLIC
11 -- PARAMETERS: p_api_version IN Standard in parameter API version
12 -- p_init_msg_list IN Standard in parameter message list
13 -- p_request_id IN Request Id
14 -- p_group_id IN Group Id
15 -- x_return_status OUT Stadard out parameter for return status
16 -- (Values E(Error), S(Success), U(Unexpected error))
17 --
18 -- COMMENT : This concurrent program will be called to process OSA Receipt,
19 -- OSA Return and RTV of SHIKYU Components at MP site. RTV of SHIKYU
20 -- Component is triggered by SHIKYU RMA at OEM site.
21 --========================================================================
22 PROCEDURE Process_Shikyu_Rcv_trx(
23 p_api_version IN NUMBER,
24 p_init_msg_list IN VARCHAR2,
25 p_request_id NUMBER,
26 p_group_id NUMBER,
27 x_return_status OUT NOCOPY VARCHAR2
28 );
29
30
31 --========================================================================
32 -- PROCEDURE : Process_Osa_Receipt PUBLIC
33 -- PARAMETERS: p_api_version IN Standard in parameter API version
34 -- p_init_msg_list IN Standard in parameter message list
35 -- x_return_status OUT Stadard out parameter for return status
36 -- (Values E(Error), S(Success), U(Unexpected error))
37 -- x_msg_count OUT Stadard out parameter for number of messages
38 -- x_msg_data OUT Stadard out parameter for message
39 -- p_po_shipment_id IN Subcontracting PO shipment
40 -- p_quantity IN Received quantity
41 -- p_uom IN UOM of received quantity
42 -- p_transaction_type IN Transaction Type
43 -- p_project_id IN Project reference
44 -- p_task_id IN Task reference
45 -- COMMENT : This procedure is called after receipt of Outsourced Assembly
46 -- Item to perform WIP completion and Misc issue at Manufacturing
47 -- Partner organization. It does allocations if required.
48 --========================================================================
49 PROCEDURE Process_Osa_Receipt
50 ( p_api_version IN NUMBER
51 , p_init_msg_list IN VARCHAR2
52 , x_return_status OUT NOCOPY VARCHAR2
53 , x_msg_count OUT NOCOPY NUMBER
54 , x_msg_data OUT NOCOPY VARCHAR2
55 , p_po_shipment_id IN NUMBER
56 , p_quantity IN NUMBER
57 , p_uom IN VARCHAR2
58 , p_transaction_type IN VARCHAR2
59 , p_project_id IN NUMBER
60 , p_task_id IN NUMBER
61 , p_status IN OUT NOCOPY VARCHAR2
62 );
63
64 --========================================================================
65 -- PROCEDURE : Process_Osa_Return PUBLIC
66 -- PARAMETERS: p_api_version IN Standard in parameter API version
67 -- p_init_msg_list IN Standard in parameter message list
68 -- x_return_status OUT Stadard out parameter for return status
69 -- (Values E(Error), S(Success), U(Unexpected error))
70 -- x_msg_count OUT Stadard out parameter for number of messages
71 -- x_msg_data OUT Stadard out parameter for message
72 -- p_po_shipment_id IN Subcontracting PO shipment
73 -- p_quantity IN Received quantity
74 -- p_uom IN UOM of received quantity
75 -- p_transaction_type IN Transaction Type
76 -- p_project_id IN project reference
77 -- p_task_id IN task reference
78 -- COMMENT : This procedure is called after return of Outsourced Assembly
79 -- Item to Supplier to perform WIP assembly return and Misc receipt at
80 -- Manufacturing Partner organization.
81 --========================================================================
82 PROCEDURE Process_Osa_Return
83 ( p_api_version IN NUMBER
84 , p_init_msg_list IN VARCHAR2
85 , x_return_status OUT NOCOPY VARCHAR2
86 , x_msg_count OUT NOCOPY NUMBER
87 , x_msg_data OUT NOCOPY VARCHAR2
88 , p_po_shipment_id IN NUMBER
89 , p_quantity IN NUMBER
90 , p_uom IN VARCHAR2
91 , p_transaction_type IN VARCHAR2
92 , p_project_id IN NUMBER
93 , p_task_id IN NUMBER
94 , p_status IN OUT NOCOPY VARCHAR2
95 );
96
97
98 --========================================================================
99 -- PROCEDURE : Process_Component_Return PUBLIC
100 -- PARAMETERS: p_api_version IN Standard in parameter API version
101 -- p_init_msg_list IN Standard in parameter message list
102 -- x_return_status OUT Stadard out parameter for return status
103 -- (Values E(Error), S(Success), U(Unexpected error))
104 -- x_msg_count OUT Stadard out parameter for number of messages
105 -- x_msg_data OUT Stadard out parameter for message
106 -- p_rma_line_id IN RMA line id
107 -- p_quantity IN Received quantity
108 -- p_uom IN UOM of received quantity
109 -- COMMENT : This procedure is called after SHIKYU RMA at Subcontracting
110 -- Organizaiton. It initiates RTV transaction at MP Organization.
111 -- It also deallocates returned quantities.
112 --========================================================================
113 PROCEDURE Process_Component_Return
114 ( p_api_version IN NUMBER
115 , p_init_msg_list IN VARCHAR2
116 , x_return_status OUT NOCOPY VARCHAR2
117 , x_msg_count OUT NOCOPY NUMBER
118 , x_msg_data OUT NOCOPY VARCHAR2
119 , p_rma_line_id IN NUMBER
120 , p_quantity IN NUMBER
121 , p_uom IN VARCHAR2
122 , p_status IN OUT NOCOPY VARCHAR2
123 );
124
125 END JMF_PROCESS_SHIKYU_RCV_TRX_PVT;