APPS.HZ_CERTIFICATIONS_PKG dependencies on FND_API

Line 52: decode( x_CERTIFICATION_NAME, FND_API.G_MISS_CHAR, NULL,x_CERTIFICATION_NAME),

48: WH_UPDATE_DATE,
49: STATUS
50: ) VALUES (
51: x_CERTIFICATION_ID,
52: decode( x_CERTIFICATION_NAME, FND_API.G_MISS_CHAR, NULL,x_CERTIFICATION_NAME),
53: decode( x_CURRENT_STATUS, FND_API.G_MISS_CHAR, NULL,x_CURRENT_STATUS),
54: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
55: decode( x_EXPIRES_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_EXPIRES_ON_DATE),
56: decode( x_GRADE, FND_API.G_MISS_CHAR, NULL,x_GRADE),

Line 53: decode( x_CURRENT_STATUS, FND_API.G_MISS_CHAR, NULL,x_CURRENT_STATUS),

49: STATUS
50: ) VALUES (
51: x_CERTIFICATION_ID,
52: decode( x_CERTIFICATION_NAME, FND_API.G_MISS_CHAR, NULL,x_CERTIFICATION_NAME),
53: decode( x_CURRENT_STATUS, FND_API.G_MISS_CHAR, NULL,x_CURRENT_STATUS),
54: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
55: decode( x_EXPIRES_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_EXPIRES_ON_DATE),
56: decode( x_GRADE, FND_API.G_MISS_CHAR, NULL,x_GRADE),
57: decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR, NULL,x_ISSUED_BY_AUTHORITY),

Line 54: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),

50: ) VALUES (
51: x_CERTIFICATION_ID,
52: decode( x_CERTIFICATION_NAME, FND_API.G_MISS_CHAR, NULL,x_CERTIFICATION_NAME),
53: decode( x_CURRENT_STATUS, FND_API.G_MISS_CHAR, NULL,x_CURRENT_STATUS),
54: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
55: decode( x_EXPIRES_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_EXPIRES_ON_DATE),
56: decode( x_GRADE, FND_API.G_MISS_CHAR, NULL,x_GRADE),
57: decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR, NULL,x_ISSUED_BY_AUTHORITY),
58: decode( x_ISSUED_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_ISSUED_ON_DATE),

Line 55: decode( x_EXPIRES_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_EXPIRES_ON_DATE),

51: x_CERTIFICATION_ID,
52: decode( x_CERTIFICATION_NAME, FND_API.G_MISS_CHAR, NULL,x_CERTIFICATION_NAME),
53: decode( x_CURRENT_STATUS, FND_API.G_MISS_CHAR, NULL,x_CURRENT_STATUS),
54: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
55: decode( x_EXPIRES_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_EXPIRES_ON_DATE),
56: decode( x_GRADE, FND_API.G_MISS_CHAR, NULL,x_GRADE),
57: decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR, NULL,x_ISSUED_BY_AUTHORITY),
58: decode( x_ISSUED_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_ISSUED_ON_DATE),
59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),

Line 56: decode( x_GRADE, FND_API.G_MISS_CHAR, NULL,x_GRADE),

52: decode( x_CERTIFICATION_NAME, FND_API.G_MISS_CHAR, NULL,x_CERTIFICATION_NAME),
53: decode( x_CURRENT_STATUS, FND_API.G_MISS_CHAR, NULL,x_CURRENT_STATUS),
54: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
55: decode( x_EXPIRES_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_EXPIRES_ON_DATE),
56: decode( x_GRADE, FND_API.G_MISS_CHAR, NULL,x_GRADE),
57: decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR, NULL,x_ISSUED_BY_AUTHORITY),
58: decode( x_ISSUED_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_ISSUED_ON_DATE),
59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
60: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),

Line 57: decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR, NULL,x_ISSUED_BY_AUTHORITY),

53: decode( x_CURRENT_STATUS, FND_API.G_MISS_CHAR, NULL,x_CURRENT_STATUS),
54: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
55: decode( x_EXPIRES_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_EXPIRES_ON_DATE),
56: decode( x_GRADE, FND_API.G_MISS_CHAR, NULL,x_GRADE),
57: decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR, NULL,x_ISSUED_BY_AUTHORITY),
58: decode( x_ISSUED_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_ISSUED_ON_DATE),
59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
60: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
61: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

