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.GMA_EDITEXT_ATTACH_MIG dependencies on FND_DOCUMENT_CATEGORIES_TL

Line 605: l_user_name fnd_document_categories_tl.user_name%TYPE :=p_user_name;

601: l_attribute14_value VARCHAR2(2000);
602: l_attribute15_value VARCHAR2(2000);
603: l_name_tbl VARCHAR_TBL_TYPE;
604: l_value_tbl VARCHAR_TBL_TYPE;
605: l_user_name fnd_document_categories_tl.user_name%TYPE :=p_user_name;
606: l_dummy VARCHAR2(1);
607: l_category_id NUMBER := 0;
608:
609: l_user_id number := 0 ;

Line 805: l_category_name fnd_document_categories_tl.name%TYPE:='OPM_MIGRATED_TEXT';

801: SELECT 1
802: FROM FND_ATTACHED_DOCUMENTS
803: WHERE document_id = l_id;
804:
805: l_category_name fnd_document_categories_tl.name%TYPE:='OPM_MIGRATED_TEXT';
806: l_user_name fnd_document_categories_tl.user_name%TYPE:='GMA Migration Text';
807: l_category_exists fnd_document_categories_tl.category_id%TYPE;
808: l_category_id fnd_document_categories_tl.category_id%TYPE;
809: l_category_usage_exists fnd_document_categories_tl.category_id%TYPE;

Line 806: l_user_name fnd_document_categories_tl.user_name%TYPE:='GMA Migration Text';

802: FROM FND_ATTACHED_DOCUMENTS
803: WHERE document_id = l_id;
804:
805: l_category_name fnd_document_categories_tl.name%TYPE:='OPM_MIGRATED_TEXT';
806: l_user_name fnd_document_categories_tl.user_name%TYPE:='GMA Migration Text';
807: l_category_exists fnd_document_categories_tl.category_id%TYPE;
808: l_category_id fnd_document_categories_tl.category_id%TYPE;
809: l_category_usage_exists fnd_document_categories_tl.category_id%TYPE;
810:

Line 807: l_category_exists fnd_document_categories_tl.category_id%TYPE;

803: WHERE document_id = l_id;
804:
805: l_category_name fnd_document_categories_tl.name%TYPE:='OPM_MIGRATED_TEXT';
806: l_user_name fnd_document_categories_tl.user_name%TYPE:='GMA Migration Text';
807: l_category_exists fnd_document_categories_tl.category_id%TYPE;
808: l_category_id fnd_document_categories_tl.category_id%TYPE;
809: l_category_usage_exists fnd_document_categories_tl.category_id%TYPE;
810:
811: Begin

Line 808: l_category_id fnd_document_categories_tl.category_id%TYPE;

804:
805: l_category_name fnd_document_categories_tl.name%TYPE:='OPM_MIGRATED_TEXT';
806: l_user_name fnd_document_categories_tl.user_name%TYPE:='GMA Migration Text';
807: l_category_exists fnd_document_categories_tl.category_id%TYPE;
808: l_category_id fnd_document_categories_tl.category_id%TYPE;
809: l_category_usage_exists fnd_document_categories_tl.category_id%TYPE;
810:
811: Begin
812:

Line 809: l_category_usage_exists fnd_document_categories_tl.category_id%TYPE;

805: l_category_name fnd_document_categories_tl.name%TYPE:='OPM_MIGRATED_TEXT';
806: l_user_name fnd_document_categories_tl.user_name%TYPE:='GMA Migration Text';
807: l_category_exists fnd_document_categories_tl.category_id%TYPE;
808: l_category_id fnd_document_categories_tl.category_id%TYPE;
809: l_category_usage_exists fnd_document_categories_tl.category_id%TYPE;
810:
811: Begin
812:
813: