APPS.PO_UDA_LOAD_TEMPLATES dependencies on EGO_ACTIONS_B

Line 608: FROM EGO_ACTIONS_B

604:
605: BEGIN
606: SELECT ACTION_ID
607: INTO l_action_id
608: FROM EGO_ACTIONS_B
609: WHERE ACTION_NAME = p_action_name
610: AND ATTR_GROUP_ID = l_attr_grp_id
611: AND CLASSIFICATION_CODE = g_pkg_template_id || '';
612:

Line 613: UPDATE EGO_ACTIONS_B

609: WHERE ACTION_NAME = p_action_name
610: AND ATTR_GROUP_ID = l_attr_grp_id
611: AND CLASSIFICATION_CODE = g_pkg_template_id || '';
612:
613: UPDATE EGO_ACTIONS_B
614: SET SEQUENCE = p_sequence
615: WHERE ACTION_ID = l_action_id;
616:
617: BEGIN

Line 673: INSERT INTO EGO_ACTIONS_B

669: INTO l_action_id
670: FROM DUAL
671: WHERE ROWNUM = 1;
672:
673: INSERT INTO EGO_ACTIONS_B
674: (
675: ACTION_ID,
676: OBJECT_ID,
677: CLASSIFICATION_CODE,

Line 813: FROM EGO_ACTIONS_B

809: IF l_attr_grp_id IS NOT NULL THEN
810:
811: SELECT ACTION_ID
812: INTO l_action_id
813: FROM EGO_ACTIONS_B
814: WHERE ACTION_NAME = p_action_name
815: AND ATTR_GROUP_ID = l_attr_grp_id
816: AND CLASSIFICATION_CODE = g_pkg_template_id || '';
817:

Line 890: FROM EGO_ACTIONS_B

886:
887: BEGIN
888: SELECT ACTION_ID
889: INTO l_action_id
890: FROM EGO_ACTIONS_B
891: WHERE ACTION_NAME = p_action_name
892: AND ATTR_GROUP_ID = l_attr_grp_id
893: AND CLASSIFICATION_CODE = g_pkg_template_id || ''
894: AND ROWNUM = 1;

Line 1013: FROM EGO_ACTIONS_B

1009: BEGIN
1010:
1011: SELECT ACTION_ID
1012: INTO l_action_id
1013: FROM EGO_ACTIONS_B
1014: WHERE ACTION_NAME = p_action_name
1015: AND ATTR_GROUP_ID = l_attr_grp_id
1016: AND CLASSIFICATION_CODE = g_pkg_template_id || ''
1017: AND ROWNUM = 1;

Line 1162: FROM EGO_ACTIONS_B

1158: -- : Exception handling in case of action not present for the AG is not present
1159: BEGIN
1160: SELECT ACTION_ID
1161: INTO l_action_id
1162: FROM EGO_ACTIONS_B
1163: WHERE ACTION_NAME = p_action_name
1164: AND ATTR_GROUP_ID = l_attr_grp_id
1165: AND CLASSIFICATION_CODE = g_pkg_template_id || ''
1166: AND ROWNUM = 1;