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_ROLE_RESPONSIBILITY_PKG dependencies on FND_API

Line 35: IF X_RESPONSIBILITY_ID = FND_API.G_MISS_NUM THEN

31: l_success VARCHAR2(1) := 'N';
32:
33: BEGIN
34:
35: IF X_RESPONSIBILITY_ID = FND_API.G_MISS_NUM THEN
36: X_RESPONSIBILITY_ID := NULL;
37: END IF;
38:
39: WHILE l_success = 'N' LOOP

Line 77: DECODE( X_RESPONSIBILITY_ID, FND_API.G_MISS_NUM, HZ_ROLE_RESPONSIBILITY_S.NEXTVAL, NULL, HZ_ROLE_RESPONSIBILITY_S.NEXTVAL, X_RESPONSIBILITY_ID ),

73: CREATED_BY_MODULE,
74: APPLICATION_ID
75: )
76: VALUES (
77: DECODE( X_RESPONSIBILITY_ID, FND_API.G_MISS_NUM, HZ_ROLE_RESPONSIBILITY_S.NEXTVAL, NULL, HZ_ROLE_RESPONSIBILITY_S.NEXTVAL, X_RESPONSIBILITY_ID ),
78: DECODE( X_CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ROLE_ID ),
79: DECODE( X_RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR, NULL, X_RESPONSIBILITY_TYPE ),
80: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
81: HZ_UTILITY_V2PUB.CREATED_BY,

Line 78: DECODE( X_CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ROLE_ID ),

74: APPLICATION_ID
75: )
76: VALUES (
77: DECODE( X_RESPONSIBILITY_ID, FND_API.G_MISS_NUM, HZ_ROLE_RESPONSIBILITY_S.NEXTVAL, NULL, HZ_ROLE_RESPONSIBILITY_S.NEXTVAL, X_RESPONSIBILITY_ID ),
78: DECODE( X_CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ROLE_ID ),
79: DECODE( X_RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR, NULL, X_RESPONSIBILITY_TYPE ),
80: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
81: HZ_UTILITY_V2PUB.CREATED_BY,
82: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 79: DECODE( X_RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR, NULL, X_RESPONSIBILITY_TYPE ),

75: )
76: VALUES (
77: DECODE( X_RESPONSIBILITY_ID, FND_API.G_MISS_NUM, HZ_ROLE_RESPONSIBILITY_S.NEXTVAL, NULL, HZ_ROLE_RESPONSIBILITY_S.NEXTVAL, X_RESPONSIBILITY_ID ),
78: DECODE( X_CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ROLE_ID ),
79: DECODE( X_RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR, NULL, X_RESPONSIBILITY_TYPE ),
80: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
81: HZ_UTILITY_V2PUB.CREATED_BY,
82: HZ_UTILITY_V2PUB.CREATION_DATE,
83: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 80: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),

76: VALUES (
77: DECODE( X_RESPONSIBILITY_ID, FND_API.G_MISS_NUM, HZ_ROLE_RESPONSIBILITY_S.NEXTVAL, NULL, HZ_ROLE_RESPONSIBILITY_S.NEXTVAL, X_RESPONSIBILITY_ID ),
78: DECODE( X_CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ROLE_ID ),
79: DECODE( X_RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR, NULL, X_RESPONSIBILITY_TYPE ),
80: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
81: HZ_UTILITY_V2PUB.CREATED_BY,
82: HZ_UTILITY_V2PUB.CREATION_DATE,
83: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
84: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 90: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

86: HZ_UTILITY_V2PUB.REQUEST_ID,
87: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
88: HZ_UTILITY_V2PUB.PROGRAM_ID,
89: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
90: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
91: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
92: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
93: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
94: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),

Line 91: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

87: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
88: HZ_UTILITY_V2PUB.PROGRAM_ID,
89: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
90: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
91: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
92: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
93: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
94: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
95: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),

Line 92: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),

88: HZ_UTILITY_V2PUB.PROGRAM_ID,
89: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
90: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
91: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
92: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
93: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
94: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
95: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
96: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),

Line 93: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),

89: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
90: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
91: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
92: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
93: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
94: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
95: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
96: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
97: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),

Line 94: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),

90: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
91: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
92: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
93: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
94: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
95: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
96: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
97: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
98: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),

Line 95: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),

91: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
92: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
93: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
94: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
95: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
96: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
97: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
98: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
99: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),

