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 2005/06/27 04:44:37 sjadhav noship $ */
3:
4: PROCEDURE Lock_Row(X_Rowid VARCHAR2,
5: X_Line_Location_Id NUMBER,

Line 109: --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

105: X_Country_of_Origin_Code VARCHAR2,
106: X_Invoice_Match_Option VARCHAR2, --bgu, Dec. 7, 98
107: -- Mahesh Chandak(GML) Add process related fields secondary_quantity, preferred
108: --grade and received,rejected,accepted and cancelled sec. qnty.Secondary_unit_of
109: --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
110: X_Secondary_Quantity NUMBER default null,
111: X_Preferred_Grade VARCHAR2 default null,
112: X_Secondary_Quantity_Received NUMBER default null,
113: X_Secondary_Quantity_Accepted NUMBER default null,

Line 120: FROM PO_LINE_LOCATIONS

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

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

207: OR ( (Recinfo.secondary_quantity_cancelled IS NULL)
208: AND (X_Secondary_Quantity_Cancelled IS NULL)))
209: ))
210: --end of 1548597
211: /* Do not need unit_meas_lookup_code as it is NOT from PO_LINE_LOCATIONS
212: ** in the form.Also, it is just a display field
213: AND ( (Recinfo.unit_meas_lookup_code = X_Unit_Meas_Lookup_Code)
214: -- OR ( (Recinfo.unit_meas_lookup_code IS NULL)
215: -- AND (X_Unit_Meas_Lookup_Code IS NULL))) */

Line 501: END PO_LINE_LOCATIONS_PKG_S1;

497:
498: end if;
499:
500: END Lock_Row;
501: END PO_LINE_LOCATIONS_PKG_S1;