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_EXT_FWK_PUB

Line 1: PACKAGE BODY EGO_EXT_FWK_PUB AS

1: PACKAGE BODY EGO_EXT_FWK_PUB AS
2: /* $Header: EGOPEFMB.pls 120.61 2008/04/21 08:45:53 sandpand ship $ */
3:
4: ------------------------------------
5: -- Global Variables and Constants --

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_EXT_FWK_PUB';

3:
4: ------------------------------------
5: -- Global Variables and Constants --
6: ------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_EXT_FWK_PUB';
8: G_APP_NAME CONSTANT VARCHAR2(3) := 'EGO';
9: G_PKG_NAME_TOKEN CONSTANT VARCHAR2(8) := 'PKG_NAME';
10: G_API_NAME_TOKEN CONSTANT VARCHAR2(8) := 'API_NAME';
11: G_SQL_ERR_MSG_TOKEN CONSTANT VARCHAR2(11) := 'SQL_ERR_MSG';

Line 1576: RETURN EGO_EXT_FWK_PUB.Get_Privilege_For_Attr_Group(

1572: IF l_attr_group_id IS NULL THEN
1573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1574: END IF;
1575:
1576: RETURN EGO_EXT_FWK_PUB.Get_Privilege_For_Attr_Group(
1577: p_attr_group_id => l_attr_group_id
1578: ,p_which_priv_to_return => p_which_priv_to_return
1579: );
1580:

Line 1764: EGO_EXT_FWK_PUB.Get_Available_AttrDBCols (

1760: l_database_columns EGO_VARCHAR_TBL_TYPE;
1761:
1762: BEGIN
1763:
1764: EGO_EXT_FWK_PUB.Get_Available_AttrDBCols (
1765: p_api_version => p_api_version
1766: ,p_attr_group_id => p_attr_group_id
1767: ,p_data_type => p_data_type
1768: ,x_database_columns => l_database_columns

Line 1792: EGO_EXT_FWK_PUB.Get_Available_AttrDBCols (

1788: l_database_columns EGO_VARCHAR_TBL_TYPE;
1789:
1790: BEGIN
1791:
1792: EGO_EXT_FWK_PUB.Get_Available_AttrDBCols (
1793: p_api_version => p_api_version
1794: ,p_application_id => p_application_id
1795: ,p_attr_group_type => p_attr_group_type
1796: ,p_attr_group_name => p_attr_group_name

Line 1941: EGO_EXT_FWK_PUB.Get_Available_AttrDBCols (

1937: BEGIN
1938:
1939: l_attr_group_pks := Get_PKs_From_Attr_Group_Id(p_attr_group_id);
1940:
1941: EGO_EXT_FWK_PUB.Get_Available_AttrDBCols (
1942: p_api_version => p_api_version
1943: ,p_application_id => l_attr_group_pks(1)
1944: ,p_attr_group_type => l_attr_group_pks(2)
1945: ,p_attr_group_name => l_attr_group_pks(3)

Line 2446: EGO_EXT_FWK_PUB.Get_Attr_Changes_Table

2442: /* -- bug: 3801472
2443: -- partition the Attribute Changes Tables
2444:
2445:
2446: EGO_EXT_FWK_PUB.Get_Attr_Changes_Table
2447: (p_attr_group_type => p_attr_group_type
2448: ,x_base_table => l_attr_chg_b_table
2449: ,x_tl_table => l_attr_chg_tl_table
2450: );*/

Line 2595: EGO_EXT_FWK_PUB.Create_Attribute_Group

2591: l_attr_group_id NUMBER;
2592:
2593: BEGIN
2594:
2595: EGO_EXT_FWK_PUB.Create_Attribute_Group
2596: (
2597: p_api_version => p_api_version
2598: ,p_application_id => p_application_id
2599: ,p_attr_group_type => p_attr_group_type

Line 2739: EGO_EXT_FWK_PUB.Create_Attribute(

2735: END LOOP;
2736: l_sequence_numbers := l_sequence_numbers||' '||l_sequence||' ';
2737:
2738:
2739: EGO_EXT_FWK_PUB.Create_Attribute(
2740: p_api_version => l_api_version
2741: ,p_application_id => p_dest_ag_app_id
2742: ,p_attr_group_type => p_dest_ag_type
2743: ,p_attr_group_name => p_dest_ag_name

Line 2817: EGO_EXT_FWK_PUB.Copy_Attribute_Group

2813: l_attr_group_id NUMBER;
2814:
2815: BEGIN
2816:
2817: EGO_EXT_FWK_PUB.Copy_Attribute_Group
2818: (
2819: p_api_version => p_api_version
2820: ,p_source_ag_app_id => p_source_ag_app_id
2821: ,p_source_ag_type => p_source_ag_type

Line 2864: EGO_EXT_FWK_PUB.Copy_Attribute_Group

2860: IF l_attr_group_pks IS NULL THEN
2861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2862: END IF;
2863:
2864: EGO_EXT_FWK_PUB.Copy_Attribute_Group
2865: (
2866: p_api_version => p_api_version
2867: ,p_source_ag_app_id => l_attr_group_pks(1)
2868: ,p_source_ag_type => l_attr_group_pks(2)

Line 2926: EGO_EXT_FWK_PUB.Update_Attribute_Group(

2922: IF l_attr_group_pks IS NULL THEN
2923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2924: END IF;
2925:
2926: EGO_EXT_FWK_PUB.Update_Attribute_Group(
2927: p_api_version => p_api_version
2928: ,p_application_id => l_attr_group_pks(1)
2929: ,p_attr_group_type => l_attr_group_pks(2)
2930: ,p_internal_name => l_attr_group_pks(3)

Line 3157: EGO_EXT_FWK_PUB.Delete_Attribute_Group(

3153: IF l_attr_group_pks IS NULL THEN
3154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3155: END IF;
3156:
3157: EGO_EXT_FWK_PUB.Delete_Attribute_Group(
3158: p_api_version => p_api_version
3159: ,p_application_id => l_attr_group_pks(1)
3160: ,p_attr_group_type => l_attr_group_pks(2)
3161: ,p_attr_group_name => l_attr_group_pks(3)

Line 3354: EGO_EXT_FWK_PUB.Get_Object_Id_For_AG_Type(

3350: ---------------------------------------------------------
3351: -- Next, get a metadata object for the Extension Table --
3352: ---------------------------------------------------------
3353: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(
3354: EGO_EXT_FWK_PUB.Get_Object_Id_For_AG_Type(
3355: l_attr_group_metadata_obj.APPLICATION_ID
3356: ,l_attr_group_metadata_obj.ATTR_GROUP_TYPE
3357: )
3358: );

Line 4981: IF (p_display = EGO_EXT_FWK_PUB.G_CHECKBOX_DISP_TYPE

4977: END IF;
4978: -- End of fix for bug 5884003
4979:
4980:
4981: IF (p_display = EGO_EXT_FWK_PUB.G_CHECKBOX_DISP_TYPE
4982: OR p_display =EGO_EXT_FWK_PUB.G_RADIO_DISP_TYPE ) THEN --bugFix:5292226
4983:
4984: SELECT MULTI_ROW
4985: INTO l_multi_row_flag

Line 4982: OR p_display =EGO_EXT_FWK_PUB.G_RADIO_DISP_TYPE ) THEN --bugFix:5292226

4978: -- End of fix for bug 5884003
4979:
4980:
4981: IF (p_display = EGO_EXT_FWK_PUB.G_CHECKBOX_DISP_TYPE
4982: OR p_display =EGO_EXT_FWK_PUB.G_RADIO_DISP_TYPE ) THEN --bugFix:5292226
4983:
4984: SELECT MULTI_ROW
4985: INTO l_multi_row_flag
4986: FROM EGO_FND_DSC_FLX_CTX_EXT

Line 5800: IF (p_display = EGO_EXT_FWK_PUB.G_CHECKBOX_DISP_TYPE

5796: END IF;
5797:
5798: END IF;
5799:
5800: IF (p_display = EGO_EXT_FWK_PUB.G_CHECKBOX_DISP_TYPE
5801: OR p_display =EGO_EXT_FWK_PUB.G_RADIO_DISP_TYPE ) THEN --bugFix:5292226
5802:
5803: SELECT MULTI_ROW
5804: INTO l_multi_row_flag

Line 5801: OR p_display =EGO_EXT_FWK_PUB.G_RADIO_DISP_TYPE ) THEN --bugFix:5292226

5797:
5798: END IF;
5799:
5800: IF (p_display = EGO_EXT_FWK_PUB.G_CHECKBOX_DISP_TYPE
5801: OR p_display =EGO_EXT_FWK_PUB.G_RADIO_DISP_TYPE ) THEN --bugFix:5292226
5802:
5803: SELECT MULTI_ROW
5804: INTO l_multi_row_flag
5805: FROM EGO_FND_DSC_FLX_CTX_EXT

Line 8636: EGO_EXT_FWK_PUB.Create_Association(

8632: IF l_attr_group_id IS NULL THEN
8633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8634: END IF;
8635:
8636: EGO_EXT_FWK_PUB.Create_Association(
8637: p_api_version => p_api_version
8638: ,p_association_id => p_association_id
8639: ,p_object_id => p_object_id
8640: ,p_classification_code => p_classification_code

Line 8720: EGO_EXT_FWK_PUB.Create_Association(

8716: IF l_object_id IS NULL THEN
8717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8718: END IF;
8719:
8720: EGO_EXT_FWK_PUB.Create_Association(
8721: p_api_version => p_api_version
8722: ,p_object_id => l_object_id
8723: ,p_classification_code => p_classification_code
8724: ,p_data_level => p_data_level

Line 8886: EGO_EXT_FWK_PUB.Update_Association(

8882: IF l_association_id IS NULL THEN
8883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8884: END IF;
8885:
8886: EGO_EXT_FWK_PUB.Update_Association(
8887: p_api_version => p_api_version
8888: ,p_association_id => l_association_id
8889: ,p_enabled_flag => p_enabled_flag
8890: ,p_view_privilege_id => p_view_privilege_id

Line 8975: EGO_EXT_FWK_PUB.Update_Association(

8971: IF l_association_id IS NULL THEN
8972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8973: END IF;
8974:
8975: EGO_EXT_FWK_PUB.Update_Association(
8976: p_api_version => p_api_version
8977: ,p_association_id => l_association_id
8978: ,p_enabled_flag => p_enabled_flag
8979: ,p_view_privilege_id => p_view_privilege_id

Line 9533: EGO_EXT_FWK_PUB.Update_Page(

9529: ELSE
9530: l_new_internal_name := p_new_internal_name;
9531: END IF;
9532:
9533: EGO_EXT_FWK_PUB.Update_Page(
9534: p_api_version => p_api_version
9535: ,p_page_id => l_page_id
9536: ,p_internal_name => l_new_internal_name
9537: ,p_display_name => p_display_name

Line 9682: EGO_EXT_FWK_PUB.Delete_Page(

9678: IF l_page_id IS NULL THEN
9679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9680: END IF;
9681:
9682: EGO_EXT_FWK_PUB.Delete_Page(
9683: p_api_version => p_api_version
9684: ,p_page_id => l_page_id
9685: ,p_init_msg_list => p_init_msg_list
9686: ,p_commit => p_commit

Line 9868: ,EGO_EXT_FWK_PUB.Get_Class_Meaning(A.OBJECT_ID, PE.CLASSIFICATION_CODE)

9864: l_class_meaning VARCHAR2(1000);
9865: BEGIN
9866: SELECT A.ATTR_GROUP_DISP_NAME
9867: ,PE.PAGE_DISPLAY_NAME
9868: ,EGO_EXT_FWK_PUB.Get_Class_Meaning(A.OBJECT_ID, PE.CLASSIFICATION_CODE)
9869: INTO l_ag_disp_name
9870: ,l_page_disp_name
9871: ,l_class_meaning
9872: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V A,

Line 9995: ,EGO_EXT_FWK_PUB.Get_Class_Meaning(A.OBJECT_ID, PE.CLASSIFICATION_CODE)

9991: l_class_meaning VARCHAR2(1000);
9992: BEGIN
9993: SELECT A.ATTR_GROUP_DISP_NAME
9994: ,PE.PAGE_DISPLAY_NAME
9995: ,EGO_EXT_FWK_PUB.Get_Class_Meaning(A.OBJECT_ID, PE.CLASSIFICATION_CODE)
9996: INTO l_ag_disp_name
9997: ,l_page_disp_name
9998: ,l_class_meaning
9999: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V A,

Line 10712: EGO_EXT_FWK_PUB.Create_Action(

10708: IF l_attr_group_id IS NULL THEN
10709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10710: END IF;
10711:
10712: EGO_EXT_FWK_PUB.Create_Action(
10713: p_api_version => p_api_version
10714: ,p_object_id => p_object_id
10715: ,p_classification_code => p_classification_code
10716: ,p_attr_group_id => l_attr_group_id

Line 10871: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_function_id,

10867: AND FUNCTION_ID = l_old_function_id
10868: AND MAPPED_OBJ_TYPE = l_mapped_obj_type;
10869:
10870: IF (l_mapping_count > 0) THEN
10871: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_function_id,
10872: l_mapped_obj_type, p_action_id, null,
10873: null, x_return_status, x_errorcode,
10874: x_msg_count, x_msg_data);
10875: END IF;

Line 11022: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_function_id, l_mapped_obj_type,

11018: AND FUNCTION_ID = l_function_id
11019: AND MAPPED_OBJ_TYPE = l_mapped_obj_type;
11020:
11021: IF (l_mapping_count > 0) THEN
11022: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_function_id, l_mapped_obj_type,
11023: p_action_id, null, null, x_return_status,
11024: x_errorcode, x_msg_count, x_msg_data);
11025: END IF;
11026:

Line 11413: EGO_EXT_FWK_PUB.Create_Action_Display (

11409: WHERE ACTION_ID = p_action_id;
11410:
11411: IF (l_disp_check_count = 0)
11412: THEN
11413: EGO_EXT_FWK_PUB.Create_Action_Display (
11414: p_api_version => '1.0'
11415: ,p_action_id => p_action_id
11416: ,p_display_style => p_display_style
11417: ,p_prompt_application_id => p_prompt_application_id

Line 11449: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_prompt_func_id,

11445: AND MAPPED_OBJ_TYPE = l_prompt_obj_type;
11446:
11447: IF (l_mapping_count > 0)
11448: THEN
11449: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_prompt_func_id,
11450: l_prompt_obj_type, p_action_id, null,
11451: null, x_return_status, x_errorcode,
11452: x_msg_count, x_msg_data);
11453: END IF;

Line 11472: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_vis_func_id,

11468: AND MAPPED_OBJ_TYPE = l_vis_obj_type;
11469:
11470: IF (l_mapping_count > 0)
11471: THEN
11472: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_vis_func_id,
11473: l_vis_obj_type, p_action_id, null,
11474: null, x_return_status, x_errorcode,
11475: x_msg_count, x_msg_data);
11476: END IF;

Line 11576: EGO_EXT_FWK_PUB.Create_Action_Display

11572: FROM EGO_ACTION_DISPLAYS_B
11573: WHERE ACTION_ID = p_action_id;
11574:
11575: IF (l_disp_check_count = 0) THEN
11576: EGO_EXT_FWK_PUB.Create_Action_Display
11577: (
11578: p_api_version => '1.0'
11579: ,p_action_id => p_action_id
11580: ,p_trigger_code => p_trigger_code

Line 11608: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_prompt_func_id,

11604: AND FUNCTION_ID = l_old_prompt_func_id
11605: AND MAPPED_OBJ_TYPE = l_prompt_obj_type;
11606:
11607: IF (l_mapping_count > 0) THEN
11608: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_prompt_func_id,
11609: l_prompt_obj_type, p_action_id, null,
11610: null, x_return_status, x_errorcode,
11611: x_msg_count, x_msg_data);
11612: END IF;

Line 11629: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_vis_func_id,

11625: AND FUNCTION_ID = l_old_vis_func_id
11626: AND MAPPED_OBJ_TYPE = l_vis_obj_type;
11627:
11628: IF (l_mapping_count > 0) THEN
11629: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_vis_func_id,
11630: l_vis_obj_type, p_action_id, null,
11631: null, x_return_status, x_errorcode,
11632: x_msg_count, x_msg_data);
11633: END IF;

Line 11755: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_prompt_func_id,

11751: AND FUNCTION_ID = l_prompt_func_id
11752: AND MAPPED_OBJ_TYPE = l_prompt_obj_type;
11753:
11754: IF (l_mapping_count > 0) THEN
11755: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_prompt_func_id,
11756: l_prompt_obj_type, p_action_id, null,
11757: null, x_return_status, x_errorcode,
11758: x_msg_count, x_msg_data);
11759: END IF;

Line 11769: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_vis_func_id,

11765: AND FUNCTION_ID = l_vis_func_id
11766: AND MAPPED_OBJ_TYPE = l_vis_obj_type;
11767:
11768: IF (l_mapping_count > 0) THEN
11769: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_vis_func_id,
11770: l_vis_obj_type, p_action_id, null,
11771: null, x_return_status, x_errorcode,
11772: x_msg_count, x_msg_data);
11773: END IF;

Line 12269: EGO_EXT_FWK_PUB.Create_Mapping(

12265: IF l_application_id IS NULL THEN
12266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12267: END IF;
12268: l_mapping_group_type := 'A';
12269: EGO_EXT_FWK_PUB.Create_Mapping(
12270: p_api_version => p_api_version
12271: ,p_function_id => p_function_id
12272: ,p_mapped_obj_type => p_mapped_obj_type
12273: ,p_mapped_obj_pk1_value => p_mapped_obj_pk1_value

Line 12502: EGO_EXT_FWK_PUB.Update_Mapping (

12498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12499: END IF;
12500: l_mapping_group_type := 'A';
12501:
12502: EGO_EXT_FWK_PUB.Update_Mapping (
12503:
12504: p_api_version => p_api_version
12505: ,p_function_id => p_function_id
12506: ,p_mapped_obj_type => p_mapped_obj_type

Line 13772: and owner in (EGO_EXT_FWK_PUB.Get_Application_Owner(cp_appl_id), EGO_EXT_FWK_PUB.Get_Oracle_UserName);

13768: CURSOR c_check_obj_name (cp_agv_name IN VARCHAR2, cp_appl_id IN NUMBER) IS
13769: SELECT object_name
13770: FROM all_objects
13771: where object_name = cp_agv_name
13772: and owner in (EGO_EXT_FWK_PUB.Get_Application_Owner(cp_appl_id), EGO_EXT_FWK_PUB.Get_Oracle_UserName);
13773:
13774: l_api_version CONSTANT NUMBER := 1.0 ;
13775: l_api_name CONSTANT VARCHAR (30) := 'Update_AGV_Name' ;
13776:

Line 14152: ' l_metadata EGO_EXT_FWK_PUB.EGO_ATTR_USG_METADATA; ' ||

14148: BEGIN
14149:
14150: EXECUTE IMMEDIATE
14151: 'DECLARE ' ||
14152: ' l_metadata EGO_EXT_FWK_PUB.EGO_ATTR_USG_METADATA; ' ||
14153: ' l_api_ret_val VARCHAR2(1); ' ||
14154: 'BEGIN ' ||
14155: ' l_api_ret_val := ''N''; ' ||
14156: ' l_metadata.application_id := :1; ' ||

Line 14397: END EGO_EXT_FWK_PUB;

14393: RETURN l_data_levels;
14394:
14395: END;
14396:
14397: END EGO_EXT_FWK_PUB;
14398: