eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CODE_ASSIGNMENTS_PKG dependencies on FND_API

Line 65: DECODE( X_CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, NULL, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, X_CODE_ASSIGNMENT_ID ),

61: APPLICATION_ID,
62: ACTUAL_CONTENT_SOURCE
63: )
64: VALUES (
65: DECODE( X_CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, NULL, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, X_CODE_ASSIGNMENT_ID ),
66: DECODE( X_OWNER_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_NAME ),
67: DECODE( X_OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),
68: DECODE( X_OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),
69: DECODE( X_OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),

Line 66: DECODE( X_OWNER_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_NAME ),

62: ACTUAL_CONTENT_SOURCE
63: )
64: VALUES (
65: DECODE( X_CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, NULL, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, X_CODE_ASSIGNMENT_ID ),
66: DECODE( X_OWNER_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_NAME ),
67: DECODE( X_OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),
68: DECODE( X_OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),
69: DECODE( X_OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),
70: DECODE( X_OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),

Line 67: DECODE( X_OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),

63: )
64: VALUES (
65: DECODE( X_CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, NULL, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, X_CODE_ASSIGNMENT_ID ),
66: DECODE( X_OWNER_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_NAME ),
67: DECODE( X_OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),
68: DECODE( X_OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),
69: DECODE( X_OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),
70: DECODE( X_OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),
71: DECODE( X_OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),

Line 68: DECODE( X_OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),

64: VALUES (
65: DECODE( X_CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, NULL, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, X_CODE_ASSIGNMENT_ID ),
66: DECODE( X_OWNER_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_NAME ),
67: DECODE( X_OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),
68: DECODE( X_OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),
69: DECODE( X_OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),
70: DECODE( X_OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),
71: DECODE( X_OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),
72: DECODE( X_OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),

Line 69: DECODE( X_OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),

65: DECODE( X_CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, NULL, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, X_CODE_ASSIGNMENT_ID ),
66: DECODE( X_OWNER_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_NAME ),
67: DECODE( X_OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),
68: DECODE( X_OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),
69: DECODE( X_OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),
70: DECODE( X_OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),
71: DECODE( X_OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),
72: DECODE( X_OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),
73: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),

Line 70: DECODE( X_OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),

66: DECODE( X_OWNER_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_NAME ),
67: DECODE( X_OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),
68: DECODE( X_OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),
69: DECODE( X_OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),
70: DECODE( X_OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),
71: DECODE( X_OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),
72: DECODE( X_OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),
73: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
74: DECODE( X_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),

Line 71: DECODE( X_OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),

67: DECODE( X_OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),
68: DECODE( X_OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),
69: DECODE( X_OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),
70: DECODE( X_OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),
71: DECODE( X_OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),
72: DECODE( X_OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),
73: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
74: DECODE( X_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
75: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, X_PRIMARY_FLAG ),

Line 72: DECODE( X_OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),

68: DECODE( X_OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),
69: DECODE( X_OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),
70: DECODE( X_OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),
71: DECODE( X_OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),
72: DECODE( X_OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),
73: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
74: DECODE( X_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
75: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, X_PRIMARY_FLAG ),
76: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE, NULL, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),

Line 73: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),

69: DECODE( X_OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),
70: DECODE( X_OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),
71: DECODE( X_OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),
72: DECODE( X_OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),
73: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
74: DECODE( X_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
75: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, X_PRIMARY_FLAG ),
76: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE, NULL, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),
77: DECODE( TO_CHAR(X_START_DATE_ACTIVE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE( NULL ), X_START_DATE_ACTIVE ),

Line 74: DECODE( X_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),

70: DECODE( X_OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),
71: DECODE( X_OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),
72: DECODE( X_OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),
73: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
74: DECODE( X_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
75: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, X_PRIMARY_FLAG ),
76: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE, NULL, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),
77: DECODE( TO_CHAR(X_START_DATE_ACTIVE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE( NULL ), X_START_DATE_ACTIVE ),
78: DECODE( TO_CHAR(X_END_DATE_ACTIVE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE( NULL ), X_END_DATE_ACTIVE ),

Line 75: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, X_PRIMARY_FLAG ),

71: DECODE( X_OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),
72: DECODE( X_OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),
73: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
74: DECODE( X_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
75: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, X_PRIMARY_FLAG ),
76: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE, NULL, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),
77: DECODE( TO_CHAR(X_START_DATE_ACTIVE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE( NULL ), X_START_DATE_ACTIVE ),
78: DECODE( TO_CHAR(X_END_DATE_ACTIVE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE( NULL ), X_END_DATE_ACTIVE ),
79: HZ_UTILITY_V2PUB.CREATED_BY,

Line 76: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE, NULL, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),

72: DECODE( X_OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),
73: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
74: DECODE( X_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
75: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, X_PRIMARY_FLAG ),
76: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE, NULL, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),
77: DECODE( TO_CHAR(X_START_DATE_ACTIVE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE( NULL ), X_START_DATE_ACTIVE ),
78: DECODE( TO_CHAR(X_END_DATE_ACTIVE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE( NULL ), X_END_DATE_ACTIVE ),
79: HZ_UTILITY_V2PUB.CREATED_BY,
80: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 77: DECODE( TO_CHAR(X_START_DATE_ACTIVE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE( NULL ), X_START_DATE_ACTIVE ),

73: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
74: DECODE( X_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
75: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, X_PRIMARY_FLAG ),
76: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE, NULL, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),
77: DECODE( TO_CHAR(X_START_DATE_ACTIVE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE( NULL ), X_START_DATE_ACTIVE ),
78: DECODE( TO_CHAR(X_END_DATE_ACTIVE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE( NULL ), X_END_DATE_ACTIVE ),
79: HZ_UTILITY_V2PUB.CREATED_BY,
80: HZ_UTILITY_V2PUB.CREATION_DATE,
81: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 78: DECODE( TO_CHAR(X_END_DATE_ACTIVE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE( NULL ), X_END_DATE_ACTIVE ),

74: DECODE( X_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
75: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, X_PRIMARY_FLAG ),
76: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE, NULL, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),
77: DECODE( TO_CHAR(X_START_DATE_ACTIVE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE( NULL ), X_START_DATE_ACTIVE ),
78: DECODE( TO_CHAR(X_END_DATE_ACTIVE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE( NULL ), X_END_DATE_ACTIVE ),
79: HZ_UTILITY_V2PUB.CREATED_BY,
80: HZ_UTILITY_V2PUB.CREATION_DATE,
81: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
82: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 84: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),

80: HZ_UTILITY_V2PUB.CREATION_DATE,
81: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
82: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
83: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
84: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
85: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
86: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
87: DECODE( X_RANK, FND_API.G_MISS_NUM, NULL, X_RANK ),
88: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),

Line 85: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

81: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
82: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
83: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
84: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
85: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
86: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
87: DECODE( X_RANK, FND_API.G_MISS_NUM, NULL, X_RANK ),
88: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
89: DECODE( X_ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,

Line 86: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

82: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
83: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
84: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
85: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
86: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
87: DECODE( X_RANK, FND_API.G_MISS_NUM, NULL, X_RANK ),
88: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
89: DECODE( X_ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
90: NULL, G_MISS_CONTENT_SOURCE_TYPE,

Line 87: DECODE( X_RANK, FND_API.G_MISS_NUM, NULL, X_RANK ),

83: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
84: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
85: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
86: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
87: DECODE( X_RANK, FND_API.G_MISS_NUM, NULL, X_RANK ),
88: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
89: DECODE( X_ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
90: NULL, G_MISS_CONTENT_SOURCE_TYPE,
91: X_ACTUAL_CONTENT_SOURCE)

Line 88: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),

84: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
85: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
86: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
87: DECODE( X_RANK, FND_API.G_MISS_NUM, NULL, X_RANK ),
88: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
89: DECODE( X_ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
90: NULL, G_MISS_CONTENT_SOURCE_TYPE,
91: X_ACTUAL_CONTENT_SOURCE)
92: ) RETURNING

Line 89: DECODE( X_ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,

85: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
86: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
87: DECODE( X_RANK, FND_API.G_MISS_NUM, NULL, X_RANK ),
88: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
89: DECODE( X_ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
90: NULL, G_MISS_CONTENT_SOURCE_TYPE,
91: X_ACTUAL_CONTENT_SOURCE)
92: ) RETURNING
93: CODE_ASSIGNMENT_ID

Line 159: CODE_ASSIGNMENT_ID = DECODE( X_CODE_ASSIGNMENT_ID, NULL, CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, X_CODE_ASSIGNMENT_ID ),

155:
156: BEGIN
157:
158: UPDATE HZ_CODE_ASSIGNMENTS SET
159: CODE_ASSIGNMENT_ID = DECODE( X_CODE_ASSIGNMENT_ID, NULL, CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, X_CODE_ASSIGNMENT_ID ),
160: OWNER_TABLE_NAME = DECODE( X_OWNER_TABLE_NAME, NULL, OWNER_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_NAME ),
161: OWNER_TABLE_ID = DECODE( X_OWNER_TABLE_ID, NULL, OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),
162: OWNER_TABLE_KEY_1 = DECODE( X_OWNER_TABLE_KEY_1, NULL, OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),
163: OWNER_TABLE_KEY_2 = DECODE( X_OWNER_TABLE_KEY_2, NULL, OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),

Line 160: OWNER_TABLE_NAME = DECODE( X_OWNER_TABLE_NAME, NULL, OWNER_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_NAME ),

156: BEGIN
157:
158: UPDATE HZ_CODE_ASSIGNMENTS SET
159: CODE_ASSIGNMENT_ID = DECODE( X_CODE_ASSIGNMENT_ID, NULL, CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, X_CODE_ASSIGNMENT_ID ),
160: OWNER_TABLE_NAME = DECODE( X_OWNER_TABLE_NAME, NULL, OWNER_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_NAME ),
161: OWNER_TABLE_ID = DECODE( X_OWNER_TABLE_ID, NULL, OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),
162: OWNER_TABLE_KEY_1 = DECODE( X_OWNER_TABLE_KEY_1, NULL, OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),
163: OWNER_TABLE_KEY_2 = DECODE( X_OWNER_TABLE_KEY_2, NULL, OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),
164: OWNER_TABLE_KEY_3 = DECODE( X_OWNER_TABLE_KEY_3, NULL, OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),

Line 161: OWNER_TABLE_ID = DECODE( X_OWNER_TABLE_ID, NULL, OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),

157:
158: UPDATE HZ_CODE_ASSIGNMENTS SET
159: CODE_ASSIGNMENT_ID = DECODE( X_CODE_ASSIGNMENT_ID, NULL, CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, X_CODE_ASSIGNMENT_ID ),
160: OWNER_TABLE_NAME = DECODE( X_OWNER_TABLE_NAME, NULL, OWNER_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_NAME ),
161: OWNER_TABLE_ID = DECODE( X_OWNER_TABLE_ID, NULL, OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),
162: OWNER_TABLE_KEY_1 = DECODE( X_OWNER_TABLE_KEY_1, NULL, OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),
163: OWNER_TABLE_KEY_2 = DECODE( X_OWNER_TABLE_KEY_2, NULL, OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),
164: OWNER_TABLE_KEY_3 = DECODE( X_OWNER_TABLE_KEY_3, NULL, OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),
165: OWNER_TABLE_KEY_4 = DECODE( X_OWNER_TABLE_KEY_4, NULL, OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),

Line 162: OWNER_TABLE_KEY_1 = DECODE( X_OWNER_TABLE_KEY_1, NULL, OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),

158: UPDATE HZ_CODE_ASSIGNMENTS SET
159: CODE_ASSIGNMENT_ID = DECODE( X_CODE_ASSIGNMENT_ID, NULL, CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, X_CODE_ASSIGNMENT_ID ),
160: OWNER_TABLE_NAME = DECODE( X_OWNER_TABLE_NAME, NULL, OWNER_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_NAME ),
161: OWNER_TABLE_ID = DECODE( X_OWNER_TABLE_ID, NULL, OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),
162: OWNER_TABLE_KEY_1 = DECODE( X_OWNER_TABLE_KEY_1, NULL, OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),
163: OWNER_TABLE_KEY_2 = DECODE( X_OWNER_TABLE_KEY_2, NULL, OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),
164: OWNER_TABLE_KEY_3 = DECODE( X_OWNER_TABLE_KEY_3, NULL, OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),
165: OWNER_TABLE_KEY_4 = DECODE( X_OWNER_TABLE_KEY_4, NULL, OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),
166: OWNER_TABLE_KEY_5 = DECODE( X_OWNER_TABLE_KEY_5, NULL, OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),

Line 163: OWNER_TABLE_KEY_2 = DECODE( X_OWNER_TABLE_KEY_2, NULL, OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),

159: CODE_ASSIGNMENT_ID = DECODE( X_CODE_ASSIGNMENT_ID, NULL, CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, X_CODE_ASSIGNMENT_ID ),
160: OWNER_TABLE_NAME = DECODE( X_OWNER_TABLE_NAME, NULL, OWNER_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_NAME ),
161: OWNER_TABLE_ID = DECODE( X_OWNER_TABLE_ID, NULL, OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),
162: OWNER_TABLE_KEY_1 = DECODE( X_OWNER_TABLE_KEY_1, NULL, OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),
163: OWNER_TABLE_KEY_2 = DECODE( X_OWNER_TABLE_KEY_2, NULL, OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),
164: OWNER_TABLE_KEY_3 = DECODE( X_OWNER_TABLE_KEY_3, NULL, OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),
165: OWNER_TABLE_KEY_4 = DECODE( X_OWNER_TABLE_KEY_4, NULL, OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),
166: OWNER_TABLE_KEY_5 = DECODE( X_OWNER_TABLE_KEY_5, NULL, OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),
167: CLASS_CATEGORY = DECODE( X_CLASS_CATEGORY, NULL, CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),

Line 164: OWNER_TABLE_KEY_3 = DECODE( X_OWNER_TABLE_KEY_3, NULL, OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),

160: OWNER_TABLE_NAME = DECODE( X_OWNER_TABLE_NAME, NULL, OWNER_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_NAME ),
161: OWNER_TABLE_ID = DECODE( X_OWNER_TABLE_ID, NULL, OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),
162: OWNER_TABLE_KEY_1 = DECODE( X_OWNER_TABLE_KEY_1, NULL, OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),
163: OWNER_TABLE_KEY_2 = DECODE( X_OWNER_TABLE_KEY_2, NULL, OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),
164: OWNER_TABLE_KEY_3 = DECODE( X_OWNER_TABLE_KEY_3, NULL, OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),
165: OWNER_TABLE_KEY_4 = DECODE( X_OWNER_TABLE_KEY_4, NULL, OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),
166: OWNER_TABLE_KEY_5 = DECODE( X_OWNER_TABLE_KEY_5, NULL, OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),
167: CLASS_CATEGORY = DECODE( X_CLASS_CATEGORY, NULL, CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
168: CLASS_CODE = DECODE( X_CLASS_CODE, NULL, CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),

Line 165: OWNER_TABLE_KEY_4 = DECODE( X_OWNER_TABLE_KEY_4, NULL, OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),

161: OWNER_TABLE_ID = DECODE( X_OWNER_TABLE_ID, NULL, OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),
162: OWNER_TABLE_KEY_1 = DECODE( X_OWNER_TABLE_KEY_1, NULL, OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),
163: OWNER_TABLE_KEY_2 = DECODE( X_OWNER_TABLE_KEY_2, NULL, OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),
164: OWNER_TABLE_KEY_3 = DECODE( X_OWNER_TABLE_KEY_3, NULL, OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),
165: OWNER_TABLE_KEY_4 = DECODE( X_OWNER_TABLE_KEY_4, NULL, OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),
166: OWNER_TABLE_KEY_5 = DECODE( X_OWNER_TABLE_KEY_5, NULL, OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),
167: CLASS_CATEGORY = DECODE( X_CLASS_CATEGORY, NULL, CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
168: CLASS_CODE = DECODE( X_CLASS_CODE, NULL, CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
169: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, X_PRIMARY_FLAG ),

Line 166: OWNER_TABLE_KEY_5 = DECODE( X_OWNER_TABLE_KEY_5, NULL, OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),

162: OWNER_TABLE_KEY_1 = DECODE( X_OWNER_TABLE_KEY_1, NULL, OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),
163: OWNER_TABLE_KEY_2 = DECODE( X_OWNER_TABLE_KEY_2, NULL, OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),
164: OWNER_TABLE_KEY_3 = DECODE( X_OWNER_TABLE_KEY_3, NULL, OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),
165: OWNER_TABLE_KEY_4 = DECODE( X_OWNER_TABLE_KEY_4, NULL, OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),
166: OWNER_TABLE_KEY_5 = DECODE( X_OWNER_TABLE_KEY_5, NULL, OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),
167: CLASS_CATEGORY = DECODE( X_CLASS_CATEGORY, NULL, CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
168: CLASS_CODE = DECODE( X_CLASS_CODE, NULL, CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
169: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, X_PRIMARY_FLAG ),
170: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),

Line 167: CLASS_CATEGORY = DECODE( X_CLASS_CATEGORY, NULL, CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),

163: OWNER_TABLE_KEY_2 = DECODE( X_OWNER_TABLE_KEY_2, NULL, OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),
164: OWNER_TABLE_KEY_3 = DECODE( X_OWNER_TABLE_KEY_3, NULL, OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),
165: OWNER_TABLE_KEY_4 = DECODE( X_OWNER_TABLE_KEY_4, NULL, OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),
166: OWNER_TABLE_KEY_5 = DECODE( X_OWNER_TABLE_KEY_5, NULL, OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),
167: CLASS_CATEGORY = DECODE( X_CLASS_CATEGORY, NULL, CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
168: CLASS_CODE = DECODE( X_CLASS_CODE, NULL, CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
169: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, X_PRIMARY_FLAG ),
170: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),
171: START_DATE_ACTIVE = DECODE( TO_CHAR(X_START_DATE_ACTIVE,'DD/MM/RRRR'), NULL, START_DATE_ACTIVE, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), NULL, X_START_DATE_ACTIVE ),

Line 168: CLASS_CODE = DECODE( X_CLASS_CODE, NULL, CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),

164: OWNER_TABLE_KEY_3 = DECODE( X_OWNER_TABLE_KEY_3, NULL, OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_3 ),
165: OWNER_TABLE_KEY_4 = DECODE( X_OWNER_TABLE_KEY_4, NULL, OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),
166: OWNER_TABLE_KEY_5 = DECODE( X_OWNER_TABLE_KEY_5, NULL, OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),
167: CLASS_CATEGORY = DECODE( X_CLASS_CATEGORY, NULL, CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
168: CLASS_CODE = DECODE( X_CLASS_CODE, NULL, CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
169: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, X_PRIMARY_FLAG ),
170: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),
171: START_DATE_ACTIVE = DECODE( TO_CHAR(X_START_DATE_ACTIVE,'DD/MM/RRRR'), NULL, START_DATE_ACTIVE, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), NULL, X_START_DATE_ACTIVE ),
172: END_DATE_ACTIVE = DECODE( TO_CHAR(X_END_DATE_ACTIVE,'DD/MM/RRRR'), NULL, END_DATE_ACTIVE, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), NULL, X_END_DATE_ACTIVE ),

Line 169: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, X_PRIMARY_FLAG ),

165: OWNER_TABLE_KEY_4 = DECODE( X_OWNER_TABLE_KEY_4, NULL, OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_4 ),
166: OWNER_TABLE_KEY_5 = DECODE( X_OWNER_TABLE_KEY_5, NULL, OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),
167: CLASS_CATEGORY = DECODE( X_CLASS_CATEGORY, NULL, CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
168: CLASS_CODE = DECODE( X_CLASS_CODE, NULL, CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
169: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, X_PRIMARY_FLAG ),
170: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),
171: START_DATE_ACTIVE = DECODE( TO_CHAR(X_START_DATE_ACTIVE,'DD/MM/RRRR'), NULL, START_DATE_ACTIVE, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), NULL, X_START_DATE_ACTIVE ),
172: END_DATE_ACTIVE = DECODE( TO_CHAR(X_END_DATE_ACTIVE,'DD/MM/RRRR'), NULL, END_DATE_ACTIVE, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), NULL, X_END_DATE_ACTIVE ),
173: CREATED_BY = CREATED_BY,

