DBA Data[Home] [Help]

APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKL_CONTRACT_STATUS_PUB

Line 541: okl_contract_status_pub.update_contract_status (l_api_version,

537: IF (p_call_mode = 'ACTUAL') THEN
538: IF ( (x_return_status = okl_api.g_ret_sts_success)
539: AND (severity = 'S')
540: ) THEN
541: okl_contract_status_pub.update_contract_status (l_api_version,
542: p_init_msg_list,
543: x_return_status,
544: x_msg_count,
545: x_msg_data,

Line 566: okl_contract_status_pub.update_contract_status (l_api_version,

562: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
563: RAISE okl_api.g_exception_error;
564: END IF;
565: ELSE
566: okl_contract_status_pub.update_contract_status (l_api_version,
567: p_init_msg_list,
568: x_return_status,
569: x_msg_count,
570: x_msg_data,

Line 593: okl_contract_status_pub.cascade_lease_status

589: END IF;
590: END IF;
591:
592: --call to cascade status on to lines
593: okl_contract_status_pub.cascade_lease_status
594: (p_api_version => p_api_version,
595: p_init_msg_list => p_init_msg_list,
596: x_return_status => x_return_status,
597: x_msg_count => x_msg_count,

Line 1208: okl_contract_status_pub.get_contract_status (l_api_version,

1204: RAISE OKL_API.G_EXCEPTION_ERROR;
1205: END IF;
1206: END IF;
1207:
1208: okl_contract_status_pub.get_contract_status (l_api_version,
1209: p_init_msg_list,
1210: x_return_status,
1211: x_msg_count,
1212: x_msg_data,

Line 1334: := okl_contract_status_pub.g_k_submit4apprvl;

1330: l_isallowed BOOLEAN;
1331: l_passstatus VARCHAR2 (100) := 'APPROVED';
1332: l_failstatus VARCHAR2 (100) := 'PENDING_APPROVAL';
1333: l_event VARCHAR2 (100)
1334: := okl_contract_status_pub.g_k_submit4apprvl;
1335: l_process_id NUMBER;
1336: l_approval_path VARCHAR2 (30) DEFAULT 'NONE';
1337:
1338: CURSOR l_sts_csr (chrid NUMBER) IS

Line 1371: okl_contract_status_pub.get_contract_status (l_api_version,

1367: INTO l_sts_rec;
1368:
1369: CLOSE l_sts_csr;
1370:
1371: okl_contract_status_pub.get_contract_status (l_api_version,
1372: p_init_msg_list,
1373: x_return_status,
1374: x_msg_count,
1375: x_msg_data,

Line 1401: okl_contract_status_pub.update_contract_status (l_api_version,

1397: END IF;
1398:
1399: IF (l_return_status = okl_api.g_ret_sts_success) THEN
1400: --temp fix to set status to approved
1401: okl_contract_status_pub.update_contract_status (l_api_version,
1402: p_init_msg_list,
1403: x_return_status,
1404: x_msg_count,
1405: x_msg_data,

Line 1416: okl_contract_status_pub.update_contract_status (l_api_version,

1412: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1413: RAISE okl_api.g_exception_error;
1414: END IF;
1415: ELSE
1416: okl_contract_status_pub.update_contract_status (l_api_version,
1417: p_init_msg_list,
1418: x_return_status,
1419: x_msg_count,
1420: x_msg_data,

Line 1433: okl_contract_status_pub.cascade_lease_status

1429: END IF;
1430: END IF;
1431:
1432: --call to cascade status on to lines
1433: okl_contract_status_pub.cascade_lease_status
1434: (p_api_version => p_api_version,
1435: p_init_msg_list => p_init_msg_list,
1436: x_return_status => x_return_status,
1437: x_msg_count => x_msg_count,

Line 1531: := okl_contract_status_pub.g_k_submit4apprvl;

1527: l_isallowed BOOLEAN;
1528: l_passstatus VARCHAR2 (100) := 'APPROVED';
1529: l_failstatus VARCHAR2 (100) := 'PENDING_APPROVAL';
1530: l_event VARCHAR2 (100)
1531: := okl_contract_status_pub.g_k_submit4apprvl;
1532: l_process_id NUMBER;
1533: l_approval_path VARCHAR2 (30) DEFAULT 'NONE';
1534:
1535: CURSOR l_sts_csr (chrid NUMBER) IS

Line 1634: okl_contract_status_pub.get_contract_status (l_api_version,

1630: INTO l_sts_rec;
1631:
1632: CLOSE l_sts_csr;
1633:
1634: okl_contract_status_pub.get_contract_status (l_api_version,
1635: p_init_msg_list,
1636: x_return_status,
1637: x_msg_count,
1638: x_msg_data,

Line 1729: okl_contract_status_pub.update_contract_status (l_api_version,

1725: IF NVL (l_approval_path, 'NONE') = 'NONE' THEN
1726: -- Change Status
1727: IF (l_return_status = okl_api.g_ret_sts_success) THEN
1728: --temp fix to set status to approved
1729: okl_contract_status_pub.update_contract_status (l_api_version,
1730: p_init_msg_list,
1731: x_return_status,
1732: x_msg_count,
1733: x_msg_data,

Line 1744: okl_contract_status_pub.update_contract_status (l_api_version,

1740: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1741: RAISE okl_api.g_exception_error;
1742: END IF;
1743: ELSE
1744: okl_contract_status_pub.update_contract_status (l_api_version,
1745: p_init_msg_list,
1746: x_return_status,
1747: x_msg_count,
1748: x_msg_data,

Line 1761: okl_contract_status_pub.cascade_lease_status

1757: END IF;
1758: END IF;
1759:
1760: --call to cascade status on to lines
1761: okl_contract_status_pub.cascade_lease_status
1762: (p_api_version => p_api_version,
1763: p_init_msg_list => p_init_msg_list,
1764: x_return_status => x_return_status,
1765: x_msg_count => x_msg_count,

Line 2166: okl_contract_status_pub.get_contract_status( l_api_version,

2162: --Bug# 2566822 : following code which was part of original
2163: --submit_for_approval has been moved to the new submit_for_approval
2164: --API . So it is being commented
2165: /*---------------------------------------------------------------
2166: okl_contract_status_pub.get_contract_status( l_api_version,
2167: p_init_msg_list,
2168: x_return_status,
2169: x_msg_count,
2170: x_msg_data,

Line 2197: okl_contract_status_pub.update_contract_status(

2193:
2194: -- Change Status
2195: IF(l_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
2196: --temp fix to set status to approved
2197: okl_contract_status_pub.update_contract_status(
2198: l_api_version,
2199: p_init_msg_list,
2200: x_return_status,
2201: x_msg_count,

Line 2211: okl_contract_status_pub.update_contract_status(

2207: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2208: RAISE Okl_Api.G_EXCEPTION_ERROR;
2209: END IF;
2210: ELSE
2211: okl_contract_status_pub.update_contract_status(
2212: l_api_version,
2213: p_init_msg_list,
2214: x_return_status,
2215: x_msg_count,

Line 2227: OKL_CONTRACT_STATUS_PUB.cascade_lease_status

2223: END IF;
2224: END IF;
2225:
2226: --call to cascade status on to lines
2227: OKL_CONTRACT_STATUS_PUB.cascade_lease_status
2228: (p_api_version => p_api_version,
2229: p_init_msg_list => p_init_msg_list,
2230: x_return_status => x_return_status,
2231: x_msg_count => x_msg_count,

Line 3505: := okl_contract_status_pub.g_k_activate;

3501: l_isallowed BOOLEAN;
3502: l_passstatus VARCHAR2 (100) := 'BOOKED';
3503: l_failstatus VARCHAR2 (100) := 'APPROVED';
3504: l_event VARCHAR2 (100)
3505: := okl_contract_status_pub.g_k_activate;
3506: l_cimv_tbl okl_okc_migration_pvt.cimv_tbl_type;
3507: x_message VARCHAR2 (256);
3508:
3509: -- Sales Tax project changes START - BUG 4373029

Line 3882: okl_contract_status_pub.get_contract_status (l_api_version,

3878: /*
3879: -- mvasudev, 11/08/2004
3880: -- END,Added to enable Business Event
3881: */
3882: okl_contract_status_pub.get_contract_status (l_api_version,
3883: p_init_msg_list,
3884: x_return_status,
3885: x_msg_count,
3886: x_msg_data,

Line 4740: okl_contract_status_pub.update_contract_status

4736: END IF; -- Vendor Program Template: End
4737:
4738: -- Change Status
4739: IF (x_return_status = okl_api.g_ret_sts_success) THEN
4740: okl_contract_status_pub.update_contract_status
4741: (l_api_version,
4742: p_init_msg_list,
4743: x_return_status,
4744: x_msg_count,

Line 4751: okl_contract_status_pub.update_contract_status

4747: l_chr_for_sts_change
4748: );
4749: --p_chr_id );
4750: ELSE
4751: okl_contract_status_pub.update_contract_status
4752: (l_api_version,
4753: p_init_msg_list,
4754: x_return_status,
4755: x_msg_count,

Line 4772: okl_contract_status_pub.cascade_lease_status

4768:
4769: -- 4895333
4770: IF (old_rec.deal_type <> 'LOAN-REVOLVING') THEN
4771: --call to cascade status on to lines
4772: okl_contract_status_pub.cascade_lease_status
4773: (p_api_version => p_api_version,
4774: p_init_msg_list => p_init_msg_list,
4775: x_return_status => x_return_status,
4776: x_msg_count => x_msg_count,

Line 4794: okl_contract_status_pub.update_contract_status(

4790: /*
4791:
4792:
4793: If ( old_rec.ORIG_SYSTEM_ID1 IS NOT NULL ) Then
4794: okl_contract_status_pub.update_contract_status(
4795: l_api_version,
4796: p_init_msg_list,
4797: x_return_status,
4798: x_msg_count,

Line 4803: OKL_CONTRACT_STATUS_PUB.cascade_lease_status

4799: x_msg_data,
4800: 'CANCELED',
4801: old_rec.ORIG_SYSTEM_ID1 );
4802:
4803: OKL_CONTRACT_STATUS_PUB.cascade_lease_status
4804: (p_api_version => p_api_version,
4805: p_init_msg_list => p_init_msg_list,
4806: x_return_status => x_return_status,
4807: x_msg_count => x_msg_count,

Line 5594: okl_contract_status_pub.update_contract_status

5590: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_contract_book_PVT.calculate_upfront_tax. ','13.1 ....'||x_return_status);
5591: END IF;
5592:
5593: --Update Contract Status to Passed
5594: okl_contract_status_pub.update_contract_status
5595: (p_api_version => p_api_version,
5596: p_init_msg_list => p_init_msg_list,
5597: x_return_status => x_return_status,
5598: x_msg_count => x_msg_count,

Line 5614: okl_contract_status_pub.cascade_lease_status

5610: RAISE okl_api.g_exception_error;
5611: END IF;
5612:
5613: --call to cascade status on to lines
5614: okl_contract_status_pub.cascade_lease_status
5615: (p_api_version => p_api_version,
5616: p_init_msg_list => p_init_msg_list,
5617: x_return_status => x_return_status,
5618: x_msg_count => x_msg_count,