APPS.PO_LINES_SV dependencies on PO_LINES

Line 1: PACKAGE BODY PO_LINES_SV as

1: PACKAGE BODY PO_LINES_SV as
2: /* $Header: POXPOL1B.pls 120.10.12020000.2 2013/02/10 14:39:08 vegajula ship $ */
3:
4: /*============================= PO_LINES_SV ===============================*/
5:

Line 4: /*============================= PO_LINES_SV ===============================*/

1: PACKAGE BODY PO_LINES_SV as
2: /* $Header: POXPOL1B.pls 120.10.12020000.2 2013/02/10 14:39:08 vegajula ship $ */
3:
4: /*============================= PO_LINES_SV ===============================*/
5:
6:
7: /*===========================================================================
8:

Line 28: -- PO_LINES_SV.check_deletion_allowed

24: x_progress := '010';
25: --
26: -- If the calling source is HTML then we need not do the validations as we
27: -- would have already performed these validations in
28: -- PO_LINES_SV.check_deletion_allowed
29: IF p_skip_validation = 'Y' THEN
30: x_allow_delete := 'Y';
31: ELSE
32: /*

Line 39: FROM po_lines pol

35: SELECT line_num,
36: po_header_id
37: INTO X_po_line_num,
38: X_po_header_id
39: FROM po_lines pol
40: WHERE po_line_id = X_po_line_id;
41:
42: /*
43: ** Verify a line can be deleted

Line 89: po_lines_sv.val_line_delete(X_po_line_id => X_po_line_id,

85: END IF;
86: Exception when others THEN
87: l_type_name := X_type_lookup_code;
88: End;
89: po_lines_sv.val_line_delete(X_po_line_id => X_po_line_id,
90: X_allow_delete => X_allow_delete,
91: p_token => 'DOCUMENT_TYPE',
92: p_token_value => l_type_name);
93:

Line 106: fnd_attached_documents2_pkg.delete_attachments('PO_LINES',

102: */
103: IF (x_allow_delete = 'Y') THEN
104:
105: /* call the ATTACHMENTS PKG to delete all attachments*/
106: fnd_attached_documents2_pkg.delete_attachments('PO_LINES',
107: x_po_line_id,
108: '', '', '', '', 'Y');
109:
110:

Line 115: po_lines_sv.delete_children(X_type_lookup_code, X_po_line_id);

111: /*
112: ** Delete all children of the selected line.
113: */
114:
115: po_lines_sv.delete_children(X_type_lookup_code, X_po_line_id);
116: --dbms_output.put_line('after delete children');
117:
118: --
119: PO_PRICE_ADJUSTMENTS_PKG.delete_price_adjustments

Line 129: po_lines_pkg_sud.delete_row(X_row_id);

125: /*
126: ** Delete the Line.
127: */
128:
129: po_lines_pkg_sud.delete_row(X_row_id);
130: --dbms_output.put_line('after call to delete row');
131:
132:
133: END IF;

Line 159: FROM po_lines_all /*Bug6632095: using base table instead of view */

155: l_isucaenabled VARCHAR2(1) :='N';
156:
157: CURSOR C_LINE is
158: SELECT po_line_id
159: FROM po_lines_all /*Bug6632095: using base table instead of view */
160: WHERE po_header_id = X_po_header_id;
161:
162:
163: BEGIN

