APPS.WSH_DEPARTURES_PKG dependencies on WSH_EXTERNAL_CUSTOM

Line 6: -- generated by wsh_external_custom.departure_name

2: /* $Header: WSHDEPHB.pls 115.2 99/07/16 08:18:42 porting ship $ */
3:
4: -- The procedure insert_row can possibly return 2 kinds of exceptions
5: -- 1. WSH_DEP_DUP_NAME : This the for the case that default departure name
6: -- generated by wsh_external_custom.departure_name
7: -- is duplicate in table wsh_departures
8: -- 2. WSH_DEP_NULL_NAME : This is for the case that default departure name
9: -- generated by wsh_external_custom.departure_name
10: -- is NULL.

Line 9: -- generated by wsh_external_custom.departure_name

5: -- 1. WSH_DEP_DUP_NAME : This the for the case that default departure name
6: -- generated by wsh_external_custom.departure_name
7: -- is duplicate in table wsh_departures
8: -- 2. WSH_DEP_NULL_NAME : This is for the case that default departure name
9: -- generated by wsh_external_custom.departure_name
10: -- is NULL.
11: PROCEDURE Insert_Row(X_Rowid IN OUT VARCHAR2,
12: X_Organization_Id NUMBER,
13: X_Departure_Id IN OUT NUMBER,

Line 75: dname := wsh_external_custom.departure_name(X_Departure_Id);

71: CLOSE C2;
72: end if;
73:
74: IF (X_Name IS NULL) THEN
75: dname := wsh_external_custom.departure_name(X_Departure_Id);
76:
77: IF ( dname IS NULL ) THEN
78: RAISE null_name;
79: -- shipping default make sure the departure name is not duplicate

Line 97: ELSE -- name is generated from wsh_external_custom.departure_name

93: FETCH C2 INTO temp_id;
94: END LOOP;
95: CLOSE C2;
96: X_Departure_Id := temp_id;
97: ELSE -- name is generated from wsh_external_custom.departure_name
98: OPEN C3( dname);
99: FETCH C3 INTO temp;
100: CLOSE C3;
101: IF ( temp > 0 ) THEN

Line 444: dname := wsh_external_custom.departure_name(X_Departure_Id);

440:
441: BEGIN
442:
443: IF (X_Name IS NULL) THEN
444: dname := wsh_external_custom.departure_name(X_Departure_Id);
445:
446: IF ( dname IS NULL ) THEN
447: RAISE null_name;
448: -- shipping default make sure the departure name is not duplicate

Line 465: ELSE -- name is generated from wsh_external_custom.departure_name

461:
462: FETCH C2 INTO temp_id;
463: END LOOP;
464: CLOSE C2;
465: ELSE -- name is generated from wsh_external_custom.departure_name
466: OPEN C3( dname);
467: FETCH C3 INTO temp;
468: CLOSE C3;
469: IF ( temp > 0 ) THEN