1 PACKAGE PO_LINES_SV1 AS
2 /* $Header: POXPILSS.pls 120.0.12000000.1 2007/07/27 08:27:41 grohit noship $ */
3
4 /*==================================================================
5 FUNCTION NAME: val_line_num_uniqueness()
6
7 DESCRIPTION: This API is used to validate the uniqueness of
8 the line number in po_lines table.
9
10 PARAMETERS: x_line_num IN NUMBER,
11 x_rowid IN VARCHAR2,
12 x_po_header_id IN NUMBER
13
14 DESIGN
15 REFERENCES: 832vlapl.doc
16
17 ALGORITHM: API returns TRUE if validation succeeds, FALSE
18 otherwise.
19
20 NOTES:
21
22 OPEN ISSUES:
23
24 CLOSE ISSUES:
25
26 CHANGE
27 HISTORY: Created 19-FEB-1996 DXYU
28
29
30 =======================================================================*/
31 FUNCTION val_line_num_uniqueness(x_line_num IN NUMBER,
32 x_rowid IN VARCHAR2,
33 x_po_header_id IN NUMBER)
34 RETURN BOOLEAN;
35
36 /*======================================================================
37 FUNCTION NAME: val_line_id_uniqueness()
38
39 DESCRIPTION: This API is used to validate the uniqueness of
40 the line id in po_lines table.
41
42 PARAMETERS: x_po_line_id IN NUMBER,
43 x_rowid IN VARCHAR2,
44 x_po_header_id IN NUMBER
45
46 DESIGN REFERENCES: 832vlapl.doc
47
48 ALGORITHM: API returns TRUE if validation succeeds, FALSE
49 otherwise.
50
51 NOTES:
52
53 OPEN ISSUES:
54
55 CLOSE ISSUES:
56
57 CHANGE HISTORY: Created 16-FEB-1996 DXYU
58
59 =======================================================================*/
60 FUNCTION val_line_id_uniqueness(x_po_line_id IN NUMBER,
61 x_rowid IN VARCHAR2,
62 x_po_header_id IN NUMBER)
63 RETURN BOOLEAN;
64
65
66 /*==================================================================
67 FUNCTION NAME: derive_po_line_id()
68
69 DESCRIPTION: This API is used to derive po_line_id given
70 po_header_id and line_numas input parameter.
71
72 PARAMETERS: x_po_header_id IN NUMBER,
73 x_line_num IN NUMBER
74
75 DESIGN
76 REFERENCES: 832dvapi.doc
77
78 ALGORITHM: API returns po_line_id (NUMBER) if found,
79 NULL otherwise.
80
81 NOTES:
82
83 OPEN ISSUES:
84
85 CLOSE ISSUES:
86
87 CHANGE
88 HISTORY: Created 19-FEB-1996 SODAYAR
89
90
91 =======================================================================*/
92 FUNCTION derive_po_line_id(X_po_header_id IN NUMBER,
93 X_line_num IN NUMBER) return NUMBER;
94
95 END PO_LINES_SV1;
[Home] [Help]