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.95.12020000.6 2012/11/29 10:35:09 lifcheng ship $ */
3:
4:
5: ------------------------------------

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

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

Line 1634: RETURN EGO_EXT_FWK_PUB.Get_Privilege_For_Attr_Group(

1630: IF l_attr_group_id IS NULL THEN
1631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1632: END IF;
1633:
1634: RETURN EGO_EXT_FWK_PUB.Get_Privilege_For_Attr_Group(
1635: p_attr_group_id => l_attr_group_id
1636: ,p_which_priv_to_return => p_which_priv_to_return
1637: );
1638:

Line 1846: EGO_EXT_FWK_PUB.Get_Available_AttrDBCols (

1842: l_database_columns EGO_VARCHAR_TBL_TYPE;
1843:
1844: BEGIN
1845:
1846: EGO_EXT_FWK_PUB.Get_Available_AttrDBCols (
1847: p_api_version => p_api_version
1848: ,p_attr_group_id => p_attr_group_id
1849: ,p_data_type => p_data_type
1850: ,x_database_columns => l_database_columns

Line 1874: EGO_EXT_FWK_PUB.Get_Available_AttrDBCols (

1870: l_database_columns EGO_VARCHAR_TBL_TYPE;
1871:
1872: BEGIN
1873:
1874: EGO_EXT_FWK_PUB.Get_Available_AttrDBCols (
1875: p_api_version => p_api_version
1876: ,p_application_id => p_application_id
1877: ,p_attr_group_type => p_attr_group_type
1878: ,p_attr_group_name => p_attr_group_name

Line 2023: EGO_EXT_FWK_PUB.Get_Available_AttrDBCols (

2019: BEGIN
2020:
2021: l_attr_group_pks := Get_PKs_From_Attr_Group_Id(p_attr_group_id);
2022:
2023: EGO_EXT_FWK_PUB.Get_Available_AttrDBCols (
2024: p_api_version => p_api_version
2025: ,p_application_id => l_attr_group_pks(1)
2026: ,p_attr_group_type => l_attr_group_pks(2)
2027: ,p_attr_group_name => l_attr_group_pks(3)

Line 2532: EGO_EXT_FWK_PUB.Get_Attr_Changes_Table

2528: /* -- bug: 3801472
2529: -- partition the Attribute Changes Tables
2530:
2531:
2532: EGO_EXT_FWK_PUB.Get_Attr_Changes_Table
2533: (p_attr_group_type => p_attr_group_type
2534: ,x_base_table => l_attr_chg_b_table
2535: ,x_tl_table => l_attr_chg_tl_table
2536: );*/

Line 2681: EGO_EXT_FWK_PUB.Create_Attribute_Group

2677: l_attr_group_id NUMBER;
2678:
2679: BEGIN
2680:
2681: EGO_EXT_FWK_PUB.Create_Attribute_Group
2682: (
2683: p_api_version => p_api_version
2684: ,p_application_id => p_application_id
2685: ,p_attr_group_type => p_attr_group_type

Line 2825: EGO_EXT_FWK_PUB.Create_Attribute(

2821: END LOOP;
2822: l_sequence_numbers := l_sequence_numbers||' '||l_sequence||' ';
2823:
2824:
2825: EGO_EXT_FWK_PUB.Create_Attribute(
2826: p_api_version => l_api_version
2827: ,p_application_id => p_dest_ag_app_id
2828: ,p_attr_group_type => p_dest_ag_type
2829: ,p_attr_group_name => p_dest_ag_name

Line 2903: EGO_EXT_FWK_PUB.Copy_Attribute_Group

2899: l_attr_group_id NUMBER;
2900:
2901: BEGIN
2902:
2903: EGO_EXT_FWK_PUB.Copy_Attribute_Group
2904: (
2905: p_api_version => p_api_version
2906: ,p_source_ag_app_id => p_source_ag_app_id
2907: ,p_source_ag_type => p_source_ag_type

Line 2950: EGO_EXT_FWK_PUB.Copy_Attribute_Group

2946: IF l_attr_group_pks IS NULL THEN
2947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2948: END IF;
2949:
2950: EGO_EXT_FWK_PUB.Copy_Attribute_Group
2951: (
2952: p_api_version => p_api_version
2953: ,p_source_ag_app_id => l_attr_group_pks(1)
2954: ,p_source_ag_type => l_attr_group_pks(2)

Line 3012: EGO_EXT_FWK_PUB.Update_Attribute_Group(

3008: IF l_attr_group_pks IS NULL THEN
3009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3010: END IF;
3011:
3012: EGO_EXT_FWK_PUB.Update_Attribute_Group(
3013: p_api_version => p_api_version
3014: ,p_application_id => l_attr_group_pks(1)
3015: ,p_attr_group_type => l_attr_group_pks(2)
3016: ,p_internal_name => l_attr_group_pks(3)

Line 3243: EGO_EXT_FWK_PUB.Delete_Attribute_Group(

3239: IF l_attr_group_pks IS NULL THEN
3240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3241: END IF;
3242:
3243: EGO_EXT_FWK_PUB.Delete_Attribute_Group(
3244: p_api_version => p_api_version
3245: ,p_application_id => l_attr_group_pks(1)
3246: ,p_attr_group_type => l_attr_group_pks(2)
3247: ,p_attr_group_name => l_attr_group_pks(3)

Line 3446: EGO_EXT_FWK_PUB.Get_Object_Id_For_AG_Type(

3442: ---------------------------------------------------------
3443: -- Next, get a metadata object for the Extension Table --
3444: ---------------------------------------------------------
3445: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(
3446: EGO_EXT_FWK_PUB.Get_Object_Id_For_AG_Type(
3447: l_attr_group_metadata_obj.APPLICATION_ID
3448: ,l_attr_group_metadata_obj.ATTR_GROUP_TYPE
3449: )
3450: );

Line 5189: IF (p_display = EGO_EXT_FWK_PUB.G_CHECKBOX_DISP_TYPE

5185: END IF;
5186: -- End of fix for bug 5884003
5187:
5188:
5189: IF (p_display = EGO_EXT_FWK_PUB.G_CHECKBOX_DISP_TYPE
5190: OR p_display =EGO_EXT_FWK_PUB.G_RADIO_DISP_TYPE ) THEN --bugFix:5292226
5191:
5192: SELECT MULTI_ROW
5193: INTO l_multi_row_flag

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

5186: -- End of fix for bug 5884003
5187:
5188:
5189: IF (p_display = EGO_EXT_FWK_PUB.G_CHECKBOX_DISP_TYPE
5190: OR p_display =EGO_EXT_FWK_PUB.G_RADIO_DISP_TYPE ) THEN --bugFix:5292226
5191:
5192: SELECT MULTI_ROW
5193: INTO l_multi_row_flag
5194: FROM EGO_FND_DSC_FLX_CTX_EXT

Line 6096: IF (p_display = EGO_EXT_FWK_PUB.G_CHECKBOX_DISP_TYPE

6092: END IF;
6093:
6094: END IF;
6095:
6096: IF (p_display = EGO_EXT_FWK_PUB.G_CHECKBOX_DISP_TYPE
6097: OR p_display =EGO_EXT_FWK_PUB.G_RADIO_DISP_TYPE ) THEN --bugFix:5292226
6098:
6099: SELECT MULTI_ROW
6100: INTO l_multi_row_flag

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

6093:
6094: END IF;
6095:
6096: IF (p_display = EGO_EXT_FWK_PUB.G_CHECKBOX_DISP_TYPE
6097: OR p_display =EGO_EXT_FWK_PUB.G_RADIO_DISP_TYPE ) THEN --bugFix:5292226
6098:
6099: SELECT MULTI_ROW
6100: INTO l_multi_row_flag
6101: FROM EGO_FND_DSC_FLX_CTX_EXT

Line 6877: EGO_EXT_FWK_PUB.Create_Value_Set(

6873:
6874:
6875: BEGIN
6876:
6877: EGO_EXT_FWK_PUB.Create_Value_Set(
6878: p_api_version => p_api_version
6879: ,p_value_set_name => p_value_set_name
6880: ,p_description => p_description
6881: ,p_format_code => p_format_code

Line 8335: EGO_EXT_FWK_PUB.Create_Value_Set_Val(

8331: AND FLEX_VALUE = P_INTERNAL_NAME ;
8332:
8333: IF(L_VALUE_EXIST < 1 ) THEN
8334:
8335: EGO_EXT_FWK_PUB.Create_Value_Set_Val(
8336: p_api_version => p_api_version
8337: ,p_value_set_name => p_value_set_name
8338: ,p_internal_name => p_internal_name
8339: ,p_display_name => p_display_name

Line 9606: EGO_EXT_FWK_PUB.Create_Association(

9602: IF l_attr_group_id IS NULL THEN
9603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9604: END IF;
9605:
9606: EGO_EXT_FWK_PUB.Create_Association(
9607: p_api_version => p_api_version
9608: ,p_association_id => p_association_id
9609: ,p_object_id => p_object_id
9610: ,p_classification_code => p_classification_code

Line 9690: EGO_EXT_FWK_PUB.Create_Association(

9686: IF l_object_id IS NULL THEN
9687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9688: END IF;
9689:
9690: EGO_EXT_FWK_PUB.Create_Association(
9691: p_api_version => p_api_version
9692: ,p_object_id => l_object_id
9693: ,p_classification_code => p_classification_code
9694: ,p_data_level => p_data_level

Line 9856: EGO_EXT_FWK_PUB.Update_Association(

9852: IF l_association_id IS NULL THEN
9853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9854: END IF;
9855:
9856: EGO_EXT_FWK_PUB.Update_Association(
9857: p_api_version => p_api_version
9858: ,p_association_id => l_association_id
9859: ,p_enabled_flag => p_enabled_flag
9860: ,p_view_privilege_id => p_view_privilege_id

Line 9945: EGO_EXT_FWK_PUB.Update_Association(

9941: IF l_association_id IS NULL THEN
9942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9943: END IF;
9944:
9945: EGO_EXT_FWK_PUB.Update_Association(
9946: p_api_version => p_api_version
9947: ,p_association_id => l_association_id
9948: ,p_enabled_flag => p_enabled_flag
9949: ,p_view_privilege_id => p_view_privilege_id

Line 10503: EGO_EXT_FWK_PUB.Update_Page(

10499: ELSE
10500: l_new_internal_name := p_new_internal_name;
10501: END IF;
10502:
10503: EGO_EXT_FWK_PUB.Update_Page(
10504: p_api_version => p_api_version
10505: ,p_page_id => l_page_id
10506: ,p_internal_name => l_new_internal_name
10507: ,p_display_name => p_display_name

Line 10652: EGO_EXT_FWK_PUB.Delete_Page(

10648: IF l_page_id IS NULL THEN
10649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10650: END IF;
10651:
10652: EGO_EXT_FWK_PUB.Delete_Page(
10653: p_api_version => p_api_version
10654: ,p_page_id => l_page_id
10655: ,p_init_msg_list => p_init_msg_list
10656: ,p_commit => p_commit

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

10834: l_class_meaning VARCHAR2(1000);
10835: BEGIN
10836: SELECT A.ATTR_GROUP_DISP_NAME
10837: ,PE.PAGE_DISPLAY_NAME
10838: ,EGO_EXT_FWK_PUB.Get_Class_Meaning(A.OBJECT_ID, PE.CLASSIFICATION_CODE)
10839: INTO l_ag_disp_name
10840: ,l_page_disp_name
10841: ,l_class_meaning
10842: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V A,

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

10961: l_class_meaning VARCHAR2(1000);
10962: BEGIN
10963: SELECT A.ATTR_GROUP_DISP_NAME
10964: ,PE.PAGE_DISPLAY_NAME
10965: ,EGO_EXT_FWK_PUB.Get_Class_Meaning(A.OBJECT_ID, PE.CLASSIFICATION_CODE)
10966: INTO l_ag_disp_name
10967: ,l_page_disp_name
10968: ,l_class_meaning
10969: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V A,

Line 11682: EGO_EXT_FWK_PUB.Create_Action(

11678: IF l_attr_group_id IS NULL THEN
11679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11680: END IF;
11681:
11682: EGO_EXT_FWK_PUB.Create_Action(
11683: p_api_version => p_api_version
11684: ,p_object_id => p_object_id
11685: ,p_classification_code => p_classification_code
11686: ,p_attr_group_id => l_attr_group_id

Line 11841: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_function_id,

11837: AND FUNCTION_ID = l_old_function_id
11838: AND MAPPED_OBJ_TYPE = l_mapped_obj_type;
11839:
11840: IF (l_mapping_count > 0) THEN
11841: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_function_id,
11842: l_mapped_obj_type, p_action_id, null,
11843: null, x_return_status, x_errorcode,
11844: x_msg_count, x_msg_data);
11845: END IF;

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

11988: AND FUNCTION_ID = l_function_id
11989: AND MAPPED_OBJ_TYPE = l_mapped_obj_type;
11990:
11991: IF (l_mapping_count > 0) THEN
11992: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_function_id, l_mapped_obj_type,
11993: p_action_id, null, null, x_return_status,
11994: x_errorcode, x_msg_count, x_msg_data);
11995: END IF;
11996:

Line 12385: EGO_EXT_FWK_PUB.Create_Action_Display (

12381: WHERE ACTION_ID = p_action_id;
12382:
12383: IF (l_disp_check_count = 0)
12384: THEN
12385: EGO_EXT_FWK_PUB.Create_Action_Display (
12386: p_api_version => '1.0'
12387: ,p_action_id => p_action_id
12388: ,p_display_style => p_display_style
12389: ,p_prompt_application_id => p_prompt_application_id

Line 12421: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_prompt_func_id,

12417: AND MAPPED_OBJ_TYPE = l_prompt_obj_type;
12418:
12419: IF (l_mapping_count > 0)
12420: THEN
12421: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_prompt_func_id,
12422: l_prompt_obj_type, p_action_id, null,
12423: null, x_return_status, x_errorcode,
12424: x_msg_count, x_msg_data);
12425: END IF;

Line 12444: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_vis_func_id,

12440: AND MAPPED_OBJ_TYPE = l_vis_obj_type;
12441:
12442: IF (l_mapping_count > 0)
12443: THEN
12444: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_vis_func_id,
12445: l_vis_obj_type, p_action_id, null,
12446: null, x_return_status, x_errorcode,
12447: x_msg_count, x_msg_data);
12448: END IF;

Line 12548: EGO_EXT_FWK_PUB.Create_Action_Display

12544: FROM EGO_ACTION_DISPLAYS_B
12545: WHERE ACTION_ID = p_action_id;
12546:
12547: IF (l_disp_check_count = 0) THEN
12548: EGO_EXT_FWK_PUB.Create_Action_Display
12549: (
12550: p_api_version => '1.0'
12551: ,p_action_id => p_action_id
12552: ,p_trigger_code => p_trigger_code

Line 12580: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_prompt_func_id,

12576: AND FUNCTION_ID = l_old_prompt_func_id
12577: AND MAPPED_OBJ_TYPE = l_prompt_obj_type;
12578:
12579: IF (l_mapping_count > 0) THEN
12580: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_prompt_func_id,
12581: l_prompt_obj_type, p_action_id, null,
12582: null, x_return_status, x_errorcode,
12583: x_msg_count, x_msg_data);
12584: END IF;

Line 12601: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_vis_func_id,

12597: AND FUNCTION_ID = l_old_vis_func_id
12598: AND MAPPED_OBJ_TYPE = l_vis_obj_type;
12599:
12600: IF (l_mapping_count > 0) THEN
12601: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_old_vis_func_id,
12602: l_vis_obj_type, p_action_id, null,
12603: null, x_return_status, x_errorcode,
12604: x_msg_count, x_msg_data);
12605: END IF;

Line 12727: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_prompt_func_id,

12723: AND FUNCTION_ID = l_prompt_func_id
12724: AND MAPPED_OBJ_TYPE = l_prompt_obj_type;
12725:
12726: IF (l_mapping_count > 0) THEN
12727: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_prompt_func_id,
12728: l_prompt_obj_type, p_action_id, null,
12729: null, x_return_status, x_errorcode,
12730: x_msg_count, x_msg_data);
12731: END IF;

Line 12741: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_vis_func_id,

12737: AND FUNCTION_ID = l_vis_func_id
12738: AND MAPPED_OBJ_TYPE = l_vis_obj_type;
12739:
12740: IF (l_mapping_count > 0) THEN
12741: EGO_EXT_FWK_PUB.Delete_Func_Mapping(p_api_version, l_vis_func_id,
12742: l_vis_obj_type, p_action_id, null,
12743: null, x_return_status, x_errorcode,
12744: x_msg_count, x_msg_data);
12745: END IF;

Line 13241: EGO_EXT_FWK_PUB.Create_Mapping(

13237: IF l_application_id IS NULL THEN
13238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13239: END IF;
13240: l_mapping_group_type := 'A';
13241: EGO_EXT_FWK_PUB.Create_Mapping(
13242: p_api_version => p_api_version
13243: ,p_function_id => p_function_id
13244: ,p_mapped_obj_type => p_mapped_obj_type
13245: ,p_mapped_obj_pk1_value => p_mapped_obj_pk1_value

Line 13474: EGO_EXT_FWK_PUB.Update_Mapping (

13470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13471: END IF;
13472: l_mapping_group_type := 'A';
13473:
13474: EGO_EXT_FWK_PUB.Update_Mapping (
13475:
13476: p_api_version => p_api_version
13477: ,p_function_id => p_function_id
13478: ,p_mapped_obj_type => p_mapped_obj_type

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

14827: CURSOR c_check_obj_name (cp_agv_name IN VARCHAR2, cp_appl_id IN NUMBER) IS
14828: SELECT object_name
14829: FROM all_objects
14830: where object_name = cp_agv_name
14831: and owner in (EGO_EXT_FWK_PUB.Get_Application_Owner(cp_appl_id), EGO_EXT_FWK_PUB.Get_Oracle_UserName);
14832:
14833: l_api_version CONSTANT NUMBER := 1.0 ;
14834: l_api_name CONSTANT VARCHAR (30) := 'Update_AGV_Name' ;
14835:

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

15218: BEGIN
15219:
15220: EXECUTE IMMEDIATE
15221: 'DECLARE ' ||
15222: ' l_metadata EGO_EXT_FWK_PUB.EGO_ATTR_USG_METADATA; ' ||
15223: ' l_api_ret_val VARCHAR2(1); ' ||
15224: 'BEGIN ' ||
15225: ' l_api_ret_val := ''N''; ' ||
15226: ' l_metadata.application_id := :1; ' ||

Line 15760: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - Function Id is '||l_function_id);

15756: IF EGO_ACTION_CSR%NOTFOUND THEN
15757: RAISE no_action_founded_exception;
15758: ELSE
15759: l_function_id := l_action_rec.FUNCTION_ID;
15760: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - Function Id is '||l_function_id);
15761: END IF;
15762: CLOSE EGO_ACTION_CSR;
15763:
15764: -------------------------------------------------------------

Line 15784: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - There are '|| l_action_mapping_table.COUNT || ' attr mappings');

15780: --Initialization
15781: l_action_mapping_table.extend();
15782: l_action_mapping_table(l_action_mapping_table.LAST) := r_action_mapping_rec;
15783: END LOOP;
15784: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - There are '|| l_action_mapping_table.COUNT || ' attr mappings');
15785:
15786: --------------------------------------------------------
15787: --Get the Function definition, Initialize l_function_rec
15788: --------------------------------------------------------

Line 15805: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - There are '|| l_function_param_table.COUNT || ' function parameters');

15801: EXIT WHEN EGO_FUNC_PARAMS_CSR%NOTFOUND;
15802: l_function_param_table.extend();
15803: l_function_param_table(l_function_param_table.LAST) := r_function_rec;
15804: END LOOP;
15805: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - There are '|| l_function_param_table.COUNT || ' function parameters');
15806:
15807: --Check if the Action <=> Function Mapping is correct or not
15808: IF l_action_mapping_table.COUNT <> l_function_param_table.COUNT THEN
15809: RAISE func_params_mapping_exception;

Line 15838: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - Constructed SQL statement is: ' || l_sql);

15834: END IF;
15835: l_sql := l_sql || '); END;';
15836:
15837:
15838: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - Constructed SQL statement is: ' || l_sql);
15839:
15840: -----------------------------------------
15841: -- Parse constructed SQL
15842: -----------------------------------------

Line 15863: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - l_func_param_name:l_attr_name => '||l_func_param_name||':'||l_attr_name);

15859: END IF;
15860:
15861: l_attr_name := l_action_mapping_table(i).MAPPED_ATTRIBUTE;
15862:
15863: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - l_func_param_name:l_attr_name => '||l_func_param_name||':'||l_attr_name);
15864:
15865: ------------------------------------------------------------------
15866: -- Check the value of l_function_param_rec.MAPPED_TO_GROUP_TYPE --
15867: -- 1. A : an Attribute Group value. --

Line 15881: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_STR);

15877: IF l_function_param_rec.PARAM_TYPE_CODE IN ('I', 'O', 'B') THEN
15878: --Check the data type for current attr/param
15879: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15880: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_STR,32767);
15881: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_STR);
15882: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15883: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_NUM);
15884: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_NUM);
15885: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN

Line 15884: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_NUM);

15880: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_STR,32767);
15881: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_STR);
15882: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15883: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_NUM);
15884: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_NUM);
15885: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15886: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_DATE);
15887: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_DATE);
15888: END IF;

Line 15887: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_DATE);

15883: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_NUM);
15884: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_NUM);
15885: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15886: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_DATE);
15887: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_DATE);
15888: END IF;
15889:
15890: ELSIF l_function_param_rec.PARAM_TYPE_CODE = 'R' THEN
15891: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN

Line 15893: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(varchar2): '||l_func_param_name||', VALUE: '|| x_attributes_data_table(j).ATTR_VALUE_STR);

15889:
15890: ELSIF l_function_param_rec.PARAM_TYPE_CODE = 'R' THEN
15891: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15892: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_STR, 32767);
15893: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(varchar2): '||l_func_param_name||', VALUE: '|| x_attributes_data_table(j).ATTR_VALUE_STR);
15894: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15895: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_NUM);
15896: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_NUM);
15897: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN

Line 15896: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_NUM);

15892: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_STR, 32767);
15893: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(varchar2): '||l_func_param_name||', VALUE: '|| x_attributes_data_table(j).ATTR_VALUE_STR);
15894: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15895: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_NUM);
15896: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_NUM);
15897: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15898: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_DATE);
15899: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(date): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_DATE);
15900: END IF;

Line 15899: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(date): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_DATE);

15895: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_NUM);
15896: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_NUM);
15897: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15898: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_DATE);
15899: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(date): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_DATE);
15900: END IF;
15901: END IF;
15902: --Found value for current paramenter, so exit loop
15903: l_boolean := TRUE;

Line 15919: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);

15915: IF l_function_param_rec.PARAM_TYPE_CODE IN ('I', 'O', 'B') THEN
15916: --Check the data type for current attr/param
15917: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15918: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE,32767);
15919: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15920: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15921: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE);
15922: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15923: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN

Line 15922: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);

15918: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE,32767);
15919: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15920: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15921: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE);
15922: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15923: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15924: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE);
15925: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15926: END IF;