Line 170: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),

166: OWNER_TABLE_KEY_5 = DECODE( X_OWNER_TABLE_KEY_5, NULL, OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_5 ),
167: CLASS_CATEGORY = DECODE( X_CLASS_CATEGORY, NULL, CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
168: CLASS_CODE = DECODE( X_CLASS_CODE, NULL, CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
169: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, X_PRIMARY_FLAG ),
170: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),
171: START_DATE_ACTIVE = DECODE( TO_CHAR(X_START_DATE_ACTIVE,'DD/MM/RRRR'), NULL, START_DATE_ACTIVE, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), NULL, X_START_DATE_ACTIVE ),
172: END_DATE_ACTIVE = DECODE( TO_CHAR(X_END_DATE_ACTIVE,'DD/MM/RRRR'), NULL, END_DATE_ACTIVE, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), NULL, X_END_DATE_ACTIVE ),
173: CREATED_BY = CREATED_BY,
174: CREATION_DATE = CREATION_DATE,

Line 171: START_DATE_ACTIVE = DECODE( TO_CHAR(X_START_DATE_ACTIVE,'DD/MM/RRRR'), NULL, START_DATE_ACTIVE, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), NULL, X_START_DATE_ACTIVE ),

167: CLASS_CATEGORY = DECODE( X_CLASS_CATEGORY, NULL, CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
168: CLASS_CODE = DECODE( X_CLASS_CODE, NULL, CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
169: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, X_PRIMARY_FLAG ),
170: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),
171: START_DATE_ACTIVE = DECODE( TO_CHAR(X_START_DATE_ACTIVE,'DD/MM/RRRR'), NULL, START_DATE_ACTIVE, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), NULL, X_START_DATE_ACTIVE ),
172: END_DATE_ACTIVE = DECODE( TO_CHAR(X_END_DATE_ACTIVE,'DD/MM/RRRR'), NULL, END_DATE_ACTIVE, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), NULL, X_END_DATE_ACTIVE ),
173: CREATED_BY = CREATED_BY,
174: CREATION_DATE = CREATION_DATE,
175: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 172: END_DATE_ACTIVE = DECODE( TO_CHAR(X_END_DATE_ACTIVE,'DD/MM/RRRR'), NULL, END_DATE_ACTIVE, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), NULL, X_END_DATE_ACTIVE ),

