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.EGO_EXT_FWK_PUB dependencies on EGO_MAPPINGS_B

Line 10790: l_mapped_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'A';

10786: l_Sysdate DATE := Sysdate;
10787: l_validate NUMBER;
10788: l_old_function_id NUMBER;
10789: l_mapping_count NUMBER;
10790: l_mapped_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'A';
10791: l_object_id NUMBER;
10792: l_classification_code VARCHAR2(150);
10793: l_attr_group_id NUMBER;
10794:

Line 10865: FROM EGO_MAPPINGS_B

10861:
10862: IF l_old_function_id <> p_function_id THEN
10863: SELECT COUNT(*)
10864: INTO l_mapping_count
10865: FROM EGO_MAPPINGS_B
10866: WHERE MAPPED_OBJ_PK1_VAL = TO_CHAR(p_action_id)
10867: AND FUNCTION_ID = l_old_function_id
10868: AND MAPPED_OBJ_TYPE = l_mapped_obj_type;
10869:

Line 10975: l_mapped_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'A';

10971: l_api_version CONSTANT NUMBER := 1.0;
10972:
10973: l_function_id NUMBER;
10974: l_mapping_count NUMBER;
10975: l_mapped_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'A';
10976: --R12C
10977: l_visibility_count NUMBER;
10978:
10979:

Line 11016: FROM EGO_MAPPINGS_B

11012: ACTION_ID = p_action_id;
11013:
11014: SELECT COUNT(*)
11015: INTO l_mapping_count
11016: FROM EGO_MAPPINGS_B
11017: WHERE MAPPED_OBJ_PK1_VAL = TO_CHAR(p_action_id)
11018: AND FUNCTION_ID = l_function_id
11019: AND MAPPED_OBJ_TYPE = l_mapped_obj_type;
11020:

Line 11383: l_prompt_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'P';

11379: l_disp_check_count NUMBER;
11380: l_old_prompt_func_id NUMBER;
11381: l_old_vis_func_id NUMBER;
11382: l_mapping_count NUMBER;
11383: l_prompt_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'P';
11384: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';
11385:
11386: BEGIN
11387:

Line 11384: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';

11380: l_old_prompt_func_id NUMBER;
11381: l_old_vis_func_id NUMBER;
11382: l_mapping_count NUMBER;
11383: l_prompt_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'P';
11384: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';
11385:
11386: BEGIN
11387:
11388: -- Standard start of API savepoint

Line 11442: FROM EGO_MAPPINGS_B

11438: IF ((l_old_prompt_func_id IS NOT NULL)
11439: AND (l_old_prompt_func_id <> p_prompt_function_id)) THEN
11440: SELECT COUNT(*)
11441: INTO l_mapping_count
11442: FROM EGO_MAPPINGS_B
11443: WHERE MAPPED_OBJ_PK1_VAL = TO_CHAR(p_action_id)
11444: AND FUNCTION_ID = l_old_prompt_func_id
11445: AND MAPPED_OBJ_TYPE = l_prompt_obj_type;
11446:

Line 11465: FROM EGO_MAPPINGS_B

11461: IF l_old_vis_func_id is not null AND l_old_vis_func_id <> p_visibility_func_id
11462: THEN
11463: SELECT COUNT(*)
11464: INTO l_mapping_count
11465: FROM EGO_MAPPINGS_B
11466: WHERE MAPPED_OBJ_PK1_VAL = to_char(p_action_id)
11467: AND FUNCTION_ID = l_old_vis_func_id
11468: AND MAPPED_OBJ_TYPE = l_vis_obj_type;
11469:

Line 11549: l_prompt_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'P';

11545: l_disp_check_count NUMBER;
11546: l_old_prompt_func_id NUMBER;
11547: l_old_vis_func_id NUMBER;
11548: l_mapping_count NUMBER;
11549: l_prompt_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'P';
11550: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';
11551:
11552: BEGIN
11553:

Line 11550: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';

11546: l_old_prompt_func_id NUMBER;
11547: l_old_vis_func_id NUMBER;
11548: l_mapping_count NUMBER;
11549: l_prompt_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'P';
11550: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';
11551:
11552: BEGIN
11553:
11554: -- Standard start of API savepoint

Line 11602: FROM EGO_MAPPINGS_B

11598:
11599: IF l_old_prompt_func_id IS NOT NULL THEN
11600: SELECT COUNT(*)
11601: INTO l_mapping_count
11602: FROM EGO_MAPPINGS_B
11603: WHERE MAPPED_OBJ_PK1_VAL = TO_CHAR(p_action_id)
11604: AND FUNCTION_ID = l_old_prompt_func_id
11605: AND MAPPED_OBJ_TYPE = l_prompt_obj_type;
11606:

Line 11623: FROM EGO_MAPPINGS_B

11619:
11620: IF l_old_vis_func_id IS NOT NULL THEN
11621: SELECT COUNT(*)
11622: INTO l_mapping_count
11623: FROM EGO_MAPPINGS_B
11624: WHERE MAPPED_OBJ_PK1_VAL = TO_CHAR(p_action_id)
11625: AND FUNCTION_ID = l_old_vis_func_id
11626: AND MAPPED_OBJ_TYPE = l_vis_obj_type;
11627:

Line 11705: l_prompt_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'P';

11701:
11702: l_mapping_count NUMBER;
11703: l_prompt_func_id NUMBER;
11704: l_vis_func_id NUMBER;
11705: l_prompt_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'P';
11706: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';
11707:
11708: BEGIN
11709:

Line 11706: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';

11702: l_mapping_count NUMBER;
11703: l_prompt_func_id NUMBER;
11704: l_vis_func_id NUMBER;
11705: l_prompt_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'P';
11706: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';
11707:
11708: BEGIN
11709:
11710: -- Standard start of API savepoint

Line 11749: FROM EGO_MAPPINGS_B

11745: -- functions for this action, if there are any
11746:
11747: SELECT COUNT(*)
11748: INTO l_mapping_count
11749: FROM EGO_MAPPINGS_B
11750: WHERE MAPPED_OBJ_PK1_VAL = TO_CHAR(p_action_id)
11751: AND FUNCTION_ID = l_prompt_func_id
11752: AND MAPPED_OBJ_TYPE = l_prompt_obj_type;
11753:

Line 11763: FROM EGO_MAPPINGS_B

11759: END IF;
11760:
11761: SELECT COUNT(*)
11762: INTO l_mapping_count
11763: FROM EGO_MAPPINGS_B
11764: WHERE MAPPED_OBJ_PK1_VAL = TO_CHAR(p_action_id)
11765: AND FUNCTION_ID = l_vis_func_id
11766: AND MAPPED_OBJ_TYPE = l_vis_obj_type;
11767:

Line 12074: DELETE FROM EGO_MAPPINGS_B

12070: DELETE FROM EGO_FUNC_PARAMS_TL
12071: WHERE
12072: FUNC_PARAM_ID = p_function_param_id;
12073:
12074: DELETE FROM EGO_MAPPINGS_B
12075: WHERE
12076: FUNC_PARAM_ID = p_function_param_id;
12077:
12078: -- Standard check of p_commit

Line 12161: INSERT INTO EGO_MAPPINGS_B

12157: IF FND_API.To_Boolean(p_init_msg_list) THEN
12158: FND_MSG_PUB.Initialize;
12159: END IF;
12160:
12161: INSERT INTO EGO_MAPPINGS_B
12162: (
12163: FUNCTION_ID
12164: ,MAPPED_OBJ_TYPE
12165: ,MAPPED_OBJ_PK1_VAL

Line 12380: UPDATE EGO_MAPPINGS_B

12376: p_new_mapping_group_pk2 IS NOT NULL AND
12377: p_new_mapping_group_pk3 IS NOT NULL AND
12378: p_new_mapping_value IS NOT NULL) THEN
12379:
12380: UPDATE EGO_MAPPINGS_B
12381: SET
12382: MAPPED_TO_GROUP_TYPE = p_mapping_group_type
12383: ,MAPPED_TO_GROUP_PK1 = p_new_mapping_group_pk1
12384: ,MAPPED_TO_GROUP_PK2 = p_new_mapping_group_pk2

Line 12406: UPDATE EGO_MAPPINGS_B

12402: MAPPED_ATTRIBUTE = p_mapping_value;
12403:
12404: ELSE
12405:
12406: UPDATE EGO_MAPPINGS_B
12407: SET
12408: MAPPED_TO_GROUP_TYPE = p_mapping_group_type
12409: ,MAPPED_TO_GROUP_PK1 = p_mapping_group_pk1
12410: ,MAPPED_TO_GROUP_PK2 = p_mapping_group_pk2

Line 12598: DELETE FROM EGO_MAPPINGS_B

12594: IF FND_API.To_Boolean(p_init_msg_list) THEN
12595: FND_MSG_PUB.Initialize;
12596: END IF;
12597:
12598: DELETE FROM EGO_MAPPINGS_B
12599: WHERE
12600: FUNCTION_ID = p_function_id AND
12601: MAPPED_OBJ_TYPE = p_mapped_obj_type AND
12602: MAPPED_OBJ_PK1_VAL = p_mapped_obj_pk1_value;

Line 12672: DELETE FROM EGO_MAPPINGS_B

12668: IF FND_API.To_Boolean(p_init_msg_list) THEN
12669: FND_MSG_PUB.Initialize;
12670: END IF;
12671:
12672: DELETE FROM EGO_MAPPINGS_B
12673: WHERE
12674: FUNCTION_ID = p_function_id AND
12675: MAPPED_OBJ_TYPE = p_mapped_obj_type AND
12676: MAPPED_OBJ_PK1_VAL = p_mapped_obj_pk1_value AND