APPS.PON_FORMS_UTIL_PVT dependencies on PON_FORM_FIELD_VALUES

Line 191: l_query_stmt := 'select ' || upper(p_mapping_column) || ' from pon_form_field_values where form_field_value_id = :1' ;

187:
188: print_debug_log(l_api_name, 'BEGIN- p_field_code = '||p_field_code||' p_mapping_column = '||p_mapping_column);
189:
190: l_display_value := to_char(null);
191: l_query_stmt := 'select ' || upper(p_mapping_column) || ' from pon_form_field_values where form_field_value_id = :1' ;
192:
193: EXECUTE IMMEDIATE l_query_stmt INTO l_field_value USING p_form_field_id;
194:
195: --dbms_output.put_line(l_api_name || ' ' || l_field_value);

Line 1404: p_query_stmt := p_query_stmt || ' from pon_form_field_values ' || l_value_alias

1400: end if;
1401: end if;
1402: end loop;
1403:
1404: p_query_stmt := p_query_stmt || ' from pon_form_field_values ' || l_value_alias
1405: || g_newline || ' where ' || l_value_alias || '.PARENT_FIELD_VALUES_FK=' ||p_parent_alias||'.' ||'FORM_FIELD_VALUE_ID'
1406: || g_newline || ' and ' || l_value_alias || '.section_id=' || to_char(p_section_id)
1407: || g_newline || ' and nvl(' || l_value_alias || '.LEVEL1_SECTION_ID,-1)= ' || to_char(nvl(p_LEVEL1_SECTION_ID,-1))
1408: || g_newline || ' and nvl(' || l_value_alias || '.LEVEL2_SECTION_ID,-1)= ' || to_char(nvl(p_LEVEL2_SECTION_ID,-1))

Line 1711: p_query_stmt := p_query_stmt || g_newline || ' from pon_form_field_values ' || l_value_alias;

1707:
1708: print_debug_log(l_api_name, 'Last if : p_query_stmt = '||p_query_stmt);
1709:
1710: -- from and where clause for the form
1711: p_query_stmt := p_query_stmt || g_newline || ' from pon_form_field_values ' || l_value_alias;
1712:
1713: p_query_stmt := p_query_stmt || g_newline || ' where ' || l_value_alias ||'.OWNING_ENTITY_CODE =:ENTITY_CODE'
1714: || g_newline || ' and ' || l_value_alias ||'.ENTITY_PK1 =:ENTITY_PK1'
1715: || g_newline || ' and ' || l_value_alias ||'.form_id =' || to_char(p_form_id)

Line 1960: insert into pon_form_field_values

1956: g_dummy_pk = '||g_dummy_pk||'
1957: g_dummy_char = '||g_dummy_char||'
1958: g_dummy_num = '||g_dummy_num);
1959:
1960: insert into pon_form_field_values
1961: (FORM_FIELD_VALUE_ID,
1962: FORM_ID,
1963: OWNING_ENTITY_CODE,
1964: ENTITY_PK1,

Line 3531: pon_form_field_values table for a given parent row.

3527: /*======================================================================
3528: PROCEDURE: deleteFormFieldValues PUBLIC
3529: PARAMETERS:
3530: COMMENT : This procedure is used to remove all the child rows from
3531: pon_form_field_values table for a given parent row.
3532: This procedure will be invoked from the remove method of the
3533: FormFieldValuesEO entity
3534: ======================================================================*/
3535:

Line 3554: delete from pon_form_field_values

3550: p_entity_code = '||p_entity_code||'
3551: p_section_id = '||p_section_id||'
3552: p_parent_fk = '||p_parent_fk);
3553:
3554: delete from pon_form_field_values
3555: where form_id = p_form_id
3556: and entity_pk1 = p_entity_pk1
3557: and owning_entity_code = p_entity_code
3558: and parent_field_values_fk = p_parent_fk

Line 3615: pon_form_field_values table for a given form.

3611: /*======================================================================
3612: PROCEDURE: deleteValues PUBLIC
3613: PARAMETERS:
3614: COMMENT : This procedure is used to remove all the rows from
3615: pon_form_field_values table for a given form.
3616: This procedure should be invoked from the remove method
3617: FormInstancesEO entity
3618: ======================================================================*/
3619:

Line 3638: delete from pon_form_field_values

3634: p_entity_code = '||p_entity_code);
3635:
3636: x_result := fnd_api.g_ret_sts_error;
3637:
3638: delete from pon_form_field_values
3639: where form_id = p_form_id
3640: and entity_pk1 = p_entity_pk1
3641: and owning_entity_code = p_entity_code;
3642: