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

Line 6372: print_debug ('Concurrent Request ID : '|| fnd_global.conc_request_id);

6368: l_total_interest_amt := l_total_interest_amt + l_interest_amt;
6369: l_interest_rate_tbl_index := l_interest_rate_tbl.NEXT(l_interest_rate_tbl_index);
6370:
6371: print_debug ('g_request_id : '|| g_request_id);
6372: print_debug ('Concurrent Request ID : '|| fnd_global.conc_request_id);
6373: print_debug ('l_derived_flag : '|| l_derived_flag);
6374:
6375: IF ((g_request_id > 0) AND (l_derived_flag = 'Y'))THEN
6376: g_vir_tbl_counter := nvl(g_vir_tbl_counter,0) + 1;

Line 6414: g_vir_tbl(g_vir_tbl_counter).created_by := FND_GLOBAL.user_id;

6410: g_vir_tbl(g_vir_tbl_counter).attribute12 := NULL;
6411: g_vir_tbl(g_vir_tbl_counter).attribute13 := NULL;
6412: g_vir_tbl(g_vir_tbl_counter).attribute14 := NULL;
6413: g_vir_tbl(g_vir_tbl_counter).attribute15 := NULL;
6414: g_vir_tbl(g_vir_tbl_counter).created_by := FND_GLOBAL.user_id;
6415: g_vir_tbl(g_vir_tbl_counter).creation_date := SYSDATE;
6416: g_vir_tbl(g_vir_tbl_counter).last_updated_by := FND_GLOBAL.user_id;
6417: g_vir_tbl(g_vir_tbl_counter).last_update_date := SYSDATE;
6418: g_vir_tbl(g_vir_tbl_counter).last_update_login := FND_GLOBAL.login_id;

Line 6416: g_vir_tbl(g_vir_tbl_counter).last_updated_by := FND_GLOBAL.user_id;

6412: g_vir_tbl(g_vir_tbl_counter).attribute14 := NULL;
6413: g_vir_tbl(g_vir_tbl_counter).attribute15 := NULL;
6414: g_vir_tbl(g_vir_tbl_counter).created_by := FND_GLOBAL.user_id;
6415: g_vir_tbl(g_vir_tbl_counter).creation_date := SYSDATE;
6416: g_vir_tbl(g_vir_tbl_counter).last_updated_by := FND_GLOBAL.user_id;
6417: g_vir_tbl(g_vir_tbl_counter).last_update_date := SYSDATE;
6418: g_vir_tbl(g_vir_tbl_counter).last_update_login := FND_GLOBAL.login_id;
6419: g_vir_tbl(g_vir_tbl_counter).interest_amt := l_interest_amt;
6420: g_vir_tbl(g_vir_tbl_counter).interest_calc_days := l_calc_days;

Line 6418: g_vir_tbl(g_vir_tbl_counter).last_update_login := FND_GLOBAL.login_id;

6414: g_vir_tbl(g_vir_tbl_counter).created_by := FND_GLOBAL.user_id;
6415: g_vir_tbl(g_vir_tbl_counter).creation_date := SYSDATE;
6416: g_vir_tbl(g_vir_tbl_counter).last_updated_by := FND_GLOBAL.user_id;
6417: g_vir_tbl(g_vir_tbl_counter).last_update_date := SYSDATE;
6418: g_vir_tbl(g_vir_tbl_counter).last_update_login := FND_GLOBAL.login_id;
6419: g_vir_tbl(g_vir_tbl_counter).interest_amt := l_interest_amt;
6420: g_vir_tbl(g_vir_tbl_counter).interest_calc_days := l_calc_days;
6421: END IF;
6422: END LOOP;

Line 8247: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;

8243: g_vpb_tbl(g_vpb_tbl_counter).attribute12 := NULL;
8244: g_vpb_tbl(g_vpb_tbl_counter).attribute13 := NULL;
8245: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8246: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8247: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8248: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8249: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8250: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8251: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

Line 8249: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;

8245: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8246: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8247: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8248: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8249: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8250: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8251: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8252: END LOOP;
8253: CLOSE l_rebook_csr;

Line 8251: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