Line 15925: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);

15921: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE);
15922: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15923: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15924: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE);
15925: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15926: END IF;
15927:
15928: ELSIF l_function_param_rec.PARAM_TYPE_CODE = 'R' THEN
15929: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN

Line 15931: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(varchar2): '||l_func_param_name||', VALUE: '|| x_external_attrs_value_pairs(j).VALUE);

15927:
15928: ELSIF l_function_param_rec.PARAM_TYPE_CODE = 'R' THEN
15929: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15930: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE, 32767);
15931: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(varchar2): '||l_func_param_name||', VALUE: '|| x_external_attrs_value_pairs(j).VALUE);
15932: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15933: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE);
15934: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15935: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN

Line 15934: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);

15930: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE, 32767);
15931: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(varchar2): '||l_func_param_name||', VALUE: '|| x_external_attrs_value_pairs(j).VALUE);
15932: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15933: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE);
15934: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15935: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15936: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE);
15937: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(date): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15938: END IF;

Line 15937: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(date): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);

15933: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE);
15934: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15935: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15936: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE);
15937: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(date): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15938: END IF;
15939: END IF;
15940: --Found value for current paramenter, so exit loop
15941: l_boolean := TRUE;

Line 15956: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);

15952: IF l_function_param_rec.PARAM_TYPE_CODE IN ('I', 'O', 'B') THEN
15953: --Check the data type for current attr/param
15954: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15955: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_pk_col_value_pairs(j).VALUE,32767);
15956: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15957: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15958: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_pk_col_value_pairs(j).VALUE);
15959: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15960: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN

Line 15959: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);

15955: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_pk_col_value_pairs(j).VALUE,32767);
15956: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15957: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15958: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_pk_col_value_pairs(j).VALUE);
15959: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15960: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15961: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_pk_col_value_pairs(j).VALUE);
15962: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15963: END IF;

Line 15962: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);

15958: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_pk_col_value_pairs(j).VALUE);
15959: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15960: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15961: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_pk_col_value_pairs(j).VALUE);
15962: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15963: END IF;
15964:
15965: ELSIF l_function_param_rec.PARAM_TYPE_CODE = 'R' THEN
15966: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN

Line 15968: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(varchar2): '||l_func_param_name||', VALUE: '|| p_pk_col_value_pairs(j).VALUE);

15964:
15965: ELSIF l_function_param_rec.PARAM_TYPE_CODE = 'R' THEN
15966: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15967: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_pk_col_value_pairs(j).VALUE, 32767);
15968: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(varchar2): '||l_func_param_name||', VALUE: '|| p_pk_col_value_pairs(j).VALUE);
15969: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15970: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_pk_col_value_pairs(j).VALUE);
15971: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15972: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN

Line 15971: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);

15967: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_pk_col_value_pairs(j).VALUE, 32767);
15968: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(varchar2): '||l_func_param_name||', VALUE: '|| p_pk_col_value_pairs(j).VALUE);
15969: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15970: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_pk_col_value_pairs(j).VALUE);
15971: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15972: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15973: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_pk_col_value_pairs(j).VALUE);
15974: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(date): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15975: END IF;