168: CLASS_CODE = DECODE( X_CLASS_CODE, NULL, CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
169: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, X_PRIMARY_FLAG ),
170: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),
171: START_DATE_ACTIVE = DECODE( TO_CHAR(X_START_DATE_ACTIVE,'DD/MM/RRRR'), NULL, START_DATE_ACTIVE, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), NULL, X_START_DATE_ACTIVE ),
172: END_DATE_ACTIVE = DECODE( TO_CHAR(X_END_DATE_ACTIVE,'DD/MM/RRRR'), NULL, END_DATE_ACTIVE, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), NULL, X_END_DATE_ACTIVE ),
173: CREATED_BY = CREATED_BY,
174: CREATION_DATE = CREATION_DATE,
175: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
176: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 178: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, NULL, X_STATUS ),

174: CREATION_DATE = CREATION_DATE,
175: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
176: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
177: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
178: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, NULL, X_STATUS ),
179: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
180: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
181: RANK = DECODE( X_RANK, NULL, RANK, FND_API.G_MISS_NUM, NULL, X_RANK ),
182: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),

Line 179: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

175: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
176: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
177: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
178: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, NULL, X_STATUS ),
179: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
180: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
181: RANK = DECODE( X_RANK, NULL, RANK, FND_API.G_MISS_NUM, NULL, X_RANK ),
182: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
183: -- Bug 4693719 : Allow update to ACS