8247: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8248: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8249: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8250: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8251: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8252: END LOOP;
8253: CLOSE l_rebook_csr;
8254: print_debug('After fetching Rebook Transactions g_vpb_tbl count is: '|| g_vpb_tbl.COUNT);
8255:

Line 8295: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;

8291: g_vpb_tbl(g_vpb_tbl_counter).attribute12 := NULL;
8292: g_vpb_tbl(g_vpb_tbl_counter).attribute13 := NULL;
8293: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8294: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8295: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8296: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8297: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8298: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8299: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

Line 8297: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;

8293: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8294: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8295: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8296: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8297: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8298: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8299: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8300: END LOOP;
8301: CLOSE l_daily_int_strm_csr;

Line 8299: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

8295: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8296: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8297: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8298: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8299: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8300: END LOOP;
8301: CLOSE l_daily_int_strm_csr;
8302: print_debug('After fetching Daily Interest streams g_vpb_tbl count is: '|| g_vpb_tbl.COUNT);
8303: ELSE

Line 8342: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;

8338: g_vpb_tbl(g_vpb_tbl_counter).attribute12 := NULL;
8339: g_vpb_tbl(g_vpb_tbl_counter).attribute13 := NULL;
8340: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8341: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8342: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8343: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8344: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8345: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8346: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

Line 8344: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;

8340: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8341: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8342: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8343: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8344: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8345: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8346: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8347: END LOOP;
8348: CLOSE l_rcpt_app_csr;

Line 8346: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

8342: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8343: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8344: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8345: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8346: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8347: END LOOP;
8348: CLOSE l_rcpt_app_csr;
8349: print_debug('After fetching Receipt Applications g_vpb_tbl count is: '|| g_vpb_tbl.COUNT);
8350:

Line 8386: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;

8382: g_vpb_tbl(g_vpb_tbl_counter).attribute12 := NULL;
8383: g_vpb_tbl(g_vpb_tbl_counter).attribute13 := NULL;
8384: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8385: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8386: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8387: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8388: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8389: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8390: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

Line 8388: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;

8384: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8385: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8386: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8387: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8388: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8389: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8390: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8391: END LOOP;
8392: CLOSE l_partial_term_csr;

Line 8390: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

8386: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8387: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8388: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8389: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8390: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8391: END LOOP;
8392: CLOSE l_partial_term_csr;
8393: print_debug('After fetching Early Termination records g_vpb_tbl count is: '|| g_vpb_tbl.COUNT);
8394: END IF;

Line 8433: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;

8429: g_vpb_tbl(g_vpb_tbl_counter).attribute12 := NULL;
8430: g_vpb_tbl(g_vpb_tbl_counter).attribute13 := NULL;
8431: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8432: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8433: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8434: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8435: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8436: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8437: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

Line 8435: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;

8431: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8432: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8433: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8434: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8435: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8436: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8437: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8438: END LOOP;
8439: CLOSE l_rcpt_app_csr;

Line 8437: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

8433: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8434: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8435: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8436: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8437: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8438: END LOOP;
8439: CLOSE l_rcpt_app_csr;
8440: print_debug('After fetching Receipt Applications g_vpb_tbl count is: '|| g_vpb_tbl.COUNT);
8441:

Line 8477: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;

8473: g_vpb_tbl(g_vpb_tbl_counter).attribute12 := NULL;
8474: g_vpb_tbl(g_vpb_tbl_counter).attribute13 := NULL;
8475: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8476: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8477: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8478: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8479: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8480: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8481: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

Line 8479: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;

8475: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8476: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8477: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8478: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8479: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8480: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8481: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8482: END LOOP;
8483: CLOSE l_partial_term_csr;

Line 8481: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

8477: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8478: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8479: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8480: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8481: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8482: END LOOP;
8483: CLOSE l_partial_term_csr;
8484: print_debug('After fetching Early Termination records g_vpb_tbl count is: '|| g_vpb_tbl.COUNT);
8485:

Line 8521: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;

8517: g_vpb_tbl(g_vpb_tbl_counter).attribute12 := NULL;
8518: g_vpb_tbl(g_vpb_tbl_counter).attribute13 := NULL;
8519: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8520: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8521: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8522: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8523: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8524: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8525: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

