APPS.SO_PICKING_LINE_DETAILS_PKG dependencies on SO_PICKING_LINE_DETAILS

Line 1: PACKAGE BODY SO_PICKING_LINE_DETAILS_PKG as

1: PACKAGE BODY SO_PICKING_LINE_DETAILS_PKG as
2: /* $Header: WSHPLDHB.pls 115.0 99/07/16 08:19:35 porting ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT VARCHAR2,
5: X_Picking_Line_Detail_Id IN OUT NUMBER,

Line 65: CURSOR C IS SELECT rowid FROM so_picking_line_details

61: X_Transaction_Temp_Id NUMBER,
62: X_Container_id NUMBER,
63: X_Movement_id NUMBER
64: ) IS
65: CURSOR C IS SELECT rowid FROM so_picking_line_details
66: WHERE picking_line_detail_id = X_Picking_Line_Detail_Id;
67: CURSOR C2 IS SELECT so_picking_line_details_s.nextval FROM sys.dual;
68: BEGIN
69: if (X_Picking_Line_Detail_Id is NULL) then

Line 67: CURSOR C2 IS SELECT so_picking_line_details_s.nextval FROM sys.dual;

63: X_Movement_id NUMBER
64: ) IS
65: CURSOR C IS SELECT rowid FROM so_picking_line_details
66: WHERE picking_line_detail_id = X_Picking_Line_Detail_Id;
67: CURSOR C2 IS SELECT so_picking_line_details_s.nextval FROM sys.dual;
68: BEGIN
69: if (X_Picking_Line_Detail_Id is NULL) then
70: OPEN C2;
71: FETCH C2 INTO X_Picking_Line_Detail_Id;

Line 75: INSERT INTO so_picking_line_details(

71: FETCH C2 INTO X_Picking_Line_Detail_Id;
72: CLOSE C2;
73: end if;
74:
75: INSERT INTO so_picking_line_details(
76: picking_line_detail_id,
77: last_update_date,
78: last_updated_by,
79: created_by,

Line 305: FROM so_picking_line_details

301: X_Movement_id NUMBER
302: ) IS
303: CURSOR C IS
304: SELECT *
305: FROM so_picking_line_details
306: WHERE rowid = X_Rowid
307: FOR UPDATE of Picking_Line_Detail_Id NOWAIT;
308: Recinfo C%ROWTYPE;
309:

Line 483: END SO_PICKING_LINE_DETAILS_PKG;

479:
480:
481:
482:
483: END SO_PICKING_LINE_DETAILS_PKG;