APPS.PQP_RIW_WEBADI_UTILS dependencies on BNE_INTEGRATORS_B

Line 2057: FROM BNE_INTEGRATORS_B

2053: ,LAST_UPDATE_DATE
2054: ,CREATE_DOC_LIST_APP_ID
2055: ,CREATE_DOC_LIST_CODE
2056: ,NEW_SESSION_FLAG
2057: FROM BNE_INTEGRATORS_B
2058: WHERE application_id = p_application_id
2059: AND INTEGRATOR_CODE = p_base_intg_code;
2060:
2061: l_intg_row c_intg_row%ROWTYPE;

Line 2064: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;

2060:
2061: l_intg_row c_intg_row%ROWTYPE;
2062: l_rowid VARCHAR2(200);
2063: no_default_layout EXCEPTION;
2064: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;
2065: l_proc_name VARCHAR2(72) := g_package||'Create_RIW_Integrator_Row';
2066:
2067: BEGIN
2068: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 2079: FROM BNE_INTEGRATORS_B

2075:
2076: BEGIN
2077: SELECT INTEGRATOR_CODE
2078: INTO VV_INTEGRATOR_CODE
2079: FROM BNE_INTEGRATORS_B
2080: WHERE APPLICATION_ID = P_APPLICATION_ID
2081: AND INTEGRATOR_CODE = p_new_intg_code;
2082: EXCEPTION
2083: WHEN NO_DATA_FOUND THEN NULL;

Line 2090: INSERT INTO BNE_INTEGRATORS_B

2086: -- If the Integrator does not exist then
2087:
2088: IF ( VV_INTEGRATOR_CODE IS NULL) THEN
2089:
2090: INSERT INTO BNE_INTEGRATORS_B
2091: (APPLICATION_ID
2092: ,INTEGRATOR_CODE
2093: ,OBJECT_VERSION_NUMBER
2094: ,ENABLED_FLAG

Line 2219: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;

2215:
2216: l_content_row c_content_row%ROWTYPE;
2217: l_rowid VARCHAR2(200);
2218: no_default_layout EXCEPTION;
2219: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;
2220: l_content_out VARCHAR2(50);
2221: --$ For Data Pump Correct Errors
2222: l_ce_content_out VARCHAR2(50);
2223:

Line 2524: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;

2520:
2521: l_content_row c_content_row%ROWTYPE;
2522: l_rowid VARCHAR2(200);
2523: no_default_layout EXCEPTION;
2524: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;
2525: l_content_out VARCHAR2(50);
2526: l_first boolean := true;
2527: l_column bne_content_cols_b.col_name%TYPE;
2528: --$ For Data Pump Correct Errors