PACKAGE: APPS.PO_CHORD_WF3

Source

1 PACKAGE PO_CHORD_WF3 as
2 /* $Header: POXWCO3S.pls 120.2 2006/03/17 10:33:15 dreddy noship $ */
3 
4 	TYPE t_shipments_control_type IS RECORD (
5 	shipment_num			VARCHAR2(1),
6 	ship_to_organization_id		VARCHAR2(1),
7 	ship_to_location_id		VARCHAR2(1),
8 	promised_date			VARCHAR2(1),
9 	need_by_date			VARCHAR2(1),
10 	last_accept_date		VARCHAR2(1),
11 	taxable_flag			VARCHAR2(1),
12 	price_discount			VARCHAR2(1),
13 	cancel_flag			VARCHAR2(1),
14 	closed_code			VARCHAR2(1),
15         start_date                      VARCHAR2(1),   /* <TIMEPHASED FPI> */
16         end_date                        VARCHAR2(1),   /* <TIMEPHASED FPI> */
17         price_override                  VARCHAR2(1),   /* Bug 2808011 */
18         payment_type                    VARCHAR2(1),   -- <Complex Work R12>
19         work_approver_id                VARCHAR2(1),   -- <Complex Work R12>
20         description                     VARCHAR2(1),   -- <Complex Work R12>
21         days_late_rcpt_allowed          VARCHAR2(1),   -- ECO 5080252
22 	quantity_change			NUMBER,
23 	price_override_change		NUMBER,
24         --<R12 Requester Driven Procurement Start>
25 	amount_change			NUMBER,
26 	start_date_change		NUMBER,
27 	end_date_change			NUMBER,
28 	need_by_date_change		NUMBER,
29 	promised_date_change		NUMBER
30 	--<R12 Requester Driven Procurement End>
31         );
32 
33 	TYPE t_shipments_parameters_type IS RECORD(
34 	po_header_id			NUMBER,
35 	po_release_id			NUMBER
36 	);
37 
38 	PROCEDURE chord_shipments(
39 			itemtype IN VARCHAR2,
40 			itemkey  IN VARCHAR2,
41 			actid    IN NUMBER,
42 			FUNCMODE IN VARCHAR2,
43 			RESULT   OUT NOCOPY VARCHAR2);
44 
45         PROCEDURE check_shipments_change(
46 			itemtype IN VARCHAR2,
47 			itemkey IN VARCHAR2,
48 			x_shipments_parameters IN t_shipments_parameters_type,
49 			x_shipments_control OUT NOCOPY t_shipments_control_type);
50 
51 	PROCEDURE set_wf_shipments_control(
52 			itemtype	IN VARCHAR2,
53 			itemkey 	IN VARCHAR2,
54 			x_shipments_control IN t_shipments_control_type);
55 
56 
57 	PROCEDURE get_wf_shipments_control(
58 			itemtype	IN VARCHAR2,
59 			itemkey 	IN VARCHAR2,
60 			x_shipments_control IN OUT NOCOPY t_shipments_control_type);
61 
62 	PROCEDURE get_wf_shipments_parameters(
63 			itemtype	 IN VARCHAR2,
64 			itemkey 	 IN VARCHAR2,
65 			x_shipments_parameters IN OUT NOCOPY t_shipments_parameters_type);
66 
67 	PROCEDURE debug_shipments_control(
68 			itemtype IN VARCHAR2,
69 			itemkey IN VARCHAR2,
70 			x_shipments_control IN t_shipments_control_type);
71 
72 
73 END PO_CHORD_WF3;