217: where ppr.proposal_id = p_proposal_id
218: and ppr.proposal_id = ppu.proposal_id
219: and ppr.user_id = ppu.user_id
220: and (ppr.role_id = 0 or ppr.role_id = 2)
221: and ppu.user_id = fnd_global.user_id
222: and sysdate >= ppu.start_date_active
223: and sysdate <= nvl(ppu.end_date_active,sysdate);
224:
225:
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:
520: --dbms_output.put_line('!!!!!!!!!!!!!!!!Inserted into igw_prop_maps .....'||to_char(l_map_id));
521: for c1 in get_map_details loop
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:
520: --dbms_output.put_line('!!!!!!!!!!!!!!!!Inserted into igw_prop_maps .....'||to_char(l_map_id));
521: for c1 in get_map_details loop
522:
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:
557: --dbms_output.put_line('################Inserted into igw_prop_map_stops .....'||to_char(l_map_id));
558:
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:
557: --dbms_output.put_line('################Inserted into igw_prop_map_stops .....'||to_char(l_map_id));
558:
559:
567: last_update_date,last_updated_by,creation_date, created_by,
568: last_update_login)
569: values(
570: g_proposal_id,l_user_id,sysdate,null,
571: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
572: fnd_global.login_id);
573:
574: end if;
575: close user_exists;
568: last_update_login)
569: values(
570: g_proposal_id,l_user_id,sysdate,null,
571: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
572: fnd_global.login_id);
573:
574: end if;
575: close user_exists;
576:
584: last_update_date,last_updated_by,creation_date, created_by,
585: last_update_login)
586: values(
587: g_proposal_id,l_user_id,4,
588: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
589: fnd_global.login_id);
590: end if;
591: close role_exists;
592:
585: last_update_login)
586: values(
587: g_proposal_id,l_user_id,4,
588: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
589: fnd_global.login_id);
590: end if;
591: close role_exists;
592:
593: elsif p_rule_type = 'R' then
598: last_update_date,last_updated_by,creation_date, created_by,
599: last_update_login)
600: values(
601: g_proposal_id,l_user_id,1,
602: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
603: fnd_global.login_id);
604: end if;
605: close role_exists;
606: end if;
599: last_update_login)
600: values(
601: g_proposal_id,l_user_id,1,
602: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
603: fnd_global.login_id);
604: end if;
605: close role_exists;
606: end if;
607: end loop;
1109: end_date_active,last_update_date,last_updated_by,creation_date,
1110: created_by,last_update_login)
1111: values(
1112: g_proposal_id,l_sign_off_user_id,sysdate,
1113: null,sysdate,fnd_global.user_id,sysdate,
1114: fnd_global.user_id,fnd_global.login_id);
1115:
1116: end if;
1117: close so_user_exists;
1110: created_by,last_update_login)
1111: values(
1112: g_proposal_id,l_sign_off_user_id,sysdate,
1113: null,sysdate,fnd_global.user_id,sysdate,
1114: fnd_global.user_id,fnd_global.login_id);
1115:
1116: end if;
1117: close so_user_exists;
1118: -- dbms_output.put_line('After inserting so into prop_users ');
1127: end_date_active,last_update_date,last_updated_by,creation_date,
1128: created_by,last_update_login)
1129: values(
1130: g_proposal_id,l_admin_off_user_id,sysdate,
1131: null,sysdate,fnd_global.user_id,sysdate,
1132: fnd_global.user_id,fnd_global.login_id);
1133:
1134: end if;
1135: close so_user_exists;
1128: created_by,last_update_login)
1129: values(
1130: g_proposal_id,l_admin_off_user_id,sysdate,
1131: null,sysdate,fnd_global.user_id,sysdate,
1132: fnd_global.user_id,fnd_global.login_id);
1133:
1134: end if;
1135: close so_user_exists;
1136: -- dbms_output.put_line('After inserting ao into prop_users ');
1144: last_update_date,last_updated_by,creation_date, created_by,
1145: last_update_login)
1146: values(
1147: g_proposal_id,l_sign_off_user_id,3,
1148: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
1149: fnd_global.login_id);
1150: end if;
1151: close so_user_role_exists;
1152:
1145: last_update_login)
1146: values(
1147: g_proposal_id,l_sign_off_user_id,3,
1148: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
1149: fnd_global.login_id);
1150: end if;
1151: close so_user_role_exists;
1152:
1153:
1159: last_update_date,last_updated_by,creation_date, created_by,
1160: last_update_login)
1161: values(
1162: g_proposal_id,l_admin_off_user_id,3,
1163: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
1164: fnd_global.login_id);
1165: end if;
1166: close so_user_role_exists;
1167:
1160: last_update_login)
1161: values(
1162: g_proposal_id,l_admin_off_user_id,3,
1163: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
1164: fnd_global.login_id);
1165: end if;
1166: close so_user_role_exists;
1167:
1168: end if;