APPS.IGW_PROPOSAL_APPROVAL dependencies on IGW_PROP_MAP_STOPS

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 555: insert into igw_prop_map_stops(prop_map_id,stop_id,

551: l_wf_display_role_name := fnd_message.get;
552:
553: end if;
554:
555: insert into igw_prop_map_stops(prop_map_id,stop_id,
556: user_name,wf_role_name,wf_display_role_name,approver_type,
557: approval_status,submission_date,approval_date,comments,
558: last_update_date,last_updated_by,creation_date,created_by,
559: last_update_login)

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

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:
566: --dbms_output.put_line('################Inserted into igw_prop_map_stops .....'||to_char(l_map_id));
567:
568:
569: -- Assign the user to the proposal if it is not already assigned
570: open user_exists;

Line 1191: igw_prop_map_stops pms

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

Line 1203: igw_prop_map_stops ppms

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

Line 1213: igw_prop_map_stops ppms

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

Line 1233: update igw_prop_map_stops

1229: -- workflow role will not be created and the user_name will be
1230: -- used as the workflow role name
1231: for i in one_approver_in_stop loop
1232:
1233: update igw_prop_map_stops
1234: set wf_role_name = user_name
1235: where prop_map_id = i.prop_map_id
1236: and stop_id = i.stop_id;
1237: