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.34 2011/11/16 07:24:05 nrayi ship $ */
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 618: PON_FORMS_UTIL_PVT.GET_FREIGHT(ah.carrier_code, fsp.inventory_organization_id)

614:
615: elsif p_field_code = 'CARRIER_NAME' then
616:
617: select
618: PON_FORMS_UTIL_PVT.GET_FREIGHT(ah.carrier_code, fsp.inventory_organization_id)
619: into rt_large_value
620: from pon_auction_headers_all ah,
621: financials_system_params_all fsp
622: where ah.auction_header_id = to_number(p_id)

Line 758: SELECT PON_FORMS_UTIL_PVT.decrypt('FedBizOpps', (select preference_value from PON_PARTY_PREFERENCES where app_short_name = 'PON' and preference_name = 'FBO_PASSWORD')) into rt_value

754: select preference_value into rt_value from PON_PARTY_PREFERENCES where app_short_name = 'PON' and preference_name = 'FBO_USER_ID';
755:
756: --Temporately use 'FedBizOpps' as key to match with encryption in NegotiationConfCO.java
757: elsif p_field_code = 'FED_PASSWORD' then
758: SELECT PON_FORMS_UTIL_PVT.decrypt('FedBizOpps', (select preference_value from PON_PARTY_PREFERENCES where app_short_name = 'PON' and preference_name = 'FBO_PASSWORD')) into rt_value
759: FROM DUAL;
760:
761: end if;
762:

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

1106: print_debug_log(l_api_name, 'l_value_set_type = '||l_value_set_type);
1107:
1108: if l_value_set_type in ('I','X') then
1109: p_query_stmt := p_query_stmt || g_newline || ',' || p_value_alias ||'.' ||p_value_column || ' AS ' || p_field_code
1110: || g_newline || ',PON_FORMS_UTIL_PVT.GetFLEXINDENDENTVALUE('''|| p_value_set_name || ''','
1111: || g_newline || ' ' || p_value_alias ||'.'|| p_value_column || ') AS ' || p_field_code || '_NM';
1112: /* ==============================================================================
1113: p_query_stmt := p_query_stmt || g_newline || ',xmlelement("FIELDVALUE"'
1114: || ' ,xmlattributes(' || p_value_alias ||'.' ||p_value_column || ' AS "CODE"'

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

1111: || g_newline || ' ' || p_value_alias ||'.'|| p_value_column || ') AS ' || p_field_code || '_NM';
1112: /* ==============================================================================
1113: p_query_stmt := p_query_stmt || g_newline || ',xmlelement("FIELDVALUE"'
1114: || ' ,xmlattributes(' || p_value_alias ||'.' ||p_value_column || ' AS "CODE"'
1115: || g_newline || ' ,PON_FORMS_UTIL_PVT.GetFLEXINDENDENTVALUE('''
1116: || p_value_set_name || ''',' || p_value_alias ||'.'
1117: || p_value_column || ') AS "DESCRIPTION"'
1118: || ')) AS ' || p_field_code;
1119: ============================================================================== */

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

1134:
1135: else
1136:
1137: p_query_stmt := p_query_stmt || g_newline || ',' || p_value_alias ||'.' ||p_value_column || ' AS ' || p_field_code
1138: || g_newline || ',PON_FORMS_UTIL_PVT.GetFLEXTBLVALUE('''|| p_field_code || ''','
1139: || g_newline || ' ' || p_value_alias ||'.'|| p_value_column || ') AS ' || p_field_code || '_NM';
1140: /* ==============================================================================
1141: p_query_stmt := p_query_stmt || g_newline || ',xmlelement("FIELDVALUE"'
1142: || ' ,xmlattributes(' || p_value_alias ||'.' ||p_value_column || ' AS "CODE"'

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

1139: || g_newline || ' ' || p_value_alias ||'.'|| p_value_column || ') AS ' || p_field_code || '_NM';
1140: /* ==============================================================================
1141: p_query_stmt := p_query_stmt || g_newline || ',xmlelement("FIELDVALUE"'
1142: || ' ,xmlattributes(' || p_value_alias ||'.' ||p_value_column || ' AS "CODE"'
1143: || g_newline || ' ,PON_FORMS_UTIL_PVT.GetFLEXTBLVALUE('''
1144: || p_field_code || ''',' || p_value_alias ||'.' ||p_value_column
1145: || ') AS "DESCRIPTION"'
1146: || ')) AS ' || p_field_code;
1147: ============================================================================== */

Line 1530: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMChar(''' || 'FED_CBAC' || ''',v_1.entity_pk1)'

1526:
1527: print_debug_log(l_api_name, 'p_query_stmt = '|| p_query_stmt);
1528: /*Add for FBO project, hard code the form code here for now because user name pass word is not field of the form, but need to contain these data in XML output*/
1529: if l_form_code in ('FED_PRESOL', 'FED_AMD_COMB_SOL', 'FED_COMB_SOL', 'FED_MOD_PRESOL', 'FED_DOC_UPLOAD') then
1530: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMChar(''' || 'FED_CBAC' || ''',v_1.entity_pk1)'
1531: || ' AS ' || 'FED_CBAC' ;
1532: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMChar(''' || 'FED_PASSWORD' || ''',v_1.entity_pk1)'
1533: || ' AS ' || 'FED_PASSWORD' ;
1534: end if;

Line 1532: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMChar(''' || 'FED_PASSWORD' || ''',v_1.entity_pk1)'

1528: /*Add for FBO project, hard code the form code here for now because user name pass word is not field of the form, but need to contain these data in XML output*/
1529: if l_form_code in ('FED_PRESOL', 'FED_AMD_COMB_SOL', 'FED_COMB_SOL', 'FED_MOD_PRESOL', 'FED_DOC_UPLOAD') then
1530: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMChar(''' || 'FED_CBAC' || ''',v_1.entity_pk1)'
1531: || ' AS ' || 'FED_CBAC' ;
1532: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMChar(''' || 'FED_PASSWORD' || ''',v_1.entity_pk1)'
1533: || ' AS ' || 'FED_PASSWORD' ;
1534: end if;
1535:
1536: for r1 in l_form_entry_cursor loop

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

1642: if r1.system_flag = 'Y' and NVL(r1.EDITABLE, 'N') = 'N' then
1643:
1644: if r1.SYSTEM_FIELD_LOV_FLAG ='Y' then
1645:
1646: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMChar(''' || r1.field_code || '_NAME'',v_1.entity_pk1)'
1647: || ' AS ' || r1.field_code || '_NAME';
1648:
1649: end if;
1650:

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