Line 58: decode( x_ISSUED_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_ISSUED_ON_DATE),

54: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
55: decode( x_EXPIRES_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_EXPIRES_ON_DATE),
56: decode( x_GRADE, FND_API.G_MISS_CHAR, NULL,x_GRADE),
57: decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR, NULL,x_ISSUED_BY_AUTHORITY),
58: decode( x_ISSUED_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_ISSUED_ON_DATE),
59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
60: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
61: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
62: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),

Line 59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),

55: decode( x_EXPIRES_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_EXPIRES_ON_DATE),
56: decode( x_GRADE, FND_API.G_MISS_CHAR, NULL,x_GRADE),
57: decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR, NULL,x_ISSUED_BY_AUTHORITY),
58: decode( x_ISSUED_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_ISSUED_ON_DATE),
59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
60: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
61: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
62: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
63: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),

Line 60: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),

56: decode( x_GRADE, FND_API.G_MISS_CHAR, NULL,x_GRADE),
57: decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR, NULL,x_ISSUED_BY_AUTHORITY),
58: decode( x_ISSUED_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_ISSUED_ON_DATE),
59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
60: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
61: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
62: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
63: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
64: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),

Line 61: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

57: decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR, NULL,x_ISSUED_BY_AUTHORITY),
58: decode( x_ISSUED_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_ISSUED_ON_DATE),
59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
60: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
61: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
62: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
63: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
64: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
65: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),

Line 62: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),

58: decode( x_ISSUED_ON_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_ISSUED_ON_DATE),
59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
60: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
61: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
62: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
63: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
64: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
65: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
66: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),

Line 63: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),

59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
60: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
61: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
62: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
63: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
64: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
65: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
66: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
67: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),

Line 64: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),

60: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
61: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
62: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
63: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
64: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
65: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
66: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
67: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
68: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE),

Line 65: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),

61: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
62: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
63: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
64: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
65: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
66: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
67: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
68: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE),
69: decode(x_STATUS,FND_API.G_MISS_CHAR,'A',x_STATUS));

Line 66: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),

62: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
63: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
64: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
65: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
66: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
67: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
68: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE),
69: decode(x_STATUS,FND_API.G_MISS_CHAR,'A',x_STATUS));
70: OPEN C;

Line 67: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),

63: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
64: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
65: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
66: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
67: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
68: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE),
69: decode(x_STATUS,FND_API.G_MISS_CHAR,'A',x_STATUS));
70: OPEN C;
71: FETCH C INTO x_Rowid;

Line 68: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE),

64: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
65: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
66: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
67: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
68: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE),
69: decode(x_STATUS,FND_API.G_MISS_CHAR,'A',x_STATUS));
70: OPEN C;
71: FETCH C INTO x_Rowid;
72: If (C%NOTFOUND) then

Line 69: decode(x_STATUS,FND_API.G_MISS_CHAR,'A',x_STATUS));

65: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
66: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
67: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
68: decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE),
69: decode(x_STATUS,FND_API.G_MISS_CHAR,'A',x_STATUS));
70: OPEN C;
71: FETCH C INTO x_Rowid;
72: If (C%NOTFOUND) then
73: CLOSE C;

Line 117: CERTIFICATION_ID = decode( x_CERTIFICATION_ID, FND_API.G_MISS_NUM,CERTIFICATION_ID,x_CERTIFICATION_ID),

113: ) IS
114: BEGIN
115: Update HZ_CERTIFICATIONS
116: SET
117: CERTIFICATION_ID = decode( x_CERTIFICATION_ID, FND_API.G_MISS_NUM,CERTIFICATION_ID,x_CERTIFICATION_ID),
118: CERTIFICATION_NAME = decode( x_CERTIFICATION_NAME, FND_API.G_MISS_CHAR,CERTIFICATION_NAME,x_CERTIFICATION_NAME),
119: CURRENT_STATUS = decode( x_CURRENT_STATUS, FND_API.G_MISS_CHAR,CURRENT_STATUS,x_CURRENT_STATUS),
120: PARTY_ID = decode( x_PARTY_ID, FND_API.G_MISS_NUM,PARTY_ID,x_PARTY_ID),
121: EXPIRES_ON_DATE = decode( x_EXPIRES_ON_DATE, FND_API.G_MISS_DATE,EXPIRES_ON_DATE,x_EXPIRES_ON_DATE),