Line 8523: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;

8519: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8520: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8521: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8522: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8523: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8524: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8525: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8526: END LOOP;
8527: CLOSE l_prin_catch_strm_csr;

Line 8525: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

8521: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8522: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8523: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8524: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8525: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8526: END LOOP;
8527: CLOSE l_prin_catch_strm_csr;
8528: print_debug('After fetching Principal Catchup streams g_vpb_tbl count is: '|| g_vpb_tbl.COUNT);
8529: END IF;

Line 8568: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;

8564: g_vpb_tbl(g_vpb_tbl_counter).attribute12 := NULL;
8565: g_vpb_tbl(g_vpb_tbl_counter).attribute13 := NULL;
8566: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8567: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8568: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8569: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8570: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8571: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8572: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

Line 8570: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;

8566: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8567: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8568: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8569: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8570: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8571: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8572: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8573: END LOOP;
8574: CLOSE l_borrow_payment_csr;

Line 8572: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

8568: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8569: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8570: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8571: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8572: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8573: END LOOP;
8574: CLOSE l_borrow_payment_csr;
8575: print_debug('After fetching Borrower payments g_vpb_tbl count is: '|| g_vpb_tbl.COUNT);
8576:

Line 8612: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;

8608: g_vpb_tbl(g_vpb_tbl_counter).attribute12 := NULL;
8609: g_vpb_tbl(g_vpb_tbl_counter).attribute13 := NULL;
8610: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8611: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8612: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8613: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8614: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8615: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8616: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

Line 8614: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;

8610: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8611: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8612: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8613: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8614: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8615: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8616: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8617: END LOOP;
8618: CLOSE l_daily_int_strm_csr;

Line 8616: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

8612: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8613: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8614: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8615: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8616: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8617: END LOOP;
8618: CLOSE l_daily_int_strm_csr;
8619: print_debug('After fetching Daily Interest streams g_vpb_tbl count is: '|| g_vpb_tbl.COUNT);
8620: ELSE

Line 8658: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;

8654: g_vpb_tbl(g_vpb_tbl_counter).attribute12 := NULL;
8655: g_vpb_tbl(g_vpb_tbl_counter).attribute13 := NULL;
8656: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8657: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8658: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8659: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8660: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8661: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8662: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

Line 8660: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;

8656: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8657: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8658: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8659: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8660: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8661: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8662: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8663: END LOOP;
8664: CLOSE l_borrow_payment_csr;

Line 8662: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

8658: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8659: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8660: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8661: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8662: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8663: END LOOP;
8664: CLOSE l_borrow_payment_csr;
8665: print_debug('After fetching Borrower payments g_vpb_tbl count is: '|| g_vpb_tbl.COUNT);
8666:

Line 8702: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;

8698: g_vpb_tbl(g_vpb_tbl_counter).attribute12 := NULL;
8699: g_vpb_tbl(g_vpb_tbl_counter).attribute13 := NULL;
8700: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8701: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8702: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8703: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8704: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8705: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8706: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

Line 8704: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;

8700: g_vpb_tbl(g_vpb_tbl_counter).attribute14 := NULL;
8701: g_vpb_tbl(g_vpb_tbl_counter).attribute15 := NULL;
8702: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8703: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8704: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8705: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8706: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8707: END LOOP;
8708: CLOSE l_rcpt_app_csr;

Line 8706: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

8702: g_vpb_tbl(g_vpb_tbl_counter).created_by := FND_GLOBAL.USER_ID;
8703: g_vpb_tbl(g_vpb_tbl_counter).creation_date := SYSDATE;
8704: g_vpb_tbl(g_vpb_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
8705: g_vpb_tbl(g_vpb_tbl_counter).last_update_date := SYSDATE;
8706: g_vpb_tbl(g_vpb_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
8707: END LOOP;
8708: CLOSE l_rcpt_app_csr;
8709: print_debug('After fetching Receipt Applications g_vpb_tbl count is: '|| g_vpb_tbl.COUNT);
8710: END IF;

Line 11103: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),

11099: g_vir_tbl_counter := NVL(g_vir_tbl_counter, 0) + 1;
11100: END IF;
11101:
11102: SELECT
11103: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
11104: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
11105: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
11106: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
11107: INTO

Line 11104: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),

