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.PON_FORMS_UTIL_PVT dependencies on PON_FORMS_UTIL_PVT

Line 1: PACKAGE BODY PON_FORMS_UTIL_PVT as

1: PACKAGE BODY PON_FORMS_UTIL_PVT as
2: /* $Header: PONFMUTB.pls 120.9 2006/03/21 04:43:19 ukottama noship $ */
3:
4: g_jrad_rgn_pkg_name CONSTANT VARCHAR2(50) := '/oracle/apps/pon/forms/jrad/webui/';
5:

Line 7: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_FORMS_UTIL_PVT';

3:
4: g_jrad_rgn_pkg_name CONSTANT VARCHAR2(50) := '/oracle/apps/pon/forms/jrad/webui/';
5:
6: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
7: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_FORMS_UTIL_PVT';
8: g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.' || g_pkg_name || '.';
9:
10:
11: g_newline Varchar2(10);

Line 152: l_ret_val := PON_FORMS_UTIL_PVT.getFlexTblValue(p_field_code, p_field_value);

148: WHERE fnd_flex_value_sets.FLEX_VALUE_SET_NAME = pon_fields.VALUE_SET_NAME
149: AND pon_fields.FIELD_CODE = P_FIELD_CODE;
150:
151: IF(l_validation_type = 'F') THEN
152: l_ret_val := PON_FORMS_UTIL_PVT.getFlexTblValue(p_field_code, p_field_value);
153: ELSIF ((l_validation_type = 'X') or (l_validation_type = 'I')) THEN
154: l_ret_val := PON_FORMS_UTIL_PVT.GetFLEXINDENDENTVALUE(l_vset_name, p_field_value);
155: END IF;
156:

Line 154: l_ret_val := PON_FORMS_UTIL_PVT.GetFLEXINDENDENTVALUE(l_vset_name, p_field_value);

150:
151: IF(l_validation_type = 'F') THEN
152: l_ret_val := PON_FORMS_UTIL_PVT.getFlexTblValue(p_field_code, p_field_value);
153: ELSIF ((l_validation_type = 'X') or (l_validation_type = 'I')) THEN
154: l_ret_val := PON_FORMS_UTIL_PVT.GetFLEXINDENDENTVALUE(l_vset_name, p_field_value);
155: END IF;
156:
157: print_debug_log(l_api_name, 'END l_ret_val = '||l_ret_val);
158:

Line 611: PON_FORMS_UTIL_PVT.GET_FREIGHT(ah.carrier_code, fsp.inventory_organization_id)

607:
608: elsif p_field_code = 'CARRIER_NAME' then
609:
610: select
611: PON_FORMS_UTIL_PVT.GET_FREIGHT(ah.carrier_code, fsp.inventory_organization_id)
612: into rt_large_value
613: from pon_auction_headers_all ah,
614: financials_system_params_all fsp
615: where ah.auction_header_id = to_number(p_id)

Line 1053: || g_newline || ',PON_FORMS_UTIL_PVT.GetFLEXINDENDENTVALUE('''|| p_value_set_name || ''','

1049: print_debug_log(l_api_name, 'l_value_set_type = '||l_value_set_type);
1050:
1051: if l_value_set_type in ('I','X') then
1052: p_query_stmt := p_query_stmt || g_newline || ',' || p_value_alias ||'.' ||p_value_column || ' AS ' || p_field_code
1053: || g_newline || ',PON_FORMS_UTIL_PVT.GetFLEXINDENDENTVALUE('''|| p_value_set_name || ''','
1054: || g_newline || ' ' || p_value_alias ||'.'|| p_value_column || ') AS ' || p_field_code || '_NM';
1055: /* ==============================================================================
1056: p_query_stmt := p_query_stmt || g_newline || ',xmlelement("FIELDVALUE"'
1057: || ' ,xmlattributes(' || p_value_alias ||'.' ||p_value_column || ' AS "CODE"'

Line 1058: || g_newline || ' ,PON_FORMS_UTIL_PVT.GetFLEXINDENDENTVALUE('''

1054: || g_newline || ' ' || p_value_alias ||'.'|| p_value_column || ') AS ' || p_field_code || '_NM';
1055: /* ==============================================================================
1056: p_query_stmt := p_query_stmt || g_newline || ',xmlelement("FIELDVALUE"'
1057: || ' ,xmlattributes(' || p_value_alias ||'.' ||p_value_column || ' AS "CODE"'
1058: || g_newline || ' ,PON_FORMS_UTIL_PVT.GetFLEXINDENDENTVALUE('''
1059: || p_value_set_name || ''',' || p_value_alias ||'.'
1060: || p_value_column || ') AS "DESCRIPTION"'
1061: || ')) AS ' || p_field_code;
1062: ============================================================================== */