Line 118: CERTIFICATION_NAME = decode( x_CERTIFICATION_NAME, FND_API.G_MISS_CHAR,CERTIFICATION_NAME,x_CERTIFICATION_NAME),

114: BEGIN
115: Update HZ_CERTIFICATIONS
116: SET
117: CERTIFICATION_ID = decode( x_CERTIFICATION_ID, FND_API.G_MISS_NUM,CERTIFICATION_ID,x_CERTIFICATION_ID),
118: CERTIFICATION_NAME = decode( x_CERTIFICATION_NAME, FND_API.G_MISS_CHAR,CERTIFICATION_NAME,x_CERTIFICATION_NAME),
119: CURRENT_STATUS = decode( x_CURRENT_STATUS, FND_API.G_MISS_CHAR,CURRENT_STATUS,x_CURRENT_STATUS),
120: PARTY_ID = decode( x_PARTY_ID, FND_API.G_MISS_NUM,PARTY_ID,x_PARTY_ID),
121: EXPIRES_ON_DATE = decode( x_EXPIRES_ON_DATE, FND_API.G_MISS_DATE,EXPIRES_ON_DATE,x_EXPIRES_ON_DATE),
122: GRADE = decode( x_GRADE, FND_API.G_MISS_CHAR,GRADE,x_GRADE),

Line 119: CURRENT_STATUS = decode( x_CURRENT_STATUS, FND_API.G_MISS_CHAR,CURRENT_STATUS,x_CURRENT_STATUS),

115: Update HZ_CERTIFICATIONS
116: SET
117: CERTIFICATION_ID = decode( x_CERTIFICATION_ID, FND_API.G_MISS_NUM,CERTIFICATION_ID,x_CERTIFICATION_ID),
118: CERTIFICATION_NAME = decode( x_CERTIFICATION_NAME, FND_API.G_MISS_CHAR,CERTIFICATION_NAME,x_CERTIFICATION_NAME),
119: CURRENT_STATUS = decode( x_CURRENT_STATUS, FND_API.G_MISS_CHAR,CURRENT_STATUS,x_CURRENT_STATUS),
120: PARTY_ID = decode( x_PARTY_ID, FND_API.G_MISS_NUM,PARTY_ID,x_PARTY_ID),
121: EXPIRES_ON_DATE = decode( x_EXPIRES_ON_DATE, FND_API.G_MISS_DATE,EXPIRES_ON_DATE,x_EXPIRES_ON_DATE),
122: GRADE = decode( x_GRADE, FND_API.G_MISS_CHAR,GRADE,x_GRADE),
123: ISSUED_BY_AUTHORITY = decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR,ISSUED_BY_AUTHORITY,x_ISSUED_BY_AUTHORITY),

Line 120: PARTY_ID = decode( x_PARTY_ID, FND_API.G_MISS_NUM,PARTY_ID,x_PARTY_ID),

116: SET
117: CERTIFICATION_ID = decode( x_CERTIFICATION_ID, FND_API.G_MISS_NUM,CERTIFICATION_ID,x_CERTIFICATION_ID),
118: CERTIFICATION_NAME = decode( x_CERTIFICATION_NAME, FND_API.G_MISS_CHAR,CERTIFICATION_NAME,x_CERTIFICATION_NAME),
119: CURRENT_STATUS = decode( x_CURRENT_STATUS, FND_API.G_MISS_CHAR,CURRENT_STATUS,x_CURRENT_STATUS),
120: PARTY_ID = decode( x_PARTY_ID, FND_API.G_MISS_NUM,PARTY_ID,x_PARTY_ID),
121: EXPIRES_ON_DATE = decode( x_EXPIRES_ON_DATE, FND_API.G_MISS_DATE,EXPIRES_ON_DATE,x_EXPIRES_ON_DATE),
122: GRADE = decode( x_GRADE, FND_API.G_MISS_CHAR,GRADE,x_GRADE),
123: ISSUED_BY_AUTHORITY = decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR,ISSUED_BY_AUTHORITY,x_ISSUED_BY_AUTHORITY),
124: ISSUED_ON_DATE = decode( x_ISSUED_ON_DATE, FND_API.G_MISS_DATE,ISSUED_ON_DATE,x_ISSUED_ON_DATE),

