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.OKC_STATUS_CHANGE_PVT dependencies on FND_GLOBAL

Line 145: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),PROGRAM_ID),

141: x_chrv_rec := p_chrv_rec;
142: UPDATE OKC_K_HEADERS_B
143: SET STS_CODE = p_chrv_rec.sts_code,
144: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
145: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),PROGRAM_ID),
146: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),
147: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
148: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
149: LAST_UPDATE_DATE = SYSDATE,

Line 146: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),

142: UPDATE OKC_K_HEADERS_B
143: SET STS_CODE = p_chrv_rec.sts_code,
144: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
145: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),PROGRAM_ID),
146: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),
147: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
148: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
149: LAST_UPDATE_DATE = SYSDATE,
150: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 147: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),

143: SET STS_CODE = p_chrv_rec.sts_code,
144: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
145: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),PROGRAM_ID),
146: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),
147: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
148: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
149: LAST_UPDATE_DATE = SYSDATE,
150: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
151: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 148: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),

144: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
145: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),PROGRAM_ID),
146: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),
147: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
148: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
149: LAST_UPDATE_DATE = SYSDATE,
150: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
151: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
152: WHERE ID = p_chrv_rec.id;

Line 150: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

146: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),
147: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
148: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
149: LAST_UPDATE_DATE = SYSDATE,
150: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
151: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
152: WHERE ID = p_chrv_rec.id;
153:
154: /*cgopinee bugfix for 6882512*/

Line 151: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

147: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
148: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
149: LAST_UPDATE_DATE = SYSDATE,
150: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
151: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
152: WHERE ID = p_chrv_rec.id;
153:
154: /*cgopinee bugfix for 6882512*/
155: IF (p_chrv_rec.old_ste_code <> p_chrv_rec.new_ste_code) THEN

Line 233: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),PROGRAM_ID),

229: x_clev_rec := p_clev_rec;
230: UPDATE OKC_K_LINES_B
231: SET STS_CODE = p_clev_rec.sts_code,
232: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
233: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),PROGRAM_ID),
234: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),
235: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
236: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
237: LAST_UPDATE_DATE = SYSDATE,

Line 234: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),

230: UPDATE OKC_K_LINES_B
231: SET STS_CODE = p_clev_rec.sts_code,
232: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
233: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),PROGRAM_ID),
234: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),
235: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
236: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
237: LAST_UPDATE_DATE = SYSDATE,
238: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 235: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),

231: SET STS_CODE = p_clev_rec.sts_code,
232: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
233: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),PROGRAM_ID),
234: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),
235: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
236: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
237: LAST_UPDATE_DATE = SYSDATE,
238: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
239: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 236: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),

232: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
233: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),PROGRAM_ID),
234: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),
235: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
236: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
237: LAST_UPDATE_DATE = SYSDATE,
238: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
239: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
240: WHERE ID = p_clev_rec.id;

Line 238: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

234: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),
235: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
236: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
237: LAST_UPDATE_DATE = SYSDATE,
238: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
239: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
240: WHERE ID = p_clev_rec.id;
241: -- Call action assembler if status is changed
242: If NVL(p_clev_rec.Call_Action_Asmblr,'Y') = 'Y' AND

Line 239: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

235: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
236: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
237: LAST_UPDATE_DATE = SYSDATE,
238: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
239: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
240: WHERE ID = p_clev_rec.id;
241: -- Call action assembler if status is changed
242: If NVL(p_clev_rec.Call_Action_Asmblr,'Y') = 'Y' AND
243: p_clev_rec.old_sts_code is not null AND