2099: l_discrete_under_flow varchar2(1) := 'N'; --will become Y if there is a discrete under top most flow parent
2100: l_sub_level_buy_item varchar2(1) := 'N';
2101: l_user_id number ;
2102: l_login_id number;
2103: --l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2104: l_program_id number;
2105:
2106: l_token CTO_MSG_PUB.token_tbl;
2107:
3495: IF (l_discrete_under_flow = 'N') THEN
3496: l_discrete_under_flow := 'Y';
3497:
3498: --intialize var's to be used in isnerting WJSI table
3499: l_user_id := FND_GLOBAL.USER_ID;
3500: l_login_id := FND_GLOBAL.LOGIN_ID;
3501: --l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
3502: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
3503:
3496: l_discrete_under_flow := 'Y';
3497:
3498: --intialize var's to be used in isnerting WJSI table
3499: l_user_id := FND_GLOBAL.USER_ID;
3500: l_login_id := FND_GLOBAL.LOGIN_ID;
3501: --l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
3502: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
3503:
3504: select wip_job_schedule_interface_s.nextval
3497:
3498: --intialize var's to be used in isnerting WJSI table
3499: l_user_id := FND_GLOBAL.USER_ID;
3500: l_login_id := FND_GLOBAL.LOGIN_ID;
3501: --l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
3502: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
3503:
3504: select wip_job_schedule_interface_s.nextval
3505: into x_groupID
3498: --intialize var's to be used in isnerting WJSI table
3499: l_user_id := FND_GLOBAL.USER_ID;
3500: l_login_id := FND_GLOBAL.LOGIN_ID;
3501: --l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
3502: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
3503:
3504: select wip_job_schedule_interface_s.nextval
3505: into x_groupID
3506: from dual;