Line 175: fnd_attached_documents2_pkg.delete_attachments('PO_LINES',

171:
172: FETCH C_LINE INTO x_po_line_id;
173: EXIT WHEN C_LINE%notfound;
174:
175: fnd_attached_documents2_pkg.delete_attachments('PO_LINES',
176: x_po_line_id,
177: '', '', '', '', 'Y');
178:
179: --

Line 203: DELETE FROM PO_LINES_ALL /*Bug6632095: using base table instead of view */

199: --Enhanced Pricing
200: PO_PRICE_ADJUSTMENTS_PKG.delete_price_adjustments(p_po_header_id => X_po_header_id );
201:
202: --dbms_output.put_line('Before delete all lines');
203: DELETE FROM PO_LINES_ALL /*Bug6632095: using base table instead of view */
204: WHERE po_header_id = X_po_header_id;
205: --Delete Line UCAS IF UCA Enabled Begin.
206:
207: SELECT Nvl(po_core_s.Retrieveoptionvalue(org_id,

Line 277: FROM po_lines

273:
274: SELECT Nvl(po_core_s.Retrieveoptionvalue(org_id,
275: po_core_s.g_undef_cont_act_col), 'N')
276: INTO l_isucaenabled
277: FROM po_lines
278: WHERE po_line_id = x_po_line_id;
279:
280: IF l_isucaenabled = 'Y' THEN
281: DELETE FROM po_line_ucas

Line 306: po_lines_sv.val_line_delete(X_po_line_id, X_allow_delete);

302: BEGIN
303:
304: --dbms_output.put_line('Before_call');
305:
306: po_lines_sv.val_line_delete(X_po_line_id, X_allow_delete);
307:
308: --dbms_output.put_line('After call');
309: --dbms_output.put_line('Allow Delete = '||X_allow_delete);
310:

Line 339: l_line_creation_date PO_LINES_ALL.creation_date%type;

335: l_approved_flag PO_HEADERS_ALL.approved_flag%type;
336: l_po_header_id PO_HEADERS_ALL.po_header_id%type;
337: l_approved_date PO_HEADERS_ALL.approved_date%type;
338:
339: l_line_creation_date PO_LINES_ALL.creation_date%type;
340: BEGIN
341: x_progress := '010';
342:
343: -- Get type lookup code and approval status. Variables are used in later checks

Line 355: po_lines_all POL

351: l_po_header_id,
352: l_approved_date,
353: l_line_creation_date
354: FROM po_headers_all POH,
355: po_lines_all POL
356: WHERE POH.po_header_id = POL.po_header_id
357: AND POL.po_line_id = X_po_line_id;
358:
359: -- Following check is in key_delrec and not in val_line_delete

Line 427: PO_LINES_ALL POL

423:
424: SELECT POH.type_lookup_code
425: INTO l_type_lookup_code
426: FROM PO_HEADERS_ALL POH,
427: PO_LINES_ALL POL
428: WHERE POH.po_header_id = POL.po_header_id
429: AND POL.po_line_id = x_po_line_id;
430:
431: X_allow_delete := 'Y';

Line 519: -- Only check for reserved distributions for Standard and Planned PO lines.

515: ** If it does, display message and prevent deletion.
516: */
517:
518: --
519: -- Only check for reserved distributions for Standard and Planned PO lines.
520:
521: SELECT POH.type_lookup_code
522: INTO l_type_lookup_code
523: FROM PO_HEADERS_ALL POH

Line 524: , PO_LINES_ALL POL

520:
521: SELECT POH.type_lookup_code
522: INTO l_type_lookup_code
523: FROM PO_HEADERS_ALL POH
524: , PO_LINES_ALL POL
525: WHERE POH.po_header_id = POL.po_header_id
526: AND POL.po_line_id = x_po_line_id
527: ;
528:

Line 534: FROM po_lines_all pol

530:
531: IF(l_type_lookup_code='BLANKET') THEN
532: SELECT Max('N')
533: INTO X_allow_delete
534: FROM po_lines_all pol
535: WHERE pol.from_line_id = X_po_line_id ;
536:
537: IF ( X_allow_delete = 'N' ) THEN
538: po_message_s.app_error('PO_PO_USE_CANCEL_ON_APRVD_PO3',p_token,p_token_value);

Line 676: IF po_lines_sv.val_approval_status

672: BEGIN
673:
674: --dbms_output.put_line('before call');
675:
676: IF po_lines_sv.val_approval_status
677: (X_po_line_id ,
678: X_type_lookup_code ,
679: X_unit_price ,
680: X_line_num ,

Line 776: FROM po_lines pol

772: --dbms_output.put_line('Not to Exceed Price = '||X_not_to_exceed_price);
773:
774: SELECT 'Y'
775: INTO X_approval_status_changed
776: FROM po_lines pol
777: WHERE pol.po_line_id = X_po_line_id
778: AND ((pol.unit_price <> X_unit_price)
779: OR (pol.unit_price is NULL
780: AND

Line 991: FROM po_lines pol

987: BEGIN
988:
989: SELECT 'Y'
990: INTO X_approval_status_changed
991: FROM po_lines pol
992: WHERE pol.po_line_id = X_po_line_id
993: AND ((pol.unit_price <> X_unit_price)
994: OR (pol.unit_price is NULL
995: AND

Line 1111: FROM po_lines pol

1107: IF X_approval_status_changed <> 'Y' THEN
1108:
1109: SELECT 'Y'
1110: INTO X_approval_status_changed
1111: FROM po_lines pol
1112: WHERE pol.po_line_id = X_po_line_id
1113: AND (
1114: (pol.note_to_vendor <> X_note_to_vendor)
1115: OR (pol.note_to_vendor is NULL

Line 1215: /* Bug# 3104460 - PO_LINES.QUANTITY should not be updated. */

1211: BEGIN
1212:
1213: x_progress := '010';
1214:
1215: /* Bug# 3104460 - PO_LINES.QUANTITY should not be updated. */
1216: IF (X_shipment_type = 'BLANKET') THEN
1217:
1218: IF (X_event = 'INSERT') THEN
1219:

Line 1220: UPDATE PO_LINES

1216: IF (X_shipment_type = 'BLANKET') THEN
1217:
1218: IF (X_event = 'INSERT') THEN
1219:
1220: UPDATE PO_LINES
1221: SET closed_code = 'OPEN'
1222: WHERE po_line_id = X_po_line_id
1223: -- Bug 3202973 Should not update quantity for Services lines:
1224: AND order_type_lookup_code NOT IN ('RATE', 'FIXED PRICE')

Line 1237: END PO_LINES_SV;

1233: po_message_s.sql_error('update_released_quantity', x_progress, sqlcode);
1234: raise;
1235: END update_released_quantity;
1236:
1237: END PO_LINES_SV;