APPS.PQP_RIW_WEBADI_UTILS dependencies on BNE_INTEGRATORS_B

Line 1774: FROM BNE_INTEGRATORS_B

1770: ,LAST_UPDATE_DATE
1771: ,CREATE_DOC_LIST_APP_ID
1772: ,CREATE_DOC_LIST_CODE
1773: ,NEW_SESSION_FLAG
1774: FROM BNE_INTEGRATORS_B
1775: WHERE application_id = p_application_id
1776: AND INTEGRATOR_CODE = p_base_intg_code;
1777:
1778: l_intg_row c_intg_row%ROWTYPE;

Line 1781: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;

1777:
1778: l_intg_row c_intg_row%ROWTYPE;
1779: l_rowid VARCHAR2(200);
1780: no_default_layout EXCEPTION;
1781: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;
1782: l_proc_name VARCHAR2(72) := g_package||'Create_RIW_Integrator_Row';
1783:
1784: BEGIN
1785: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 1796: FROM BNE_INTEGRATORS_B

1792:
1793: BEGIN
1794: SELECT INTEGRATOR_CODE
1795: INTO VV_INTEGRATOR_CODE
1796: FROM BNE_INTEGRATORS_B
1797: WHERE APPLICATION_ID = P_APPLICATION_ID
1798: AND INTEGRATOR_CODE = p_new_intg_code;
1799: EXCEPTION
1800: WHEN NO_DATA_FOUND THEN NULL;

Line 1807: INSERT INTO BNE_INTEGRATORS_B

1803: -- If the Integrator does not exist then
1804:
1805: IF ( VV_INTEGRATOR_CODE IS NULL) THEN
1806:
1807: INSERT INTO BNE_INTEGRATORS_B
1808: (APPLICATION_ID
1809: ,INTEGRATOR_CODE
1810: ,OBJECT_VERSION_NUMBER
1811: ,ENABLED_FLAG

Line 1936: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;

1932:
1933: l_content_row c_content_row%ROWTYPE;
1934: l_rowid VARCHAR2(200);
1935: no_default_layout EXCEPTION;
1936: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;
1937: l_content_out VARCHAR2(50);
1938: --$ For Data Pump Correct Errors
1939: l_ce_content_out VARCHAR2(50);
1940:

Line 2238: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;

2234:
2235: l_content_row c_content_row%ROWTYPE;
2236: l_rowid VARCHAR2(200);
2237: no_default_layout EXCEPTION;
2238: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;
2239: l_content_out VARCHAR2(50);
2240: l_first boolean := true;
2241: l_column bne_content_cols_b.col_name%TYPE;
2242: --$ For Data Pump Correct Errors