1 PACKAGE qa_skiplot_rcv_grp AUTHID CURRENT_USER AS
2 /* $Header: qaslrcvs.pls 120.0.12000000.2 2007/07/05 11:23:35 bhsankar ship $ */
3
4 --
5 -- This package containts the external APIs
6 -- called from PO code.
7 --
8
9 --
10 -- This procedure locks rows in criteria table to
11 -- prevent multiple users from accessing the same
12 -- criteria at the same time.
13 -- This is done to prevent over skipping.
14 --
15
16 PROCEDURE CHECK_AVAILABILITY
17 (p_api_version IN NUMBER, -- 1.0
18 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
19 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
20 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
21 p_organization_id IN NUMBER,
22 x_qa_availability OUT NOCOPY VARCHAR2, -- return fnd_api.g_true/false
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_count OUT NOCOPY NUMBER,
25 x_msg_data OUT NOCOPY VARCHAR2);
26
27 --
28 -- This procedure calls skip lot evaluation
29 -- engine to evaluate inspection status for
30 -- a given lot and return "INSPECT" for
31 -- inspection required lot and "STANDARD"
32 -- for skipped lot.
33 --
34
35 PROCEDURE EVALUATE_LOT
36 (p_api_version IN NUMBER, -- 1.0
37 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
40 p_interface_txn_id IN NUMBER,
41 p_organization_id IN NUMBER,
42 p_vendor_id IN NUMBER,
43 p_vendor_site_id IN NUMBER,
44 p_item_id IN NUMBER,
45 p_item_revision IN VARCHAR2,
46 p_item_category_id IN NUMBER,
47 p_project_id IN NUMBER,
48 p_task_id IN NUMBER,
49 p_manufacturer_id IN NUMBER,
50 p_source_inspected IN NUMBER,
51 p_receipt_qty IN NUMBER,
52 p_receipt_date IN DATE,
53 p_primary_uom IN varchar2 DEFAULT null,
54 p_transaction_uom IN varchar2 DEFAULT null,
55 p_po_header_id IN NUMBER DEFAULT null,
56 p_po_line_id IN NUMBER DEFAULT null,
57 p_po_line_location_id IN NUMBER DEFAULT null,
58 p_po_distribution_id IN NUMBER DEFAULT null,
59 p_lpn_id IN NUMBER DEFAULT null,
60 p_wms_flag IN VARCHAR2 DEFAULT 'N',
61 x_evaluation_result OUT NOCOPY VARCHAR2, -- returns INSPECTor STANDARD
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2);
65
66 --
67 -- This procedure is used to update qa_skiplot_rcv_results
68 -- table with shipment line id and set valid flag to 2, i.e. valid
69 -- The procedure is called from po rcv processor file rvtsh.lpc
70 --
71 PROCEDURE MATCH_SHIPMENT
72 (p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
74 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
75 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
76 p_interface_txn_id IN NUMBER,
77 p_shipment_header_id IN NUMBER,
78 p_shipment_line_id IN NUMBER,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2);
82
83
84 --
85 -- ilawler Thu Jan 22 11:09:42 2004
86 -- This procedure is used by PO's RCV integration to check a
87 -- collection_id against qa_results and return a boolean representing
88 -- whether results were actually collected with this collection_id.
89 -- This API is being introduced for the ERES project so that an eRecord
90 -- is only captured when quality results are present.
91 -- returns x_result_present = {fnd_api.g_true | fnd_api.g_false}
92 --
93 PROCEDURE IS_QA_RESULT_PRESENT
94 (p_api_version IN NUMBER, -- 1.0
95 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
96 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
97 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
98 p_collection_id IN NUMBER,
99 x_result_present OUT NOCOPY VARCHAR2,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2);
103
104 --
105 -- bug 6064562
106 -- This procedure is used by PO's RCV integration to
107 -- check if a receiving transaction lot was skipped.
108 -- This API is being introduced since, AP Invoicing
109 -- creates an hold for skipped records for PO's created
110 -- with 4 Way Match with Receipt. This happens because
111 -- AP calls Receiving API to get the quantity details
112 -- from rcv_transactions but rcv_transactions does
113 -- not maintain details of Skipped lots.
114 -- returns x_skip_status = {fnd_api.g_true | fnd_api.g_false}
115 -- bhsankar Thu Jul 5 04:09:04 PDT 2007
116 --
117 PROCEDURE IS_LOT_SKIPPED
118 (p_api_version IN NUMBER, -- 1.0
119 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
120 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
121 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
122 p_transaction_id IN NUMBER,
123 x_skip_status OUT NOCOPY VARCHAR2,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2);
127
128 END QA_SKIPLOT_RCV_GRP;