APPS.PO_LINE_LOCATIONS_PKG_S1 dependencies on PO_LINE_LOCATIONS

Line 1: PACKAGE BODY PO_LINE_LOCATIONS_PKG_S1 as

1: PACKAGE BODY PO_LINE_LOCATIONS_PKG_S1 as
2: /* $Header: POXP2PSB.pls 120.2.12020000.2 2013/02/10 14:15:14 vegajula ship $ */
3: -- Read the profile option that enables/disables the debug log
4: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

Line 6: c_log_head CONSTANT VARCHAR2(40) := 'po.plsql.PO_LINE_LOCATIONS_PKG_S1.';

2: /* $Header: POXP2PSB.pls 120.2.12020000.2 2013/02/10 14:15:14 vegajula ship $ */
3: -- Read the profile option that enables/disables the debug log
4: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: c_log_head CONSTANT VARCHAR2(40) := 'po.plsql.PO_LINE_LOCATIONS_PKG_S1.';
7:
8: PROCEDURE Lock_Row(X_Rowid VARCHAR2,
9: X_Line_Location_Id NUMBER,
10: X_Po_Header_Id NUMBER,

Line 113: --measure is not required since this is not populated in release form in po_line_locations_all but is referenced from the view. Bug# 1548597

109: X_Country_of_Origin_Code VARCHAR2,
110: X_Invoice_Match_Option VARCHAR2, --bgu, Dec. 7, 98
111: -- Mahesh Chandak(GML) Add process related fields secondary_quantity, preferred
112: --grade and received,rejected,accepted and cancelled sec. qnty.Secondary_unit_of
113: --measure is not required since this is not populated in release form in po_line_locations_all but is referenced from the view. Bug# 1548597
114: X_Secondary_Quantity NUMBER default null,
115: X_Preferred_Grade VARCHAR2 default null,
116: X_Secondary_Quantity_Received NUMBER default null,
117: X_Secondary_Quantity_Accepted NUMBER default null,

Line 124: FROM PO_LINE_LOCATIONS

120: X_amount NUMBER default null --
121: ) IS
122: CURSOR C IS
123: SELECT *
124: FROM PO_LINE_LOCATIONS
125: WHERE rowid = X_Rowid
126: FOR UPDATE of Line_Location_Id NOWAIT;
127: Recinfo C%ROWTYPE;
128:

Line 217: /* Do not need unit_meas_lookup_code as it is NOT from PO_LINE_LOCATIONS

213: OR ( (Recinfo.secondary_quantity_cancelled IS NULL)
214: AND (X_Secondary_Quantity_Cancelled IS NULL)))
215: ))
216: --end of 1548597
217: /* Do not need unit_meas_lookup_code as it is NOT from PO_LINE_LOCATIONS
218: ** in the form.Also, it is just a display field
219: AND ( (Recinfo.unit_meas_lookup_code = X_Unit_Meas_Lookup_Code)
220: -- OR ( (Recinfo.unit_meas_lookup_code IS NULL)
221: -- AND (X_Unit_Meas_Lookup_Code IS NULL))) */

Line 1123: END PO_LINE_LOCATIONS_PKG_S1;

1119:
1120: end if;
1121:
1122: END Lock_Row;
1123: END PO_LINE_LOCATIONS_PKG_S1;