Line 180: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

176: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
177: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
178: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, NULL, X_STATUS ),
179: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
180: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
181: RANK = DECODE( X_RANK, NULL, RANK, FND_API.G_MISS_NUM, NULL, X_RANK ),
182: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
183: -- Bug 4693719 : Allow update to ACS
184: ACTUAL_CONTENT_SOURCE = DECODE ( X_ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,

Line 181: RANK = DECODE( X_RANK, NULL, RANK, FND_API.G_MISS_NUM, NULL, X_RANK ),

177: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
178: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, NULL, X_STATUS ),
179: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
180: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
181: RANK = DECODE( X_RANK, NULL, RANK, FND_API.G_MISS_NUM, NULL, X_RANK ),
182: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
183: -- Bug 4693719 : Allow update to ACS
184: ACTUAL_CONTENT_SOURCE = DECODE ( X_ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
185: NULL, ACTUAL_CONTENT_SOURCE,

Line 182: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),

178: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, NULL, X_STATUS ),
179: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
180: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
181: RANK = DECODE( X_RANK, NULL, RANK, FND_API.G_MISS_NUM, NULL, X_RANK ),
182: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
183: -- Bug 4693719 : Allow update to ACS
184: ACTUAL_CONTENT_SOURCE = DECODE ( X_ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
185: NULL, ACTUAL_CONTENT_SOURCE,
186: X_ACTUAL_CONTENT_SOURCE)

Line 184: ACTUAL_CONTENT_SOURCE = DECODE ( X_ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,

180: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
181: RANK = DECODE( X_RANK, NULL, RANK, FND_API.G_MISS_NUM, NULL, X_RANK ),
182: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
183: -- Bug 4693719 : Allow update to ACS
184: ACTUAL_CONTENT_SOURCE = DECODE ( X_ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
185: NULL, ACTUAL_CONTENT_SOURCE,
186: X_ACTUAL_CONTENT_SOURCE)
187: WHERE ROWID = X_RowId;
188:

Line 353: NVL( CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM ),

349:
350: BEGIN
351:
352: SELECT
353: NVL( CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM ),
354: NVL( OWNER_TABLE_NAME, FND_API.G_MISS_CHAR ),
355: NVL( OWNER_TABLE_ID, FND_API.G_MISS_NUM ),
356: NVL( OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR ),
357: NVL( OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR ),

Line 354: NVL( OWNER_TABLE_NAME, FND_API.G_MISS_CHAR ),

350: BEGIN
351:
352: SELECT
353: NVL( CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM ),
354: NVL( OWNER_TABLE_NAME, FND_API.G_MISS_CHAR ),
355: NVL( OWNER_TABLE_ID, FND_API.G_MISS_NUM ),
356: NVL( OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR ),
357: NVL( OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR ),
358: NVL( OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR ),

Line 355: NVL( OWNER_TABLE_ID, FND_API.G_MISS_NUM ),

351:
352: SELECT
353: NVL( CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM ),
354: NVL( OWNER_TABLE_NAME, FND_API.G_MISS_CHAR ),
355: NVL( OWNER_TABLE_ID, FND_API.G_MISS_NUM ),
356: NVL( OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR ),
357: NVL( OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR ),
358: NVL( OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR ),
359: NVL( OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR ),

Line 356: NVL( OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR ),

352: SELECT
353: NVL( CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM ),
354: NVL( OWNER_TABLE_NAME, FND_API.G_MISS_CHAR ),
355: NVL( OWNER_TABLE_ID, FND_API.G_MISS_NUM ),
356: NVL( OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR ),
357: NVL( OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR ),
358: NVL( OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR ),
359: NVL( OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR ),
360: NVL( OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR ),

Line 357: NVL( OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR ),

353: NVL( CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM ),
354: NVL( OWNER_TABLE_NAME, FND_API.G_MISS_CHAR ),
355: NVL( OWNER_TABLE_ID, FND_API.G_MISS_NUM ),
356: NVL( OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR ),
357: NVL( OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR ),
358: NVL( OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR ),
359: NVL( OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR ),
360: NVL( OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR ),
361: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),

