APPS.PO_LINES_SV2 dependencies on PO_LINES

Line 1: PACKAGE BODY PO_LINES_SV2 as

1: PACKAGE BODY PO_LINES_SV2 as
2: /* $Header: POXPOL2B.pls 120.1.12020000.3 2013/02/10 11:35:28 vegajula ship $ */
3:
4: /*============================= PO_LINES_SV2 ===============================*/
5: /*===========================================================================

Line 4: /*============================= PO_LINES_SV2 ===============================*/

1: PACKAGE BODY PO_LINES_SV2 as
2: /* $Header: POXPOL2B.pls 120.1.12020000.3 2013/02/10 11:35:28 vegajula ship $ */
3:
4: /*============================= PO_LINES_SV2 ===============================*/
5: /*===========================================================================
6:
7: FUNCTION NAME: get_max_line_num()
8:

Line 21: FROM po_lines

17: X_Progress := '010';
18:
19: SELECT nvl(max(line_num),0)
20: INTO X_max_line_num
21: FROM po_lines
22: WHERE po_header_id = X_po_header_id;
23:
24: return(x_max_line_num);
25:

Line 38: Moved to PO_LINES_SV11

34:
35: /*===========================================================================
36:
37: PROCEDURE NAME: update_line()
38: Moved to PO_LINES_SV11
39: ecso 3/19/97 for globalization
40:
41: ===========================================================================*/
42:

Line 54: /* Bug 12648504 Start , try to get the lock on the record in PO_LINES before updating the

50:
51: BEGIN
52: X_progress := '010';
53:
54: /* Bug 12648504 Start , try to get the lock on the record in PO_LINES before updating the
55: record . If system can't get the lock then it trhows an exception with sqlcode -54
56: */
57:
58: SELECT po_line_id INTO l_line_id

Line 60: PO_LINES

56: */
57:
58: SELECT po_line_id INTO l_line_id
59: FROM
60: PO_LINES
61: WHERE
62: po_line_id = p_po_line_id FOR UPDATE OF RETROACTIVE_DATE NOWAIT;
63:
64: /* Bug 12648504 End */

Line 67: update po_lines

63:
64: /* Bug 12648504 End */
65:
66:
67: update po_lines
68: set retroactive_date = sysdate,
69: last_update_date = sysdate,
70: last_updated_by = x_user_id
71: where po_line_id = p_po_line_id;

Line 125: FROM po_lines_all pl

121: --on the corresponding blanket agreement line. The approval workflow
122: --would not update the retroactive_date again
123: UPDATE po_line_locations pll
124: SET retroactive_date = (SELECT pl.retroactive_date
125: FROM po_lines_all pl
126: WHERE pl.po_line_id = pll.po_line_id),
127: --retroactive_date = SYSDATE,
128: last_update_date = SYSDATE,
129: last_updated_by = l_user_id

Line 139: END PO_LINES_SV2;

135: END retro_change_shipment;
136: --
137:
138:
139: END PO_LINES_SV2;