DBA Data[Home] [Help]

APPS.OKL_ACC_CALL_PVT dependencies on OKL_ACCOUNT_DIST_PUB

Line 52: x_acc_gen_tbl OUT NOCOPY Okl_Account_Dist_Pub.acc_gen_primary_key,

48:
49: PROCEDURE Okl_Populate_Acc_Gen (
50: p_contract_id IN NUMBER,
51: p_contract_line_id IN NUMBER,
52: x_acc_gen_tbl OUT NOCOPY Okl_Account_Dist_Pub.acc_gen_primary_key,
53: x_return_status OUT NOCOPY VARCHAR2) IS
54:
55: l_acc_gen_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
56: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 55: l_acc_gen_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

51: p_contract_line_id IN NUMBER,
52: x_acc_gen_tbl OUT NOCOPY Okl_Account_Dist_Pub.acc_gen_primary_key,
53: x_return_status OUT NOCOPY VARCHAR2) IS
54:
55: l_acc_gen_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
56: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
57: l_ind NUMBER := 0;
58: l_value VARCHAR2(100) := NULL;
59:

Line 302: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;

298: ) IS
299:
300: -- Local instance of AE rec/tbl Types
301:
302: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
303: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
304: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
305: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
306: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;

Line 303: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;

299:
300: -- Local instance of AE rec/tbl Types
301:
302: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
303: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
304: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
305: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
306: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
307: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;

Line 304: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;

300: -- Local instance of AE rec/tbl Types
301:
302: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
303: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
304: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
305: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
306: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
307: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
308:

Line 305: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

301:
302: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
303: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
304: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
305: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
306: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
307: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
308:
309:

Line 306: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;

302: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
303: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
304: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
305: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
306: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
307: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
308:
309:
310: p_taiv_rec taiv_rec_type;

Line 307: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;

303: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
304: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
305: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
306: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
307: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
308:
309:
310: p_taiv_rec taiv_rec_type;
311: x_taiv_rec taiv_rec_type;

Line 948: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST

944: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
945: RAISE OKL_API.G_EXCEPTION_ERROR;
946: END IF;
947:
948: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
949: IF(L_DEBUG_ENABLED='Y') THEN
950: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
951: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
952: END IF;

Line 955: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRACCB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');

951: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
952: END IF;
953: IF(IS_DEBUG_PROCEDURE_ON) THEN
954: BEGIN
955: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRACCB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
956: END;
957: END IF;
958: Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST(
959: p_api_version => p_api_version

Line 958: Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST(

954: BEGIN
955: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRACCB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
956: END;
957: END IF;
958: Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST(
959: p_api_version => p_api_version
960: ,p_init_msg_list => p_init_msg_list
961: ,x_return_status => x_return_status
962: ,x_msg_count => x_msg_count

Line 979: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRACCB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');

975: END IF;
976:
977: IF(IS_DEBUG_PROCEDURE_ON) THEN
978: BEGIN
979: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRACCB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
980: END;
981: END IF;
982: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
983:

Line 982: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST

978: BEGIN
979: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRACCB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
980: END;
981: END IF;
982: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
983:
984: --Start code changes for rev rec by fmiao on 10/05/2004
985: --rseela..bug# 5046450..added AND clause to check for 4 dists only for Billing txns and not CMs
986: IF (l_rev_rec_basis = 'CASH_RECEIPT' AND l_acct_call_rec.line_amount > 0) THEN

Line 1715: ,x_tmpl_identify_rec OUT NOCOPY Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE

1711: ,x_return_status OUT NOCOPY VARCHAR2
1712: ,x_msg_count OUT NOCOPY NUMBER
1713: ,x_msg_data OUT NOCOPY VARCHAR2
1714: ,p_bpd_acc_rec IN bpd_acc_rec_type
1715: ,x_tmpl_identify_rec OUT NOCOPY Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE
1716: ,x_dist_info_rec OUT NOCOPY Okl_Account_Dist_Pub.DIST_INFO_REC_TYPE
1717: ,x_ctxt_val_tbl OUT NOCOPY Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE
1718: ,x_acc_gen_primary_key_tbl OUT NOCOPY Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY
1719: ) IS

Line 1716: ,x_dist_info_rec OUT NOCOPY Okl_Account_Dist_Pub.DIST_INFO_REC_TYPE

1712: ,x_msg_count OUT NOCOPY NUMBER
1713: ,x_msg_data OUT NOCOPY VARCHAR2
1714: ,p_bpd_acc_rec IN bpd_acc_rec_type
1715: ,x_tmpl_identify_rec OUT NOCOPY Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE
1716: ,x_dist_info_rec OUT NOCOPY Okl_Account_Dist_Pub.DIST_INFO_REC_TYPE
1717: ,x_ctxt_val_tbl OUT NOCOPY Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE
1718: ,x_acc_gen_primary_key_tbl OUT NOCOPY Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY
1719: ) IS
1720:

Line 1717: ,x_ctxt_val_tbl OUT NOCOPY Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE

1713: ,x_msg_data OUT NOCOPY VARCHAR2
1714: ,p_bpd_acc_rec IN bpd_acc_rec_type
1715: ,x_tmpl_identify_rec OUT NOCOPY Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE
1716: ,x_dist_info_rec OUT NOCOPY Okl_Account_Dist_Pub.DIST_INFO_REC_TYPE
1717: ,x_ctxt_val_tbl OUT NOCOPY Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE
1718: ,x_acc_gen_primary_key_tbl OUT NOCOPY Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY
1719: ) IS
1720:
1721: -- Local instance of AE rec/tbl Types

