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.

[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on EGO_MAPPINGS_B

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

11756: l_Sysdate DATE := Sysdate;
11757: l_validate NUMBER;
11758: l_old_function_id NUMBER;
11759: l_mapping_count NUMBER;
11760: l_mapped_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'A';
11761: l_object_id NUMBER;
11762: l_classification_code VARCHAR2(150);
11763: l_attr_group_id NUMBER;
11764:

Line 11835: FROM EGO_MAPPINGS_B

11831:
11832: IF l_old_function_id <> p_function_id THEN
11833: SELECT COUNT(*)
11834: INTO l_mapping_count
11835: FROM EGO_MAPPINGS_B
11836: WHERE MAPPED_OBJ_PK1_VAL = TO_CHAR(p_action_id)
11837: AND FUNCTION_ID = l_old_function_id
11838: AND MAPPED_OBJ_TYPE = l_mapped_obj_type;
11839:

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

11941: l_api_version CONSTANT NUMBER := 1.0;
11942:
11943: l_function_id NUMBER;
11944: l_mapping_count NUMBER;
11945: l_mapped_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'A';
11946: --R12C
11947: l_visibility_count NUMBER;
11948:
11949:

Line 11986: FROM EGO_MAPPINGS_B

11982: ACTION_ID = p_action_id;
11983:
11984: SELECT COUNT(*)
11985: INTO l_mapping_count
11986: FROM EGO_MAPPINGS_B
11987: WHERE MAPPED_OBJ_PK1_VAL = TO_CHAR(p_action_id)
11988: AND FUNCTION_ID = l_function_id
11989: AND MAPPED_OBJ_TYPE = l_mapped_obj_type;
11990:

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

12351: l_disp_check_count NUMBER;
12352: l_old_prompt_func_id NUMBER;
12353: l_old_vis_func_id NUMBER;
12354: l_mapping_count NUMBER;
12355: l_prompt_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'P';
12356: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';
12357:
12358: BEGIN
12359:

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

12352: l_old_prompt_func_id NUMBER;
12353: l_old_vis_func_id NUMBER;
12354: l_mapping_count NUMBER;
12355: l_prompt_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'P';
12356: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';
12357:
12358: BEGIN
12359:
12360: -- Standard start of API savepoint

Line 12414: FROM EGO_MAPPINGS_B

12410: IF ((l_old_prompt_func_id IS NOT NULL)
12411: AND (l_old_prompt_func_id <> p_prompt_function_id)) THEN
12412: SELECT COUNT(*)
12413: INTO l_mapping_count
12414: FROM EGO_MAPPINGS_B
12415: WHERE MAPPED_OBJ_PK1_VAL = TO_CHAR(p_action_id)
12416: AND FUNCTION_ID = l_old_prompt_func_id
12417: AND MAPPED_OBJ_TYPE = l_prompt_obj_type;
12418:

Line 12437: FROM EGO_MAPPINGS_B

12433: IF l_old_vis_func_id is not null AND l_old_vis_func_id <> p_visibility_func_id
12434: THEN
12435: SELECT COUNT(*)
12436: INTO l_mapping_count
12437: FROM EGO_MAPPINGS_B
12438: WHERE MAPPED_OBJ_PK1_VAL = to_char(p_action_id)
12439: AND FUNCTION_ID = l_old_vis_func_id
12440: AND MAPPED_OBJ_TYPE = l_vis_obj_type;
12441:

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

12517: l_disp_check_count NUMBER;
12518: l_old_prompt_func_id NUMBER;
12519: l_old_vis_func_id NUMBER;
12520: l_mapping_count NUMBER;
12521: l_prompt_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'P';
12522: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';
12523:
12524: BEGIN
12525:

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

12518: l_old_prompt_func_id NUMBER;
12519: l_old_vis_func_id NUMBER;
12520: l_mapping_count NUMBER;
12521: l_prompt_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'P';
12522: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';
12523:
12524: BEGIN
12525:
12526: -- Standard start of API savepoint

Line 12574: FROM EGO_MAPPINGS_B

12570:
12571: IF l_old_prompt_func_id IS NOT NULL THEN
12572: SELECT COUNT(*)
12573: INTO l_mapping_count
12574: FROM EGO_MAPPINGS_B
12575: WHERE MAPPED_OBJ_PK1_VAL = TO_CHAR(p_action_id)
12576: AND FUNCTION_ID = l_old_prompt_func_id
12577: AND MAPPED_OBJ_TYPE = l_prompt_obj_type;
12578:

Line 12595: FROM EGO_MAPPINGS_B

12591:
12592: IF l_old_vis_func_id IS NOT NULL THEN
12593: SELECT COUNT(*)
12594: INTO l_mapping_count
12595: FROM EGO_MAPPINGS_B
12596: WHERE MAPPED_OBJ_PK1_VAL = TO_CHAR(p_action_id)
12597: AND FUNCTION_ID = l_old_vis_func_id
12598: AND MAPPED_OBJ_TYPE = l_vis_obj_type;
12599:

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

12673:
12674: l_mapping_count NUMBER;
12675: l_prompt_func_id NUMBER;
12676: l_vis_func_id NUMBER;
12677: l_prompt_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'P';
12678: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';
12679:
12680: BEGIN
12681:

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

12674: l_mapping_count NUMBER;
12675: l_prompt_func_id NUMBER;
12676: l_vis_func_id NUMBER;
12677: l_prompt_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'P';
12678: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';
12679:
12680: BEGIN
12681:
12682: -- Standard start of API savepoint

Line 12721: FROM EGO_MAPPINGS_B

12717: -- functions for this action, if there are any
12718:
12719: SELECT COUNT(*)
12720: INTO l_mapping_count
12721: FROM EGO_MAPPINGS_B
12722: WHERE MAPPED_OBJ_PK1_VAL = TO_CHAR(p_action_id)
12723: AND FUNCTION_ID = l_prompt_func_id
12724: AND MAPPED_OBJ_TYPE = l_prompt_obj_type;
12725:

Line 12735: FROM EGO_MAPPINGS_B

12731: END IF;
12732:
12733: SELECT COUNT(*)
12734: INTO l_mapping_count
12735: FROM EGO_MAPPINGS_B
12736: WHERE MAPPED_OBJ_PK1_VAL = TO_CHAR(p_action_id)
12737: AND FUNCTION_ID = l_vis_func_id
12738: AND MAPPED_OBJ_TYPE = l_vis_obj_type;
12739:

Line 13046: DELETE FROM EGO_MAPPINGS_B

13042: DELETE FROM EGO_FUNC_PARAMS_TL
13043: WHERE
13044: FUNC_PARAM_ID = p_function_param_id;
13045:
13046: DELETE FROM EGO_MAPPINGS_B
13047: WHERE
13048: FUNC_PARAM_ID = p_function_param_id;
13049:
13050: -- Standard check of p_commit

Line 13133: INSERT INTO EGO_MAPPINGS_B

13129: IF FND_API.To_Boolean(p_init_msg_list) THEN
13130: FND_MSG_PUB.Initialize;
13131: END IF;
13132:
13133: INSERT INTO EGO_MAPPINGS_B
13134: (
13135: FUNCTION_ID
13136: ,MAPPED_OBJ_TYPE
13137: ,MAPPED_OBJ_PK1_VAL

Line 13352: UPDATE EGO_MAPPINGS_B

13348: p_new_mapping_group_pk2 IS NOT NULL AND
13349: p_new_mapping_group_pk3 IS NOT NULL AND
13350: p_new_mapping_value IS NOT NULL) THEN
13351:
13352: UPDATE EGO_MAPPINGS_B
13353: SET
13354: MAPPED_TO_GROUP_TYPE = p_mapping_group_type
13355: ,MAPPED_TO_GROUP_PK1 = p_new_mapping_group_pk1
13356: ,MAPPED_TO_GROUP_PK2 = p_new_mapping_group_pk2

Line 13378: UPDATE EGO_MAPPINGS_B

13374: MAPPED_ATTRIBUTE = p_mapping_value;
13375:
13376: ELSE
13377:
13378: UPDATE EGO_MAPPINGS_B
13379: SET
13380: MAPPED_TO_GROUP_TYPE = p_mapping_group_type
13381: ,MAPPED_TO_GROUP_PK1 = p_mapping_group_pk1
13382: ,MAPPED_TO_GROUP_PK2 = p_mapping_group_pk2

Line 13570: DELETE FROM EGO_MAPPINGS_B

13566: IF FND_API.To_Boolean(p_init_msg_list) THEN
13567: FND_MSG_PUB.Initialize;
13568: END IF;
13569:
13570: DELETE FROM EGO_MAPPINGS_B
13571: WHERE
13572: FUNCTION_ID = p_function_id AND
13573: MAPPED_OBJ_TYPE = p_mapped_obj_type AND
13574: MAPPED_OBJ_PK1_VAL = p_mapped_obj_pk1_value;

Line 13644: DELETE FROM EGO_MAPPINGS_B

13640: IF FND_API.To_Boolean(p_init_msg_list) THEN
13641: FND_MSG_PUB.Initialize;
13642: END IF;
13643:
13644: DELETE FROM EGO_MAPPINGS_B
13645: WHERE
13646: FUNCTION_ID = p_function_id AND
13647: MAPPED_OBJ_TYPE = p_mapped_obj_type AND
13648: MAPPED_OBJ_PK1_VAL = p_mapped_obj_pk1_value AND