Line 121: EXPIRES_ON_DATE = decode( x_EXPIRES_ON_DATE, FND_API.G_MISS_DATE,EXPIRES_ON_DATE,x_EXPIRES_ON_DATE),

117: CERTIFICATION_ID = decode( x_CERTIFICATION_ID, FND_API.G_MISS_NUM,CERTIFICATION_ID,x_CERTIFICATION_ID),
118: CERTIFICATION_NAME = decode( x_CERTIFICATION_NAME, FND_API.G_MISS_CHAR,CERTIFICATION_NAME,x_CERTIFICATION_NAME),
119: CURRENT_STATUS = decode( x_CURRENT_STATUS, FND_API.G_MISS_CHAR,CURRENT_STATUS,x_CURRENT_STATUS),
120: PARTY_ID = decode( x_PARTY_ID, FND_API.G_MISS_NUM,PARTY_ID,x_PARTY_ID),
121: EXPIRES_ON_DATE = decode( x_EXPIRES_ON_DATE, FND_API.G_MISS_DATE,EXPIRES_ON_DATE,x_EXPIRES_ON_DATE),
122: GRADE = decode( x_GRADE, FND_API.G_MISS_CHAR,GRADE,x_GRADE),
123: ISSUED_BY_AUTHORITY = decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR,ISSUED_BY_AUTHORITY,x_ISSUED_BY_AUTHORITY),
124: ISSUED_ON_DATE = decode( x_ISSUED_ON_DATE, FND_API.G_MISS_DATE,ISSUED_ON_DATE,x_ISSUED_ON_DATE),
125: -- Bug 3032780

Line 122: GRADE = decode( x_GRADE, FND_API.G_MISS_CHAR,GRADE,x_GRADE),

