492: delete mtl_period_summary WHERE organization_id = l_organization_id;
493:
494: select sysdate into l_date from dual;
495:
496: l_user_id := fnd_global.user_id;
497: l_login_id := fnd_global.login_id;
498:
499: IF l_login_id = -1 THEN
500: l_login_id := fnd_global.conc_login_id;
493:
494: select sysdate into l_date from dual;
495:
496: l_user_id := fnd_global.user_id;
497: l_login_id := fnd_global.login_id;
498:
499: IF l_login_id = -1 THEN
500: l_login_id := fnd_global.conc_login_id;
501: END IF;
496: l_user_id := fnd_global.user_id;
497: l_login_id := fnd_global.login_id;
498:
499: IF l_login_id = -1 THEN
500: l_login_id := fnd_global.conc_login_id;
501: END IF;
502:
503: l_request_id := fnd_global.conc_request_id;
504: l_prog_appl_id := fnd_global.prog_appl_id;
499: IF l_login_id = -1 THEN
500: l_login_id := fnd_global.conc_login_id;
501: END IF;
502:
503: l_request_id := fnd_global.conc_request_id;
504: l_prog_appl_id := fnd_global.prog_appl_id;
505: l_program_id := fnd_global.conc_program_id;
506:
507: /*
500: l_login_id := fnd_global.conc_login_id;
501: END IF;
502:
503: l_request_id := fnd_global.conc_request_id;
504: l_prog_appl_id := fnd_global.prog_appl_id;
505: l_program_id := fnd_global.conc_program_id;
506:
507: /*
508: ** Reload grouped data into table
501: END IF;
502:
503: l_request_id := fnd_global.conc_request_id;
504: l_prog_appl_id := fnd_global.prog_appl_id;
505: l_program_id := fnd_global.conc_program_id;
506:
507: /*
508: ** Reload grouped data into table
509: */
565: end loop;
566: delete mtl_period_summary WHERE organization_id = l_organization_id;
567: select sysdate into l_date from dual;
568:
569: l_user_id := fnd_global.user_id;
570: l_login_id := fnd_global.login_id;
571:
572: IF l_login_id = -1 THEN
573: l_login_id := fnd_global.conc_login_id;
566: delete mtl_period_summary WHERE organization_id = l_organization_id;
567: select sysdate into l_date from dual;
568:
569: l_user_id := fnd_global.user_id;
570: l_login_id := fnd_global.login_id;
571:
572: IF l_login_id = -1 THEN
573: l_login_id := fnd_global.conc_login_id;
574: END IF;
569: l_user_id := fnd_global.user_id;
570: l_login_id := fnd_global.login_id;
571:
572: IF l_login_id = -1 THEN
573: l_login_id := fnd_global.conc_login_id;
574: END IF;
575:
576: l_request_id := fnd_global.conc_request_id;
577: l_prog_appl_id := fnd_global.prog_appl_id;
572: IF l_login_id = -1 THEN
573: l_login_id := fnd_global.conc_login_id;
574: END IF;
575:
576: l_request_id := fnd_global.conc_request_id;
577: l_prog_appl_id := fnd_global.prog_appl_id;
578: l_program_id := fnd_global.conc_program_id;
579:
580: /*
573: l_login_id := fnd_global.conc_login_id;
574: END IF;
575:
576: l_request_id := fnd_global.conc_request_id;
577: l_prog_appl_id := fnd_global.prog_appl_id;
578: l_program_id := fnd_global.conc_program_id;
579:
580: /*
581: ** Reload grouped data into table
574: END IF;
575:
576: l_request_id := fnd_global.conc_request_id;
577: l_prog_appl_id := fnd_global.prog_appl_id;
578: l_program_id := fnd_global.conc_program_id;
579:
580: /*
581: ** Reload grouped data into table
582: */