APPS.IGW_PROP_APPROVALS_PVT dependencies on IGW_PROP_MAP_STOPS

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

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:

Line 546: insert into igw_prop_map_stops(prop_map_id,stop_id,

542: l_wf_display_role_name := fnd_message.get;
543:
544: end if;
545:
546: insert into igw_prop_map_stops(prop_map_id,stop_id,
547: user_name,wf_role_name,wf_display_role_name,approver_type,
548: approval_status,submission_date,approval_date,comments,
549: last_update_date,last_updated_by,creation_date,created_by,
550: last_update_login)

Line 557: --dbms_output.put_line('################Inserted into igw_prop_map_stops .....'||to_char(l_map_id));

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:
560: -- Assign the user to the proposal if it is not already assigned
561: open user_exists;

Line 1180: igw_prop_map_stops pms

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'
1184: group by pms.prop_map_id,pms.stop_id

Line 1192: igw_prop_map_stops ppms

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;
1196:

Line 1202: igw_prop_map_stops ppms

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;
1206:

Line 1222: update igw_prop_map_stops

1218: -- workflow role will not be created and the user_name will be
1219: -- used as the workflow role name
1220: for i in one_approver_in_stop loop
1221:
1222: update igw_prop_map_stops
1223: set wf_role_name = user_name
1224: where prop_map_id = i.prop_map_id
1225: and stop_id = i.stop_id;
1226: