eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGW_PROP dependencies on IGW_PROP

Line 1: PACKAGE BODY igw_prop AS

1: PACKAGE BODY igw_prop AS
2: --$Header: igwprcpb.pls 115.57 2002/11/14 18:49:26 vmedikon ship $
3:
4: -----------------------------------------------------------------------------
5:

Line 106: FROM igw_prop_persons pp,

102: BEGIN
103:
104: SELECT full_name
105: INTO v_pi_full_name
106: FROM igw_prop_persons pp,
107: per_people_x per
108: WHERE pp.proposal_id = p_proposal_id
109: AND pp.pi_flag = 'Y'
110: AND per.person_id = pp.person_id;

Line 131: FROM igw_prop_persons pp,

127: BEGIN
128:
129: SELECT last_name||','||first_name
130: INTO v_pi_full_name
131: FROM igw_prop_persons pp,
132: per_people_x per
133: WHERE pp.proposal_id = p_proposal_id
134: AND pp.pi_flag = 'Y'
135: AND per.person_id = pp.person_id;

Line 184: FROM igw_prop_narratives

180: BEGIN
181:
182: SELECT count(*)
183: INTO v_count_incomplete
184: FROM igw_prop_narratives
185: WHERE proposal_id = p_proposal_id
186: AND module_status = 'I';
187:
188: SELECT count(*)

Line 190: FROM igw_prop_narratives

186: AND module_status = 'I';
187:
188: SELECT count(*)
189: INTO v_count_complete
190: FROM igw_prop_narratives
191: WHERE proposal_id = p_proposal_id
192: AND module_status = 'C';
193:
194: IF v_count_incomplete = 0 and v_count_complete = 0 THEN

Line 239: from igw_prop_user_roles

235: RETURN varchar2 IS
236:
237: CURSOR cur_user_roles IS
238: select 'Y'
239: from igw_prop_user_roles
240: where proposal_id = p_proposal_id
241: and user_id = p_user_id
242: and role_id = 3;
243:

Line 274: v_parent_organization_id := igw_proposal_approval.get_parent_org_id( v_curr_organization_id );

270: BEGIN
271:
272: LOOP
273:
274: v_parent_organization_id := igw_proposal_approval.get_parent_org_id( v_curr_organization_id );
275:
276: IF v_parent_organization_id IS null THEN
277: exit;
278: END IF;

Line 308: INSERT INTO igw_prop_users

304: p_user_id number,
305: p_role_id number ) IS
306: BEGIN
307:
308: INSERT INTO igw_prop_users
309: (
310: proposal_id,
311: user_id,
312: start_date_active,

Line 334: FROM igw_prop_users

330: FROM
331: dual
332: WHERE not exists
333: ( SELECT 'X'
334: FROM igw_prop_users
335: WHERE proposal_id = p_proposal_id
336: AND user_id = p_user_id );
337:
338:

Line 339: INSERT INTO igw_prop_user_roles

335: WHERE proposal_id = p_proposal_id
336: AND user_id = p_user_id );
337:
338:
339: INSERT INTO igw_prop_user_roles
340: (
341: proposal_id,
342: user_id,
343: role_id,

Line 363: FROM igw_prop_user_roles

359: FROM
360: dual
361: WHERE not exists
362: ( SELECT 'X'
363: FROM igw_prop_user_roles
364: WHERE proposal_id = p_proposal_id
365: AND user_id = p_user_id
366: AND role_id = p_role_id );
367:

Line 378: DELETE igw_prop_user_roles

374: p_user_id number,
375: p_role_id number ) IS
376: BEGIN
377:
378: DELETE igw_prop_user_roles
379: WHERE proposal_id = p_proposal_id
380: AND user_id = p_user_id
381: AND role_id = p_role_id;
382:

Line 383: DELETE igw_prop_users