Line 96: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),

92: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
93: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
94: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
95: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
96: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
97: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
98: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
99: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
100: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),

Line 97: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),

93: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
94: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
95: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
96: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
97: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
98: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
99: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
100: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
101: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

Line 98: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),

94: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
95: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
96: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
97: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
98: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
99: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
100: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
101: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
102: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

Line 99: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),

95: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
96: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
97: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
98: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
99: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
100: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
101: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
102: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
103: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),

Line 100: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),

96: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
97: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
98: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
99: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
100: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
101: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
102: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
103: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
104: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),

Line 101: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

97: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
98: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
99: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
100: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
101: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
102: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
103: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
104: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
105: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),

Line 102: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

98: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
99: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
100: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
101: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
102: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
103: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
104: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
105: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
106: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), NULL, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

Line 103: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),

99: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
100: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
101: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
102: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
103: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
104: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
105: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
106: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), NULL, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
107: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

Line 104: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),

100: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
101: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
102: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
103: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
104: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
105: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
106: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), NULL, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
107: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
108: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

Line 105: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),

101: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
102: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
103: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
104: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
105: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
106: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), NULL, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
107: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
108: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
109: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

Line 106: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), NULL, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

102: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
103: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
104: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
105: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
106: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), NULL, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
107: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
108: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
109: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
110: ) RETURNING

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

103: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
104: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
105: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
106: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), NULL, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
107: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
108: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
109: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
110: ) RETURNING
111: RESPONSIBILITY_ID

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

104: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
105: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
106: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), NULL, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
107: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
108: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
109: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
110: ) RETURNING
111: RESPONSIBILITY_ID
112: INTO

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

105: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
106: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), NULL, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
107: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
108: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
109: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
110: ) RETURNING
111: RESPONSIBILITY_ID
112: INTO
113: X_RESPONSIBILITY_ID;

Line 181: RESPONSIBILITY_ID = DECODE( X_RESPONSIBILITY_ID, NULL, RESPONSIBILITY_ID, FND_API.G_MISS_NUM, NULL, X_RESPONSIBILITY_ID ),

177:
178: BEGIN
179:
180: UPDATE HZ_ROLE_RESPONSIBILITY SET
181: RESPONSIBILITY_ID = DECODE( X_RESPONSIBILITY_ID, NULL, RESPONSIBILITY_ID, FND_API.G_MISS_NUM, NULL, X_RESPONSIBILITY_ID ),
182: CUST_ACCOUNT_ROLE_ID = DECODE( X_CUST_ACCOUNT_ROLE_ID, NULL, CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ROLE_ID ),
183: RESPONSIBILITY_TYPE = DECODE( X_RESPONSIBILITY_TYPE, NULL, RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR, NULL, X_RESPONSIBILITY_TYPE ),
184: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_FLAG ),
185: CREATED_BY = CREATED_BY,

Line 182: CUST_ACCOUNT_ROLE_ID = DECODE( X_CUST_ACCOUNT_ROLE_ID, NULL, CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ROLE_ID ),

178: BEGIN
179:
180: UPDATE HZ_ROLE_RESPONSIBILITY SET
181: RESPONSIBILITY_ID = DECODE( X_RESPONSIBILITY_ID, NULL, RESPONSIBILITY_ID, FND_API.G_MISS_NUM, NULL, X_RESPONSIBILITY_ID ),
182: CUST_ACCOUNT_ROLE_ID = DECODE( X_CUST_ACCOUNT_ROLE_ID, NULL, CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ROLE_ID ),
183: RESPONSIBILITY_TYPE = DECODE( X_RESPONSIBILITY_TYPE, NULL, RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR, NULL, X_RESPONSIBILITY_TYPE ),
184: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_FLAG ),
185: CREATED_BY = CREATED_BY,
186: CREATION_DATE = CREATION_DATE,

Line 183: RESPONSIBILITY_TYPE = DECODE( X_RESPONSIBILITY_TYPE, NULL, RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR, NULL, X_RESPONSIBILITY_TYPE ),