118: CERTIFICATION_NAME = decode( x_CERTIFICATION_NAME, FND_API.G_MISS_CHAR,CERTIFICATION_NAME,x_CERTIFICATION_NAME),
119: CURRENT_STATUS = decode( x_CURRENT_STATUS, FND_API.G_MISS_CHAR,CURRENT_STATUS,x_CURRENT_STATUS),
120: PARTY_ID = decode( x_PARTY_ID, FND_API.G_MISS_NUM,PARTY_ID,x_PARTY_ID),
121: EXPIRES_ON_DATE = decode( x_EXPIRES_ON_DATE, FND_API.G_MISS_DATE,EXPIRES_ON_DATE,x_EXPIRES_ON_DATE),
122: GRADE = decode( x_GRADE, FND_API.G_MISS_CHAR,GRADE,x_GRADE),
123: ISSUED_BY_AUTHORITY = decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR,ISSUED_BY_AUTHORITY,x_ISSUED_BY_AUTHORITY),
124: ISSUED_ON_DATE = decode( x_ISSUED_ON_DATE, FND_API.G_MISS_DATE,ISSUED_ON_DATE,x_ISSUED_ON_DATE),
125: -- Bug 3032780
126: /*

Line 123: ISSUED_BY_AUTHORITY = decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR,ISSUED_BY_AUTHORITY,x_ISSUED_BY_AUTHORITY),

119: CURRENT_STATUS = decode( x_CURRENT_STATUS, FND_API.G_MISS_CHAR,CURRENT_STATUS,x_CURRENT_STATUS),
120: PARTY_ID = decode( x_PARTY_ID, FND_API.G_MISS_NUM,PARTY_ID,x_PARTY_ID),
121: EXPIRES_ON_DATE = decode( x_EXPIRES_ON_DATE, FND_API.G_MISS_DATE,EXPIRES_ON_DATE,x_EXPIRES_ON_DATE),
122: GRADE = decode( x_GRADE, FND_API.G_MISS_CHAR,GRADE,x_GRADE),
123: ISSUED_BY_AUTHORITY = decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR,ISSUED_BY_AUTHORITY,x_ISSUED_BY_AUTHORITY),
124: ISSUED_ON_DATE = decode( x_ISSUED_ON_DATE, FND_API.G_MISS_DATE,ISSUED_ON_DATE,x_ISSUED_ON_DATE),
125: -- Bug 3032780
126: /*
127: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),

Line 124: ISSUED_ON_DATE = decode( x_ISSUED_ON_DATE, FND_API.G_MISS_DATE,ISSUED_ON_DATE,x_ISSUED_ON_DATE),

120: PARTY_ID = decode( x_PARTY_ID, FND_API.G_MISS_NUM,PARTY_ID,x_PARTY_ID),
121: EXPIRES_ON_DATE = decode( x_EXPIRES_ON_DATE, FND_API.G_MISS_DATE,EXPIRES_ON_DATE,x_EXPIRES_ON_DATE),
122: GRADE = decode( x_GRADE, FND_API.G_MISS_CHAR,GRADE,x_GRADE),
123: ISSUED_BY_AUTHORITY = decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR,ISSUED_BY_AUTHORITY,x_ISSUED_BY_AUTHORITY),
124: ISSUED_ON_DATE = decode( x_ISSUED_ON_DATE, FND_API.G_MISS_DATE,ISSUED_ON_DATE,x_ISSUED_ON_DATE),
125: -- Bug 3032780
126: /*
127: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
128: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),

Line 127: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),

123: ISSUED_BY_AUTHORITY = decode( x_ISSUED_BY_AUTHORITY, FND_API.G_MISS_CHAR,ISSUED_BY_AUTHORITY,x_ISSUED_BY_AUTHORITY),
124: ISSUED_ON_DATE = decode( x_ISSUED_ON_DATE, FND_API.G_MISS_DATE,ISSUED_ON_DATE,x_ISSUED_ON_DATE),
125: -- Bug 3032780
126: /*
127: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
128: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
129: */
130: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
131: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),

Line 128: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),

124: ISSUED_ON_DATE = decode( x_ISSUED_ON_DATE, FND_API.G_MISS_DATE,ISSUED_ON_DATE,x_ISSUED_ON_DATE),
125: -- Bug 3032780
126: /*
127: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
128: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
129: */
130: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
131: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
132: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),

Line 130: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),

126: /*
127: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
128: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
129: */
130: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
131: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
132: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
133: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
134: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),

Line 131: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),

127: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
128: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
129: */
130: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
131: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
132: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
133: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
134: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
135: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),

Line 132: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),

128: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
129: */
130: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
131: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
132: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
133: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
134: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
135: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
136: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),

Line 133: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),

129: */
130: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
131: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
132: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
133: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
134: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
135: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
136: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
137: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE),

Line 134: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),

130: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
131: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
132: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
133: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
134: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
135: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
136: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
137: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE),
138:

Line 135: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),

131: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
132: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
133: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
134: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
135: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
136: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
137: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE),
138:
139: STATUS = decode( x_STATUS,FND_API.G_MISS_char,STATUS,x_STATUS)

Line 136: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),

132: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
133: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
134: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
135: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
136: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
137: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE),
138:
139: STATUS = decode( x_STATUS,FND_API.G_MISS_char,STATUS,x_STATUS)
140: where rowid = X_RowId;

Line 137: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE),

133: REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
134: PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
135: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
136: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
137: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE),
138:
139: STATUS = decode( x_STATUS,FND_API.G_MISS_char,STATUS,x_STATUS)
140: where rowid = X_RowId;
141:

Line 139: STATUS = decode( x_STATUS,FND_API.G_MISS_char,STATUS,x_STATUS)

135: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
136: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
137: WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE),
138:
139: STATUS = decode( x_STATUS,FND_API.G_MISS_char,STATUS,x_STATUS)
140: where rowid = X_RowId;
141:
142: If (SQL%NOTFOUND) then
143: RAISE NO_DATA_FOUND;