379: WHERE proposal_id = p_proposal_id
380: AND user_id = p_user_id
381: AND role_id = p_role_id;
382:
383: DELETE igw_prop_users
384: WHERE proposal_id = p_proposal_id
385: AND user_id = p_user_id
386: AND not exists (
387: SELECT 'X'

Line 388: FROM igw_prop_user_roles

384: WHERE proposal_id = p_proposal_id
385: AND user_id = p_user_id
386: AND not exists (
387: SELECT 'X'
388: FROM igw_prop_user_roles
389: WHERE proposal_id = p_proposal_id
390: AND user_id = p_user_id );
391:
392: END del_prop_user_role;

Line 410: INSERT INTO igw_proposals_all

406:
407: PROCEDURE copy_proposal
408: ( p_old_proposal_id number, p_new_proposal_id number, p_new_proposal_number varchar2 ) IS
409: BEGIN
410: INSERT INTO igw_proposals_all
411: (
412: sponsor_action_code,
413: sponsor_action_date,
414: award_amount,

Line 523: igw_proposals_all

519: attribute13,
520: attribute14,
521: attribute15
522: FROM
523: igw_proposals_all
524: WHERE
525: proposal_id = p_old_proposal_id;
526: EXCEPTION
527: WHEN OTHERS THEN

Line 528: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_PROPOSAL');

524: WHERE
525: proposal_id = p_old_proposal_id;
526: EXCEPTION
527: WHEN OTHERS THEN
528: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_PROPOSAL');
529: raise;
530: END;
531:
532:

Line 536: INSERT INTO igw_prop_users

532:
533: PROCEDURE copy_proposal_manager_role
534: ( p_old_proposal_id number, p_new_proposal_id number ) IS
535: BEGIN
536: INSERT INTO igw_prop_users
537: (
538: proposal_id,
539: user_id,
540: start_date_active,

Line 561: igw_prop_user_roles

557: SYSDATE,
558: FND_GLOBAL.USER_ID,
559: FND_GLOBAL.LOGIN_ID
560: FROM
561: igw_prop_user_roles
562: WHERE
563: proposal_id = p_old_proposal_id and
564: role_id = 0
565: ;

Line 568: INSERT INTO igw_prop_user_roles

564: role_id = 0
565: ;
566:
567:
568: INSERT INTO igw_prop_user_roles
569: (
570: proposal_id,
571: user_id,
572: role_id,

Line 591: igw_prop_user_roles

587: SYSDATE,
588: FND_GLOBAL.USER_ID,
589: FND_GLOBAL.LOGIN_ID
590: FROM
591: igw_prop_user_roles
592: WHERE
593: proposal_id = p_old_proposal_id and
594: role_id = 0
595: ;

Line 599: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_PROPOSAL_MANAGER_ROLE');

595: ;
596:
597: EXCEPTION
598: WHEN OTHERS THEN
599: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_PROPOSAL_MANAGER_ROLE');
600: raise;
601: END;
602:
603:

Line 609: INSERT INTO igw_prop_program_addresses

605:
606: PROCEDURE copy_program_addresses
607: ( p_old_proposal_id number, p_new_proposal_id number ) IS
608: BEGIN
609: INSERT INTO igw_prop_program_addresses
610: (
611: proposal_id,
612: address_id,
613: number_of_copies,

Line 634: igw_prop_program_addresses

630: SYSDATE,
631: FND_GLOBAL.USER_ID,
632: FND_GLOBAL.LOGIN_ID
633: FROM
634: igw_prop_program_addresses
635: WHERE
636: proposal_id = p_old_proposal_id;
637: EXCEPTION
638: WHEN OTHERS THEN

Line 639: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_PROGRAM_ADDRESSES');

635: WHERE
636: proposal_id = p_old_proposal_id;
637: EXCEPTION
638: WHEN OTHERS THEN
639: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_PROGRAM_ADDRESSES');
640: raise;
641: END;
642:
643:

Line 648: INSERT INTO igw_prop_locations

644:
645: PROCEDURE copy_locations
646: ( p_old_proposal_id number, p_new_proposal_id number ) IS
647: BEGIN
648: INSERT INTO igw_prop_locations
649: (
650: prop_location_id,
651: proposal_id,
652: performing_organization_id,

Line 662: igw_prop_locations_s.nextval,

658: created_by,
659: last_update_login
660: )
661: SELECT
662: igw_prop_locations_s.nextval,
663: p_new_proposal_id,
664: performing_organization_id,
665: party_id,
666: 1,

Line 673: igw_prop_locations

669: SYSDATE,
670: FND_GLOBAL.USER_ID,
671: FND_GLOBAL.LOGIN_ID
672: FROM
673: igw_prop_locations
674: WHERE
675: proposal_id = p_old_proposal_id;
676: EXCEPTION
677: WHEN OTHERS THEN

Line 678: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_LOCATIONS');

674: WHERE
675: proposal_id = p_old_proposal_id;
676: EXCEPTION
677: WHEN OTHERS THEN
678: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_LOCATIONS');
679: raise;
680: END;
681:
682:

Line 687: INSERT INTO igw_prop_persons

683:
684: PROCEDURE copy_persons
685: ( p_old_proposal_id number, p_new_proposal_id number ) IS
686: BEGIN
687: INSERT INTO igw_prop_persons
688: (
689: proposal_id,
690: person_id,
691: person_party_id,

Line 724: igw_prop_persons

720: SYSDATE,
721: FND_GLOBAL.USER_ID,
722: FND_GLOBAL.LOGIN_ID
723: FROM
724: igw_prop_persons
725: WHERE
726: proposal_id = p_old_proposal_id;
727: EXCEPTION
728: WHEN OTHERS THEN

Line 729: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_PERSONS');

725: WHERE
726: proposal_id = p_old_proposal_id;
727: EXCEPTION
728: WHEN OTHERS THEN
729: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_PERSONS');
730: raise;
731: END;
732:
733:

Line 737: INSERT INTO igw_prop_special_reviews

733:
734: PROCEDURE copy_special_reviews
735: ( p_old_proposal_id number, p_new_proposal_id number ) IS
736: BEGIN
737: INSERT INTO igw_prop_special_reviews
738: (
739: proposal_id,
740: special_review_code,
741: special_review_type,

Line 770: igw_prop_special_reviews

766: SYSDATE,
767: FND_GLOBAL.USER_ID,
768: FND_GLOBAL.LOGIN_ID
769: FROM
770: igw_prop_special_reviews
771: WHERE
772: proposal_id = p_old_proposal_id;
773: EXCEPTION
774: WHEN OTHERS THEN

Line 775: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_SPECIAL_REVIEWS');

771: WHERE
772: proposal_id = p_old_proposal_id;
773: EXCEPTION
774: WHEN OTHERS THEN
775: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_SPECIAL_REVIEWS');
776: raise;
777: END;
778:
779:

Line 785: INSERT INTO igw_prop_science_codes

781:
782: PROCEDURE copy_science_codes
783: ( p_old_proposal_id number, p_new_proposal_id number ) IS
784: BEGIN
785: INSERT INTO igw_prop_science_codes
786: (
787: proposal_id,
788: science_code,
789: record_version_number,

Line 806: igw_prop_science_codes

802: SYSDATE,
803: FND_GLOBAL.USER_ID,
804: FND_GLOBAL.LOGIN_ID
805: FROM
806: igw_prop_science_codes
807: WHERE
808: proposal_id = p_old_proposal_id;
809: EXCEPTION
810: WHEN OTHERS THEN

Line 811: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_SCIENCE_CODES');

807: WHERE
808: proposal_id = p_old_proposal_id;
809: EXCEPTION
810: WHEN OTHERS THEN
811: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_SCIENCE_CODES');
812: raise;
813: END;
814:
815:

Line 819: INSERT INTO igw_prop_abstracts

815:
816: PROCEDURE copy_abstracts
817: ( p_old_proposal_id number, p_new_proposal_id number ) IS
818: BEGIN
819: INSERT INTO igw_prop_abstracts
820: (
821: proposal_id,
822: abstract_type,
823: abstract_type_code,

Line 876: igw_prop_abstracts

872: attribute13,
873: attribute14,
874: attribute15
875: FROM
876: igw_prop_abstracts
877: WHERE
878: proposal_id = p_old_proposal_id;
879: EXCEPTION
880: WHEN OTHERS THEN

Line 881: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_ABSTRACTS');

877: WHERE
878: proposal_id = p_old_proposal_id;
879: EXCEPTION
880: WHEN OTHERS THEN
881: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_ABSTRACTS');
882: raise;
883: END;
884:
885:

Line 916: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_BUDGETS');

912: END IF;
913:
914: EXCEPTION
915: WHEN copy_budget_error THEN
916: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_BUDGETS');
917: raise;
918:
919: WHEN others THEN
920: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_BUDGETS');

Line 920: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_BUDGETS');

916: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_BUDGETS');
917: raise;
918:
919: WHEN others THEN
920: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_BUDGETS');
921: raise;
922: END;
923:
924:

Line 929: INSERT INTO igw_prop_narratives

925:
926: PROCEDURE copy_narratives
927: ( p_old_proposal_id number, p_new_proposal_id number ) IS
928: BEGIN
929: INSERT INTO igw_prop_narratives
930: (
931: proposal_id,
932: module_id,
933: comments,

Line 962: igw_prop_narratives

958: contact_name,
959: phone_number,
960: module_title
961: FROM
962: igw_prop_narratives
963: WHERE
964: proposal_id = p_old_proposal_id;
965:
966: UPDATE igw_proposals_all

Line 966: UPDATE igw_proposals_all

962: igw_prop_narratives
963: WHERE
964: proposal_id = p_old_proposal_id;
965:
966: UPDATE igw_proposals_all
967: SET (narrative_type_code, narrative_submission_code) =
968: ( SELECT narrative_type_code, narrative_submission_code
969: FROM igw_proposals_all
970: WHERE proposal_id = p_old_proposal_id )

Line 969: FROM igw_proposals_all

965:
966: UPDATE igw_proposals_all
967: SET (narrative_type_code, narrative_submission_code) =
968: ( SELECT narrative_type_code, narrative_submission_code
969: FROM igw_proposals_all
970: WHERE proposal_id = p_old_proposal_id )
971: WHERE proposal_id = p_new_proposal_id;
972:
973: EXCEPTION

Line 975: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_NARRATIVES');

971: WHERE proposal_id = p_new_proposal_id;
972:
973: EXCEPTION
974: WHEN OTHERS THEN
975: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_NARRATIVES');
976: raise;
977: END;
978:
979:

Line 990: INSERT INTO igw_prop_checklist

986: BEGIN
987:
988: /*
989:
990: INSERT INTO igw_prop_checklist
991: (
992: proposal_id,
993: document_type_code,
994: checklist_order,

Line 1017: igw_prop_checklist

1013: SYSDATE,
1014: FND_GLOBAL.USER_ID,
1015: FND_GLOBAL.LOGIN_ID
1016: FROM
1017: igw_prop_checklist
1018: WHERE
1019: proposal_id = p_old_proposal_id;
1020:
1021: */

Line 1023: Igw_Prop_Checklist_Pvt.Populate_Checklist

1019: proposal_id = p_old_proposal_id;
1020:
1021: */
1022:
1023: Igw_Prop_Checklist_Pvt.Populate_Checklist
1024: (
1025: p_proposal_id => p_new_proposal_id,
1026: x_return_status => l_return_status
1027: );

Line 1031: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_COMPONENT_STATUSES');

1027: );
1028:
1029: EXCEPTION
1030: WHEN OTHERS THEN
1031: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_COMPONENT_STATUSES');
1032: raise;
1033: END;
1034:
1035:

Line 1041: x_from_entity_name => 'IGW_PROPOSALS_ALL',

1037: ( p_old_proposal_id number, p_new_proposal_id number ) IS
1038: BEGIN
1039: fnd_attached_documents2_pkg.copy_attachments
1040: (
1041: x_from_entity_name => 'IGW_PROPOSALS_ALL',
1042: x_from_pk1_value => p_old_proposal_id,
1043: x_from_pk2_value => null,
1044: x_from_pk3_value => null,
1045: x_from_pk4_value => null,

Line 1047: x_to_entity_name => 'IGW_PROPOSALS_ALL',

1043: x_from_pk2_value => null,
1044: x_from_pk3_value => null,
1045: x_from_pk4_value => null,
1046: x_from_pk5_value => null,
1047: x_to_entity_name => 'IGW_PROPOSALS_ALL',
1048: x_to_pk1_value => p_new_proposal_id,
1049: x_to_pk2_value => null,
1050: x_to_pk3_value => null,
1051: x_to_pk4_value => null,

Line 1061: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_PROPOSAL_ATTACHMENTS');

1057: x_request_id => null
1058: );
1059: EXCEPTION
1060: WHEN OTHERS THEN
1061: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_PROPOSAL_ATTACHMENTS');
1062: raise;
1063: END;
1064:
1065:

Line 1072: where entity_name = 'IGW_PROP_NARRATIVES'

1068:
1069: cursor cur_narr_attch is
1070: select distinct pk2_value
1071: from fnd_attached_documents
1072: where entity_name = 'IGW_PROP_NARRATIVES'
1073: and pk1_value = p_old_proposal_id;
1074:
1075: BEGIN
1076:

Line 1081: x_from_entity_name => 'IGW_PROP_NARRATIVES',

1077: for rec_narr_attch in cur_narr_attch loop
1078:
1079: fnd_attached_documents2_pkg.copy_attachments
1080: (
1081: x_from_entity_name => 'IGW_PROP_NARRATIVES',
1082: x_from_pk1_value => p_old_proposal_id,
1083: x_from_pk2_value => rec_narr_attch.pk2_value,
1084: x_from_pk3_value => null,
1085: x_from_pk4_value => null,

Line 1087: x_to_entity_name => 'IGW_PROP_NARRATIVES',

1083: x_from_pk2_value => rec_narr_attch.pk2_value,
1084: x_from_pk3_value => null,
1085: x_from_pk4_value => null,
1086: x_from_pk5_value => null,
1087: x_to_entity_name => 'IGW_PROP_NARRATIVES',
1088: x_to_pk1_value => p_new_proposal_id,
1089: x_to_pk2_value => rec_narr_attch.pk2_value,
1090: x_to_pk3_value => null,
1091: x_to_pk4_value => null,

Line 1104: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_NARRATIVE_ATTACHMENTS');

1100: end loop;
1101:
1102: EXCEPTION
1103: WHEN OTHERS THEN
1104: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_NARRATIVE_ATTACHMENTS');
1105: raise;
1106: END;
1107:
1108:

Line 1152: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_PROPOSAL_ALL' );

1148:
1149: exception
1150: when others then
1151: rollback to a;
1152: fnd_msg_pub.add_exc_msg('IGW_PROP', 'COPY_PROPOSAL_ALL' );
1153: o_error_message := fnd_msg_pub.get( p_msg_index => FND_MSG_PUB.G_FIRST,
1154: p_encoded => FND_API.G_TRUE );
1155: o_return_status := 'U';
1156:

Line 1168: update igw_prop_checklist

1164: i_value IN varchar2 ) IS
1165: BEGIN
1166:
1167: IF i_component_name = 'BUDGET' THEN
1168: update igw_prop_checklist
1169: set complete = decode(i_value,'C','Y','N'),
1170: not_applicable = decode(i_value,'N','Y','N'),
1171: last_update_date = sysdate,
1172: last_updated_by = fnd_global.user_id,

Line 1179: update igw_prop_checklist

1175: and document_type_code = 'BUDGETS';
1176:
1177: ELSIF i_component_name = 'NARRATIVE' THEN
1178:
1179: update igw_prop_checklist
1180: set complete = decode(i_value,'C','Y','N'),
1181: not_applicable = decode(i_value,'N','Y','N'),
1182: last_update_date = sysdate,
1183: last_updated_by = fnd_global.user_id,

Line 1194: END igw_prop;

1190: END set_component_status;
1191:
1192: -----------------------------------------------------------------------------
1193:
1194: END igw_prop;