Line 1718: ,x_acc_gen_primary_key_tbl OUT NOCOPY Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY

1714: ,p_bpd_acc_rec IN bpd_acc_rec_type
1715: ,x_tmpl_identify_rec OUT NOCOPY Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE
1716: ,x_dist_info_rec OUT NOCOPY Okl_Account_Dist_Pub.DIST_INFO_REC_TYPE
1717: ,x_ctxt_val_tbl OUT NOCOPY Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE
1718: ,x_acc_gen_primary_key_tbl OUT NOCOPY Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY
1719: ) IS
1720:
1721: -- Local instance of AE rec/tbl Types
1722:

Line 1723: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;

1719: ) IS
1720:
1721: -- Local instance of AE rec/tbl Types
1722:
1723: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
1724: l_dist_info_rec Okl_Account_Dist_Pub.DIST_INFO_REC_TYPE;
1725: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
1726: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY;
1727:

Line 1724: l_dist_info_rec Okl_Account_Dist_Pub.DIST_INFO_REC_TYPE;

1720:
1721: -- Local instance of AE rec/tbl Types
1722:
1723: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
1724: l_dist_info_rec Okl_Account_Dist_Pub.DIST_INFO_REC_TYPE;
1725: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
1726: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY;
1727:
1728: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;

Line 1725: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;

1721: -- Local instance of AE rec/tbl Types
1722:
1723: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
1724: l_dist_info_rec Okl_Account_Dist_Pub.DIST_INFO_REC_TYPE;
1725: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
1726: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY;
1727:
1728: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
1729: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;

Line 1726: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY;

1722:
1723: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
1724: l_dist_info_rec Okl_Account_Dist_Pub.DIST_INFO_REC_TYPE;
1725: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
1726: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY;
1727:
1728: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
1729: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
1730:

Line 1728: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;

1724: l_dist_info_rec Okl_Account_Dist_Pub.DIST_INFO_REC_TYPE;
1725: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
1726: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY;
1727:
1728: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
1729: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
1730:
1731: p_taiv_rec taiv_rec_type;
1732: x_taiv_rec taiv_rec_type;

Line 1729: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;

1725: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
1726: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY;
1727:
1728: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
1729: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
1730:
1731: p_taiv_rec taiv_rec_type;
1732: x_taiv_rec taiv_rec_type;
1733:

Line 2371: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST

2367: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2368: RAISE OKL_API.G_EXCEPTION_ERROR;
2369: END IF;
2370:
2371: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
2372: IF(L_DEBUG_ENABLED='Y') THEN
2373: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2374: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2375: END IF;

Line 2378: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRACCB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');

2374: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2375: END IF;
2376: IF(IS_DEBUG_PROCEDURE_ON) THEN
2377: BEGIN
2378: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRACCB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
2379: END;
2380: END IF;
2381:
2382:

Line 2389: Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST(

2385: x_ctxt_val_tbl := l_ctxt_val_tbl;
2386: x_acc_gen_primary_key_tbl := l_acc_gen_primary_key_tbl;
2387:
2388: /* -- Commented by Vpanwar -- for calling this API with new signature from one single time After the call of create_acc_trans_new in loop.
2389: Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST(
2390: p_api_version => p_api_version
2391: ,p_init_msg_list => p_init_msg_list
2392: ,x_return_status => x_return_status
2393: ,x_msg_count => x_msg_count

Line 2410: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRACCB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');

2406: END IF;
2407: */
2408: IF(IS_DEBUG_PROCEDURE_ON) THEN
2409: BEGIN
2410: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRACCB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
2411: END;
2412: END IF;
2413: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
2414:

Line 2413: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST

2409: BEGIN
2410: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRACCB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
2411: END;
2412: END IF;
2413: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
2414:
2415: --Start code changes for rev rec by fmiao on 10/05/2004
2416: --rseela..bug# 5046450..added AND clause to check for 4 dists only for Billing txns and not CMs
2417: /* -- Bug 6441837