DBA Data[Home] [Help]

APPS.OKC_RENEW_PVT dependencies on OKC_CONTRACT_PUB

Line 1414: l_chr_rec okc_contract_pub.chrv_rec_type;

1410: l_ren_id_tbl idTab;
1411:
1412: header_rec cur_header%rowtype;
1413:
1414: l_chr_rec okc_contract_pub.chrv_rec_type;
1415: i_chr_rec okc_contract_pub.chrv_rec_type;
1416:
1417: l_cle_tbl okc_contract_pub.clev_tbl_type;
1418: x_cle_tbl okc_contract_pub.clev_tbl_type;

Line 1415: i_chr_rec okc_contract_pub.chrv_rec_type;

1411:
1412: header_rec cur_header%rowtype;
1413:
1414: l_chr_rec okc_contract_pub.chrv_rec_type;
1415: i_chr_rec okc_contract_pub.chrv_rec_type;
1416:
1417: l_cle_tbl okc_contract_pub.clev_tbl_type;
1418: x_cle_tbl okc_contract_pub.clev_tbl_type;
1419: i number;

Line 1417: l_cle_tbl okc_contract_pub.clev_tbl_type;

1413:
1414: l_chr_rec okc_contract_pub.chrv_rec_type;
1415: i_chr_rec okc_contract_pub.chrv_rec_type;
1416:
1417: l_cle_tbl okc_contract_pub.clev_tbl_type;
1418: x_cle_tbl okc_contract_pub.clev_tbl_type;
1419: i number;
1420:
1421: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1418: x_cle_tbl okc_contract_pub.clev_tbl_type;

1414: l_chr_rec okc_contract_pub.chrv_rec_type;
1415: i_chr_rec okc_contract_pub.chrv_rec_type;
1416:
1417: l_cle_tbl okc_contract_pub.clev_tbl_type;
1418: x_cle_tbl okc_contract_pub.clev_tbl_type;
1419: i number;
1420:
1421: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
1422: l_api_name constant VARCHAR2(30) := 'update_old_contract';

Line 1455: okc_contract_pub.lock_contract_header(

1451:
1452: IF (l_debug = 'Y') THEN
1453: okc_debug.log('5800: Before lock_contract_header');
1454: END IF;
1455: okc_contract_pub.lock_contract_header(
1456: p_api_version => 1,
1457: p_init_msg_list => OKC_API.G_FALSE,
1458: x_return_status => l_return_status,
1459: x_msg_count => x_msg_count,

Line 1475: okc_contract_pub.update_contract_header (

1471:
1472: IF (l_debug = 'Y') THEN
1473: okc_debug.log('6000: Before update_contract_header');
1474: END IF;
1475: okc_contract_pub.update_contract_header (
1476: p_api_version => 1,
1477: p_init_msg_list => OKC_API.G_FALSE,
1478: x_return_status => l_return_status,
1479: x_msg_count => x_msg_count,

Line 1514: okc_contract_pub.lock_contract_line(

1510:
1511: EXIT WHEN i=l_id_tbl.last;
1512: i:=l_id_tbl.next(i);
1513: END LOOP;
1514: okc_contract_pub.lock_contract_line(
1515: p_api_version => 1,
1516: p_init_msg_list => OKC_API.G_FALSE,
1517: x_return_status => l_return_status,
1518: x_msg_count => x_msg_count,

Line 1528: okc_contract_pub.update_contract_line (

1524: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1525: RAISE OKC_API.G_EXCEPTION_ERROR;
1526: END IF;
1527:
1528: okc_contract_pub.update_contract_line (
1529: p_api_version => 1,
1530: p_init_msg_list => OKC_API.G_FALSE,
1531: x_return_status => l_return_status,
1532: x_msg_count => x_msg_count,

Line 1688: l_chr_rec okc_contract_pub.chrv_rec_type;

1684:
1685: header_rec cur_headers%rowtype;
1686: rule_rec cur_rules%rowtype;
1687:
1688: l_chr_rec okc_contract_pub.chrv_rec_type;
1689: i_chr_rec okc_contract_pub.chrv_rec_type;
1690:
1691: l_cle_rec okc_contract_pub.clev_rec_type;
1692: i_cle_rec okc_contract_pub.clev_rec_type;

Line 1689: i_chr_rec okc_contract_pub.chrv_rec_type;

1685: header_rec cur_headers%rowtype;
1686: rule_rec cur_rules%rowtype;
1687:
1688: l_chr_rec okc_contract_pub.chrv_rec_type;
1689: i_chr_rec okc_contract_pub.chrv_rec_type;
1690:
1691: l_cle_rec okc_contract_pub.clev_rec_type;
1692: i_cle_rec okc_contract_pub.clev_rec_type;
1693:

Line 1691: l_cle_rec okc_contract_pub.clev_rec_type;

1687:
1688: l_chr_rec okc_contract_pub.chrv_rec_type;
1689: i_chr_rec okc_contract_pub.chrv_rec_type;
1690:
1691: l_cle_rec okc_contract_pub.clev_rec_type;
1692: i_cle_rec okc_contract_pub.clev_rec_type;
1693:
1694: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
1695: l_api_name constant VARCHAR2(30) := 'update_renewal_dates';

Line 1692: i_cle_rec okc_contract_pub.clev_rec_type;

1688: l_chr_rec okc_contract_pub.chrv_rec_type;
1689: i_chr_rec okc_contract_pub.chrv_rec_type;
1690:
1691: l_cle_rec okc_contract_pub.clev_rec_type;
1692: i_cle_rec okc_contract_pub.clev_rec_type;
1693:
1694: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
1695: l_api_name constant VARCHAR2(30) := 'update_renewal_dates';
1696: l_uom_code okx_units_of_measure_v.uom_code%type;

Line 1705: l_cle_tbl okc_contract_pub.clev_tbl_type;

1701: l_parent_start_date date;
1702: l_parent_level number;
1703: l_DNR_LEVEL number:=0;
1704: l_cle_renew_type OKC_RULES_V.rule_information1%type;
1705: l_cle_tbl okc_contract_pub.clev_tbl_type;
1706: l_cle BINARY_INTEGER:=0;
1707: j BINARY_INTEGER;
1708:
1709: k_dates number :=0;

Line 1849: okc_contract_pub.update_contract_header (

1845: if l_chr_rec.end_date is not null then -- Added for Bugfix 2803674 to avoid Perpetual
1846: l_chr_rec.end_date := TO_DATE(TO_CHAR(l_chr_rec.end_date, 'dd/mm/yyYY') || TO_CHAR(header_rec.end_date, 'hh24:mi:ss'), 'dd/mm/yyYYhh24:mi:ss');
1847: end if;
1848:
1849: okc_contract_pub.update_contract_header (
1850: p_api_version => 1,
1851: p_init_msg_list => OKC_API.G_FALSE,
1852: x_return_status => l_return_status,
1853: x_msg_count => x_msg_count,

Line 2118: okc_contract_pub.update_contract_line (

2114: INTO l_cle_rec.start_date, l_cle_rec.end_date
2115: FROM okc_k_lines_b
2116: WHERE id = (SELECT object_cle_id FROM okc_operation_lines WHERE subject_cle_id = l_cle_rec.id);
2117:
2118: okc_contract_pub.update_contract_line (
2119: p_api_version => 1,
2120: p_init_msg_list => OKC_API.G_FALSE,
2121: x_return_status => l_return_status,
2122: x_msg_count => x_msg_count,

Line 2181: OKC_CONTRACT_PUB.Delete_Contract_Line(

2177:
2178: IF l_cle_tbl.count>0 then
2179: j:=l_cle_tbl.first;
2180: loop
2181: OKC_CONTRACT_PUB.Delete_Contract_Line(
2182: p_api_version => 1,
2183: p_init_msg_list => OKC_API.G_FALSE,
2184: x_return_status => l_return_status,
2185: x_msg_count => x_msg_count,