[Home] [Help]
467: -- If rule_type = 'V' and the function returns 'T', then continue
468: -- If rule_type = 'V' and the function returns 'F', then display error
469: -- If rule_type = 'N' or 'R' and the function returns 'F', then continue
470: -- If rule_type = 'N' or 'R' and the function returns 'T', then
471: -- insert row in igw_prop_maps and igw_prop_map_stops table
472:
473: if (p_rule_type = 'V' and l_execute_result = '1=2' and l_valid_flag = 'V') or
474: (p_rule_type = 'V' and l_execute_result = '1=1' and l_valid_flag = 'I') then
475:
506: p_run_id,g_proposal_id,l_run_number,'I',sysdate);
507: end if;
508: end if;
509:
510: insert into igw_prop_maps(prop_map_id,proposal_id,description,
511: map_type,map_sequence_number,run_id,approval_status,
512: last_update_date,last_updated_by,creation_date,created_by,
513: last_update_login)
514: values(
511: map_type,map_sequence_number,run_id,approval_status,
512: last_update_date,last_updated_by,creation_date,created_by,
513: last_update_login)
514: values(
515: igw_prop_maps_s.nextval,g_proposal_id,l_description,
516: p_rule_type,l_map_seq_number,p_run_id,null,
517: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
518: fnd_global.login_id);
519:
516: p_rule_type,l_map_seq_number,p_run_id,null,
517: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
518: fnd_global.login_id);
519:
520: --dbms_output.put_line('!!!!!!!!!!!!!!!!Inserted into igw_prop_maps .....'||to_char(l_map_id));
521: for c1 in get_map_details loop
522:
523: l_user_id := c1.user_id;
524:
548: approval_status,submission_date,approval_date,comments,
549: last_update_date,last_updated_by,creation_date,created_by,
550: last_update_login)
551: values(
552: igw_prop_maps_s.currval,c1.stop_id,c1.user_name,l_wf_role_name,
553: l_wf_display_role_name,c1.approver_type,null,null,null,null,
554: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
555: fnd_global.login_id);
556:
1175: /*
1176: cursor one_approver_in_stop is
1177: select pms.prop_map_id,
1178: pms.stop_id
1179: from igw_prop_maps pm,
1180: igw_prop_map_stops pms
1181: where pms.prop_map_id = pm.prop_map_id
1182: and pm.run_id = p_run_id
1183: and pm.map_type = 'R'
1187: cursor create_local_role is
1188: select distinct
1189: ppms.wf_role_name,
1190: ppms.wf_display_role_name
1191: from igw_prop_maps ppm,
1192: igw_prop_map_stops ppms
1193: where ppm.prop_map_id = ppms.prop_map_id
1194: and ppm.run_id = to_number(p_run_id)
1195: and wf_role_name <> user_name;
1197: cursor assign_user_to_role is
1198: select distinct
1199: ppms.user_name,
1200: ppms.wf_role_name
1201: from igw_prop_maps ppm,
1202: igw_prop_map_stops ppms
1203: where ppm.prop_map_id = ppms.prop_map_id
1204: and ppm.run_id = to_number(p_run_id)
1205: and wf_role_name <> user_name;