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 FND_GLOBAL

Line 326: FND_GLOBAL.USER_ID,

322: p_user_id,
323: SYSDATE,
324: null,
325: SYSDATE,
326: FND_GLOBAL.USER_ID,
327: SYSDATE,
328: FND_GLOBAL.USER_ID,
329: FND_GLOBAL.LOGIN_ID
330: FROM

Line 328: FND_GLOBAL.USER_ID,

324: null,
325: SYSDATE,
326: FND_GLOBAL.USER_ID,
327: SYSDATE,
328: FND_GLOBAL.USER_ID,
329: FND_GLOBAL.LOGIN_ID
330: FROM
331: dual
332: WHERE not exists

Line 329: FND_GLOBAL.LOGIN_ID

325: SYSDATE,
326: FND_GLOBAL.USER_ID,
327: SYSDATE,
328: FND_GLOBAL.USER_ID,
329: FND_GLOBAL.LOGIN_ID
330: FROM
331: dual
332: WHERE not exists
333: ( SELECT 'X'

Line 355: FND_GLOBAL.USER_ID,

351: p_proposal_id,
352: p_user_id,
353: p_role_id,
354: SYSDATE,
355: FND_GLOBAL.USER_ID,
356: SYSDATE,
357: FND_GLOBAL.USER_ID,
358: FND_GLOBAL.LOGIN_ID
359: FROM

Line 357: FND_GLOBAL.USER_ID,

353: p_role_id,
354: SYSDATE,
355: FND_GLOBAL.USER_ID,
356: SYSDATE,
357: FND_GLOBAL.USER_ID,
358: FND_GLOBAL.LOGIN_ID
359: FROM
360: dual
361: WHERE not exists

Line 358: FND_GLOBAL.LOGIN_ID

354: SYSDATE,
355: FND_GLOBAL.USER_ID,
356: SYSDATE,
357: FND_GLOBAL.USER_ID,
358: FND_GLOBAL.LOGIN_ID
359: FROM
360: dual
361: WHERE not exists
362: ( SELECT 'X'

Line 502: FND_GLOBAL.USER_ID,

498: deadline_type,
499: letter_of_intent_due_date,
500: 1,
501: SYSDATE,
502: FND_GLOBAL.USER_ID,
503: SYSDATE,
504: FND_GLOBAL.USER_ID,
505: FND_GLOBAL.LOGIN_ID,
506: attribute_category,

Line 504: FND_GLOBAL.USER_ID,

500: 1,
501: SYSDATE,
502: FND_GLOBAL.USER_ID,
503: SYSDATE,
504: FND_GLOBAL.USER_ID,
505: FND_GLOBAL.LOGIN_ID,
506: attribute_category,
507: attribute1,
508: attribute2,

Line 505: FND_GLOBAL.LOGIN_ID,

501: SYSDATE,
502: FND_GLOBAL.USER_ID,
503: SYSDATE,
504: FND_GLOBAL.USER_ID,
505: FND_GLOBAL.LOGIN_ID,
506: attribute_category,
507: attribute1,
508: attribute2,
509: attribute3,

Line 556: FND_GLOBAL.USER_ID,

552: SYSDATE,
553: null,
554: 1,
555: SYSDATE,
556: FND_GLOBAL.USER_ID,
557: SYSDATE,
558: FND_GLOBAL.USER_ID,
559: FND_GLOBAL.LOGIN_ID
560: FROM

Line 558: FND_GLOBAL.USER_ID,

554: 1,
555: SYSDATE,
556: FND_GLOBAL.USER_ID,
557: SYSDATE,
558: FND_GLOBAL.USER_ID,
559: FND_GLOBAL.LOGIN_ID
560: FROM
561: igw_prop_user_roles
562: WHERE

Line 559: FND_GLOBAL.LOGIN_ID

555: SYSDATE,
556: FND_GLOBAL.USER_ID,
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

Line 586: FND_GLOBAL.USER_ID,

582: user_id,
583: role_id,
584: 1,
585: SYSDATE,
586: FND_GLOBAL.USER_ID,
587: SYSDATE,
588: FND_GLOBAL.USER_ID,
589: FND_GLOBAL.LOGIN_ID
590: FROM

Line 588: FND_GLOBAL.USER_ID,

584: 1,
585: SYSDATE,
586: FND_GLOBAL.USER_ID,
587: SYSDATE,
588: FND_GLOBAL.USER_ID,
589: FND_GLOBAL.LOGIN_ID
590: FROM
591: igw_prop_user_roles
592: WHERE

Line 589: FND_GLOBAL.LOGIN_ID

585: SYSDATE,
586: FND_GLOBAL.USER_ID,
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

Line 629: FND_GLOBAL.USER_ID,

625: number_of_copies,
626: mail_description,
627: 1,
628: SYSDATE,
629: FND_GLOBAL.USER_ID,
630: SYSDATE,
631: FND_GLOBAL.USER_ID,
632: FND_GLOBAL.LOGIN_ID
633: FROM

Line 631: FND_GLOBAL.USER_ID,

627: 1,
628: SYSDATE,
629: FND_GLOBAL.USER_ID,
630: SYSDATE,
631: FND_GLOBAL.USER_ID,
632: FND_GLOBAL.LOGIN_ID
633: FROM
634: igw_prop_program_addresses
635: WHERE

Line 632: FND_GLOBAL.LOGIN_ID

628: SYSDATE,
629: FND_GLOBAL.USER_ID,
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;

Line 668: FND_GLOBAL.USER_ID,

664: performing_organization_id,
665: party_id,
666: 1,
667: SYSDATE,
668: FND_GLOBAL.USER_ID,
669: SYSDATE,
670: FND_GLOBAL.USER_ID,
671: FND_GLOBAL.LOGIN_ID
672: FROM

Line 670: FND_GLOBAL.USER_ID,

666: 1,
667: SYSDATE,
668: FND_GLOBAL.USER_ID,
669: SYSDATE,
670: FND_GLOBAL.USER_ID,
671: FND_GLOBAL.LOGIN_ID
672: FROM
673: igw_prop_locations
674: WHERE

Line 671: FND_GLOBAL.LOGIN_ID

667: SYSDATE,
668: FND_GLOBAL.USER_ID,
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;

Line 719: FND_GLOBAL.USER_ID,

715: person_organization_id,
716: org_party_id,
717: 1,
718: SYSDATE,
719: FND_GLOBAL.USER_ID,
720: SYSDATE,
721: FND_GLOBAL.USER_ID,
722: FND_GLOBAL.LOGIN_ID
723: FROM

Line 721: FND_GLOBAL.USER_ID,

717: 1,
718: SYSDATE,
719: FND_GLOBAL.USER_ID,
720: SYSDATE,
721: FND_GLOBAL.USER_ID,
722: FND_GLOBAL.LOGIN_ID
723: FROM
724: igw_prop_persons
725: WHERE

Line 722: FND_GLOBAL.LOGIN_ID

718: SYSDATE,
719: FND_GLOBAL.USER_ID,
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;

Line 765: FND_GLOBAL.USER_ID,

761: approval_date,
762: comments,
763: 1,
764: SYSDATE,
765: FND_GLOBAL.USER_ID,
766: SYSDATE,
767: FND_GLOBAL.USER_ID,
768: FND_GLOBAL.LOGIN_ID
769: FROM

Line 767: FND_GLOBAL.USER_ID,

763: 1,
764: SYSDATE,
765: FND_GLOBAL.USER_ID,
766: SYSDATE,
767: FND_GLOBAL.USER_ID,
768: FND_GLOBAL.LOGIN_ID
769: FROM
770: igw_prop_special_reviews
771: WHERE

Line 768: FND_GLOBAL.LOGIN_ID

764: SYSDATE,
765: FND_GLOBAL.USER_ID,
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;

Line 801: FND_GLOBAL.USER_ID,

797: p_new_proposal_id,
798: science_code,
799: 1,
800: SYSDATE,
801: FND_GLOBAL.USER_ID,
802: SYSDATE,
803: FND_GLOBAL.USER_ID,
804: FND_GLOBAL.LOGIN_ID
805: FROM

Line 803: FND_GLOBAL.USER_ID,

799: 1,
800: SYSDATE,
801: FND_GLOBAL.USER_ID,
802: SYSDATE,
803: FND_GLOBAL.USER_ID,
804: FND_GLOBAL.LOGIN_ID
805: FROM
806: igw_prop_science_codes
807: WHERE

Line 804: FND_GLOBAL.LOGIN_ID

800: SYSDATE,
801: FND_GLOBAL.USER_ID,
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;

Line 855: decode(last_updated_by,null,null,FND_GLOBAL.USER_ID),

851: abstract_type_code,
852: abstract,
853: 1,
854: decode(last_update_date,null,null,SYSDATE),
855: decode(last_updated_by,null,null,FND_GLOBAL.USER_ID),
856: SYSDATE,
857: FND_GLOBAL.USER_ID,
858: FND_GLOBAL.LOGIN_ID,
859: attribute_category,

Line 857: FND_GLOBAL.USER_ID,

853: 1,
854: decode(last_update_date,null,null,SYSDATE),
855: decode(last_updated_by,null,null,FND_GLOBAL.USER_ID),
856: SYSDATE,
857: FND_GLOBAL.USER_ID,
858: FND_GLOBAL.LOGIN_ID,
859: attribute_category,
860: attribute1,
861: attribute2,

Line 858: FND_GLOBAL.LOGIN_ID,

854: decode(last_update_date,null,null,SYSDATE),
855: decode(last_updated_by,null,null,FND_GLOBAL.USER_ID),
856: SYSDATE,
857: FND_GLOBAL.USER_ID,
858: FND_GLOBAL.LOGIN_ID,
859: attribute_category,
860: attribute1,
861: attribute2,
862: attribute3,

Line 952: FND_GLOBAL.USER_ID,

948: module_id,
949: comments,
950: 1,
951: SYSDATE,
952: FND_GLOBAL.USER_ID,
953: SYSDATE,
954: FND_GLOBAL.USER_ID,
955: FND_GLOBAL.LOGIN_ID,
956: email_address,

Line 954: FND_GLOBAL.USER_ID,

950: 1,
951: SYSDATE,
952: FND_GLOBAL.USER_ID,
953: SYSDATE,
954: FND_GLOBAL.USER_ID,
955: FND_GLOBAL.LOGIN_ID,
956: email_address,
957: 'I',
958: contact_name,

Line 955: FND_GLOBAL.LOGIN_ID,

951: SYSDATE,
952: FND_GLOBAL.USER_ID,
953: SYSDATE,
954: FND_GLOBAL.USER_ID,
955: FND_GLOBAL.LOGIN_ID,
956: email_address,
957: 'I',
958: contact_name,
959: phone_number,

Line 1012: FND_GLOBAL.USER_ID,

1008: 'N',
1009: not_applicable,
1010: 1,
1011: SYSDATE,
1012: FND_GLOBAL.USER_ID,
1013: SYSDATE,
1014: FND_GLOBAL.USER_ID,
1015: FND_GLOBAL.LOGIN_ID
1016: FROM

Line 1014: FND_GLOBAL.USER_ID,

1010: 1,
1011: SYSDATE,
1012: FND_GLOBAL.USER_ID,
1013: SYSDATE,
1014: FND_GLOBAL.USER_ID,
1015: FND_GLOBAL.LOGIN_ID
1016: FROM
1017: igw_prop_checklist
1018: WHERE

Line 1015: FND_GLOBAL.LOGIN_ID

1011: SYSDATE,
1012: FND_GLOBAL.USER_ID,
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;

Line 1172: last_updated_by = fnd_global.user_id,

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,
1173: last_update_login = fnd_global.login_id
1174: where proposal_id = i_proposal_id
1175: and document_type_code = 'BUDGETS';
1176:

Line 1173: last_update_login = fnd_global.login_id

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,
1173: last_update_login = fnd_global.login_id
1174: where proposal_id = i_proposal_id
1175: and document_type_code = 'BUDGETS';
1176:
1177: ELSIF i_component_name = 'NARRATIVE' THEN

Line 1183: last_updated_by = fnd_global.user_id,

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,
1184: last_update_login = fnd_global.login_id
1185: where proposal_id = i_proposal_id
1186: and document_type_code = 'NARRATIVES';
1187:

Line 1184: last_update_login = fnd_global.login_id

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,
1184: last_update_login = fnd_global.login_id
1185: where proposal_id = i_proposal_id
1186: and document_type_code = 'NARRATIVES';
1187:
1188: END IF;