APPS.WSH_DELIVERIES_PKG dependencies on WSH_EXTERNAL_CUSTOM

Line 6: -- generated by wsh_external_custom.delivery_name

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
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:
13: PROCEDURE Update_Row(X_Rowid VARCHAR2,

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

92: null_name EXCEPTION;
93: BEGIN
94:
95: IF (X_Name IS NULL) THEN
96: dname := wsh_external_custom.delivery_name(X_Delivery_Id);
97:
98: IF ( dname IS NULL ) THEN
99: RAISE null_name;
100: -- shipping default make sure the delivery name is not duplicate

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

113:
114: FETCH C2 INTO temp_id;
115: END LOOP;
116: CLOSE C2;
117: ELSE -- name is generated from wsh_external_custom.delivery_name
118: OPEN C3( dname);
119: FETCH C3 INTO temp;
120: CLOSE C3;
121: IF ( temp > 0 ) THEN

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

569: null_name EXCEPTION;
570: BEGIN
571:
572: IF (X_Name IS NULL) THEN
573: dname := wsh_external_custom.delivery_name(X_Delivery_Id);
574:
575: IF ( dname IS NULL ) THEN
576: RAISE null_name;
577: -- shipping default make sure the delivery name is not duplicate

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

590:
591: FETCH C2 INTO temp_id;
592: END LOOP;
593: CLOSE C2;
594: ELSE -- name is generated from wsh_external_custom.delivery_name
595: OPEN C3( dname);
596: FETCH C3 INTO temp;
597: CLOSE C3;
598: IF ( temp > 0 ) THEN