APPS.EDR_PSIG dependencies on EDR_PSIG_DOC_PARAMS_VL

Line 1624: select parameter_id into l_parameter_id from EDR_PSIG_DOC_PARAMS_VL

1620: /* Process Table and inser rows in Table */
1621: FOR i in 1.. P_PARAMETERS.count LOOP
1622: IF P_PARAMETERS(i).PARAM_NAME IS NOT NULL THEN
1623: BEGIN
1624: select parameter_id into l_parameter_id from EDR_PSIG_DOC_PARAMS_VL
1625: where document_id=P_DOCUMENT_ID and
1626: NAME=P_PARAMETERS(i).PARAM_NAME;
1627: EDR_PSIG_DOC_PARAMS_PKG.UPDATE_ROW (
1628: X_PARAMETER_ID => L_PARAMETER_ID,

Line 1850: from EDR_PSIG_DOC_PARAMS_VL

1846: i number;
1847:
1848: CURSOR DOC_PARAMS
1849: is SELECT NAME,VALUE,DISPLAY_NAME
1850: from EDR_PSIG_DOC_PARAMS_VL
1851: where DOCUMENT_ID=P_DOCUMENT_ID;
1852: CURSOR SIGN_DETAILS
1853: is SELECT SIGNATURE_ID,
1854: DOCUMENT_ID,

Line 2534: from edr_psig_doc_params_vl param1

2530: (select xmlagg(xmlelement("DOC_PARAMS",
2531: xmlforest(param1.name as PARAM_NAME,
2532: param1.value as PARAM_VALUE)
2533: ))
2534: from edr_psig_doc_params_vl param1
2535: where param1.document_id = evid.document_id
2536: ) as DOC_PARAM_DETAILS
2537: )
2538: )