PACKAGE: APPS.OKC_REVIEW_UPLD_HEADER_PVT

Source

1 PACKAGE OKC_REVIEW_UPLD_HEADER_PVT AS
2 /* $Header: OKCVRUHS.pls 120.0 2005/09/13 22:42 vnanjang noship $ */
3   ---------------------------------------------------------------------------
4   -- Procedures and Functions
5   ---------------------------------------------------------------------------
6 
7  ---------------------------------------------------------------------------
8   -- Procedures and Functions
9   ---------------------------------------------------------------------------
10 
11   PROCEDURE insert_row(
12     p_validation_level	           IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
13     x_return_status                OUT NOCOPY VARCHAR2,
14 
15     p_review_upld_header_id IN NUMBER,
16     p_file_name              IN VARCHAR2,
17     p_file_content_type      IN VARCHAR2,
18     p_file_data              IN BLOB,
19     p_document_type          IN VARCHAR2,
20     p_document_id            IN NUMBER,
21     p_new_contract_source    IN VARCHAR2,
22     p_enable_reporting_flag  IN VARCHAR2,
23     p_file_description       IN VARCHAR2,
24 
25 
26 
27     x_review_upld_header_id OUT NOCOPY NUMBER
28   );
29 
30   PROCEDURE lock_row(
31     x_return_status                OUT NOCOPY VARCHAR2,
32 
33     p_review_upld_header_id IN NUMBER,
34 
35     p_object_version_number  IN NUMBER
36   );
37 
38   PROCEDURE Update_Row(
39     p_validation_level	           IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40 
41     x_return_status                OUT NOCOPY VARCHAR2,
42 
43     p_review_upld_header_id IN NUMBER,
44 
45     p_file_name              IN VARCHAR2 := NULL,
46     p_file_content_type      IN VARCHAR2 := NULL,
47     p_file_data              IN BLOB := NULL,
48     p_document_type          IN VARCHAR2 := NULL,
49     p_document_id            IN NUMBER := NULL,
50 
51     p_object_version_number  IN NUMBER,
52     p_new_contract_source    IN VARCHAR2 := NULL,
53     p_enable_reporting_flag  IN VARCHAR2 := NULL,
54     p_file_description       IN VARCHAR2 := NULL
55   );
56 
57 
58 
59 
60   PROCEDURE delete_row(
61     x_return_status                OUT NOCOPY VARCHAR2,
62 
63     p_review_upld_header_id IN NUMBER,
64 
65     p_object_version_number  IN NUMBER
66   );
67 
68   PROCEDURE validate_row(
69     p_validation_level	           IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70     x_return_status                OUT NOCOPY VARCHAR2,
71 
72     p_review_upld_header_id IN NUMBER,
73     p_file_name              IN VARCHAR2,
74     p_file_content_type      IN VARCHAR2,
75     p_file_data              IN BLOB,
76     p_document_type          IN VARCHAR2,
77     p_document_id            IN NUMBER,
78     p_new_contract_source    IN VARCHAR2,
79     p_enable_reporting_flag  IN VARCHAR2,
80     p_file_description       IN VARCHAR2,
81 
82 
83     p_object_version_number  IN NUMBER
84   );
85 
86   FUNCTION get_rec (
87     p_review_upld_header_id IN NUMBER,
88 
89     x_file_name              OUT NOCOPY VARCHAR2,
90     x_file_content_type      OUT NOCOPY VARCHAR2,
91     x_file_data              OUT NOCOPY BLOB,
92     x_document_type          OUT NOCOPY VARCHAR2,
93     x_document_id            OUT NOCOPY NUMBER,
94     x_object_version_number  OUT NOCOPY NUMBER,
95     x_created_by             OUT NOCOPY NUMBER,
96     x_creation_date          OUT NOCOPY DATE,
97     x_last_updated_by        OUT NOCOPY NUMBER,
98     x_last_update_login      OUT NOCOPY NUMBER,
99     x_last_update_date       OUT NOCOPY DATE,
100     x_new_contract_source    OUT NOCOPY VARCHAR2,
101     x_enable_reporting_flag  OUT NOCOPY VARCHAR2,
102     x_file_description       OUT NOCOPY VARCHAR2
103 
104   ) RETURN VARCHAR2;
105 
106 
107 
108 
109 END OKC_REVIEW_UPLD_HEADER_PVT;
110