[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;