179:
180: UPDATE HZ_ROLE_RESPONSIBILITY SET
181: RESPONSIBILITY_ID = DECODE( X_RESPONSIBILITY_ID, NULL, RESPONSIBILITY_ID, FND_API.G_MISS_NUM, NULL, X_RESPONSIBILITY_ID ),
182: CUST_ACCOUNT_ROLE_ID = DECODE( X_CUST_ACCOUNT_ROLE_ID, NULL, CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ROLE_ID ),
183: RESPONSIBILITY_TYPE = DECODE( X_RESPONSIBILITY_TYPE, NULL, RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR, NULL, X_RESPONSIBILITY_TYPE ),
184: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_FLAG ),
185: CREATED_BY = CREATED_BY,
186: CREATION_DATE = CREATION_DATE,
187: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 184: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_FLAG ),

180: UPDATE HZ_ROLE_RESPONSIBILITY SET
181: RESPONSIBILITY_ID = DECODE( X_RESPONSIBILITY_ID, NULL, RESPONSIBILITY_ID, FND_API.G_MISS_NUM, NULL, X_RESPONSIBILITY_ID ),
182: CUST_ACCOUNT_ROLE_ID = DECODE( X_CUST_ACCOUNT_ROLE_ID, NULL, CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ROLE_ID ),
183: RESPONSIBILITY_TYPE = DECODE( X_RESPONSIBILITY_TYPE, NULL, RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR, NULL, X_RESPONSIBILITY_TYPE ),
184: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_FLAG ),
185: CREATED_BY = CREATED_BY,
186: CREATION_DATE = CREATION_DATE,
187: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
188: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 194: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

190: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
191: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
192: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
193: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
194: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
195: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
196: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
197: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
198: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),

Line 195: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

191: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
192: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
193: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
194: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
195: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
196: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
197: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
198: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
199: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),

Line 196: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),

192: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
193: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
194: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
195: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
196: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
197: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
198: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
199: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
200: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),

Line 197: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),

193: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
194: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
195: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
196: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
197: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
198: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
199: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
200: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
201: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),

Line 198: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),

194: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
195: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
196: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
197: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
198: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
199: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
200: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
201: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
202: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),

Line 199: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),

195: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
196: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
197: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
198: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
199: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
200: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
201: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
202: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
203: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),

Line 200: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),

196: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
197: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
198: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
199: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
200: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
201: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
202: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
203: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
204: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),

Line 201: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),

197: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
198: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
199: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
200: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
201: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
202: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
203: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
204: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
205: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

Line 202: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),

198: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
199: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
200: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
201: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
202: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
203: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
204: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
205: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
206: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

Line 203: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),

199: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
200: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
201: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
202: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
203: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
204: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
205: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
206: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
207: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),

Line 204: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),

200: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
201: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
202: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
203: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
204: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
205: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
206: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
207: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
208: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),

Line 205: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

201: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
202: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
203: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
204: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
205: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
206: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
207: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
208: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
209: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),

Line 206: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

202: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
203: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
204: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
205: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
206: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
207: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
208: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
209: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
210: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_RESPONSIBILITY_ID), X_ORIG_SYSTEM_REFERENCE ),

Line 207: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),

203: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
204: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
205: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
206: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
207: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
208: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
209: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
210: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_RESPONSIBILITY_ID), X_ORIG_SYSTEM_REFERENCE ),
211: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

Line 208: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),

204: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
205: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
206: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
207: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
208: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
209: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
210: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_RESPONSIBILITY_ID), X_ORIG_SYSTEM_REFERENCE ),
211: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
212: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

Line 209: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),

205: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
206: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
207: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
208: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
209: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
210: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_RESPONSIBILITY_ID), X_ORIG_SYSTEM_REFERENCE ),
211: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
212: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
213: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

Line 210: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_RESPONSIBILITY_ID), X_ORIG_SYSTEM_REFERENCE ),

206: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
207: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
208: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
209: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
210: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_RESPONSIBILITY_ID), X_ORIG_SYSTEM_REFERENCE ),
211: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
212: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
213: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
214: WHERE ROWID = X_RowId;

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

207: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
208: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
209: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
210: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_RESPONSIBILITY_ID), X_ORIG_SYSTEM_REFERENCE ),
211: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
212: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
213: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
214: WHERE ROWID = X_RowId;
215:

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

208: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
209: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
210: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_RESPONSIBILITY_ID), X_ORIG_SYSTEM_REFERENCE ),
211: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
212: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
213: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
214: WHERE ROWID = X_RowId;
215:
216: IF ( SQL%NOTFOUND ) THEN

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

