1 PACKAGE PO_HEADERS_SV9 AUTHID CURRENT_USER AS
2 /* $Header: POXPIRDS.pls 115.7 2004/03/24 10:25:31 amritunj ship $ */
3
4 /*==================================================================
5 PROCEDURE NAME: replace_po_original_catalog()
6
7 DESCRIPTION: This API is used validate the original catelog
8
9
10 PARAMETERS:
11
12
13 DESIGN
14 REFERENCES: 832proc.doc
15
16 ALGORITHM:
17
18 NOTES:
19
20 OPEN ISSUES:
21
22 CLOSE ISSUES:
23
24 CHANGE
25 HISTORY: Created 03-Mar-1996 Rajan Odayar
26 Modified 16-MAR-1996 Daisy Yu
27 Modified 19-MAR-2003 Akhilesh Mritunjai
28
29 =======================================================================*/
30 PROCEDURE replace_po_original_catalog(X_interface_header_id IN NUMBER,
31 X_interface_line_id IN NUMBER,
32 X_vendor_id IN NUMBER,
33 X_document_type_code IN VARCHAR2,
34 X_vendor_doc_num IN VARCHAR2,
35 X_start_date IN DATE,
36 X_end_date IN DATE,
37 X_header_processable_flag IN OUT NOCOPY VARCHAR2,
38 p_ga_flag IN VARCHAR2); --<Bug 3504001>
39
40
41 /*==================================================================
42 PROCEDURE NAME: check_po_original_catalog()
43
44 DESCRIPTION: This API is used to just validate the original catelog
45 It does not replace the original catalog/blanket - used
46 for the "UPDATE" action code.
47
48 PARAMETERS:
49
50
51 DESIGN
52 REFERENCES:
53
54 ALGORITHM:
55
56 NOTES:
57
58 OPEN ISSUES:
59
60 CLOSE ISSUES:
61
62 CHANGE
63 HISTORY: Created 26-Jun-1998 Imran Ali
64
65 =======================================================================*/
66 PROCEDURE check_po_original_catalog (X_interface_header_id IN NUMBER,
67 X_interface_line_id IN NUMBER,
68 X_vendor_id IN NUMBER,
69 X_document_type_code IN VARCHAR2,
70 X_vendor_doc_num IN VARCHAR2,
71 X_start_date IN DATE,
72 X_end_date IN DATE,
73 X_document_num IN VARCHAR2,
74 X_po_header_id IN OUT NOCOPY VARCHAR2,
75 X_header_processable_flag IN OUT NOCOPY VARCHAR2);
76
77
78
79 PROCEDURE check_if_catalog_exists (X_interface_header_id IN NUMBER,
80 X_interface_line_id IN NUMBER,
81 X_vendor_id IN NUMBER,
82 X_document_type_code IN VARCHAR2,
83 X_vendor_doc_num IN VARCHAR2,
84 X_start_date IN DATE,
85 X_end_date IN DATE,
86 X_po_header_id IN OUT NOCOPY VARCHAR2,
87 X_header_processable_flag IN OUT NOCOPY VARCHAR2);
88
89 END PO_HEADERS_SV9;