APPS.WSH_DELIVERIES_PKG dependencies on WSH_DELIVERIES

Line 1: PACKAGE BODY WSH_DELIVERIES_PKG as

1: PACKAGE BODY WSH_DELIVERIES_PKG as
2: /* $Header: WSHDELHB.pls 115.2 99/08/11 19:22:52 porting s $ */
3:
4: -- The procedure insert_row can possibly return 2 kinds of exceptions
5: -- 1. WSH_DEL_DUP_NAME : This the for the case that default delivery name

Line 7: -- is duplicate in table wsh_deliveries

3:
4: -- The procedure insert_row can possibly return 2 kinds of exceptions
5: -- 1. WSH_DEL_DUP_NAME : This the for the case that default delivery name
6: -- generated by wsh_external_custom.delivery_name
7: -- is duplicate in table wsh_deliveries
8: -- 2. WSH_DEL_NULL_NAME : This is for the case that default delivery name
9: -- generated by wsh_external_custom.delivery_name
10: -- is NULL.
11:

Line 84: dname wsh_deliveries.name%TYPE;

80: X_Last_Update_Date DATE,
81: X_Last_Updated_By NUMBER,
82: X_Last_Update_Login NUMBER
83: ) IS
84: dname wsh_deliveries.name%TYPE;
85: CURSOR C2 IS SELECT wsh_deliveries_s.nextval FROM sys.dual;
86: CURSOR C3 (del_name VARCHAR2) IS
87: SELECT COUNT(*) FROM wsh_deliveries
88: WHERE name = del_name;

Line 85: CURSOR C2 IS SELECT wsh_deliveries_s.nextval FROM sys.dual;

81: X_Last_Updated_By NUMBER,
82: X_Last_Update_Login NUMBER
83: ) IS
84: dname wsh_deliveries.name%TYPE;
85: CURSOR C2 IS SELECT wsh_deliveries_s.nextval FROM sys.dual;
86: CURSOR C3 (del_name VARCHAR2) IS
87: SELECT COUNT(*) FROM wsh_deliveries
88: WHERE name = del_name;
89: temp NUMBER;

Line 87: SELECT COUNT(*) FROM wsh_deliveries

83: ) IS
84: dname wsh_deliveries.name%TYPE;
85: CURSOR C2 IS SELECT wsh_deliveries_s.nextval FROM sys.dual;
86: CURSOR C3 (del_name VARCHAR2) IS
87: SELECT COUNT(*) FROM wsh_deliveries
88: WHERE name = del_name;
89: temp NUMBER;
90: temp_id NUMBER;
91: duplicate_name EXCEPTION;

Line 129: UPDATE wsh_deliveries

125: END IF;
126: X_Name := dname;
127: END IF;
128:
129: UPDATE wsh_deliveries
130: SET
131: organization_id = X_Organization_Id,
132: delivery_id = X_Delivery_Id,
133: name = X_Name,

Line 279: FROM wsh_deliveries

275: X_Global_Attribute20 VARCHAR2 default null
276: ) IS
277: CURSOR C IS
278: SELECT *
279: FROM wsh_deliveries
280: WHERE rowid = X_Rowid
281: FOR UPDATE of Delivery_Id NOWAIT;
282: Recinfo C%ROWTYPE;
283:

Line 561: dname wsh_deliveries.name%TYPE;

557: X_Last_Update_Date DATE,
558: X_Last_Updated_By NUMBER,
559: X_Last_Update_Login NUMBER
560: ) IS
561: dname wsh_deliveries.name%TYPE;
562: CURSOR C2 IS SELECT wsh_deliveries_s.nextval FROM sys.dual;
563: CURSOR C3 (del_name VARCHAR2) IS
564: SELECT COUNT(*) FROM wsh_deliveries
565: WHERE name = del_name;

Line 562: CURSOR C2 IS SELECT wsh_deliveries_s.nextval FROM sys.dual;

558: X_Last_Updated_By NUMBER,
559: X_Last_Update_Login NUMBER
560: ) IS
561: dname wsh_deliveries.name%TYPE;
562: CURSOR C2 IS SELECT wsh_deliveries_s.nextval FROM sys.dual;
563: CURSOR C3 (del_name VARCHAR2) IS
564: SELECT COUNT(*) FROM wsh_deliveries
565: WHERE name = del_name;
566: temp NUMBER;

Line 564: SELECT COUNT(*) FROM wsh_deliveries

560: ) IS
561: dname wsh_deliveries.name%TYPE;
562: CURSOR C2 IS SELECT wsh_deliveries_s.nextval FROM sys.dual;
563: CURSOR C3 (del_name VARCHAR2) IS
564: SELECT COUNT(*) FROM wsh_deliveries
565: WHERE name = del_name;
566: temp NUMBER;
567: temp_id NUMBER;
568: duplicate_name EXCEPTION;

Line 606: UPDATE wsh_deliveries

602: END IF;
603: X_Name := dname;
604: END IF;
605:
606: UPDATE wsh_deliveries
607: SET
608: organization_id = X_Organization_Id,
609: delivery_id = X_Delivery_Id,
610: name = X_Name,

Line 758: FROM wsh_deliveries

754: X_Global_Attribute20 VARCHAR2 default null
755: ) IS
756: CURSOR C IS
757: SELECT *
758: FROM wsh_deliveries
759: WHERE rowid = X_Rowid
760: FOR UPDATE of Delivery_Id NOWAIT;
761: Recinfo C%ROWTYPE;
762:

Line 972: END WSH_DELIVERIES_PKG;

968:
969:
970:
971:
972: END WSH_DELIVERIES_PKG;