Line 358: NVL( OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR ),

354: NVL( OWNER_TABLE_NAME, FND_API.G_MISS_CHAR ),
355: NVL( OWNER_TABLE_ID, FND_API.G_MISS_NUM ),
356: NVL( OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR ),
357: NVL( OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR ),
358: NVL( OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR ),
359: NVL( OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR ),
360: NVL( OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR ),
361: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
362: NVL( CLASS_CODE, FND_API.G_MISS_CHAR ),

Line 359: NVL( OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR ),

355: NVL( OWNER_TABLE_ID, FND_API.G_MISS_NUM ),
356: NVL( OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR ),
357: NVL( OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR ),
358: NVL( OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR ),
359: NVL( OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR ),
360: NVL( OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR ),
361: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
362: NVL( CLASS_CODE, FND_API.G_MISS_CHAR ),
363: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),

Line 360: NVL( OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR ),

356: NVL( OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR ),
357: NVL( OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR ),
358: NVL( OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR ),
359: NVL( OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR ),
360: NVL( OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR ),
361: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
362: NVL( CLASS_CODE, FND_API.G_MISS_CHAR ),
363: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
364: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),

Line 361: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),

357: NVL( OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR ),
358: NVL( OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR ),
359: NVL( OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR ),
360: NVL( OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR ),
361: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
362: NVL( CLASS_CODE, FND_API.G_MISS_CHAR ),
363: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
364: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),
365: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),

