1 PACKAGE PO_LINES_SV2 AUTHID CURRENT_USER as
2 /* $Header: POXPOL2S.pls 115.5 2003/10/08 16:57:55 zxzhang ship $ */
3
4
5 /*===========================================================================
6 PACKAGE NAME: PO_LINES_SV2
7
8 DESCRIPTION: This package contains the server side Line level
9 Application Program Interfaces (APIs).
10
11 CLIENT/SERVER: Server
12
13 OWNER: Melissa Snyder
14
15 FUNCTION/PROCEDURE: get_max_line_num()
16 update_line()
17 ===========================================================================*/
18
19
20 /*===========================================================================
21 FUNCTION NAME: get_max_line_num()
22
23 DESCRIPTION: This function will get the max line number for
24 a given po_header_id
25
26 PARAMETERS: X_line_id IN NUMBER
27 X_po_header_id IN NUMBER
28
29 DESIGN REFERENCES:
30
31 ALGORITHM:
32
33 NOTES:
34
35 OPEN ISSUES:
36
37 CLOSED ISSUES:
38
39 CHANGE HISTORY: Created 13-Jul-95 SIYER
40 ===========================================================================*/
41
42 function get_max_line_num(X_po_header_id IN NUMBER)
43 RETURN NUMBER ;
44 -- pragma restrict_references(get_max_line_num,WNDS,RNPS,WNPS);
45
46 /*===========================================================================
47 PROCEDURE NAME: update_line()
48
49 DESCRIPTION: This procedure will be updating a po line
50 and performing other update related activities.
51
52 PARAMETERS:
53
54 DESIGN REFERENCES:
55
56 ALGORITHM:
57
58 NOTES:
59
60 OPEN ISSUES:
61
62 CLOSED ISSUES:
63
64 CHANGE HISTORY: Created 21-Jul-95 SIYER
65 Moved to PO_LINES_SV11 3/19/97 ECSO
66 ===========================================================================*/
67 /* RETROACTIVE FPI START */
68
69 /*******************************************************************
70 PROCEDURE NAME: retroactive_change
71
72 DESCRIPTION : This is the API which updates the column retroactive_date
73 in po_lines with sysdate. This procedure is called from
74 ON-UPDATE triggers of PO_LINES and PO_SHIPMENTS block
75 in the Enter PO form. Po_lines.retroactive_date gives
76 the time when the blanket agreement had some retroactive
77 price change.
78 Referenced by :
79 parameters : p_po_line_id. This is the line_id for which the
80 retroactive_Date needs to be updated.
81
82 CHANGE History: Created 12-Feb-2002 pparthas
83 *******************************************************************/
84 Procedure retroactive_change(p_po_line_id IN number);
85 /* RETROACTIVE FPI END*/
86
87 -- <FPJ Retroactive START>
88 --------------------------------------------------------------------------------
89 --Start of Comments
90 --Name: retroactive_change
91 --Pre-reqs:
92 -- None.
93 --Modifies:
94 -- PO_LINE_LOCATIONS_ALL.retroactive_date.
95 --Locks:
96 -- None.
97 --Function:
98 -- This is the API which updates the column retroactive_date in po_line_locations
99 -- for Release ONLY with sysdate.
100 -- This procedure is called from PO_SHIPMENTS.price_override WHEN-VALIDATE-ITEM
101 -- trigger in the Enter Release form.
102 -- This will give the release shipment a different time with its corresponding
103 -- blanket agreement line, so that Approval Workflow will know this release had
104 -- some retroactive price change.
105 --Parameters:
106 --IN:
107 --p_line_location_id
108 -- the line_location_id for which the retroactive_Date needs to be updated.
109 --OUT:
110 -- None.
111 --Testing:
112 --
113 --End of Comments
114 -------------------------------------------------------------------------------
115 Procedure retro_change_shipment(p_line_location_id IN number);
116 -- <FPJ Retroactive END>
117
118 END PO_LINES_SV2;