APPS.WSH_DELIVERIES_PKG1 dependencies on WSH_EXTERNAL_CUSTOM

Line 6: -- generated by wsh_external_custom.delivery_name

2: /* $Header: WSHDELXB.pls 115.3 99/08/11 19:22:58 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
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.

Line 9: -- generated by wsh_external_custom.delivery_name

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:
12: PROCEDURE Insert_Row(X_Rowid IN OUT VARCHAR2,
13: X_Organization_Id NUMBER,

Line 104: dname := wsh_external_custom.delivery_name(X_Delivery_Id);

100: CLOSE C2;
101: end if;
102:
103: IF (X_Name IS NULL) THEN
104: dname := wsh_external_custom.delivery_name(X_Delivery_Id);
105:
106: IF ( dname IS NULL ) THEN
107: RAISE null_name;
108: -- shipping default make sure the delivery name is not duplicate

Line 129: ELSE -- name is generated from wsh_external_custom.delivery_name

125: CLOSE C2;
126: END IF;
127:
128: X_Delivery_Id := temp_id;
129: ELSE -- name is generated from wsh_external_custom.delivery_name
130: OPEN C3( dname);
131: FETCH C3 INTO temp;
132: CLOSE C3;
133: IF ( temp > 0 ) THEN

Line 397: dname := wsh_external_custom.delivery_name(X_Delivery_Id);

393: CLOSE C2;
394: end if;
395:
396: IF (X_Name IS NULL) THEN
397: dname := wsh_external_custom.delivery_name(X_Delivery_Id);
398:
399: IF ( dname IS NULL ) THEN
400: RAISE null_name;
401: -- shipping default make sure the delivery name is not duplicate

Line 422: ELSE -- name is generated from wsh_external_custom.delivery_name

418: CLOSE C2;
419: END IF;
420:
421: X_Delivery_Id := temp_id;
422: ELSE -- name is generated from wsh_external_custom.delivery_name
423: OPEN C3( dname);
424: FETCH C3 INTO temp;
425: CLOSE C3;
426: IF ( temp > 0 ) THEN