APPS.PO_UDA_LOAD_TEMPLATES dependencies on EGO_ACTIONS_TL

Line 621: FROM EGO_ACTIONS_TL

617: BEGIN
618:
619: SELECT ACTION_ID
620: INTO l_action_id
621: FROM EGO_ACTIONS_TL
622: WHERE ACTION_ID = l_action_id
623: AND LANGUAGE = USERENV('LANG');
624:
625: UPDATE EGO_ACTIONS_TL

Line 625: UPDATE EGO_ACTIONS_TL

621: FROM EGO_ACTIONS_TL
622: WHERE ACTION_ID = l_action_id
623: AND LANGUAGE = USERENV('LANG');
624:
625: UPDATE EGO_ACTIONS_TL
626: SET DESCRIPTION = p_description
627: WHERE ACTION_ID = l_action_id
628: AND LANGUAGE = USERENV('LANG');
629: EXCEPTION

Line 632: INSERT INTO EGO_ACTIONS_TL

628: AND LANGUAGE = USERENV('LANG');
629: EXCEPTION
630: WHEN NO_DATA_FOUND THEN
631:
632: INSERT INTO EGO_ACTIONS_TL
633: (
634: ACTION_ID,
635: DESCRIPTION,
636: LANGUAGE,

Line 658: FROM EGO_ACTIONS_TL T

654: FROM FND_LANGUAGES L
655: WHERE L.INSTALLED_FLAG in ('I', 'B')
656: AND NOT EXISTS
657: ( SELECT NULL
658: FROM EGO_ACTIONS_TL T
659: WHERE T.ACTION_ID =l_action_id
660: AND T.LANGUAGE = L.LANGUAGE_CODE
661: );
662: END;

Line 704: INSERT INTO EGO_ACTIONS_TL

700: SYSDATE,
701: 0
702: );
703:
704: INSERT INTO EGO_ACTIONS_TL
705: (
706: ACTION_ID,
707: DESCRIPTION,
708: LANGUAGE,

Line 730: FROM EGO_ACTIONS_TL T

726: FROM FND_LANGUAGES L
727: WHERE L.INSTALLED_FLAG in ('I', 'B')
728: AND NOT EXISTS
729: ( SELECT NULL
730: FROM EGO_ACTIONS_TL T
731: WHERE T.ACTION_ID =l_action_id
732: AND T.LANGUAGE = L.LANGUAGE_CODE
733: );
734:

Line 819: UPDATE EGO_ACTIONS_TL

815: AND ATTR_GROUP_ID = l_attr_grp_id
816: AND CLASSIFICATION_CODE = g_pkg_template_id || '';
817:
818:
819: UPDATE EGO_ACTIONS_TL
820: SET DESCRIPTION = p_description,
821: SOURCE_LANG = USERENV('LANG'),
822: LAST_UPDATE_DATE = SYSDATE,
823: LAST_UPDATED_BY = DECODE(p_owner, 'SEED', 1, 0),