Line 362: NVL( CLASS_CODE, FND_API.G_MISS_CHAR ),

358: NVL( OWNER_TABLE_KEY_3, FND_API.G_MISS_CHAR ),
359: NVL( OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR ),
360: NVL( OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR ),
361: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
362: NVL( CLASS_CODE, FND_API.G_MISS_CHAR ),
363: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
364: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),
365: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
366: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),

Line 363: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),

359: NVL( OWNER_TABLE_KEY_4, FND_API.G_MISS_CHAR ),
360: NVL( OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR ),
361: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
362: NVL( CLASS_CODE, FND_API.G_MISS_CHAR ),
363: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
364: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),
365: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
366: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),
367: NVL( STATUS, FND_API.G_MISS_CHAR ),

Line 364: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),

360: NVL( OWNER_TABLE_KEY_5, FND_API.G_MISS_CHAR ),
361: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
362: NVL( CLASS_CODE, FND_API.G_MISS_CHAR ),
363: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
364: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),
365: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
366: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),
367: NVL( STATUS, FND_API.G_MISS_CHAR ),
368: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

Line 365: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),

361: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
362: NVL( CLASS_CODE, FND_API.G_MISS_CHAR ),
363: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
364: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),
365: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
366: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),
367: NVL( STATUS, FND_API.G_MISS_CHAR ),
368: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
369: NVL( RANK, FND_API.G_MISS_NUM ),

Line 366: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),

362: NVL( CLASS_CODE, FND_API.G_MISS_CHAR ),
363: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
364: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),
365: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
366: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),
367: NVL( STATUS, FND_API.G_MISS_CHAR ),
368: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
369: NVL( RANK, FND_API.G_MISS_NUM ),
370: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),

Line 367: NVL( STATUS, FND_API.G_MISS_CHAR ),

363: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
364: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),
365: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
366: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),
367: NVL( STATUS, FND_API.G_MISS_CHAR ),
368: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
369: NVL( RANK, FND_API.G_MISS_NUM ),
370: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
371: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR)

Line 368: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

364: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),
365: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
366: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),
367: NVL( STATUS, FND_API.G_MISS_CHAR ),
368: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
369: NVL( RANK, FND_API.G_MISS_NUM ),
370: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
371: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR)
372: INTO

Line 369: NVL( RANK, FND_API.G_MISS_NUM ),

365: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
366: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),
367: NVL( STATUS, FND_API.G_MISS_CHAR ),
368: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
369: NVL( RANK, FND_API.G_MISS_NUM ),
370: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
371: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR)
372: INTO
373: X_CODE_ASSIGNMENT_ID,

Line 370: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),

366: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),
367: NVL( STATUS, FND_API.G_MISS_CHAR ),
368: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
369: NVL( RANK, FND_API.G_MISS_NUM ),
370: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
371: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR)
372: INTO
373: X_CODE_ASSIGNMENT_ID,
374: X_OWNER_TABLE_NAME,

Line 371: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR)

367: NVL( STATUS, FND_API.G_MISS_CHAR ),
368: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
369: NVL( RANK, FND_API.G_MISS_NUM ),
370: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
371: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR)
372: INTO
373: X_CODE_ASSIGNMENT_ID,
374: X_OWNER_TABLE_NAME,
375: X_OWNER_TABLE_ID,

Line 401: RAISE FND_API.G_EXC_ERROR;

397: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
398: FND_MESSAGE.SET_TOKEN( 'RECORD', 'code_assignment_rec');
399: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CODE_ASSIGNMENT_ID ) );
400: FND_MSG_PUB.ADD;
401: RAISE FND_API.G_EXC_ERROR;
402:
403: END Select_Row;
404:
405: PROCEDURE Delete_Row (