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.CAC_NOTES_PVT dependencies on FND_GLOBAL

Line 494: NVL(p_entered_by,fnd_global.user_id),

490: PARENT_NOTE_ID
491: ) values (
492: p_SOURCE_OBJECT_CODE,
493: L_NOTE_STATUS,
494: NVL(p_entered_by,fnd_global.user_id),
495: NVL(p_entered_date,l_current_date),
496: P_NOTE_TYPE,
497: L_JTF_NOTE_ID,
498: P_SOURCE_OBJECT_ID,

Line 500: NVL(p_created_by,fnd_global.user_id),

496: P_NOTE_TYPE,
497: L_JTF_NOTE_ID,
498: P_SOURCE_OBJECT_ID,
499: NVL(p_creation_date,l_current_date),
500: NVL(p_created_by,fnd_global.user_id),
501: NVL(p_last_update_date,l_current_date),
502: NVL(p_last_updated_by,fnd_global.user_id),
503: NVL(p_last_update_login,fnd_global.login_id),
504: P_ATTRIBUTE1,

Line 502: NVL(p_last_updated_by,fnd_global.user_id),

498: P_SOURCE_OBJECT_ID,
499: NVL(p_creation_date,l_current_date),
500: NVL(p_created_by,fnd_global.user_id),
501: NVL(p_last_update_date,l_current_date),
502: NVL(p_last_updated_by,fnd_global.user_id),
503: NVL(p_last_update_login,fnd_global.login_id),
504: P_ATTRIBUTE1,
505: P_ATTRIBUTE2,
506: P_ATTRIBUTE3,

Line 503: NVL(p_last_update_login,fnd_global.login_id),

499: NVL(p_creation_date,l_current_date),
500: NVL(p_created_by,fnd_global.user_id),
501: NVL(p_last_update_date,l_current_date),
502: NVL(p_last_updated_by,fnd_global.user_id),
503: NVL(p_last_update_login,fnd_global.login_id),
504: P_ATTRIBUTE1,
505: P_ATTRIBUTE2,
506: P_ATTRIBUTE3,
507: P_ATTRIBUTE4,

Line 538: NVL(p_created_by,fnd_global.user_id),

534: L_JTF_NOTE_ID,
535: L_NOTES,
536: P_NOTES_DETAIL,
537: NVL(p_creation_date,l_current_date),
538: NVL(p_created_by,fnd_global.user_id),
539: NVL(p_last_update_date,l_current_date),
540: NVL(p_last_updated_by,fnd_global.user_id),
541: NVL(p_last_update_login,fnd_global.login_id),
542: L.LANGUAGE_CODE,

Line 540: NVL(p_last_updated_by,fnd_global.user_id),

536: P_NOTES_DETAIL,
537: NVL(p_creation_date,l_current_date),
538: NVL(p_created_by,fnd_global.user_id),
539: NVL(p_last_update_date,l_current_date),
540: NVL(p_last_updated_by,fnd_global.user_id),
541: NVL(p_last_update_login,fnd_global.login_id),
542: L.LANGUAGE_CODE,
543: userenv('LANG')
544: from FND_LANGUAGES L

Line 541: NVL(p_last_update_login,fnd_global.login_id),

537: NVL(p_creation_date,l_current_date),
538: NVL(p_created_by,fnd_global.user_id),
539: NVL(p_last_update_date,l_current_date),
540: NVL(p_last_updated_by,fnd_global.user_id),
541: NVL(p_last_update_login,fnd_global.login_id),
542: L.LANGUAGE_CODE,
543: userenv('LANG')
544: from FND_LANGUAGES L
545: where L.INSTALLED_FLAG in ('I', 'B');

Line 563: NVL(p_created_by,fnd_global.user_id),

559: L_jtf_note_id,
560: P_source_object_id,
561: P_source_object_code,
562: NVL(p_creation_date,l_current_date),
563: NVL(p_created_by,fnd_global.user_id),
564: NVL(p_last_update_date,l_current_date),
565: NVL(p_last_updated_by,fnd_global.user_id),
566: NVL(p_last_update_login,fnd_global.login_id)
567: );

Line 565: NVL(p_last_updated_by,fnd_global.user_id),

561: P_source_object_code,
562: NVL(p_creation_date,l_current_date),
563: NVL(p_created_by,fnd_global.user_id),
564: NVL(p_last_update_date,l_current_date),
565: NVL(p_last_updated_by,fnd_global.user_id),
566: NVL(p_last_update_login,fnd_global.login_id)
567: );
568:
569: --

Line 566: NVL(p_last_update_login,fnd_global.login_id)

562: NVL(p_creation_date,l_current_date),
563: NVL(p_created_by,fnd_global.user_id),
564: NVL(p_last_update_date,l_current_date),
565: NVL(p_last_updated_by,fnd_global.user_id),
566: NVL(p_last_update_login,fnd_global.login_id)
567: );
568:
569: --
570: -- Make the post processing call to the user hooks

Line 588: , p_entered_by => FND_GLOBAL.USER_ID

584: , p_source_object_id => p_source_object_id
585: , p_source_object_code => p_source_object_code
586: , p_notes => P_notes
587: , p_note_status => l_note_status
588: , p_entered_by => FND_GLOBAL.USER_ID
589: , p_entered_date => l_current_date
590: , x_jtf_note_id => X_jtf_note_id
591: , p_last_update_date => l_current_date
592: , p_last_updated_by => FND_GLOBAL.USER_ID

Line 592: , p_last_updated_by => FND_GLOBAL.USER_ID

588: , p_entered_by => FND_GLOBAL.USER_ID
589: , p_entered_date => l_current_date
590: , x_jtf_note_id => X_jtf_note_id
591: , p_last_update_date => l_current_date
592: , p_last_updated_by => FND_GLOBAL.USER_ID
593: , p_creation_date => l_current_date
594: , p_created_by => FND_GLOBAL.USER_ID
595: , p_last_update_login => FND_GLOBAL.LOGIN_ID
596: , p_attribute1 => p_attribute1

Line 594: , p_created_by => FND_GLOBAL.USER_ID

590: , x_jtf_note_id => X_jtf_note_id
591: , p_last_update_date => l_current_date
592: , p_last_updated_by => FND_GLOBAL.USER_ID
593: , p_creation_date => l_current_date
594: , p_created_by => FND_GLOBAL.USER_ID
595: , p_last_update_login => FND_GLOBAL.LOGIN_ID
596: , p_attribute1 => p_attribute1
597: , p_attribute2 => p_attribute2
598: , p_attribute3 => p_attribute3

Line 595: , p_last_update_login => FND_GLOBAL.LOGIN_ID

591: , p_last_update_date => l_current_date
592: , p_last_updated_by => FND_GLOBAL.USER_ID
593: , p_creation_date => l_current_date
594: , p_created_by => FND_GLOBAL.USER_ID
595: , p_last_update_login => FND_GLOBAL.LOGIN_ID
596: , p_attribute1 => p_attribute1
597: , p_attribute2 => p_attribute2
598: , p_attribute3 => p_attribute3
599: , p_attribute4 => p_attribute4

Line 641: , p_entered_by => FND_GLOBAL.USER_ID

637: , p_source_object_id => p_source_object_id
638: , p_source_object_code => p_source_object_code
639: , p_notes => l_notes
640: , p_note_status => l_note_status
641: , p_entered_by => FND_GLOBAL.USER_ID
642: , p_entered_date => l_current_date
643: , x_jtf_note_id => X_jtf_note_id
644: , p_last_update_date => l_current_date
645: , p_last_updated_by => FND_GLOBAL.USER_ID

Line 645: , p_last_updated_by => FND_GLOBAL.USER_ID

641: , p_entered_by => FND_GLOBAL.USER_ID
642: , p_entered_date => l_current_date
643: , x_jtf_note_id => X_jtf_note_id
644: , p_last_update_date => l_current_date
645: , p_last_updated_by => FND_GLOBAL.USER_ID
646: , p_creation_date => l_current_date
647: , p_created_by => FND_GLOBAL.USER_ID
648: , p_last_update_login => FND_GLOBAL.LOGIN_ID
649: , p_attribute1 => p_attribute1

Line 647: , p_created_by => FND_GLOBAL.USER_ID

643: , x_jtf_note_id => X_jtf_note_id
644: , p_last_update_date => l_current_date
645: , p_last_updated_by => FND_GLOBAL.USER_ID
646: , p_creation_date => l_current_date
647: , p_created_by => FND_GLOBAL.USER_ID
648: , p_last_update_login => FND_GLOBAL.LOGIN_ID
649: , p_attribute1 => p_attribute1
650: , p_attribute2 => p_attribute2
651: , p_attribute3 => p_attribute3

Line 648: , p_last_update_login => FND_GLOBAL.LOGIN_ID

644: , p_last_update_date => l_current_date
645: , p_last_updated_by => FND_GLOBAL.USER_ID
646: , p_creation_date => l_current_date
647: , p_created_by => FND_GLOBAL.USER_ID
648: , p_last_update_login => FND_GLOBAL.LOGIN_ID
649: , p_attribute1 => p_attribute1
650: , p_attribute2 => p_attribute2
651: , p_attribute3 => p_attribute3
652: , p_attribute4 => p_attribute4

Line 690: , p_entered_by => FND_GLOBAL.USER_ID

686: , x_msg_data => x_msg_data
687: , p_source_object_id => p_source_object_id
688: , p_source_object_code => p_source_object_code
689: , p_notes => p_notes
690: , p_entered_by => FND_GLOBAL.USER_ID
691: , p_entered_date => l_current_date
692: , x_jtf_note_id => X_jtf_note_id
693: , p_last_update_date => l_current_date
694: , p_last_updated_by => FND_GLOBAL.USER_ID

Line 694: , p_last_updated_by => FND_GLOBAL.USER_ID

690: , p_entered_by => FND_GLOBAL.USER_ID
691: , p_entered_date => l_current_date
692: , x_jtf_note_id => X_jtf_note_id
693: , p_last_update_date => l_current_date
694: , p_last_updated_by => FND_GLOBAL.USER_ID
695: , p_creation_date => l_current_date
696: )
697: THEN
698: l_bind_data_id := JTF_USR_HKS.Get_bind_data_id;

Line 846: , p_entered_by => FND_GLOBAL.USER_ID

