1 package PO_CONTERMS_WF_PVT AUTHID CURRENT_USER AS
2 /* $Header: POXVWCTS.pls 115.7 2004/02/03 00:45:29 sahegde noship $ */
3
4 -- Contracts business events codes TBL Type
5 SUBTYPE Event_tbl_type IS OKC_MANAGE_DELIVERABLES_GRP.BUSDOCDATES_TBL_TYPE;
6
7 -- Checks if contract terms were changed in current revision
8 FUNCTION CONTRACT_TERMS_CHANGED(itemtype IN VARCHAR2,
9 Itemkey IN VARCHAR2)
10 return VARCHAR2;
11
12 --returns event codes and their due dates for deliverables
13 PROCEDURE Get_DELIVERABLE_EVENTS (p_po_header_id IN NUMBER,
14 p_action_code IN VARCHAR2 DEFAULT 'A',
15 p_doc_subtype IN VARCHAR2,
16 x_event_tbl OUT NOCOPY EVENT_TBL_TYPE);
17 --Get last update date for conterms date fields
18 PROCEDURE UPDATE_CONTERMS_DATES(
19 p_po_header_id IN NUMBER,
20 p_po_doc_type IN VARCHAR2,
21 p_po_doc_subtype IN VARCHAR2,
22 p_conterms_exist_flag IN VARCHAR2,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_data OUT NOCOPY VARCHAR2,
25 x_msg_count OUT NOCOPY NUMBER);
26
27 -- informs contracts about approval
28 PROCEDURE UPDATE_CONTRACT_TERMS(p_po_header_id IN NUMBER,
29 p_signed_date IN DATE,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER);
33
34 --Checks if any deviation from standard Contract template
35 PROCEDURE IS_STANDARD_CONTRACT (itemtype IN VARCHAR2,
36 itemkey IN VARCHAR2,
37 actid IN NUMBER,
38 funcmode IN VARCHAR2,
39 result OUT NOCOPY VARCHAR2);
40 --Checks if template expired
41 PROCEDURE IS_CONTRACT_TEMPLATE_EXPIRED(itemtype IN VARCHAR2,
42 itemkey IN VARCHAR2,
43 actid IN NUMBER,
44 funcmode IN VARCHAR2,
45 result OUT NOCOPY VARCHAR2);
46 --checks if articles attached to po
47 PROCEDURE IS_CONTRACT_ARTICLES_EXIST (itemtype IN VARCHAR2,
48 itemkey IN VARCHAR2,
49 actid IN NUMBER,
50 funcmode IN VARCHAR2,
51 result OUT NOCOPY VARCHAR2);
52
53 --Checks if articles amended in this revision
54 PROCEDURE IS_CONTRACT_ARTICLES_AMENDED(itemtype IN VARCHAR2,
55 itemkey IN VARCHAR2,
56 actid IN NUMBER,
57 funcmode IN VARCHAR2,
58 result OUT NOCOPY VARCHAR2);
59
60 --Checks if deliverables attached to purchase order
61 PROCEDURE IS_CONTRACT_DELIVRABLS_EXIST(itemtype IN VARCHAR2,
62 itemkey IN VARCHAR2,
63 actid IN NUMBER,
64 funcmode IN VARCHAR2,
65 result OUT NOCOPY VARCHAR2);
66
67 --Checks if deliverables amended in this revision
68 PROCEDURE IS_CONTRACT_DELIVRABLS_AMENDED(itemtype IN VARCHAR2,
69 itemkey IN VARCHAR2,
70 actid IN NUMBER,
71 funcmode IN VARCHAR2,
72 result OUT NOCOPY VARCHAR2);
73
74 --Cancels deliverables associated with the PO
75 PROCEDURE cancel_deliverables (p_bus_doc_id IN NUMBER
76 ,p_bus_doc_type IN VARCHAR2
77 ,p_bus_doc_subtype IN VARCHAR2
78 ,p_bus_doc_version IN NUMBER
79 ,p_event_code IN VARCHAR2
80 ,p_event_date IN DATE
81 ,p_busdocdates_tbl IN EVENT_TBL_TYPE
82 ,x_return_status OUT NOCOPY VARCHAR2 );
83
84
85 End PO_CONTERMS_WF_PVT;