DBA Data[Home] [Help]

APPS.IGW_PROP_APPROVALS_PVT dependencies on FND_GLOBAL

Line 221: and ppu.user_id = fnd_global.user_id

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:

Line 517: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,

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

Line 518: fnd_global.login_id);

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:

Line 554: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,

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:

Line 555: fnd_global.login_id);

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:

Line 571: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,

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;

Line 572: fnd_global.login_id);

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:

Line 588: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,

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:

Line 589: fnd_global.login_id);

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

Line 602: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,

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;

Line 603: fnd_global.login_id);

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;

Line 1113: null,sysdate,fnd_global.user_id,sysdate,

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;

Line 1114: fnd_global.user_id,fnd_global.login_id);

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 ');

Line 1131: null,sysdate,fnd_global.user_id,sysdate,

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;

Line 1132: fnd_global.user_id,fnd_global.login_id);

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 ');

Line 1148: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,

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:

Line 1149: fnd_global.login_id);

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:

Line 1163: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,

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:

Line 1164: fnd_global.login_id);

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;