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 143: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),PROGRAM_ID),

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

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

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

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

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

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

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

Line 148: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

144: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),
145: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
146: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
147: LAST_UPDATE_DATE = SYSDATE,
148: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
149: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
150: WHERE ID = p_chrv_rec.id;
151:
152: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_sts_code'||p_chrv_rec.old_sts_code);

Line 149: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

145: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
146: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
147: LAST_UPDATE_DATE = SYSDATE,
148: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
149: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
150: WHERE ID = p_chrv_rec.id;
151:
152: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_sts_code'||p_chrv_rec.old_sts_code);
153: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_ste_code'||p_chrv_rec.old_ste_code);

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

215: x_clev_rec := p_clev_rec;
216: UPDATE OKC_K_LINES_B
217: SET STS_CODE = p_clev_rec.sts_code,
218: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
219: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),PROGRAM_ID),
220: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),
221: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
222: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
223: LAST_UPDATE_DATE = SYSDATE,

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

216: UPDATE OKC_K_LINES_B
217: SET STS_CODE = p_clev_rec.sts_code,
218: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
219: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),PROGRAM_ID),
220: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),
221: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
222: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
223: LAST_UPDATE_DATE = SYSDATE,
224: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

217: SET STS_CODE = p_clev_rec.sts_code,
218: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
219: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),PROGRAM_ID),
220: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),
221: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
222: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
223: LAST_UPDATE_DATE = SYSDATE,
224: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
225: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

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

218: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
219: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),PROGRAM_ID),
220: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),
221: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
222: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
223: LAST_UPDATE_DATE = SYSDATE,
224: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
225: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
226: WHERE ID = p_clev_rec.id;

Line 224: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

220: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),
221: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
222: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
223: LAST_UPDATE_DATE = SYSDATE,
224: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
225: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
226: WHERE ID = p_clev_rec.id;
227: -- Call action assembler if status is changed
228: If NVL(p_clev_rec.Call_Action_Asmblr,'Y') = 'Y' AND

Line 225: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

221: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,SYSDATE),
222: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),PROGRAM_APPLICATION_ID),
223: LAST_UPDATE_DATE = SYSDATE,
224: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
225: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
226: WHERE ID = p_clev_rec.id;
227: -- Call action assembler if status is changed
228: If NVL(p_clev_rec.Call_Action_Asmblr,'Y') = 'Y' AND
229: p_clev_rec.old_sts_code is not null AND