11100: END IF;
11101:
11102: SELECT
11103: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
11104: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
11105: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
11106: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
11107: INTO
11108: l_request_id,

Line 11105: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

11101:
11102: SELECT
11103: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
11104: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
11105: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
11106: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
11107: INTO
11108: l_request_id,
11109: l_program_application_id,

Line 11106: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)

11102: SELECT
11103: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
11104: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
11105: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
11106: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
11107: INTO
11108: l_request_id,
11109: l_program_application_id,
11110: l_program_id,

Line 11148: g_vir_tbl(g_vir_tbl_counter).created_by := FND_GLOBAL.USER_ID;

11144: g_vir_tbl(g_vir_tbl_counter).attribute12 := NULL;
11145: g_vir_tbl(g_vir_tbl_counter).attribute13 := NULL;
11146: g_vir_tbl(g_vir_tbl_counter).attribute14 := NULL;
11147: g_vir_tbl(g_vir_tbl_counter).attribute15 := NULL;
11148: g_vir_tbl(g_vir_tbl_counter).created_by := FND_GLOBAL.USER_ID;
11149: g_vir_tbl(g_vir_tbl_counter).creation_date := SYSDATE;
11150: g_vir_tbl(g_vir_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
11151: g_vir_tbl(g_vir_tbl_counter).last_update_date := SYSDATE;
11152: g_vir_tbl(g_vir_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

Line 11150: g_vir_tbl(g_vir_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;

11146: g_vir_tbl(g_vir_tbl_counter).attribute14 := NULL;
11147: g_vir_tbl(g_vir_tbl_counter).attribute15 := NULL;
11148: g_vir_tbl(g_vir_tbl_counter).created_by := FND_GLOBAL.USER_ID;
11149: g_vir_tbl(g_vir_tbl_counter).creation_date := SYSDATE;
11150: g_vir_tbl(g_vir_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
11151: g_vir_tbl(g_vir_tbl_counter).last_update_date := SYSDATE;
11152: g_vir_tbl(g_vir_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
11153: g_vir_tbl(g_vir_tbl_counter).interest_amt := NULL;
11154: g_vir_tbl(g_vir_tbl_counter).interest_calc_days := NULL;

Line 11152: g_vir_tbl(g_vir_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;

11148: g_vir_tbl(g_vir_tbl_counter).created_by := FND_GLOBAL.USER_ID;
11149: g_vir_tbl(g_vir_tbl_counter).creation_date := SYSDATE;
11150: g_vir_tbl(g_vir_tbl_counter).last_updated_by := FND_GLOBAL.USER_ID;
11151: g_vir_tbl(g_vir_tbl_counter).last_update_date := SYSDATE;
11152: g_vir_tbl(g_vir_tbl_counter).last_update_login := FND_GLOBAL.LOGIN_ID;
11153: g_vir_tbl(g_vir_tbl_counter).interest_amt := NULL;
11154: g_vir_tbl(g_vir_tbl_counter).interest_calc_days := NULL;
11155:
11156: populate_vir_params(

Line 12688: g_request_id := FND_GLOBAL.CONC_REQUEST_ID;

12684: ------------------------------------------------------------
12685:
12686: x_return_status := OKL_API.G_RET_STS_SUCCESS;
12687:
12688: g_request_id := FND_GLOBAL.CONC_REQUEST_ID;
12689:
12690: print_debug ('g_request_id : '|| g_request_id);
12691: print_debug ('Concurrent Request ID : '|| FND_GLOBAL.CONC_REQUEST_ID);
12692:

Line 12691: print_debug ('Concurrent Request ID : '|| FND_GLOBAL.CONC_REQUEST_ID);

12687:
12688: g_request_id := FND_GLOBAL.CONC_REQUEST_ID;
12689:
12690: print_debug ('g_request_id : '|| g_request_id);
12691: print_debug ('Concurrent Request ID : '|| FND_GLOBAL.CONC_REQUEST_ID);
12692:
12693: g_to_date := p_to_date;
12694:
12695: ------------------------------------------------------------