552: l_incomplete_fail_flag VARCHAR2(2) ;
553: result NUMBER ;
554:
555: /* Bug#3018526. Added variables to get the who column values */
556: l_request_id NUMBER := nvl(fnd_global.conc_request_id(), -1);
557: l_program_id NUMBER := nvl(fnd_global.conc_program_id(), -1);
558: l_update_login NUMBER := nvl(FND_GLOBAL.login_id, -1);
559:
560: -- bug 9339798 start
553: result NUMBER ;
554:
555: /* Bug#3018526. Added variables to get the who column values */
556: l_request_id NUMBER := nvl(fnd_global.conc_request_id(), -1);
557: l_program_id NUMBER := nvl(fnd_global.conc_program_id(), -1);
558: l_update_login NUMBER := nvl(FND_GLOBAL.login_id, -1);
559:
560: -- bug 9339798 start
561: CURSOR est_asset_units_cur ( i_project_asset_id NUMBER)
554:
555: /* Bug#3018526. Added variables to get the who column values */
556: l_request_id NUMBER := nvl(fnd_global.conc_request_id(), -1);
557: l_program_id NUMBER := nvl(fnd_global.conc_program_id(), -1);
558: l_update_login NUMBER := nvl(FND_GLOBAL.login_id, -1);
559:
560: -- bug 9339798 start
561: CURSOR est_asset_units_cur ( i_project_asset_id NUMBER)
562: IS