eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PO_REQ_TEMPLATE_SV

Source


1 PACKAGE PO_REQ_TEMPLATE_SV AS
2 /* $Header: POXRQT1S.pls 120.0 2005/06/02 01:43:50 appldev noship $*/
3 
4 PROCEDURE insert_line (x_rowid				IN OUT NOCOPY VARCHAR2,
5 		        x_express_name			IN 	VARCHAR2,
6 			x_sequence_num			IN	NUMBER,
7 			x_creation_date			IN	DATE,
8 			x_last_update_date		IN 	DATE,
9 			x_po_header_id			IN	NUMBER,
10 			x_po_line_id			IN	NUMBER,
11 			x_created_by			IN	NUMBER,
12 			x_last_update_login		IN	NUMBER,
13 			x_item_id			IN	NUMBER,
14 			x_line_type_id			IN	NUMBER,
15 			x_item_revision			IN	VARCHAR2,
16 			x_category_id			IN	NUMBER,
17 			x_unit_meas_lookup_code 	IN	VARCHAR2,
18 			x_suggested_quantity		IN	NUMBER, --KitSupport FPJ
19 			x_unit_price			IN	NUMBER,
20 			x_suggested_vendor_id 		IN	NUMBER,
21 			x_suggested_vendor_site_id	IN	NUMBER,
22 			x_suggested_vendor_contact_id	IN	NUMBER,
23 			x_suggested_vendor_prod_code 	IN	VARCHAR2,
24 			x_suggested_buyer_id		IN	NUMBER,
25 			x_rfq_required_flag		IN	VARCHAR2,
26 			x_vendor_source_context		IN	VARCHAR2,
27 			x_source_type_code		IN	VARCHAR2,
28 			x_source_organization_id	IN	NUMBER,
29 			x_source_subinventory		IN	VARCHAR2,
30 			x_item_description		IN	VARCHAR2,
31 			x_attribute_category		IN	VARCHAR2,
32 			x_attribute1			IN      VARCHAR2,
33 			x_attribute2			IN      VARCHAR2,
34 			x_attribute3			IN      VARCHAR2,
35 			x_attribute4			IN      VARCHAR2,
36 			x_attribute5			IN      VARCHAR2,
37 			x_attribute6			IN      VARCHAR2,
38 			x_attribute7			IN      VARCHAR2,
39 			x_attribute8			IN      VARCHAR2,
40 			x_attribute9			IN      VARCHAR2,
41 			x_attribute10			IN      VARCHAR2,
42 			x_attribute11			IN      VARCHAR2,
43 			x_attribute12			IN      VARCHAR2,
44 			x_attribute13			IN      VARCHAR2,
45 			x_attribute14			IN      VARCHAR2,
46 			x_attribute15			IN      VARCHAR2,
47                         x_amount                        IN      NUMBER,  -- <SERVICES FPJ>
48 			x_negotiated_by_preparer_flag   IN      VARCHAR2, --<DBI FPJ>
49                         p_org_id                        IN      NUMBER DEFAULT NULL   -- <R12 MOAC>
50 			);
51 
52 PROCEDURE update_line (x_rowid		VARCHAR2,
53 		        x_express_name		VARCHAR2,
54 			x_sequence_num		NUMBER,
55 			x_last_updated_by	NUMBER,
56 			x_last_update_date	DATE,
57 			x_po_header_id		NUMBER,
58 			x_po_line_id		NUMBER,
59 			x_last_update_login	NUMBER,
60 			x_item_id		NUMBER,
61 			x_line_type_id		NUMBER,
62 			x_item_revision		VARCHAR2,
63 			x_category_id		NUMBER,
64 			x_unit_meas_lookup_code VARCHAR2,
65 			x_suggested_quantity	NUMBER, --KitSupport FPJ
66 			x_unit_price		NUMBER,
67 			x_suggested_vendor_id 	NUMBER,
68 			x_suggested_vendor_site_id	NUMBER,
69 			x_suggested_vendor_contact_id	NUMBER,
70 			x_suggested_vendor_prod_code 	VARCHAR2,
71 			x_suggested_buyer_id		NUMBER,
72 			x_rfq_required_flag		VARCHAR2,
73 			x_vendor_source_context		VARCHAR2,
74 			x_source_type_code		VARCHAR2,
75 			x_source_organization_id	NUMBER,
76 			x_source_subinventory		VARCHAR2,
77 			x_item_description		VARCHAR2,
78 			x_attribute_category		VARCHAR2,
79 			x_attribute1			VARCHAR2,
80 			x_attribute2			VARCHAR2,
81 			x_attribute3			VARCHAR2,
82 			x_attribute4			VARCHAR2,
83 			x_attribute5			VARCHAR2,
84 			x_attribute6			VARCHAR2,
85 			x_attribute7			VARCHAR2,
86 			x_attribute8			VARCHAR2,
87 			x_attribute9			VARCHAR2,
88 			x_attribute10			VARCHAR2,
89 			x_attribute11			VARCHAR2,
90 			x_attribute12			VARCHAR2,
91 			x_attribute13			VARCHAR2,
92 			x_attribute14			VARCHAR2,
93 			x_attribute15			VARCHAR2,
94                         x_amount                        NUMBER,  -- <SERVICES FPJ>
95 			x_negotiated_by_preparer_flag   VARCHAR2); --<DBI FPJ>
96 
97 PROCEDURE lock_line (x_rowid		VARCHAR2,
98 		        x_express_name		VARCHAR2,
99 			x_sequence_num		NUMBER,
100 			x_po_header_id		NUMBER,
101 			x_po_line_id		NUMBER,
102 			x_item_id		NUMBER,
103 			x_line_type_id		NUMBER,
104 			x_item_revision		VARCHAR2,
105 			x_category_id		NUMBER,
106 			x_unit_meas_lookup_code VARCHAR2,
107 			x_suggested_quantity	NUMBER, --KitSupport FPJ
108 			x_unit_price		NUMBER,
109 			x_suggested_vendor_id 	NUMBER,
110 			x_suggested_vendor_site_id	NUMBER,
111 			x_suggested_vendor_contact_id	NUMBER,
112 			x_suggested_vendor_prod_code 	VARCHAR2,
113 			x_suggested_buyer_id		NUMBER,
114 			x_rfq_required_flag		VARCHAR2,
115 			x_vendor_source_context		VARCHAR2,
116 			x_source_type_code		VARCHAR2,
117 			x_source_organization_id	NUMBER,
118 			x_source_subinventory		VARCHAR2,
119 			x_item_description		VARCHAR2,
120 			x_attribute_category		VARCHAR2,
121 			x_attribute1			VARCHAR2,
122 			x_attribute2			VARCHAR2,
123 			x_attribute3			VARCHAR2,
124 			x_attribute4			VARCHAR2,
125 			x_attribute5			VARCHAR2,
126 			x_attribute6			VARCHAR2,
127 			x_attribute7			VARCHAR2,
128 			x_attribute8			VARCHAR2,
129 			x_attribute9			VARCHAR2,
130 			x_attribute10			VARCHAR2,
131 			x_attribute11			VARCHAR2,
132 			x_attribute12			VARCHAR2,
133 			x_attribute13			VARCHAR2,
134 			x_attribute14			VARCHAR2,
135 			x_attribute15			VARCHAR2,
136                         x_amount                        NUMBER);  -- <SERVICES FPJ>
137 
138 
139 PROCEDURE delete_line (x_rowid VARCHAR2);
140 
141 
142 END PO_REQ_TEMPLATE_SV;