APPS.CZ_PB_MGR dependencies on CZ_MODEL_USAGES_TL

Line 6760: FROM cz_model_usages_tl;

6756:
6757: BEGIN
6758: SELECT model_usage_id, LANGUAGE
6759: BULK COLLECT INTO cz_pb_mgr.v_model_usages_tbl, v_usages_lang_tbl
6760: FROM cz_model_usages_tl;
6761: EXCEPTION
6762: WHEN NO_DATA_FOUND
6763: THEN
6764: cz_pb_mgr.v_err_message := 'No model usages translations found';

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

6764: cz_pb_mgr.v_err_message := 'No model usages translations found';
6765: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
6766: WHEN OTHERS
6767: THEN
6768: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_usages_tl', 'SQLERRM', SQLERRM);
6769: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
6770: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
6771: RAISE;
6772: END;

Line 6778: || 'DELETE FROM CZ_MODEL_USAGES_TL'

6774: IF (cz_pb_mgr.v_model_usages_tbl.COUNT > 0)
6775: THEN
6776: EXECUTE IMMEDIATE 'BEGIN'
6777: || ' '
6778: || 'DELETE FROM CZ_MODEL_USAGES_TL'
6779: || cz_pb_mgr.v_db_link
6780: || ';'
6781: || ' '
6782: || 'FOR I IN cz_pb_mgr.v_model_usages_tbl.FIRST..cz_pb_mgr.v_model_usages_tbl.LAST'

Line 6788: || 'INSERT INTO cz_model_usages_tl'

6784: || 'LOOP'
6785: || ' '
6786: || 'BEGIN'
6787: || ' '
6788: || 'INSERT INTO cz_model_usages_tl'
6789: || cz_pb_mgr.v_db_link
6790: || ' '
6791: || '(MODEL_USAGE_ID,LANGUAGE,SOURCE_LANG,DESCRIPTION)'
6792: || ' '

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

6789: || cz_pb_mgr.v_db_link
6790: || ' '
6791: || '(MODEL_USAGE_ID,LANGUAGE,SOURCE_LANG,DESCRIPTION)'
6792: || ' '
6793: || 'SELECT MODEL_USAGE_ID,LANGUAGE,SOURCE_LANG,DESCRIPTION FROM cz_model_usages_tl t'
6794: || ' '
6795: || 'WHERE t.model_usage_id = cz_pb_mgr.v_model_usages_tbl(i)'
6796: || ' '
6797: || 'and t.language=cz_pb_mgr.v_usages_lang_tbl(i);'