APPS.OE_SO_PLD_TABLE dependencies on SO_PICKING_LINE_DETAILS

Line 81: CURSOR C IS SELECT rowid FROM so_picking_line_details

77: X_WIP_COMPLETED_QUANTITY NUMBER,
78: X_WIP_RESERVED_QUANTITY NUMBER
79: )IS
80:
81: CURSOR C IS SELECT rowid FROM so_picking_line_details
82: WHERE PICKING_LINE_DETAIL_ID = X_PICKING_LINE_DETAIL_ID;
83:
84: BEGIN
85: INSERT INTO so_picking_line_details(

Line 85: INSERT INTO so_picking_line_details(

81: CURSOR C IS SELECT rowid FROM so_picking_line_details
82: WHERE PICKING_LINE_DETAIL_ID = X_PICKING_LINE_DETAIL_ID;
83:
84: BEGIN
85: INSERT INTO so_picking_line_details(
86: ATTRIBUTE1,
87: ATTRIBUTE10,
88: ATTRIBUTE11,
89: ATTRIBUTE12,

Line 323: CURSOR C IS SELECT * FROM so_picking_line_details

319: X_WIP_COMPLETED_QUANTITY NUMBER,
320: X_WIP_RESERVED_QUANTITY NUMBER,
321: Result OUT VARCHAR2)IS
322:
323: CURSOR C IS SELECT * FROM so_picking_line_details
324: WHERE rowid = X_rowid
325: FOR UPDATE NOWAIT;
326:
327: Recinfo C%ROWTYPE;

Line 602: UPDATE so_picking_line_details

598: X_WIP_RESERVED_QUANTITY NUMBER
599: )IS
600:
601: BEGIN
602: UPDATE so_picking_line_details
603: SET
604: ATTRIBUTE1 = X_ATTRIBUTE1,
605: ATTRIBUTE10 = X_ATTRIBUTE10,
606: ATTRIBUTE11 = X_ATTRIBUTE11,

Line 689: DELETE FROM so_picking_line_details

685: PROCEDURE Delete_Row(X_Rowid VARCHAR2)
686: IS
687:
688: BEGIN
689: DELETE FROM so_picking_line_details
690: WHERE ROWID = X_Rowid;
691:
692: IF (SQL%NOTFOUND) then
693: Raise NO_DATA_FOUND;