PACKAGE: APPS.CSP_NOTIFICATIONS_ORDER_PKG

Source

1 package csp_notifications_order_pkg authid current_user as
2 /* $Header: cspgnops.pls 120.0.12020000.4 2013/03/21 03:57:56 sunarasi noship $ */
3 -- Start of Comments
4 -- Package name     :csp_notifications_order_pkg
5 -- Purpose          :
6 -- History          :
7 --  01-Mar-13, sunarasi
8 --
9 -- NOTE             :
10 -- End of Comments
11 type notif_order_cur is ref cursor;
12   FUNCTION Create_Order(p_item_id	NUMBER,
13 			 p_Dest_orgn_id	NUMBER,
14 			 p_src_orgn_id	NUMBER,
15 			 p_src_subinv	VARCHAR2,
16 			 p_src_type	VARCHAR2,
17 			 p_repair_supplier_id NUMBER,
18 			 p_qty		NUMBER,
19 			 p_need_date	date,
20        p_notification_id NUMBER)  RETURN notif_order_cur;
21 END;