DBA Data[Home] [Help]

APPS.OKL_EC_UPTAKE_PVT dependencies on OKL_ECC_PUB

Line 379: --Populate the Record Structure for the OKL_ECC_PUB.validate method

375: RAISE okl_api.g_exception_unexpected_error;
376: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
377: RAISE okl_api.g_exception_error;
378: END IF;
379: --Populate the Record Structure for the OKL_ECC_PUB.validate method
380: --l_okl_ec_rec_type.target
381: l_okl_ec_rec_type.src_type:='LRS';
382: l_okl_ec_rec_type.target_id:= p_target_id;
383: l_okl_ec_rec_type.target_type:= p_target_type;

Line 408: OKL_ECC_PUB.evaluate_eligibility_criteria(p_api_version

404: FOR l_okl_lrs_rec IN c_lrs_rec(p_target_eff_from,p_currency_code)LOOP
405: l_okl_ec_rec_type.src_id:=l_okl_lrs_rec.rate_set_version_id;
406: l_okl_ec_rec_type.source_name:=l_okl_lrs_rec.name;
407:
408: OKL_ECC_PUB.evaluate_eligibility_criteria(p_api_version
409: ,p_init_msg_list
410: ,x_return_status
411: ,x_msg_count
412: ,x_msg_data

Line 643: --Populate the Record Structure for the OKL_ECC_PUB.validate method

639: RAISE okl_api.g_exception_unexpected_error;
640: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
641: RAISE okl_api.g_exception_error;
642: END IF;
643: --Populate the Record Structure for the OKL_ECC_PUB.validate method
644: --l_okl_ec_rec_type.target
645: l_okl_ec_rec_type.src_type:='SRT';
646: l_okl_ec_rec_type.target_id:= p_target_id;
647: l_okl_ec_rec_type.target_type:= p_target_type;

Line 672: OKL_ECC_PUB.evaluate_eligibility_criteria(p_api_version

668: FOR l_okl_srt_rec IN c_srt_rec(p_target_eff_from,p_currency_code)
669: LOOP
670: l_okl_ec_rec_type.src_id:=l_okl_srt_rec.std_rate_tmpl_ver_id;
671: l_okl_ec_rec_type.source_name:=l_okl_srt_rec.name;
672: OKL_ECC_PUB.evaluate_eligibility_criteria(p_api_version
673: ,p_init_msg_list
674: ,x_return_status
675: ,x_msg_count
676: ,x_msg_data

Line 874: --Populate the Record Structure for the OKL_ECC_PUB.validate method

870: RAISE okl_api.g_exception_unexpected_error;
871: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
872: RAISE okl_api.g_exception_error;
873: END IF;
874: --Populate the Record Structure for the OKL_ECC_PUB.validate method
875: --l_okl_ec_rec_type.target
876: l_okl_ec_rec_type.src_type := 'LRS';
877: l_okl_ec_rec_type.target_id := p_target_id;
878: l_okl_ec_rec_type.target_type := p_target_type;

Line 895: OKL_ECC_PUB.evaluate_eligibility_criteria(p_api_version

891: i := 1;
892: FOR l_okl_lrs_rec IN c_lrs_rec(l_okl_ec_rec_type.target_eff_from,l_okl_ec_rec_type.currency_code)LOOP
893: l_okl_ec_rec_type.src_id := l_okl_lrs_rec.rate_set_version_id;
894: l_okl_ec_rec_type.source_name := l_okl_lrs_rec.name;
895: OKL_ECC_PUB.evaluate_eligibility_criteria(p_api_version
896: ,p_init_msg_list
897: ,x_return_status
898: ,x_msg_count
899: ,x_msg_data

Line 1115: --Populate the Record Structure for the OKL_ECC_PUB.validate method

1111: RAISE okl_api.g_exception_unexpected_error;
1112: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1113: RAISE okl_api.g_exception_error;
1114: END IF;
1115: --Populate the Record Structure for the OKL_ECC_PUB.validate method
1116: --l_okl_ec_rec_type.target
1117: l_okl_ec_rec_type.src_type:='SRT';
1118: l_okl_ec_rec_type.target_id:= p_target_id;
1119: l_okl_ec_rec_type.target_type:= p_target_type;

Line 1138: OKL_ECC_PUB.evaluate_eligibility_criteria(p_api_version

1134: FOR l_okl_srt_rec IN c_srt_rec(l_okl_ec_rec_type.target_eff_from,l_okl_ec_rec_type.currency_code)
1135: LOOP
1136: l_okl_ec_rec_type.src_id:=l_okl_srt_rec.std_rate_tmpl_ver_id;
1137: l_okl_ec_rec_type.source_name:=l_okl_srt_rec.name;
1138: OKL_ECC_PUB.evaluate_eligibility_criteria(p_api_version
1139: ,p_init_msg_list
1140: ,x_return_status
1141: ,x_msg_count
1142: ,x_msg_data

Line 1362: --Populate the Record Structure for the OKL_ECC_PUB.validate method

1358: RAISE okl_api.g_exception_unexpected_error;
1359: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1360: RAISE okl_api.g_exception_error;
1361: END IF;
1362: --Populate the Record Structure for the OKL_ECC_PUB.validate method
1363: --l_okl_ec_rec_type.target
1364: l_okl_ec_rec_type.src_type:='PRODUCT';
1365: l_okl_ec_rec_type.target_id:= p_target_id;
1366: l_okl_ec_rec_type.target_type:= p_target_type;

Line 1386: OKL_ECC_PUB.evaluate_eligibility_criteria(p_api_version

1382: FOR l_okl_prod_rec IN c_product_rec1(l_okl_ec_rec_type.target_eff_from)
1383: LOOP
1384: l_okl_ec_rec_type.src_id:=l_okl_prod_rec.id;
1385: l_okl_ec_rec_type.source_name:=l_okl_prod_rec.name;
1386: OKL_ECC_PUB.evaluate_eligibility_criteria(p_api_version
1387: ,p_init_msg_list
1388: ,x_return_status
1389: ,x_msg_count
1390: ,x_msg_data

Line 1411: OKL_ECC_PUB.evaluate_eligibility_criteria(p_api_version

1407: FOR l_okl_prod_rec IN c_product_rec2(l_vendor_prog_id)
1408: LOOP
1409: l_okl_ec_rec_type.src_id:=l_okl_prod_rec.id;
1410: l_okl_ec_rec_type.source_name:=l_okl_prod_rec.name;
1411: OKL_ECC_PUB.evaluate_eligibility_criteria(p_api_version
1412: ,p_init_msg_list
1413: ,x_return_status
1414: ,x_msg_count
1415: ,x_msg_data

Line 1562: --Populate the Record Structure for the OKL_ECC_PUB.validate method

1558: RAISE okl_api.g_exception_unexpected_error;
1559: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1560: RAISE okl_api.g_exception_error;
1561: END IF;
1562: --Populate the Record Structure for the OKL_ECC_PUB.validate method
1563: --l_okl_ec_rec_type.target
1564: l_okl_ec_rec_type.src_type:='VENDOR_PROGRAM';
1565: l_okl_ec_rec_type.target_id:= p_target_id;
1566: l_okl_ec_rec_type.target_type:= p_target_type;

Line 1582: OKL_ECC_PUB.evaluate_eligibility_criteria(p_api_version

1578: FOR l_okl_vp_rec IN c_vp_rec(p_target_eff_from)LOOP
1579: l_okl_ec_rec_type.src_id:=l_okl_vp_rec.id;
1580: l_okl_ec_rec_type.source_name:=l_okl_vp_rec.contract_number;
1581:
1582: OKL_ECC_PUB.evaluate_eligibility_criteria(p_api_version
1583: ,p_init_msg_list
1584: ,x_return_status
1585: ,x_msg_count
1586: ,x_msg_data