PACKAGE: APPS.CSFW_REQ_PUB

Source

1 PACKAGE csfw_req_pub AS
2 /*$Header: csfwreqs.pls 120.1 2006/01/27 05:38:36 htank noship $*/
3 PROCEDURE CREATE_REQUIREMENT_HEADER
4 (
5   p_task_id IN NUMBER
6 , p_location_id IN NUMBER
7 , p_ATTRIBUTE1 IN VARCHAR2
8 , p_ATTRIBUTE2 IN VARCHAR2
9 , p_ATTRIBUTE3 IN VARCHAR2
10 , p_ATTRIBUTE4 IN VARCHAR2
11 , p_ATTRIBUTE5 IN VARCHAR2
12 , p_ATTRIBUTE6 IN VARCHAR2
13 , p_ATTRIBUTE7 IN VARCHAR2
14 , p_ATTRIBUTE8 IN VARCHAR2
15 , p_ATTRIBUTE9 IN VARCHAR2
16 , p_ATTRIBUTE10 IN VARCHAR2
17 , p_ATTRIBUTE11 IN VARCHAR2
18 , p_ATTRIBUTE12 IN VARCHAR2
19 , p_ATTRIBUTE13 IN VARCHAR2
20 , p_ATTRIBUTE14 IN VARCHAR2
21 , p_ATTRIBUTE15 IN VARCHAR2
22 , p_ATTRIBUTE_CATEGORY IN VARCHAR2
23 , x_header_id OUT NOCOPY NUMBER
24 , x_error_id  OUT NOCOPY NUMBER
25 , x_error     OUT NOCOPY VARCHAR2
26 ) ;
27 
28 PROCEDURE DELETE_REQUIREMENT_HEADER
29 (
30   p_header_id IN NUMBER
31 , x_error_id  OUT NOCOPY NUMBER
32 , x_error     OUT NOCOPY VARCHAR2
33 ) ;
34 
35 
36 PROCEDURE CREATE_REQUIREMENT_LINE
37 (
38   p_header_id   IN NUMBER
39 , p_inv_item_id IN NUMBER
40 , p_UOM         IN VARCHAR2
41 , p_quantity    IN NUMBER
42 , p_revision    IN VARCHAR2
43 , p_ATTRIBUTE1 IN VARCHAR2
44 , p_ATTRIBUTE2 IN VARCHAR2
45 , p_ATTRIBUTE3 IN VARCHAR2
46 , p_ATTRIBUTE4 IN VARCHAR2
47 , p_ATTRIBUTE5 IN VARCHAR2
48 , p_ATTRIBUTE6 IN VARCHAR2
49 , p_ATTRIBUTE7 IN VARCHAR2
50 , p_ATTRIBUTE8 IN VARCHAR2
51 , p_ATTRIBUTE9 IN VARCHAR2
52 , p_ATTRIBUTE10 IN VARCHAR2
53 , p_ATTRIBUTE11 IN VARCHAR2
54 , p_ATTRIBUTE12 IN VARCHAR2
55 , p_ATTRIBUTE13 IN VARCHAR2
56 , p_ATTRIBUTE14 IN VARCHAR2
57 , p_ATTRIBUTE15 IN VARCHAR2
58 , p_ATTRIBUTE_CATEGORY IN VARCHAR2
59 , x_error_id  OUT NOCOPY NUMBER
60 , x_error     OUT NOCOPY VARCHAR2
61 , x_line_id   OUT NOCOPY NUMBER
62 ) ;
63 
64 PROCEDURE DELETE_REQUIREMENT_LINE
65 (
66   p_LINE_ID   IN NUMBER
67 , x_error_id  OUT NOCOPY NUMBER
68 , x_error     OUT NOCOPY VARCHAR2
69 ) ;
70 
71 
72 
73 
74 END csfw_req_pub;
75