842: ( p_api_version => l_api_version
843: , x_msg_count => l_msg_count
844: , x_msg_data => l_msg_data
845: , p_jtf_note_id => p_jtf_note_id
846: , p_entered_by => FND_GLOBAL.USER_ID
847: , p_last_updated_by => p_last_updated_by
848: , p_notes => p_notes
849: , p_note_status => p_note_status
850: , p_note_type => p_note_type

Line 873: , p_entered_by => FND_GLOBAL.USER_ID

869: ( p_api_version => l_api_version
870: , x_msg_count => l_msg_count
871: , x_msg_data => l_msg_data
872: , p_jtf_note_id => p_jtf_note_id
873: , p_entered_by => FND_GLOBAL.USER_ID
874: , p_last_updated_by => p_last_updated_by
875: , p_notes => p_notes
876: , p_note_status => p_note_status
877: , p_note_type => p_note_type

Line 915: SET last_updated_by = NVL(p_last_updated_by,fnd_global.user_id)

911: --
912: -- Perform the database operation.
913: --
914: UPDATE JTF_NOTES_B
915: SET last_updated_by = NVL(p_last_updated_by,fnd_global.user_id)
916: , last_update_date = NVL(p_last_update_date,l_current_date)
917: , last_update_login = NVL(p_last_update_login,fnd_global.login_id)
918: , note_status = NVL(l_note_status,note_status)
919: , note_type = l_note_type

Line 917: , last_update_login = NVL(p_last_update_login,fnd_global.login_id)

913: --
914: UPDATE JTF_NOTES_B
915: SET last_updated_by = NVL(p_last_updated_by,fnd_global.user_id)
916: , last_update_date = NVL(p_last_update_date,l_current_date)
917: , last_update_login = NVL(p_last_update_login,fnd_global.login_id)
918: , note_status = NVL(l_note_status,note_status)
919: , note_type = l_note_type
920: , attribute1 = p_attribute1
921: , attribute2 = p_attribute2

Line 943: , LAST_UPDATED_BY = NVL(p_last_updated_by,fnd_global.user_id)

939: THEN
940: UPDATE JTF_NOTES_TL
941: SET NOTES = NVL(l_notes,NOTES)
942: , LAST_UPDATE_DATE = NVL(p_last_update_date,l_current_date)
943: , LAST_UPDATED_BY = NVL(p_last_updated_by,fnd_global.user_id)
944: , LAST_UPDATE_LOGIN = NVL(p_last_update_login,fnd_global.login_id)
945: , SOURCE_LANG = USERENV('LANG')
946: WHERE JTF_NOTE_ID = p_jtf_note_id;
947: ELSE

Line 944: , LAST_UPDATE_LOGIN = NVL(p_last_update_login,fnd_global.login_id)

940: UPDATE JTF_NOTES_TL
941: SET NOTES = NVL(l_notes,NOTES)
942: , LAST_UPDATE_DATE = NVL(p_last_update_date,l_current_date)
943: , LAST_UPDATED_BY = NVL(p_last_updated_by,fnd_global.user_id)
944: , LAST_UPDATE_LOGIN = NVL(p_last_update_login,fnd_global.login_id)
945: , SOURCE_LANG = USERENV('LANG')
946: WHERE JTF_NOTE_ID = p_jtf_note_id;
947: ELSE
948: UPDATE JTF_NOTES_TL

Line 952: , LAST_UPDATED_BY = NVL(p_last_updated_by,fnd_global.user_id)

948: UPDATE JTF_NOTES_TL
949: SET NOTES = NVL(l_notes,NOTES)
950: , NOTES_DETAIL = p_notes_detail
951: , LAST_UPDATE_DATE = NVL(p_last_update_date,l_current_date)
952: , LAST_UPDATED_BY = NVL(p_last_updated_by,fnd_global.user_id)
953: , LAST_UPDATE_LOGIN = NVL(p_last_update_login,fnd_global.login_id)
954: , SOURCE_LANG = USERENV('LANG')
955: WHERE JTF_NOTE_ID = p_jtf_note_id;
956: END IF;

Line 953: , LAST_UPDATE_LOGIN = NVL(p_last_update_login,fnd_global.login_id)

949: SET NOTES = NVL(l_notes,NOTES)
950: , NOTES_DETAIL = p_notes_detail
951: , LAST_UPDATE_DATE = NVL(p_last_update_date,l_current_date)
952: , LAST_UPDATED_BY = NVL(p_last_updated_by,fnd_global.user_id)
953: , LAST_UPDATE_LOGIN = NVL(p_last_update_login,fnd_global.login_id)
954: , SOURCE_LANG = USERENV('LANG')
955: WHERE JTF_NOTE_ID = p_jtf_note_id;
956: END IF;
957:

Line 969: , p_entered_by => FND_GLOBAL.USER_ID

965: ( p_api_version => l_api_version
966: , x_msg_count => l_msg_count
967: , x_msg_data => l_msg_data
968: , p_jtf_note_id => p_jtf_note_id
969: , p_entered_by => FND_GLOBAL.USER_ID
970: , p_last_updated_by => p_last_updated_by
971: , p_notes => l_notes
972: , p_note_status => l_note_status
973: , p_note_type => l_note_type

Line 996: , p_entered_by => FND_GLOBAL.USER_ID

992: ( p_api_version => l_api_version
993: , x_msg_count => l_msg_count
994: , x_msg_data => l_msg_data
995: , p_jtf_note_id => p_jtf_note_id
996: , p_entered_by => FND_GLOBAL.USER_ID
997: , p_last_updated_by => p_last_updated_by
998: , p_notes => l_notes
999: , p_note_status => l_note_status
1000: , p_note_type => l_note_type

Line 1024: , p_entered_by => FND_GLOBAL.USER_ID

1020: ( p_api_version => l_api_version
1021: , x_msg_count => l_msg_count
1022: , x_msg_data => l_msg_data
1023: , p_jtf_note_id => p_jtf_note_id
1024: , p_entered_by => FND_GLOBAL.USER_ID
1025: , p_last_updated_by => p_last_updated_by
1026: , p_notes => l_notes
1027: , p_note_status => l_note_status
1028: , p_note_type => l_note_type

Line 1284: NVL(p_created_by,fnd_global.user_id),

1280: p_jtf_note_id,
1281: p_note_context_type_id,
1282: p_note_context_type,
1283: NVL(p_creation_date,l_current_date),
1284: NVL(p_created_by,fnd_global.user_id),
1285: NVL(p_last_update_date,l_current_date),
1286: NVL(p_last_updated_by,fnd_global.user_id),
1287: NVL(p_last_update_login,fnd_global.login_id)
1288: )

Line 1286: NVL(p_last_updated_by,fnd_global.user_id),

1282: p_note_context_type,
1283: NVL(p_creation_date,l_current_date),
1284: NVL(p_created_by,fnd_global.user_id),
1285: NVL(p_last_update_date,l_current_date),
1286: NVL(p_last_updated_by,fnd_global.user_id),
1287: NVL(p_last_update_login,fnd_global.login_id)
1288: )
1289: RETURNING note_context_id INTO x_note_context_id;
1290:

Line 1287: NVL(p_last_update_login,fnd_global.login_id)

1283: NVL(p_creation_date,l_current_date),
1284: NVL(p_created_by,fnd_global.user_id),
1285: NVL(p_last_update_date,l_current_date),
1286: NVL(p_last_updated_by,fnd_global.user_id),
1287: NVL(p_last_update_login,fnd_global.login_id)
1288: )
1289: RETURNING note_context_id INTO x_note_context_id;
1290:
1291: ELSE

Line 1393: LAST_UPDATED_BY = NVL(p_last_updated_by,fnd_global.user_id),

1389: JTF_NOTE_ID = NVL(p_jtf_note_id,JTF_NOTE_ID),
1390: NOTE_CONTEXT_TYPE_ID = NVL(p_note_context_type_id,NOTE_CONTEXT_TYPE_ID),
1391: NOTE_CONTEXT_TYPE = NVL(p_note_context_type,NOTE_CONTEXT_TYPE),
1392: LAST_UPDATE_DATE = NVL(p_last_update_date,SYSDATE),
1393: LAST_UPDATED_BY = NVL(p_last_updated_by,fnd_global.user_id),
1394: LAST_UPDATE_LOGIN = NVL(p_last_update_login,fnd_global.login_id)
1395: WHERE NOTE_CONTEXT_ID = p_note_context_id;
1396:
1397: fnd_msg_pub.count_and_get( p_encoded => 'F'

Line 1394: LAST_UPDATE_LOGIN = NVL(p_last_update_login,fnd_global.login_id)

1390: NOTE_CONTEXT_TYPE_ID = NVL(p_note_context_type_id,NOTE_CONTEXT_TYPE_ID),
1391: NOTE_CONTEXT_TYPE = NVL(p_note_context_type,NOTE_CONTEXT_TYPE),
1392: LAST_UPDATE_DATE = NVL(p_last_update_date,SYSDATE),
1393: LAST_UPDATED_BY = NVL(p_last_updated_by,fnd_global.user_id),
1394: LAST_UPDATE_LOGIN = NVL(p_last_update_login,fnd_global.login_id)
1395: WHERE NOTE_CONTEXT_ID = p_note_context_id;
1396:
1397: fnd_msg_pub.count_and_get( p_encoded => 'F'
1398: , p_count => x_msg_count