Line 15974: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(date): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);

15970: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_pk_col_value_pairs(j).VALUE);
15971: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15972: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15973: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_pk_col_value_pairs(j).VALUE);
15974: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(date): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15975: END IF;
15976: END IF;
15977: --Found value for current paramenter, so exit loop
15978: l_boolean := TRUE;

Line 15992: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);

15988: IF l_function_param_rec.PARAM_TYPE_CODE IN ('I', 'O', 'B') THEN
15989: --Check the data type for current attr/param
15990: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15991: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_dtlevel_col_value_pairs(j).VALUE,32767);
15992: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);
15993: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15994: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_dtlevel_col_value_pairs(j).VALUE);
15995: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);
15996: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN

Line 15995: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);

15991: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_dtlevel_col_value_pairs(j).VALUE,32767);
15992: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);
15993: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15994: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_dtlevel_col_value_pairs(j).VALUE);
15995: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);
15996: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15997: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_dtlevel_col_value_pairs(j).VALUE);
15998: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);
15999: END IF;

Line 15998: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);

15994: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_dtlevel_col_value_pairs(j).VALUE);
15995: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);
15996: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15997: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_dtlevel_col_value_pairs(j).VALUE);
15998: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);
15999: END IF;
16000:
16001: ELSIF l_function_param_rec.PARAM_TYPE_CODE = 'R' THEN
16002: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN

