2206:
2207:
2208: g_global_start_date := bis_common_parameters.get_global_start_date;
2209: g_4712_date := to_date('01/01/4712' , 'MM/DD/YYYY');
2210: l_login_id := FND_GLOBAL.login_id ;
2211: l_run_date := sysdate;
2212:
2213: l_annu_curr_code := bis_common_parameters.get_annualized_currency_code;
2214: l_glob_curr_code := 'PRIMARY';/* BUg 4015406 bis_common_parameters.get_currency_code; */
3441: BEGIN
3442:
3443:
3444:
3445: l_user_id := FND_GLOBAL.user_id ;
3446: l_request_id := FND_GLOBAL.conc_request_id;
3447: l_program_application_id := FND_GLOBAL.prog_appl_id;
3448: l_program_id := FND_GLOBAL.conc_program_id;
3449: l_program_login_id := FND_GLOBAL.conc_login_id;
3442:
3443:
3444:
3445: l_user_id := FND_GLOBAL.user_id ;
3446: l_request_id := FND_GLOBAL.conc_request_id;
3447: l_program_application_id := FND_GLOBAL.prog_appl_id;
3448: l_program_id := FND_GLOBAL.conc_program_id;
3449: l_program_login_id := FND_GLOBAL.conc_login_id;
3450: l_run_date := OKI_DBI_LOAD_CLEB_PVT.g_run_date ;
3443:
3444:
3445: l_user_id := FND_GLOBAL.user_id ;
3446: l_request_id := FND_GLOBAL.conc_request_id;
3447: l_program_application_id := FND_GLOBAL.prog_appl_id;
3448: l_program_id := FND_GLOBAL.conc_program_id;
3449: l_program_login_id := FND_GLOBAL.conc_login_id;
3450: l_run_date := OKI_DBI_LOAD_CLEB_PVT.g_run_date ;
3451: l_oki_schema :='OKI';
3444:
3445: l_user_id := FND_GLOBAL.user_id ;
3446: l_request_id := FND_GLOBAL.conc_request_id;
3447: l_program_application_id := FND_GLOBAL.prog_appl_id;
3448: l_program_id := FND_GLOBAL.conc_program_id;
3449: l_program_login_id := FND_GLOBAL.conc_login_id;
3450: l_run_date := OKI_DBI_LOAD_CLEB_PVT.g_run_date ;
3451: l_oki_schema :='OKI';
3452: l_start_date := OKI_DBI_LOAD_CLEB_PVT.g_start_date ;
3445: l_user_id := FND_GLOBAL.user_id ;
3446: l_request_id := FND_GLOBAL.conc_request_id;
3447: l_program_application_id := FND_GLOBAL.prog_appl_id;
3448: l_program_id := FND_GLOBAL.conc_program_id;
3449: l_program_login_id := FND_GLOBAL.conc_login_id;
3450: l_run_date := OKI_DBI_LOAD_CLEB_PVT.g_run_date ;
3451: l_oki_schema :='OKI';
3452: l_start_date := OKI_DBI_LOAD_CLEB_PVT.g_start_date ;
3453: l_end_date := OKI_DBI_LOAD_CLEB_PVT.g_end_date ;
4553: BEGIN
4554:
4555:
4556:
4557: l_login_id := FND_GLOBAL.login_id ;
4558: l_user_id := FND_GLOBAL.user_id ;
4559: l_request_id := fnd_global.CONC_REQUEST_ID;
4560: l_program_application_id := fnd_global.PROG_APPL_ID;
4561: l_program_id := fnd_global.CONC_PROGRAM_ID;
4554:
4555:
4556:
4557: l_login_id := FND_GLOBAL.login_id ;
4558: l_user_id := FND_GLOBAL.user_id ;
4559: l_request_id := fnd_global.CONC_REQUEST_ID;
4560: l_program_application_id := fnd_global.PROG_APPL_ID;
4561: l_program_id := fnd_global.CONC_PROGRAM_ID;
4562: l_program_login_id := fnd_global.conc_login_id;
4555:
4556:
4557: l_login_id := FND_GLOBAL.login_id ;
4558: l_user_id := FND_GLOBAL.user_id ;
4559: l_request_id := fnd_global.CONC_REQUEST_ID;
4560: l_program_application_id := fnd_global.PROG_APPL_ID;
4561: l_program_id := fnd_global.CONC_PROGRAM_ID;
4562: l_program_login_id := fnd_global.conc_login_id;
4563:
4556:
4557: l_login_id := FND_GLOBAL.login_id ;
4558: l_user_id := FND_GLOBAL.user_id ;
4559: l_request_id := fnd_global.CONC_REQUEST_ID;
4560: l_program_application_id := fnd_global.PROG_APPL_ID;
4561: l_program_id := fnd_global.CONC_PROGRAM_ID;
4562: l_program_login_id := fnd_global.conc_login_id;
4563:
4564: l_sysdate := OKI_DBI_LOAD_CLEB_PVT.g_run_date ;
4557: l_login_id := FND_GLOBAL.login_id ;
4558: l_user_id := FND_GLOBAL.user_id ;
4559: l_request_id := fnd_global.CONC_REQUEST_ID;
4560: l_program_application_id := fnd_global.PROG_APPL_ID;
4561: l_program_id := fnd_global.CONC_PROGRAM_ID;
4562: l_program_login_id := fnd_global.conc_login_id;
4563:
4564: l_sysdate := OKI_DBI_LOAD_CLEB_PVT.g_run_date ;
4565: l_annu_curr_code := bis_common_parameters. get_annualized_currency_code;
4558: l_user_id := FND_GLOBAL.user_id ;
4559: l_request_id := fnd_global.CONC_REQUEST_ID;
4560: l_program_application_id := fnd_global.PROG_APPL_ID;
4561: l_program_id := fnd_global.CONC_PROGRAM_ID;
4562: l_program_login_id := fnd_global.conc_login_id;
4563:
4564: l_sysdate := OKI_DBI_LOAD_CLEB_PVT.g_run_date ;
4565: l_annu_curr_code := bis_common_parameters. get_annualized_currency_code;
4566: l_glob_curr_code := 'PRIMARY';/* BUg 4015406 bis_common_parameters.get_currency_code; */