DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on DBMS_UTILITY

Line 7457: l_tbl_index_cust := dbms_utility.get_hash_value(P_DOCUMENT_SUB_TYPE_TBL(i),1,8192);

7453: */
7454:
7455: FOR i in 1..nvl(P_DOCUMENT_SUB_TYPE_TBL.last,0) LOOP
7456:
7457: l_tbl_index_cust := dbms_utility.get_hash_value(P_DOCUMENT_SUB_TYPE_TBL(i),1,8192);
7458:
7459:
7460: IF P_DOCUMENT_SUB_TYPE_TBL(i) IS NULL THEN
7461: X_CL_NUM_OF_DOC_TBL(i) := NULL;

Line 7494: l_tbl_index_cust := dbms_utility.get_hash_value(L_CL_DOC_SUB_TYPE_TBL(i),1,8192);

7490: IF (g_level_statement >= g_current_runtime_level ) THEN
7491: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.GET_COUNTED_SUM_DOC',
7492: 'Cache Assignment : '||L_CL_DOC_SUB_TYPE_TBL(i));
7493: END IF;
7494: l_tbl_index_cust := dbms_utility.get_hash_value(L_CL_DOC_SUB_TYPE_TBL(i),1,8192);
7495: g_zxclpplr_doc_sub_typ_tbl(l_tbl_index_cust).CL_DOC_SUB_TYPE := L_CL_DOC_SUB_TYPE_TBL(i);
7496: g_zxclpplr_doc_sub_typ_tbl(l_tbl_index_cust).CL_NUM_OF_DOC := L_CL_NUM_OF_DOC_TBL(i);
7497: g_zxclpplr_doc_sub_typ_tbl(l_tbl_index_cust).CL_TOTAL_VAT_TAX := L_CL_TOTAL_VAT_TAX_TBL(i);
7498: g_zxclpplr_doc_sub_typ_tbl(l_tbl_index_cust).CL_TOTAL_OTHER_TAX := L_CL_TOTAL_OTHER_TAX_TBL(i);

Line 7505: l_tbl_index_cust := dbms_utility.get_hash_value(P_DOCUMENT_SUB_TYPE_TBL(i),1,8192);

7501: END IF;
7502: END LOOP;
7503: CLOSE GET_TOT_VAT_PER_DOC_TYPE;
7504:
7505: l_tbl_index_cust := dbms_utility.get_hash_value(P_DOCUMENT_SUB_TYPE_TBL(i),1,8192);
7506:
7507: IF g_zxclpplr_doc_sub_typ_tbl.EXISTS(l_tbl_index_cust) THEN
7508: X_CL_NUM_OF_DOC_TBL(i) := g_zxclpplr_doc_sub_typ_tbl(l_tbl_index_cust).CL_NUM_OF_DOC;
7509: X_CL_TOTAL_VAT_TAX_TBL(i) := g_zxclpplr_doc_sub_typ_tbl(l_tbl_index_cust).CL_TOTAL_VAT_TAX;