DBA Data[Home] [Help]

APPS.PO_VALIDATIONS dependencies on DUAL

Line 1277: FROM DUAL

1273: END IF;
1274:
1275: SELECT PO_VALIDATION_RESULT_SET_ID_S.NEXTVAL
1276: INTO l_nextval
1277: FROM DUAL
1278: ;
1279:
1280: IF PO_LOG.d_proc THEN
1281: PO_LOG.proc_return(d_mod,l_nextval);

Line 1886: -- Contain additional parameters that may be passed to individual

1882: -- Use one of the c_result_type_XXX variables.
1883: -- For no stopping, use NULL.
1884: --p_parameter_name_tbl
1885: --p_parameter_value_tbl
1886: -- Contain additional parameters that may be passed to individual
1887: -- validation subroutines.
1888: -- The parameter names and associated value should be located
1889: -- at identical indexes in the input tables.
1890: --IN OUT:

Line 7013: SELECT 'N','PO_INVALID_ENC_AMT' INTO x_return_status,x_return_message from dual

7009: IF PO_LOG.d_proc THEN
7010: po_log.proc_begin(d_mod, 'p_po_header_id', p_po_header_id);
7011: END IF;
7012:
7013: SELECT 'N','PO_INVALID_ENC_AMT' INTO x_return_status,x_return_message from dual
7014: WHERE EXISTS
7015: (SELECT po_distribution_id
7016: FROM po_lines_all pl,
7017: po_line_locations_all pll,