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.CN_ROLE_PAY_GROUPS_PKG dependencies on FND_API

Line 74: SELECT DECODE(X_end_date, FND_API.G_MISS_DATE,

70:
71: BEGIN
72: -- dbms_output.put_line('begin insert_row');
73:
74: SELECT DECODE(X_end_date, FND_API.G_MISS_DATE,
75: to_date(NULL),X_end_date)
76: INTO L_end_date FROM dual;
77: SELECT DECODE(X_attribute_category, FND_API.G_MISS_CHAR,
78: NULL,Ltrim(Rtrim(X_attribute_category)))

Line 77: SELECT DECODE(X_attribute_category, FND_API.G_MISS_CHAR,

73:
74: SELECT DECODE(X_end_date, FND_API.G_MISS_DATE,
75: to_date(NULL),X_end_date)
76: INTO L_end_date FROM dual;
77: SELECT DECODE(X_attribute_category, FND_API.G_MISS_CHAR,
78: NULL,Ltrim(Rtrim(X_attribute_category)))
79: INTO L_attribute_category FROM dual;
80: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,
81: NULL,Ltrim(Rtrim(X_ATTRIBUTE1)))

Line 80: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,

76: INTO L_end_date FROM dual;
77: SELECT DECODE(X_attribute_category, FND_API.G_MISS_CHAR,
78: NULL,Ltrim(Rtrim(X_attribute_category)))
79: INTO L_attribute_category FROM dual;
80: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,
81: NULL,Ltrim(Rtrim(X_ATTRIBUTE1)))
82: INTO L_ATTRIBUTE1 FROM dual;
83: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,
84: NULL,Ltrim(Rtrim(X_ATTRIBUTE2)))

Line 83: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,

79: INTO L_attribute_category FROM dual;
80: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,
81: NULL,Ltrim(Rtrim(X_ATTRIBUTE1)))
82: INTO L_ATTRIBUTE1 FROM dual;
83: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,
84: NULL,Ltrim(Rtrim(X_ATTRIBUTE2)))
85: INTO L_ATTRIBUTE2 FROM dual;
86: SELECT DECODE(X_ATTRIBUTE3, FND_API.G_MISS_CHAR,
87: NULL,Ltrim(Rtrim(X_ATTRIBUTE3)))

Line 86: SELECT DECODE(X_ATTRIBUTE3, FND_API.G_MISS_CHAR,

82: INTO L_ATTRIBUTE1 FROM dual;
83: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,
84: NULL,Ltrim(Rtrim(X_ATTRIBUTE2)))
85: INTO L_ATTRIBUTE2 FROM dual;
86: SELECT DECODE(X_ATTRIBUTE3, FND_API.G_MISS_CHAR,
87: NULL,Ltrim(Rtrim(X_ATTRIBUTE3)))
88: INTO L_ATTRIBUTE3 FROM dual;
89: SELECT DECODE(X_ATTRIBUTE4, FND_API.G_MISS_CHAR,
90: NULL,Ltrim(Rtrim(X_ATTRIBUTE4)))

Line 89: SELECT DECODE(X_ATTRIBUTE4, FND_API.G_MISS_CHAR,

85: INTO L_ATTRIBUTE2 FROM dual;
86: SELECT DECODE(X_ATTRIBUTE3, FND_API.G_MISS_CHAR,
87: NULL,Ltrim(Rtrim(X_ATTRIBUTE3)))
88: INTO L_ATTRIBUTE3 FROM dual;
89: SELECT DECODE(X_ATTRIBUTE4, FND_API.G_MISS_CHAR,
90: NULL,Ltrim(Rtrim(X_ATTRIBUTE4)))
91: INTO L_ATTRIBUTE4 FROM dual;
92: SELECT DECODE(X_ATTRIBUTE5, FND_API.G_MISS_CHAR,
93: NULL,Ltrim(Rtrim(X_ATTRIBUTE5)))

Line 92: SELECT DECODE(X_ATTRIBUTE5, FND_API.G_MISS_CHAR,

88: INTO L_ATTRIBUTE3 FROM dual;
89: SELECT DECODE(X_ATTRIBUTE4, FND_API.G_MISS_CHAR,
90: NULL,Ltrim(Rtrim(X_ATTRIBUTE4)))
91: INTO L_ATTRIBUTE4 FROM dual;
92: SELECT DECODE(X_ATTRIBUTE5, FND_API.G_MISS_CHAR,
93: NULL,Ltrim(Rtrim(X_ATTRIBUTE5)))
94: INTO L_ATTRIBUTE5 FROM dual;
95: SELECT DECODE(X_ATTRIBUTE6, FND_API.G_MISS_CHAR,
96: NULL,Ltrim(Rtrim(X_ATTRIBUTE6)))

Line 95: SELECT DECODE(X_ATTRIBUTE6, FND_API.G_MISS_CHAR,

91: INTO L_ATTRIBUTE4 FROM dual;
92: SELECT DECODE(X_ATTRIBUTE5, FND_API.G_MISS_CHAR,
93: NULL,Ltrim(Rtrim(X_ATTRIBUTE5)))
94: INTO L_ATTRIBUTE5 FROM dual;
95: SELECT DECODE(X_ATTRIBUTE6, FND_API.G_MISS_CHAR,
96: NULL,Ltrim(Rtrim(X_ATTRIBUTE6)))
97: INTO L_ATTRIBUTE6 FROM dual;
98: SELECT DECODE(X_ATTRIBUTE7, FND_API.G_MISS_CHAR,
99: NULL,Ltrim(Rtrim(X_ATTRIBUTE7)))

Line 98: SELECT DECODE(X_ATTRIBUTE7, FND_API.G_MISS_CHAR,

94: INTO L_ATTRIBUTE5 FROM dual;
95: SELECT DECODE(X_ATTRIBUTE6, FND_API.G_MISS_CHAR,
96: NULL,Ltrim(Rtrim(X_ATTRIBUTE6)))
97: INTO L_ATTRIBUTE6 FROM dual;
98: SELECT DECODE(X_ATTRIBUTE7, FND_API.G_MISS_CHAR,
99: NULL,Ltrim(Rtrim(X_ATTRIBUTE7)))
100: INTO L_ATTRIBUTE7 FROM dual;
101: SELECT DECODE(X_ATTRIBUTE8, FND_API.G_MISS_CHAR,
102: NULL,Ltrim(Rtrim(X_ATTRIBUTE8)))

Line 101: SELECT DECODE(X_ATTRIBUTE8, FND_API.G_MISS_CHAR,

97: INTO L_ATTRIBUTE6 FROM dual;
98: SELECT DECODE(X_ATTRIBUTE7, FND_API.G_MISS_CHAR,
99: NULL,Ltrim(Rtrim(X_ATTRIBUTE7)))
100: INTO L_ATTRIBUTE7 FROM dual;
101: SELECT DECODE(X_ATTRIBUTE8, FND_API.G_MISS_CHAR,
102: NULL,Ltrim(Rtrim(X_ATTRIBUTE8)))
103: INTO L_ATTRIBUTE8 FROM dual;
104: SELECT DECODE(X_ATTRIBUTE9, FND_API.G_MISS_CHAR,
105: NULL,Ltrim(Rtrim(X_ATTRIBUTE9)))

Line 104: SELECT DECODE(X_ATTRIBUTE9, FND_API.G_MISS_CHAR,

100: INTO L_ATTRIBUTE7 FROM dual;
101: SELECT DECODE(X_ATTRIBUTE8, FND_API.G_MISS_CHAR,
102: NULL,Ltrim(Rtrim(X_ATTRIBUTE8)))
103: INTO L_ATTRIBUTE8 FROM dual;
104: SELECT DECODE(X_ATTRIBUTE9, FND_API.G_MISS_CHAR,
105: NULL,Ltrim(Rtrim(X_ATTRIBUTE9)))
106: INTO L_ATTRIBUTE9 FROM dual;
107: SELECT DECODE(X_ATTRIBUTE10, FND_API.G_MISS_CHAR,
108: NULL,Ltrim(Rtrim(X_ATTRIBUTE10)))

Line 107: SELECT DECODE(X_ATTRIBUTE10, FND_API.G_MISS_CHAR,

103: INTO L_ATTRIBUTE8 FROM dual;
104: SELECT DECODE(X_ATTRIBUTE9, FND_API.G_MISS_CHAR,
105: NULL,Ltrim(Rtrim(X_ATTRIBUTE9)))
106: INTO L_ATTRIBUTE9 FROM dual;
107: SELECT DECODE(X_ATTRIBUTE10, FND_API.G_MISS_CHAR,
108: NULL,Ltrim(Rtrim(X_ATTRIBUTE10)))
109: INTO L_ATTRIBUTE10 FROM dual;
110: SELECT DECODE(X_ATTRIBUTE11, FND_API.G_MISS_CHAR,
111: NULL,Ltrim(Rtrim(X_ATTRIBUTE11)))

Line 110: SELECT DECODE(X_ATTRIBUTE11, FND_API.G_MISS_CHAR,

106: INTO L_ATTRIBUTE9 FROM dual;
107: SELECT DECODE(X_ATTRIBUTE10, FND_API.G_MISS_CHAR,
108: NULL,Ltrim(Rtrim(X_ATTRIBUTE10)))
109: INTO L_ATTRIBUTE10 FROM dual;
110: SELECT DECODE(X_ATTRIBUTE11, FND_API.G_MISS_CHAR,
111: NULL,Ltrim(Rtrim(X_ATTRIBUTE11)))
112: INTO L_ATTRIBUTE11 FROM dual;
113: SELECT DECODE(X_ATTRIBUTE12, FND_API.G_MISS_CHAR,
114: NULL,Ltrim(Rtrim(X_ATTRIBUTE12)))

Line 113: SELECT DECODE(X_ATTRIBUTE12, FND_API.G_MISS_CHAR,

109: INTO L_ATTRIBUTE10 FROM dual;
110: SELECT DECODE(X_ATTRIBUTE11, FND_API.G_MISS_CHAR,
111: NULL,Ltrim(Rtrim(X_ATTRIBUTE11)))
112: INTO L_ATTRIBUTE11 FROM dual;
113: SELECT DECODE(X_ATTRIBUTE12, FND_API.G_MISS_CHAR,
114: NULL,Ltrim(Rtrim(X_ATTRIBUTE12)))
115: INTO L_ATTRIBUTE12 FROM dual;
116: SELECT DECODE(X_ATTRIBUTE13, FND_API.G_MISS_CHAR,
117: NULL,Ltrim(Rtrim(X_ATTRIBUTE13)))

Line 116: SELECT DECODE(X_ATTRIBUTE13, FND_API.G_MISS_CHAR,

112: INTO L_ATTRIBUTE11 FROM dual;
113: SELECT DECODE(X_ATTRIBUTE12, FND_API.G_MISS_CHAR,
114: NULL,Ltrim(Rtrim(X_ATTRIBUTE12)))
115: INTO L_ATTRIBUTE12 FROM dual;
116: SELECT DECODE(X_ATTRIBUTE13, FND_API.G_MISS_CHAR,
117: NULL,Ltrim(Rtrim(X_ATTRIBUTE13)))
118: INTO L_ATTRIBUTE13 FROM dual;
119: SELECT DECODE(X_ATTRIBUTE14, FND_API.G_MISS_CHAR,
120: NULL,Ltrim(Rtrim(X_ATTRIBUTE14)))

Line 119: SELECT DECODE(X_ATTRIBUTE14, FND_API.G_MISS_CHAR,

115: INTO L_ATTRIBUTE12 FROM dual;
116: SELECT DECODE(X_ATTRIBUTE13, FND_API.G_MISS_CHAR,
117: NULL,Ltrim(Rtrim(X_ATTRIBUTE13)))
118: INTO L_ATTRIBUTE13 FROM dual;
119: SELECT DECODE(X_ATTRIBUTE14, FND_API.G_MISS_CHAR,
120: NULL,Ltrim(Rtrim(X_ATTRIBUTE14)))
121: INTO L_ATTRIBUTE14 FROM dual;
122: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,
123: NULL,Ltrim(Rtrim(X_attribute15)))

Line 122: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,

118: INTO L_ATTRIBUTE13 FROM dual;
119: SELECT DECODE(X_ATTRIBUTE14, FND_API.G_MISS_CHAR,
120: NULL,Ltrim(Rtrim(X_ATTRIBUTE14)))
121: INTO L_ATTRIBUTE14 FROM dual;
122: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,
123: NULL,Ltrim(Rtrim(X_attribute15)))
124: INTO L_attribute15 FROM dual;
125: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,
126: G_CREATED_BY,Ltrim(Rtrim(X_CREATED_BY)))

Line 125: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,

121: INTO L_ATTRIBUTE14 FROM dual;
122: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,
123: NULL,Ltrim(Rtrim(X_attribute15)))
124: INTO L_attribute15 FROM dual;
125: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,
126: G_CREATED_BY,Ltrim(Rtrim(X_CREATED_BY)))
127: INTO L_created_by FROM dual;
128: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,
129: G_CREATION_DATE,X_CREATION_DATE)

Line 128: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,

124: INTO L_attribute15 FROM dual;
125: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,
126: G_CREATED_BY,Ltrim(Rtrim(X_CREATED_BY)))
127: INTO L_created_by FROM dual;
128: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,
129: G_CREATION_DATE,X_CREATION_DATE)
130: INTO L_creation_date FROM dual;
131: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,
132: G_LAST_UPDATE_LOGIN,Ltrim(Rtrim(X_LAST_UPDATE_LOGIN)))

Line 131: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,

127: INTO L_created_by FROM dual;
128: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,
129: G_CREATION_DATE,X_CREATION_DATE)
130: INTO L_creation_date FROM dual;
131: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,
132: G_LAST_UPDATE_LOGIN,Ltrim(Rtrim(X_LAST_UPDATE_LOGIN)))
133: INTO L_last_update_login FROM dual;
134: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,
135: G_LAST_UPDATE_DATE,X_LAST_UPDATE_DATE)

