DBA Data[Home] [Help]

APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKL_CONTRACT_STATUS_PUB

Line 447: okl_contract_status_pub.update_contract_status (l_api_version,

443: IF (p_call_mode = 'ACTUAL') THEN
444: IF ( (x_return_status = okl_api.g_ret_sts_success)
445: AND (severity = 'S')
446: ) THEN
447: okl_contract_status_pub.update_contract_status (l_api_version,
448: p_init_msg_list,
449: x_return_status,
450: x_msg_count,
451: x_msg_data,

Line 472: okl_contract_status_pub.update_contract_status (l_api_version,

468: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
469: RAISE okl_api.g_exception_error;
470: END IF;
471: ELSE
472: okl_contract_status_pub.update_contract_status (l_api_version,
473: p_init_msg_list,
474: x_return_status,
475: x_msg_count,
476: x_msg_data,

Line 499: okl_contract_status_pub.cascade_lease_status

495: END IF;
496: END IF;
497:
498: --call to cascade status on to lines
499: okl_contract_status_pub.cascade_lease_status
500: (p_api_version => p_api_version,
501: p_init_msg_list => p_init_msg_list,
502: x_return_status => x_return_status,
503: x_msg_count => x_msg_count,

Line 909: okl_contract_status_pub.get_contract_status (l_api_version,

905: );
906: RAISE okl_api.g_exception_error;
907: END IF;
908:
909: okl_contract_status_pub.get_contract_status (l_api_version,
910: p_init_msg_list,
911: x_return_status,
912: x_msg_count,
913: x_msg_data,

Line 1034: := okl_contract_status_pub.g_k_submit4apprvl;

1030: l_isallowed BOOLEAN;
1031: l_passstatus VARCHAR2 (100) := 'APPROVED';
1032: l_failstatus VARCHAR2 (100) := 'PENDING_APPROVAL';
1033: l_event VARCHAR2 (100)
1034: := okl_contract_status_pub.g_k_submit4apprvl;
1035: l_process_id NUMBER;
1036: l_approval_path VARCHAR2 (30) DEFAULT 'NONE';
1037:
1038: CURSOR l_sts_csr (chrid NUMBER) IS

Line 1071: okl_contract_status_pub.get_contract_status (l_api_version,

1067: INTO l_sts_rec;
1068:
1069: CLOSE l_sts_csr;
1070:
1071: okl_contract_status_pub.get_contract_status (l_api_version,
1072: p_init_msg_list,
1073: x_return_status,
1074: x_msg_count,
1075: x_msg_data,

Line 1101: okl_contract_status_pub.update_contract_status (l_api_version,

1097: END IF;
1098:
1099: IF (l_return_status = okl_api.g_ret_sts_success) THEN
1100: --temp fix to set status to approved
1101: okl_contract_status_pub.update_contract_status (l_api_version,
1102: p_init_msg_list,
1103: x_return_status,
1104: x_msg_count,
1105: x_msg_data,

Line 1116: okl_contract_status_pub.update_contract_status (l_api_version,

1112: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1113: RAISE okl_api.g_exception_error;
1114: END IF;
1115: ELSE
1116: okl_contract_status_pub.update_contract_status (l_api_version,
1117: p_init_msg_list,
1118: x_return_status,
1119: x_msg_count,
1120: x_msg_data,

Line 1133: okl_contract_status_pub.cascade_lease_status

1129: END IF;
1130: END IF;
1131:
1132: --call to cascade status on to lines
1133: okl_contract_status_pub.cascade_lease_status
1134: (p_api_version => p_api_version,
1135: p_init_msg_list => p_init_msg_list,
1136: x_return_status => x_return_status,
1137: x_msg_count => x_msg_count,

Line 1229: := okl_contract_status_pub.g_k_submit4apprvl;

1225: l_isallowed BOOLEAN;
1226: l_passstatus VARCHAR2 (100) := 'APPROVED';
1227: l_failstatus VARCHAR2 (100) := 'PENDING_APPROVAL';
1228: l_event VARCHAR2 (100)
1229: := okl_contract_status_pub.g_k_submit4apprvl;
1230: l_process_id NUMBER;
1231: l_approval_path VARCHAR2 (30) DEFAULT 'NONE';
1232:
1233: CURSOR l_sts_csr (chrid NUMBER) IS

Line 1332: okl_contract_status_pub.get_contract_status (l_api_version,

1328: INTO l_sts_rec;
1329:
1330: CLOSE l_sts_csr;
1331:
1332: okl_contract_status_pub.get_contract_status (l_api_version,
1333: p_init_msg_list,
1334: x_return_status,
1335: x_msg_count,
1336: x_msg_data,

Line 1427: okl_contract_status_pub.update_contract_status (l_api_version,

1423: IF NVL (l_approval_path, 'NONE') = 'NONE' THEN
1424: -- Change Status
1425: IF (l_return_status = okl_api.g_ret_sts_success) THEN
1426: --temp fix to set status to approved
1427: okl_contract_status_pub.update_contract_status (l_api_version,
1428: p_init_msg_list,
1429: x_return_status,
1430: x_msg_count,
1431: x_msg_data,

Line 1442: okl_contract_status_pub.update_contract_status (l_api_version,

1438: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1439: RAISE okl_api.g_exception_error;
1440: END IF;
1441: ELSE
1442: okl_contract_status_pub.update_contract_status (l_api_version,
1443: p_init_msg_list,
1444: x_return_status,
1445: x_msg_count,
1446: x_msg_data,

Line 1459: okl_contract_status_pub.cascade_lease_status

1455: END IF;
1456: END IF;
1457:
1458: --call to cascade status on to lines
1459: okl_contract_status_pub.cascade_lease_status
1460: (p_api_version => p_api_version,
1461: p_init_msg_list => p_init_msg_list,
1462: x_return_status => x_return_status,
1463: x_msg_count => x_msg_count,

Line 1863: okl_contract_status_pub.get_contract_status( l_api_version,

1859: --Bug# 2566822 : following code which was part of original
1860: --submit_for_approval has been moved to the new submit_for_approval
1861: --API . So it is being commented
1862: /*---------------------------------------------------------------
1863: okl_contract_status_pub.get_contract_status( l_api_version,
1864: p_init_msg_list,
1865: x_return_status,
1866: x_msg_count,
1867: x_msg_data,

Line 1894: okl_contract_status_pub.update_contract_status(

1890:
1891: -- Change Status
1892: IF(l_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
1893: --temp fix to set status to approved
1894: okl_contract_status_pub.update_contract_status(
1895: l_api_version,
1896: p_init_msg_list,
1897: x_return_status,
1898: x_msg_count,

Line 1908: okl_contract_status_pub.update_contract_status(

1904: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1905: RAISE Okl_Api.G_EXCEPTION_ERROR;
1906: END IF;
1907: ELSE
1908: okl_contract_status_pub.update_contract_status(
1909: l_api_version,
1910: p_init_msg_list,
1911: x_return_status,
1912: x_msg_count,

Line 1924: OKL_CONTRACT_STATUS_PUB.cascade_lease_status

1920: END IF;
1921: END IF;
1922:
1923: --call to cascade status on to lines
1924: OKL_CONTRACT_STATUS_PUB.cascade_lease_status
1925: (p_api_version => p_api_version,
1926: p_init_msg_list => p_init_msg_list,
1927: x_return_status => x_return_status,
1928: x_msg_count => x_msg_count,

Line 3202: := okl_contract_status_pub.g_k_activate;

3198: l_isallowed BOOLEAN;
3199: l_passstatus VARCHAR2 (100) := 'BOOKED';
3200: l_failstatus VARCHAR2 (100) := 'APPROVED';
3201: l_event VARCHAR2 (100)
3202: := okl_contract_status_pub.g_k_activate;
3203: l_cimv_tbl okl_okc_migration_pvt.cimv_tbl_type;
3204: x_message VARCHAR2 (256);
3205:
3206: -- Sales Tax project changes START - BUG 4373029

Line 3568: okl_contract_status_pub.get_contract_status (l_api_version,

3564: /*
3565: -- mvasudev, 11/08/2004
3566: -- END,Added to enable Business Event
3567: */
3568: okl_contract_status_pub.get_contract_status (l_api_version,
3569: p_init_msg_list,
3570: x_return_status,
3571: x_msg_count,
3572: x_msg_data,

Line 4272: okl_contract_status_pub.update_contract_status

4268: END IF; -- Vendor Program Template: End
4269:
4270: -- Change Status
4271: IF (x_return_status = okl_api.g_ret_sts_success) THEN
4272: okl_contract_status_pub.update_contract_status
4273: (l_api_version,
4274: p_init_msg_list,
4275: x_return_status,
4276: x_msg_count,

Line 4283: okl_contract_status_pub.update_contract_status

4279: l_chr_for_sts_change
4280: );
4281: --p_chr_id );
4282: ELSE
4283: okl_contract_status_pub.update_contract_status
4284: (l_api_version,
4285: p_init_msg_list,
4286: x_return_status,
4287: x_msg_count,

Line 4304: okl_contract_status_pub.cascade_lease_status

4300:
4301: -- 4895333
4302: IF (old_rec.deal_type <> 'LOAN-REVOLVING') THEN
4303: --call to cascade status on to lines
4304: okl_contract_status_pub.cascade_lease_status
4305: (p_api_version => p_api_version,
4306: p_init_msg_list => p_init_msg_list,
4307: x_return_status => x_return_status,
4308: x_msg_count => x_msg_count,

Line 4326: okl_contract_status_pub.update_contract_status(

4322: /*
4323:
4324:
4325: If ( old_rec.ORIG_SYSTEM_ID1 IS NOT NULL ) Then
4326: okl_contract_status_pub.update_contract_status(
4327: l_api_version,
4328: p_init_msg_list,
4329: x_return_status,
4330: x_msg_count,

Line 4335: OKL_CONTRACT_STATUS_PUB.cascade_lease_status

4331: x_msg_data,
4332: 'CANCELED',
4333: old_rec.ORIG_SYSTEM_ID1 );
4334:
4335: OKL_CONTRACT_STATUS_PUB.cascade_lease_status
4336: (p_api_version => p_api_version,
4337: p_init_msg_list => p_init_msg_list,
4338: x_return_status => x_return_status,
4339: x_msg_count => x_msg_count,

Line 5070: okl_contract_status_pub.update_contract_status

5066: END IF;
5067: END IF;
5068:
5069: --Update Contract Status to Passed
5070: okl_contract_status_pub.update_contract_status
5071: (p_api_version => p_api_version,
5072: p_init_msg_list => p_init_msg_list,
5073: x_return_status => x_return_status,
5074: x_msg_count => x_msg_count,

Line 5087: okl_contract_status_pub.cascade_lease_status

5083: RAISE okl_api.g_exception_error;
5084: END IF;
5085:
5086: --call to cascade status on to lines
5087: okl_contract_status_pub.cascade_lease_status
5088: (p_api_version => p_api_version,
5089: p_init_msg_list => p_init_msg_list,
5090: x_return_status => x_return_status,
5091: x_msg_count => x_msg_count,