APPS.WSH_CHARGES_PKG dependencies on SO_FREIGHT_CHARGES

Line 55: CURSOR C IS SELECT rowid FROM SO_FREIGHT_CHARGES

51: X_AC_Attribute13 VARCHAR2 DEFAULT NULL,
52: X_AC_Attribute14 VARCHAR2 DEFAULT NULL,
53: X_AC_Attribute15 VARCHAR2 DEFAULT NULL
54: ) IS
55: CURSOR C IS SELECT rowid FROM SO_FREIGHT_CHARGES
56: WHERE freight_charge_id = X_Freight_Charge_Id;
57: CURSOR NEXTID IS SELECT so_freight_charges_s.nextval FROM sys.dual;
58: BEGIN
59:

Line 57: CURSOR NEXTID IS SELECT so_freight_charges_s.nextval FROM sys.dual;

53: X_AC_Attribute15 VARCHAR2 DEFAULT NULL
54: ) IS
55: CURSOR C IS SELECT rowid FROM SO_FREIGHT_CHARGES
56: WHERE freight_charge_id = X_Freight_Charge_Id;
57: CURSOR NEXTID IS SELECT so_freight_charges_s.nextval FROM sys.dual;
58: BEGIN
59:
60: IF (X_Freight_Charge_Id is NULL) THEN
61: OPEN NEXTID;

Line 66: INSERT INTO SO_FREIGHT_CHARGES(

62: FETCH NEXTID INTO X_Freight_Charge_Id;
63: CLOSE NEXTID;
64: END IF;
65:
66: INSERT INTO SO_FREIGHT_CHARGES(
67:
68: freight_charge_id,
69: creation_date,
70: created_by,

Line 230: FROM SO_FREIGHT_CHARGES

226: X_AC_Attribute15 VARCHAR2 DEFAULT NULL
227: ) IS
228: CURSOR C IS
229: SELECT *
230: FROM SO_FREIGHT_CHARGES
231: WHERE rowid = X_Rowid
232: FOR UPDATE of Freight_Charge_Id NOWAIT;
233: Recinfo C%ROWTYPE;
234:

Line 437: UPDATE SO_FREIGHT_CHARGES

433: X_AC_Attribute15 VARCHAR2 DEFAULT NULL
434:
435: ) IS
436: BEGIN
437: UPDATE SO_FREIGHT_CHARGES
438: SET
439: freight_charge_id = X_Freight_Charge_Id,
440: last_update_date = X_Last_Update_Date,
441: last_updated_by = X_Last_Updated_By,

Line 494: DELETE FROM SO_FREIGHT_CHARGES

490: end if;
491: END Update_Row;
492: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
493: BEGIN
494: DELETE FROM SO_FREIGHT_CHARGES
495: WHERE rowid = X_Rowid;
496:
497: if (SQL%NOTFOUND) then
498: Raise NO_DATA_FOUND;