Line 134: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,

130: INTO L_creation_date FROM dual;
131: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,
132: G_LAST_UPDATE_LOGIN,Ltrim(Rtrim(X_LAST_UPDATE_LOGIN)))
133: INTO L_last_update_login FROM dual;
134: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,
135: G_LAST_UPDATE_DATE,X_LAST_UPDATE_DATE)
136: INTO L_last_update_date FROM dual;
137: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,
138: G_LAST_UPDATED_BY,Ltrim(Rtrim(X_LAST_UPDATED_BY)))

Line 137: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,

133: INTO L_last_update_login FROM dual;
134: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,
135: G_LAST_UPDATE_DATE,X_LAST_UPDATE_DATE)
136: INTO L_last_update_date FROM dual;
137: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,
138: G_LAST_UPDATED_BY,Ltrim(Rtrim(X_LAST_UPDATED_BY)))
139: INTO L_last_updated_by FROM dual;
140: SELECT DECODE(X_ORG_ID, FND_API.G_MISS_NUM,
141: NULL,Ltrim(Rtrim(X_ORG_ID)))

Line 140: SELECT DECODE(X_ORG_ID, FND_API.G_MISS_NUM,

136: INTO L_last_update_date FROM dual;
137: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,
138: G_LAST_UPDATED_BY,Ltrim(Rtrim(X_LAST_UPDATED_BY)))
139: INTO L_last_updated_by FROM dual;
140: SELECT DECODE(X_ORG_ID, FND_API.G_MISS_NUM,
141: NULL,Ltrim(Rtrim(X_ORG_ID)))
142: INTO L_ORG_ID FROM dual;
143:
144: -- dbms_output.put_line('before insert_row');