Line 16031: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND NULL VALUE FOR PARAM: ' || l_func_param_name);

16027: DBMS_SQL.BIND_VARIABLE(v_cursor, ':'||l_func_param_name, l_null_n);
16028: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
16029: DBMS_SQL.BIND_VARIABLE(v_cursor, ':'||l_func_param_name, l_null_d);
16030: END IF;
16031: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND NULL VALUE FOR PARAM: ' || l_func_param_name);
16032: ELSE
16033: RAISE no_data_found_for_param_bind;
16034: END IF;
16035: END IF;

Line 16038: --code_debug ('EGO_EXT_FWK_PUB.Execute_Function - CHECK POINT 1');

16034: END IF;
16035: END IF;
16036: END LOOP;
16037:
16038: --code_debug ('EGO_EXT_FWK_PUB.Execute_Function - CHECK POINT 1');
16039:
16040: -----------------------------------------
16041: -- Execute the Dynamic SQL using DBMS_SQL
16042: -----------------------------------------

Line 16044: --code_debug ('EGO_EXT_FWK_PUB.Execute_Function - CHECK POINT 2, l_dummy:' || l_dummy);

16040: -----------------------------------------
16041: -- Execute the Dynamic SQL using DBMS_SQL
16042: -----------------------------------------
16043: l_dummy := DBMS_SQL.EXECUTE(v_cursor);
16044: --code_debug ('EGO_EXT_FWK_PUB.Execute_Function - CHECK POINT 2, l_dummy:' || l_dummy);
16045:
16046: -----------------------------------------
16047: -- Retrieve the value of OUTPUT parameter
16048: -----------------------------------------

Line 16067: --code_debug ('EGO_EXT_FWK_PUB.Execute_Function - CHECK POINT 3');

16063: LOOP
16064: IF x_attributes_data_table(j).ATTR_NAME = l_attr_name THEN
16065: --For OUTPUT, INPUT/OUTPUT, RETURN parameters
16066: IF l_function_param_table(i).PARAM_TYPE_CODE IN ('O', 'B') THEN
16067: --code_debug ('EGO_EXT_FWK_PUB.Execute_Function - CHECK POINT 3');
16068: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
16069: DBMS_SQL.VARIABLE_VALUE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_STR);
16070: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
16071: DBMS_SQL.VARIABLE_VALUE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_NUM);

Line 16175: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_EXT_FWK_PUB');

16171: WHEN OTHERS THEN
16172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16173:
16174: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
16175: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_EXT_FWK_PUB');
16176: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
16177: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
16178: FND_MSG_PUB.Add;
16179: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 16274: END EGO_EXT_FWK_PUB;

16270: END IF;
16271: CLOSE csr1;
16272: END Check_Attr_Group_View;
16273:
16274: END EGO_EXT_FWK_PUB;