APPS.IGW_PROPOSAL_APPROVAL dependencies on IGW_PROP_MAPS

Line 475: -- insert row in igw_prop_maps and igw_prop_map_stops table

471: -- If rule_type = 'V' and the function returns 'T', then continue
472: -- If rule_type = 'V' and the function returns 'F', then display error
473: -- If rule_type = 'N' or 'R' and the function returns 'F', then continue
474: -- If rule_type = 'N' or 'R' and the function returns 'T', then
475: -- insert row in igw_prop_maps and igw_prop_map_stops table
476:
477: if (p_rule_type = 'V' and l_execute_result = '1=2' and l_valid_flag = 'V') or
478: (p_rule_type = 'V' and l_execute_result = '1=1' and l_valid_flag = 'I') then
479:

Line 517: insert into igw_prop_maps(prop_map_id,proposal_id,description,

513: p_run_id,g_proposal_id,l_run_number,'I',sysdate);
514: end if;
515: end if;
516:
517: insert into igw_prop_maps(prop_map_id,proposal_id,description,
518: map_type,map_sequence_number,run_id,approval_status,
519: last_update_date,last_updated_by,creation_date,created_by,
520: last_update_login)
521: values(

Line 522: igw_prop_maps_s.nextval,g_proposal_id,l_description,

518: map_type,map_sequence_number,run_id,approval_status,
519: last_update_date,last_updated_by,creation_date,created_by,
520: last_update_login)
521: values(
522: igw_prop_maps_s.nextval,g_proposal_id,l_description,
523: p_rule_type,l_map_seq_number,p_run_id,null,
524: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
525: fnd_global.login_id);
526:

Line 527: --dbms_output.put_line('!!!!!!!!!!!!!!!!Inserted into igw_prop_maps .....'||to_char(l_map_id));

523: p_rule_type,l_map_seq_number,p_run_id,null,
524: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
525: fnd_global.login_id);
526:
527: --dbms_output.put_line('!!!!!!!!!!!!!!!!Inserted into igw_prop_maps .....'||to_char(l_map_id));
528: for c1 in get_map_details loop
529:
530: l_user_id := c1.user_id;
531:

Line 561: igw_prop_maps_s.currval,c1.stop_id,c1.user_name,l_wf_role_name,

557: approval_status,submission_date,approval_date,comments,
558: last_update_date,last_updated_by,creation_date,created_by,
559: last_update_login)
560: values(
561: igw_prop_maps_s.currval,c1.stop_id,c1.user_name,l_wf_role_name,
562: l_wf_display_role_name,c1.approver_type,null,null,null,null,
563: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
564: fnd_global.login_id);
565:

Line 1190: from igw_prop_maps pm,

1186: /*
1187: cursor one_approver_in_stop is
1188: select pms.prop_map_id,
1189: pms.stop_id
1190: from igw_prop_maps pm,
1191: igw_prop_map_stops pms
1192: where pms.prop_map_id = pm.prop_map_id
1193: and pm.run_id = p_run_id
1194: and pm.map_type = 'R'

Line 1202: from igw_prop_maps ppm,

1198: cursor create_local_role is
1199: select distinct
1200: ppms.wf_role_name,
1201: ppms.wf_display_role_name
1202: from igw_prop_maps ppm,
1203: igw_prop_map_stops ppms
1204: where ppm.prop_map_id = ppms.prop_map_id
1205: and ppm.run_id = to_number(p_run_id)
1206: and wf_role_name <> user_name;

Line 1212: from igw_prop_maps ppm,

1208: cursor assign_user_to_role is
1209: select distinct
1210: ppms.user_name,
1211: ppms.wf_role_name
1212: from igw_prop_maps ppm,
1213: igw_prop_map_stops ppms
1214: where ppm.prop_map_id = ppms.prop_map_id
1215: and ppm.run_id = to_number(p_run_id)
1216: and wf_role_name <> user_name;