Line 1081: || g_newline || ',PON_FORMS_UTIL_PVT.GetFLEXTBLVALUE('''|| p_field_code || ''','

1077:
1078: else
1079:
1080: p_query_stmt := p_query_stmt || g_newline || ',' || p_value_alias ||'.' ||p_value_column || ' AS ' || p_field_code
1081: || g_newline || ',PON_FORMS_UTIL_PVT.GetFLEXTBLVALUE('''|| p_field_code || ''','
1082: || g_newline || ' ' || p_value_alias ||'.'|| p_value_column || ') AS ' || p_field_code || '_NM';
1083: /* ==============================================================================
1084: p_query_stmt := p_query_stmt || g_newline || ',xmlelement("FIELDVALUE"'
1085: || ' ,xmlattributes(' || p_value_alias ||'.' ||p_value_column || ' AS "CODE"'

Line 1086: || g_newline || ' ,PON_FORMS_UTIL_PVT.GetFLEXTBLVALUE('''

1082: || g_newline || ' ' || p_value_alias ||'.'|| p_value_column || ') AS ' || p_field_code || '_NM';
1083: /* ==============================================================================
1084: p_query_stmt := p_query_stmt || g_newline || ',xmlelement("FIELDVALUE"'
1085: || ' ,xmlattributes(' || p_value_alias ||'.' ||p_value_column || ' AS "CODE"'
1086: || g_newline || ' ,PON_FORMS_UTIL_PVT.GetFLEXTBLVALUE('''
1087: || p_field_code || ''',' || p_value_alias ||'.' ||p_value_column
1088: || ') AS "DESCRIPTION"'
1089: || ')) AS ' || p_field_code;
1090: ============================================================================== */

Line 1581: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMChar(''' || r1.field_code || '_NAME'',v_1.entity_pk1)'

1577: if r1.system_flag = 'Y' then
1578:
1579: if r1.SYSTEM_FIELD_LOV_FLAG ='Y' then
1580:
1581: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMChar(''' || r1.field_code || '_NAME'',v_1.entity_pk1)'
1582: || ' AS ' || r1.field_code || '_NAME';
1583:
1584: end if;
1585:

Line 1588: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMDate(''' || r1.field_code || ''',v_1.entity_pk1)'

1584: end if;
1585:
1586: if r1.datatype in ('DATE','DATETIME') then
1587:
1588: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMDate(''' || r1.field_code || ''',v_1.entity_pk1)'
1589: || ' AS ' || r1.field_code ;
1590:
1591: elsif r1.datatype in ( 'NUMBER','AMOUNT') then
1592:

Line 1593: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMNumber(''' || r1.field_code || ''',v_1.entity_pk1)'

1589: || ' AS ' || r1.field_code ;
1590:
1591: elsif r1.datatype in ( 'NUMBER','AMOUNT') then
1592:
1593: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMNumber(''' || r1.field_code || ''',v_1.entity_pk1)'
1594: || ' AS ' || r1.field_code ;
1595:
1596: else
1597:

Line 1598: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMChar(''' || r1.field_code || ''',v_1.entity_pk1)'

1594: || ' AS ' || r1.field_code ;
1595:
1596: else
1597:
1598: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMChar(''' || r1.field_code || ''',v_1.entity_pk1)'
1599: || ' AS ' || r1.field_code ;
1600:
1601: end if;
1602:

Line 3241: x_data_entry_region_name := PON_FORMS_UTIL_PVT.getDataEntryRegionName(p_form_id);

3237: end if;
3238:
3239: -- update the JRAD region references
3240: -- if the form/abstract/section is active
3241: x_data_entry_region_name := PON_FORMS_UTIL_PVT.getDataEntryRegionName(p_form_id);
3242: x_read_only_region_name_disp := PON_FORMS_UTIL_PVT.getReadOnlyRegionName(p_form_id);
3243:
3244: UPDATE pon_forms_sections
3245: SET

Line 3242: x_read_only_region_name_disp := PON_FORMS_UTIL_PVT.getReadOnlyRegionName(p_form_id);

3238:
3239: -- update the JRAD region references
3240: -- if the form/abstract/section is active
3241: x_data_entry_region_name := PON_FORMS_UTIL_PVT.getDataEntryRegionName(p_form_id);
3242: x_read_only_region_name_disp := PON_FORMS_UTIL_PVT.getReadOnlyRegionName(p_form_id);
3243:
3244: UPDATE pon_forms_sections
3245: SET
3246: jrad_xml_region_name = x_data_entry_region_name,

Line 3613: END PON_FORMS_UTIL_PVT;

3609: END IF;
3610: END;
3611:
3612:
3613: END PON_FORMS_UTIL_PVT;