1 package POR_RCV_ORD_SV AUTHID CURRENT_USER as
2 /* $Header: PORRCVOS.pls 120.2 2005/11/07 16:31:38 tolick noship $ */
3
4
5 type rcvInfoRecord is record(
6 rcv_line_id number,
7 available boolean,
8 used_quantity number);
9 type rcvInfoTable is table of rcvInfoRecord index by binary_integer;
10
11 /*************************************************************
12 ** Public Function :
13 ** groupPoTransaction
14 ** Description :
15 ** grouping logic to group and split into transaction lines
16 ** each transaction line is inserted to rcv transaction interface
17 ** return true if grouping is successful
18 **************************************************************/
19
20 function groupPoTransaction (X_po_header_id IN rcvNumberArray,
21 X_line_location_id IN rcvNumberArray,
22 X_receipt_qty IN rcvNumberArray,
23 X_receipt_uom IN rcvVarcharArray,
24 X_receipt_date IN date,
25 X_item_id IN rcvNumberArray,
26 X_uom_class IN rcvVarcharArray,
27 X_org_id IN rcvNumberArray,
28 X_po_distribution_id IN rcvNumberArray,
29 X_group_id IN number,
30 X_caller IN varchar2,
31 X_Comments IN rcvVarcharArray,
32 X_PackingSlip IN rcvVarcharArray,
33 X_WayBillNum IN rcvVarcharArray)
34 return number;
35
36
37 /*************************************************************
38 ** Public Function :
39 ** groupInternalTransaction
40 ** Description :
41 ** grouping logic to group and split into transaction lines
42 ** return true if grouping is successful
43 **************************************************************/
44
45 function groupInternalTransaction (x_req_line_id in rcvNumberArray,
46 x_receipt_qty in rcvNumberArray,
47 x_receipt_uom in rcvVarcharArray,
48 x_item_id in rcvNumberArray,
49 x_uom_class in rcvVarcharArray,
50 x_org_id in rcvNumberArray,
51 x_comments in rcvVarcharArray,
52 x_packingSlip in rcvVarcharArray,
53 x_waybillNum in rcvVarcharArray,
54 x_group_id in number,
55 x_receipt_date in date,
56 x_caller in varchar2)
57 return number;
58
59
60 procedure INSERT_RCV_TXN_INTERFACE_IR (
61 X_rcv_shipment_line_id IN number,
62 x_req_line_id in number,
63 X_receipt_qty IN number,
64 X_receipt_uom IN varchar2,
65 X_receipt_date IN date,
66 X_item_id IN number,
67 X_uom_class IN varchar2,
68 X_org_id IN number,
69 X_group_id IN number,
70 X_caller IN varchar2,
71 X_Comments IN varchar2 default null,
72 X_PackingSlip IN varchar2 default null,
73 X_WayBillNum IN varchar2 default null
74 );
75
76 procedure INSERT_RCV_TXN_INTERFACE (X_source_type_code IN varchar2 default 'VENDOR',
77 X_rcv_shipment_line_id IN number default 0,
78 X_po_header_id IN number,
79 X_line_location_id IN number,
80 X_receipt_qty IN number,
81 X_receipt_uom IN varchar2,
82 X_receipt_date IN date,
83 X_item_id IN number,
84 X_uom_class IN varchar2,
85 X_org_id IN number,
86 X_po_distribution_id IN number,
87 X_group_id IN number,
88 X_caller IN varchar2,
89 X_Comments IN varchar2 default null,
90 X_PackingSlip IN varchar2 default null,
91 X_WayBillNum IN varchar2 default null
92 );
93
94 /*************************************************************
95 ** Function : Process_Transactions
96 ** Description : This is a procedure that validates
97 ** the transactions and calls create_rcv_shipment_headers
98 ** and call_txn_processor.
99 **************************************************************/
100
101 function process_transactions (X_group_id IN number,
102 X_caller IN varchar2,
103 X_Comments IN varchar2 default null,
104 X_PackingSlip IN varchar2 default null,
105 X_WayBillNum IN varchar2 default null)
106 return number;
107
108 /*************************************************************
109 ** Function : Create_Rcv_Shipment_Header
110 ** Description : This procedure creates a header
111 ** for those txns that have the same vendor
112 ** and to_org_id.
113 **************************************************************/
114
115 function create_rcv_shipment_headers (X_group_Id IN number,
116 X_caller IN varchar2,
117 X_Comments IN varchar2 default null,
118 X_PackingSlip IN varchar2 default null,
119 X_WayBillNum IN varchar2 default null)
120 return boolean;
121
122 /*************************************************************
123 ** Function : Call_Txn_Processor
124 ** Description : This function calls the transaction processor
125 ** in IMMEDIATE mode.
126 **************************************************************/
127
128 function call_txn_processor (X_group_Id IN number,
129 X_caller IN varchar2)
130 return number;
131
132 /*************************************************************
133 ** Function : check_group_id
134 ** Description : This function checks if there are records
135 ** in RTI with teh specified group id
136 **************************************************************/
137 FUNCTION check_group_id (x_group_id IN NUMBER) RETURN BOOLEAN;
138
139 /*************************************************************
140 ** Function : cancel_pending_notifs
141 ** Description : This function cancels any open notifications
142 ** if the user has received from the web
143 **************************************************************/
144 PROCEDURE cancel_pending_notifs (x_group_id IN NUMBER) ;
145
146 /*************************************************************
147 ** Function : notif_is_active
148 ** Description : This function checks if the notification is
149 ** active ( ie., not COMPLETE or ERROR )
150 **************************************************************/
151 FUNCTION notif_is_active (wf_item_type in varchar2,
152 wf_item_key in varchar2) RETURN BOOLEAN;
153
154 end;