PACKAGE: APPS.PO_CHORD_WF2

Source

1 PACKAGE PO_CHORD_WF2 as
2 /* $Header: POXWCO2S.pls 120.3 2006/03/30 15:43:17 dreddy noship $ */
3 
4 	TYPE t_lines_control_type IS RECORD (
5 	/* valid values : Y (modified) or N (not modified) */
6 	line_num			VARCHAR2(1),
7 	item_id				VARCHAR2(1),
8 	item_revision			VARCHAR2(1),
9 	category_id			VARCHAR2(1),
10 	item_description		VARCHAR2(1),
11  	unit_meas_lookup_code		VARCHAR2(1),
12 	un_number_id			VARCHAR2(1),
13 	hazard_class_id			VARCHAR2(1),
14 	note_to_vendor			VARCHAR2(1),
15 	from_header_id			VARCHAR2(1),
16 	from_line_id			VARCHAR2(1),
17 	closed_code			VARCHAR2(1), --not in used
18 	vendor_product_num		VARCHAR2(1),
19 	contract_num			VARCHAR2(1),
20 	price_type_lookup_code		VARCHAR2(1),
21 	cancel_flag			VARCHAR2(1), --not in used
22         retainage_rate                  VARCHAR2(1),     -- <Complex Work R12>
23         max_retainage_amount            VARCHAR2(1),     -- <Complex Work R12>
24         progress_payment_rate           VARCHAR2(1),     -- <Complex Work R12>
25         recoupment_rate                 VARCHAR2(1),     -- <Complex Work R12>
26         advance_amount                  VARCHAR2(1),     -- <Complex Work R12>
27 	end_date	         	VARCHAR2(1), --<R12 Requester Driven Procurement>
28 	/* valid values: percentage */
29 	quantity_change			NUMBER,
30 	unit_price_change		NUMBER,
31 	quantity_committed_change	NUMBER,
32 	committed_amount_change		NUMBER,
33 	not_to_exceed_price_change	NUMBER,
34 	amount_change			NUMBER,--<R12 Requester Driven Procurement>
35 	start_date_change		NUMBER,--<R12 Requester Driven Procurement>
36 	end_date_change			NUMBER --<R12 Requester Driven Procurement>
37 	);
38 
39 	TYPE t_lines_parameters_type IS RECORD(
40 	po_header_id			NUMBER
41 	);
42 
43 	PROCEDURE chord_lines(itemtype IN VARCHAR2,
44 			      itemkey  IN VARCHAR2,
45 			      actid    IN NUMBER,
46 			      FUNCMODE IN VARCHAR2,
47 			      RESULT   OUT NOCOPY VARCHAR2);
48 
49 
50         PROCEDURE check_lines_change(
51 		  itemtype	IN VARCHAR2,
52 		  itemkey	IN VARCHAR2,
53 		  x_lines_parameters IN t_lines_parameters_type,
54 		  x_lines_control In OUT NOCOPY t_lines_control_type);
55 
56 	PROCEDURE set_wf_lines_control( itemtype	IN VARCHAR2,
57 				        itemkey 	IN VARCHAR2,
58 					x_lines_control IN t_lines_control_type);
59 
60 
61 	PROCEDURE get_wf_lines_control( itemtype	IN VARCHAR2,
62 				        itemkey 	IN VARCHAR2,
63 					x_lines_control IN OUT NOCOPY t_lines_control_type);
64 
65 	PROCEDURE get_wf_lines_parameters(itemtype	 IN VARCHAR2,
66 					  itemkey 	 IN VARCHAR2,
67 					  x_lines_parameters IN OUT NOCOPY t_lines_parameters_type);
68 
69 	PROCEDURE debug_lines_control(
70 			  itemtype	IN VARCHAR2,
71 			  itemkey	IN VARCHAR2,
72 			  x_lines_control IN t_lines_control_type);
73 
74 
75 END PO_CHORD_WF2;