APPS.CZ_PB_MGR dependencies on CZ_MODEL_USAGES_TL

Line 7481: FROM cz_model_usages_tl;

7477:
7478: BEGIN
7479: SELECT model_usage_id, LANGUAGE
7480: BULK COLLECT INTO cz_pb_mgr.v_model_usages_tbl, v_usages_lang_tbl
7481: FROM cz_model_usages_tl;
7482: EXCEPTION
7483: WHEN NO_DATA_FOUND
7484: THEN
7485: cz_pb_mgr.v_err_message := 'No model usages translations found';

Line 7489: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_usages_tl', 'SQLERRM', SQLERRM);

7485: cz_pb_mgr.v_err_message := 'No model usages translations found';
7486: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
7487: WHEN OTHERS
7488: THEN
7489: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_usages_tl', 'SQLERRM', SQLERRM);
7490: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
7491: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
7492: RAISE;
7493: END;

Line 7499: || 'DELETE FROM CZ_MODEL_USAGES_TL'

7495: IF (cz_pb_mgr.v_model_usages_tbl.COUNT > 0)
7496: THEN
7497: EXECUTE IMMEDIATE 'BEGIN'
7498: || ' '
7499: || 'DELETE FROM CZ_MODEL_USAGES_TL'
7500: || cz_pb_mgr.v_db_link
7501: || ';'
7502: || ' '
7503: || 'FOR I IN cz_pb_mgr.v_model_usages_tbl.FIRST..cz_pb_mgr.v_model_usages_tbl.LAST'

Line 7509: || 'INSERT INTO cz_model_usages_tl'

7505: || 'LOOP'
7506: || ' '
7507: || 'BEGIN'
7508: || ' '
7509: || 'INSERT INTO cz_model_usages_tl'
7510: || cz_pb_mgr.v_db_link
7511: || ' '
7512: || '(MODEL_USAGE_ID,LANGUAGE,SOURCE_LANG,DESCRIPTION)'
7513: || ' '

Line 7514: || 'SELECT MODEL_USAGE_ID,LANGUAGE,SOURCE_LANG,DESCRIPTION FROM cz_model_usages_tl t'

7510: || cz_pb_mgr.v_db_link
7511: || ' '
7512: || '(MODEL_USAGE_ID,LANGUAGE,SOURCE_LANG,DESCRIPTION)'
7513: || ' '
7514: || 'SELECT MODEL_USAGE_ID,LANGUAGE,SOURCE_LANG,DESCRIPTION FROM cz_model_usages_tl t'
7515: || ' '
7516: || 'WHERE t.model_usage_id = cz_pb_mgr.v_model_usages_tbl(i)'
7517: || ' '
7518: || 'and t.language=cz_pb_mgr.v_usages_lang_tbl(i);'