35: l_conc_program_id NUMBER;
36:
37: begin
38:
39: l_user_id := FND_GLOBAL.user_id;
40: l_conc_login_id := FND_GLOBAL.CONC_LOGIN_ID;
41: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
42: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
43: l_conc_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
36:
37: begin
38:
39: l_user_id := FND_GLOBAL.user_id;
40: l_conc_login_id := FND_GLOBAL.CONC_LOGIN_ID;
41: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
42: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
43: l_conc_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
44:
37: begin
38:
39: l_user_id := FND_GLOBAL.user_id;
40: l_conc_login_id := FND_GLOBAL.CONC_LOGIN_ID;
41: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
42: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
43: l_conc_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
44:
45: If x_determining_factor_code.count <> 0 then
38:
39: l_user_id := FND_GLOBAL.user_id;
40: l_conc_login_id := FND_GLOBAL.CONC_LOGIN_ID;
41: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
42: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
43: l_conc_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
44:
45: If x_determining_factor_code.count <> 0 then
46: forall i in x_determining_factor_code.first..x_determining_factor_code.last
39: l_user_id := FND_GLOBAL.user_id;
40: l_conc_login_id := FND_GLOBAL.CONC_LOGIN_ID;
41: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
42: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
43: l_conc_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
44:
45: If x_determining_factor_code.count <> 0 then
46: forall i in x_determining_factor_code.first..x_determining_factor_code.last
47: INSERT INTO ZX_CONDITIONS