DBA Data[Home] [Help]

APPS.EDR_PSIG dependencies on EDR_PSIG_DOC_PARAMS_PKG

Line 1627: EDR_PSIG_DOC_PARAMS_PKG.UPDATE_ROW (

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,
1629: X_DOCUMENT_ID => P_DOCUMENT_ID,
1630: X_NAME => P_PARAMETERS(i).PARAM_NAME,
1631: X_VALUE => P_PARAMETERS(i).PARAM_VALUE,

Line 1642: EDR_PSIG_DOC_PARAMS_PKG.INSERT_ROW(

1638: EXCEPTION
1639: WHEN NO_DATA_FOUND then
1640: /* Insert a ROW */
1641: select EDR_PSIG_PARAMS_S.nextval into l_parameter_id from dual;
1642: EDR_PSIG_DOC_PARAMS_PKG.INSERT_ROW(
1643: X_ROWID => L_ROWID,
1644: X_PARAMETER_ID => L_PARAMETER_ID,
1645: X_DOCUMENT_ID => P_DOCUMENT_ID,
1646: X_NAME => P_PARAMETERS(i).PARAM_NAME,