DBA Data[Home] [Help]

PACKAGE: APPS.PO_CHORD_WF5

Source


1 PACKAGE PO_CHORD_WF5 AUTHID CURRENT_USER as
2 /* $Header: POXWCO5S.pls 115.2 2002/11/26 19:47:08 sbull ship $ */
3 
4 
5  	TYPE t_release_control_type IS RECORD (
6 	agent_id			VARCHAR2(1),
7 	acceptance_required_flag	VARCHAR2(1),
8 	acceptance_due_date		VARCHAR2(1),
9 	release_num			VARCHAR2(1),
10 	release_date			VARCHAR2(1),
11 	release_total_change		NUMBER       -- %change
12 	);
13 
14 	TYPE t_release_parameters_type IS RECORD (
15 	po_release_id			NUMBER,
16 	po_header_id			NUMBER,
17 	release_type			VARCHAR2(25)
18 	);
19 
20 	PROCEDURE chord_release(itemtype IN VARCHAR2,
21 			   itemkey  IN VARCHAR2,
22 			   actid    IN NUMBER,
23 			   FUNCMODE IN VARCHAR2,
24 			   RESULT   OUT NOCOPY VARCHAR2);
25 
26         PROCEDURE check_release_change(
27 		itemtype IN VARCHAR2,
28 		itemkey  IN VARCHAR2,
29 		x_release_parameters IN t_release_parameters_type,
30 		x_release_control 	IN OUT NOCOPY t_release_control_type);
31 
32 
33 	FUNCTION  release_total_change(
34 		   x_po_release_id 	IN 	NUMBER)
35 		   RETURN NUMBER;
36 
37 	PROCEDURE set_wf_release_control(itemtype	IN VARCHAR2,
38 					itemkey		IN VARCHAR2,
39 					x_release_control IN t_release_control_type);
40 
41 	PROCEDURE get_wf_release_control(itemtype	 IN VARCHAR2,
42 					itemkey 	 IN VARCHAR2,
43 					x_release_control IN OUT NOCOPY t_release_control_type);
44 
45 	PROCEDURE get_wf_release_parameters(itemtype	 IN VARCHAR2,
46 					itemkey 	 IN VARCHAR2,
47 					x_release_parameters IN OUT NOCOPY t_release_parameters_type);
48 
49 	PROCEDURE debug_release_control(
50 		itemtype IN VARCHAR2,
51 		itemkey  IN VARCHAR2,
52 		x_release_control IN t_release_control_type);
53 
54 END PO_CHORD_WF5;