209: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
210: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_RESPONSIBILITY_ID), X_ORIG_SYSTEM_REFERENCE ),
211: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
212: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
213: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
214: WHERE ROWID = X_RowId;
215:
216: IF ( SQL%NOTFOUND ) THEN
217: RAISE NO_DATA_FOUND;

Line 414: NVL( RESPONSIBILITY_ID, FND_API.G_MISS_NUM ),

410:
411: BEGIN
412:
413: SELECT
414: NVL( RESPONSIBILITY_ID, FND_API.G_MISS_NUM ),
415: NVL( CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM ),
416: NVL( RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR ),
417: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
418: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),

Line 415: NVL( CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM ),

411: BEGIN
412:
413: SELECT
414: NVL( RESPONSIBILITY_ID, FND_API.G_MISS_NUM ),
415: NVL( CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM ),
416: NVL( RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR ),
417: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
418: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
419: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),

Line 416: NVL( RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR ),

412:
413: SELECT
414: NVL( RESPONSIBILITY_ID, FND_API.G_MISS_NUM ),
415: NVL( CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM ),
416: NVL( RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR ),
417: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
418: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
419: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
420: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),

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

413: SELECT
414: NVL( RESPONSIBILITY_ID, FND_API.G_MISS_NUM ),
415: NVL( CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM ),
416: NVL( RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR ),
417: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
418: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
419: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
420: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
421: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),

Line 418: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),

414: NVL( RESPONSIBILITY_ID, FND_API.G_MISS_NUM ),
415: NVL( CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM ),
416: NVL( RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR ),
417: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
418: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
419: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
420: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
421: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
422: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),

Line 419: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),

415: NVL( CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM ),
416: NVL( RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR ),
417: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
418: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
419: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
420: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
421: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
422: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
423: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),

Line 420: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),

416: NVL( RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR ),
417: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
418: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
419: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
420: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
421: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
422: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
423: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
424: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),

Line 421: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),

417: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
418: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
419: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
420: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
421: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
422: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
423: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
424: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
425: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),

Line 422: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),

418: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
419: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
420: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
421: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
422: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
423: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
424: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
425: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
426: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),

Line 423: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),

419: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
420: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
421: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
422: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
423: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
424: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
425: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
426: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
427: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),

Line 424: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),

420: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
421: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
422: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
423: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
424: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
425: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
426: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
427: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
428: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),

Line 425: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),

421: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
422: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
423: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
424: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
425: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
426: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
427: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
428: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
429: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),

Line 426: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),

422: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
423: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
424: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
425: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
426: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
427: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
428: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
429: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
430: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),

Line 427: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),

423: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
424: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
425: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
426: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
427: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
428: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
429: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
430: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
431: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),

Line 428: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),

424: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
425: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
426: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
427: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
428: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
429: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
430: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
431: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
432: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),

Line 429: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),

425: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
426: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
427: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
428: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
429: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
430: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
431: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
432: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
433: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),

Line 430: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),

426: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
427: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
428: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
429: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
430: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
431: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
432: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
433: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
434: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),

Line 431: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),

427: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
428: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
429: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
430: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
431: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
432: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
433: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
434: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
435: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

Line 432: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),

428: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
429: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
430: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
431: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
432: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
433: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
434: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
435: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
436: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

Line 433: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),

429: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
430: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
431: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
432: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
433: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
434: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
435: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
436: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
437: INTO

Line 434: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),

430: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
431: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
432: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
433: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
434: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
435: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
436: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
437: INTO
438: X_RESPONSIBILITY_ID,

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

431: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
432: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
433: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
434: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
435: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
436: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
437: INTO
438: X_RESPONSIBILITY_ID,
439: X_CUST_ACCOUNT_ROLE_ID,

Line 436: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

432: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
433: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
434: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
435: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
436: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
437: INTO
438: X_RESPONSIBILITY_ID,
439: X_CUST_ACCOUNT_ROLE_ID,
440: X_RESPONSIBILITY_TYPE,

Line 470: RAISE FND_API.G_EXC_ERROR;

466: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
467: FND_MESSAGE.SET_TOKEN( 'RECORD', 'role_responsibility_rec');
468: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_RESPONSIBILITY_ID ) );
469: FND_MSG_PUB.ADD;
470: RAISE FND_API.G_EXC_ERROR;
471:
472: END Select_Row;
473:
474: PROCEDURE Delete_Row (