1649: end if;
1650:
1651: if r1.datatype in ('DATE','DATETIME') then
1652:
1653: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMDate(''' || r1.field_code || ''',v_1.entity_pk1)'
1654: || ' AS ' || r1.field_code ;
1655:
1656: elsif r1.datatype in ( 'NUMBER','AMOUNT') then
1657:

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

1654: || ' AS ' || r1.field_code ;
1655:
1656: elsif r1.datatype in ( 'NUMBER','AMOUNT') then
1657:
1658: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMNumber(''' || r1.field_code || ''',v_1.entity_pk1)'
1659: || ' AS ' || r1.field_code ;
1660:
1661: else
1662: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMChar(''' || r1.field_code || ''',v_1.entity_pk1)'

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

1658: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMNumber(''' || r1.field_code || ''',v_1.entity_pk1)'
1659: || ' AS ' || r1.field_code ;
1660:
1661: else
1662: p_query_stmt := p_query_stmt || g_newline || ',PON_FORMS_UTIL_PVT.GetSYSTEMChar(''' || r1.field_code || ''',v_1.entity_pk1)'
1663: || ' AS ' || r1.field_code ;
1664:
1665: end if;
1666:

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

3313: end if;
3314:
3315: -- update the JRAD region references
3316: -- if the form/abstract/section is active
3317: x_data_entry_region_name := PON_FORMS_UTIL_PVT.getDataEntryRegionName(p_form_id);
3318: x_read_only_region_name_disp := PON_FORMS_UTIL_PVT.getReadOnlyRegionName(p_form_id);
3319:
3320: UPDATE pon_forms_sections
3321: SET

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

3314:
3315: -- update the JRAD region references
3316: -- if the form/abstract/section is active
3317: x_data_entry_region_name := PON_FORMS_UTIL_PVT.getDataEntryRegionName(p_form_id);
3318: x_read_only_region_name_disp := PON_FORMS_UTIL_PVT.getReadOnlyRegionName(p_form_id);
3319:
3320: UPDATE pon_forms_sections
3321: SET
3322: jrad_xml_region_name = x_data_entry_region_name,

Line 4151: l_contact_xml := pon_forms_util_Pvt.get_uda_value(p_attr_group_name => 'addresses',

4147: l_email_address varchar2(4000);
4148:
4149: BEGIN
4150:
4151: l_contact_xml := pon_forms_util_Pvt.get_uda_value(p_attr_group_name => 'addresses',
4152: p_attr_name => 'contactdtlsxml',
4153: p_where => 'c_ext_attr39=''ISSUING_OFFICE''',
4154: p_auction_header_id => p_auction_header_id);
4155:

Line 4518: END PON_FORMS_UTIL_PVT;

4514: x_result := fnd_api.g_ret_sts_error;
4515: END get_posting_date;
4516:
4517:
4518: END PON_FORMS_UTIL_PVT;