eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CONTRACT_INFO dependencies on OKL_API

Line 13: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

9: x_customer OUT NOCOPY VARCHAR2)
10: RETURN VARCHAR2
11: IS
12: l_api_version NUMBER := 1.0;
13: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
14: l_init_msg_list VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
15: l_msg_count NUMBER;
16: l_msg_data VARCHAR2(2000);
17: l_party_tab OKL_JTOT_EXTRACT.party_tab_type;

Line 14: l_init_msg_list VARCHAR2(1) DEFAULT OKL_API.G_FALSE;

10: RETURN VARCHAR2
11: IS
12: l_api_version NUMBER := 1.0;
13: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
14: l_init_msg_list VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
15: l_msg_count NUMBER;
16: l_msg_data VARCHAR2(2000);
17: l_party_tab OKL_JTOT_EXTRACT.party_tab_type;
18: BEGIN

Line 34: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

30: 'S',
31: l_party_tab
32: );
33:
34: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
35: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
36: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
37: RAISE okl_api.G_EXCEPTION_ERROR;
38: END IF;

Line 35: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

31: l_party_tab
32: );
33:
34: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
35: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
36: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
37: RAISE okl_api.G_EXCEPTION_ERROR;
38: END IF;
39:

Line 36: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

32: );
33:
34: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
35: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
36: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
37: RAISE okl_api.G_EXCEPTION_ERROR;
38: END IF;
39:
40: IF l_party_tab.FIRST IS NOT NULL

Line 37: RAISE okl_api.G_EXCEPTION_ERROR;

33:
34: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
35: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
36: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
37: RAISE okl_api.G_EXCEPTION_ERROR;
38: END IF;
39:
40: IF l_party_tab.FIRST IS NOT NULL
41: THEN --fetch from table only if some data is retrieved

Line 52: WHEN okl_api.G_EXCEPTION_ERROR THEN

48: END IF;
49:
50: RETURN l_return_status;
51: EXCEPTION
52: WHEN okl_api.G_EXCEPTION_ERROR THEN
53: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
54: ,p_msg_name => G_ERROR
55: ,p_token1 => G_SQLCODE_TOKEN
56: ,p_token1_value => SQLCODE

Line 62: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN

58: ,p_token2_value => SQLERRM);
59: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
60: RETURN(l_return_status);
61:
62: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN
63: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
64: ,p_msg_name => G_UNEXPECTED_ERROR
65: ,p_token1 => G_SQLCODE_TOKEN
66: ,p_token1_value => SQLCODE

Line 102: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

98: WHERE id = p_contract_id);
99:
100: l_vendor_program VARCHAR2(240);
101: l_api_version NUMBER;
102: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
103: l_msg_count NUMBER;
104: l_msg_data VARCHAR2(2000);
105:
106: BEGIN

Line 145: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

141: WHERE id =p_contract_id;
142:
143: l_bill_to_address_id VARCHAR2(240);
144: l_api_version NUMBER;
145: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
146: l_msg_count NUMBER;
147: l_msg_data VARCHAR2(2000);
148:
149: BEGIN

Line 180: l_init_msg_list VARCHAR2(1) DEFAULT OKL_API.G_FALSE;

176: x_private_label OUT NOCOPY VARCHAR2)
177: RETURN VARCHAR2
178: IS
179: l_api_version NUMBER := 1.0;
180: l_init_msg_list VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
181: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
182: l_msg_count NUMBER;
183: l_msg_data VARCHAR2(2000);
184: l_party_tab OKL_JTOT_EXTRACT.party_tab_type;

Line 181: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

177: RETURN VARCHAR2
178: IS
179: l_api_version NUMBER := 1.0;
180: l_init_msg_list VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
181: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
182: l_msg_count NUMBER;
183: l_msg_data VARCHAR2(2000);
184: l_party_tab OKL_JTOT_EXTRACT.party_tab_type;
185: BEGIN

Line 202: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

198: 'S',
199: l_party_tab
200: );
201:
202: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
203: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
204: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
205: RAISE okl_api.G_EXCEPTION_ERROR;
206: END IF;

Line 203: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

199: l_party_tab
200: );
201:
202: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
203: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
204: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
205: RAISE okl_api.G_EXCEPTION_ERROR;
206: END IF;
207:

Line 204: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

200: );
201:
202: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
203: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
204: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
205: RAISE okl_api.G_EXCEPTION_ERROR;
206: END IF;
207:
208: IF l_party_tab.FIRST IS NOT NULL

Line 205: RAISE okl_api.G_EXCEPTION_ERROR;

201:
202: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
203: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
204: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
205: RAISE okl_api.G_EXCEPTION_ERROR;
206: END IF;
207:
208: IF l_party_tab.FIRST IS NOT NULL
209: THEN --fetch from table only if some data is retrieved

Line 220: WHEN okl_api.G_EXCEPTION_ERROR THEN

216: END IF;
217:
218: RETURN l_return_status;
219: EXCEPTION
220: WHEN okl_api.G_EXCEPTION_ERROR THEN
221: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
222: ,p_msg_name => G_ERROR
223: ,p_token1 => G_SQLCODE_TOKEN
224: ,p_token1_value => SQLCODE

Line 230: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN

226: ,p_token2_value => SQLERRM);
227: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
228: RETURN(l_return_status);
229:
230: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN
231: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
232: ,p_msg_name => G_UNEXPECTED_ERROR
233: ,p_token1 => G_SQLCODE_TOKEN
234: ,p_token1_value => SQLCODE

Line 262: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

258: RETURN VARCHAR2
259: IS
260: l_non_notify_flag VARCHAR2(200);
261: l_api_version NUMBER;
262: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
263: l_msg_count NUMBER;
264: l_msg_data VARCHAR2(2000);
265: l_id1 Varchar2(40);
266: l_id2 Varchar2(200);

Line 324: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

320: WHERE id = p_contract_id;
321:
322: l_currency VARCHAR2(240);
323: l_api_version NUMBER;
324: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
325: l_msg_count NUMBER;
326: l_msg_data VARCHAR2(2000);
327:
328: BEGIN

Line 385: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

381: AND chr.scs_code in ('LEASE','LOAN');
382:
383: l_syndicate_flag VARCHAR2(1) := 'N';
384: l_api_version NUMBER;
385: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
386: l_msg_count NUMBER;
387: l_msg_data VARCHAR2(2000);
388:
389: BEGIN

Line 426: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

422: FROM okc_k_headers_b
423: WHERE id = p_contract_id;
424:
425: l_api_version NUMBER;
426: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
427: l_msg_count NUMBER;
428: l_msg_data VARCHAR2(2000);
429:
430: BEGIN

Line 481: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

477: AND khr.scs_code IN ('LEASE', 'LOAN')
478: AND khr.id = p_contract_id;
479:
480: l_remaining_payments NUMBER := 0;
481: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
482:
483: BEGIN
484:
485: OPEN remaining_payments_csr(p_contract_id);

Line 540: ,p_init_msg_list => OKL_API.G_FALSE

536:
537: -- Procedure call to get Rule Value
538: OKL_RULE_APIS_PUB.Get_rule_Segment_Value
539: ( p_api_version => 1.0
540: ,p_init_msg_list => OKL_API.G_FALSE
541: ,x_return_status => l_return_status
542: ,x_msg_count => l_msg_count
543: ,x_msg_data => l_msg_data
544: ,p_chr_id => p_contract_id

Line 561: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

557: ,x_inv_org_id => l_inv_org_id
558: ,x_book_type_code => l_book_type_code
559: ,x_select => l_select );
560:
561: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
562: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
563: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
564: RAISE okl_api.G_EXCEPTION_ERROR;
565: END IF;

Line 562: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

558: ,x_book_type_code => l_book_type_code
559: ,x_select => l_select );
560:
561: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
562: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
563: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
564: RAISE okl_api.G_EXCEPTION_ERROR;
565: END IF;
566:

Line 563: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

559: ,x_select => l_select );
560:
561: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
562: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
563: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
564: RAISE okl_api.G_EXCEPTION_ERROR;
565: END IF;
566:
567: RETURN l_return_status;

Line 564: RAISE okl_api.G_EXCEPTION_ERROR;

560:
561: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
562: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
563: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
564: RAISE okl_api.G_EXCEPTION_ERROR;
565: END IF;
566:
567: RETURN l_return_status;
568:

Line 616: ,p_init_msg_list => OKL_API.G_FALSE

612:
613: -- Procedure call to get Rule Value
614: OKL_RULE_APIS_PUB.Get_rule_Segment_Value
615: ( p_api_version => 1.0
616: ,p_init_msg_list => OKL_API.G_FALSE
617: ,x_return_status => l_return_status
618: ,x_msg_count => l_msg_count
619: ,x_msg_data => l_msg_data
620: ,p_chr_id => p_contract_id

Line 637: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

633: ,x_inv_org_id => l_inv_org_id
634: ,x_book_type_code => l_book_type_code
635: ,x_select => l_select );
636:
637: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
638: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
639: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
640: RAISE okl_api.G_EXCEPTION_ERROR;
641: END IF;

Line 638: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

634: ,x_book_type_code => l_book_type_code
635: ,x_select => l_select );
636:
637: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
638: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
639: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
640: RAISE okl_api.G_EXCEPTION_ERROR;
641: END IF;
642:

Line 639: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

635: ,x_select => l_select );
636:
637: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
638: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
639: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
640: RAISE okl_api.G_EXCEPTION_ERROR;
641: END IF;
642:
643: RETURN l_return_status;

Line 640: RAISE okl_api.G_EXCEPTION_ERROR;

636:
637: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
638: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
639: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
640: RAISE okl_api.G_EXCEPTION_ERROR;
641: END IF;
642:
643: RETURN l_return_status;
644:

Line 697: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

693: -- ASHIM CHANGE - END
694:
695:
696: l_due_date DATE;
697: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
698:
699: BEGIN
700:
701: OPEN days_past_due_csr(p_contract_id);

Line 772: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

768: -- ASHIM CHANGE - END
769:
770:
771: l_amount_past_due NUMBER;
772: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
773: x_primary_sty_id NUMBER;
774:
775: BEGIN
776:

Line 786: OKL_API.SET_MESSAGE (

782: );
783:
784: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS or x_primary_sty_id is null) THEN
785:
786: OKL_API.SET_MESSAGE (
787: p_app_name => 'OKL',
788: p_msg_name => G_REQUIRED_VALUE,
789: p_token1 => 'COL_NAME',
790: p_token1_value => 'Sty Id');

Line 824: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

820: x_next_due_amt OUT NOCOPY NUMBER,
821: x_next_due_date OUT NOCOPY DATE )
822: RETURN VARCHAR2 IS
823: l_api_version NUMBER;
824: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
825: l_msg_count NUMBER;
826: l_msg_data VARCHAR2(2000);
827:
828:

Line 916: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

912: x_last_due_amt OUT NOCOPY NUMBER,
913: x_last_due_date OUT NOCOPY DATE )
914: RETURN VARCHAR2 IS
915: l_api_version NUMBER;
916: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
917: l_msg_count NUMBER;
918: l_msg_data VARCHAR2(2000);
919:
920:

Line 1006: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1002: p_contract_id IN NUMBER,
1003: x_asset_cost OUT NOCOPY NUMBER )
1004: RETURN VARCHAR2 IS
1005: l_api_version NUMBER;
1006: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1007: l_msg_count NUMBER;
1008: l_msg_data VARCHAR2(2000);
1009:
1010: -- Get total Asset Cost

Line 1050: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1046: p_contract_id IN NUMBER,
1047: x_rcvble_amt OUT NOCOPY NUMBER)
1048: RETURN VARCHAR2 IS
1049: l_api_version NUMBER;
1050: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1051: l_msg_count NUMBER;
1052: l_msg_data VARCHAR2(2000);
1053:
1054: -- Get amount outstanding

Line 1109: OKL_API.SET_MESSAGE (

1105: );
1106:
1107: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS or x_primary_sty_id is null) THEN
1108:
1109: OKL_API.SET_MESSAGE (
1110: p_app_name => 'OKL',
1111: p_msg_name => G_REQUIRED_VALUE,
1112: p_token1 => 'COL_NAME',
1113: p_token1_value => 'Sty Id');

Line 1143: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1139: x_end_date OUT NOCOPY DATE,
1140: x_term_duration OUT NOCOPY NUMBER)
1141: RETURN VARCHAR2 IS
1142: l_api_version NUMBER;
1143: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1144: l_msg_count NUMBER;
1145: l_msg_data VARCHAR2(2000);
1146:
1147: -- Get contract term duration and dates

Line 1177: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1173: p_contract_id IN NUMBER,
1174: x_net_investment OUT NOCOPY NUMBER)
1175: RETURN VARCHAR2 IS
1176: l_api_version NUMBER;
1177: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1178: l_msg_count NUMBER;
1179: l_msg_data VARCHAR2(2000);
1180: l_return_rent NUMBER;
1181: l_return_residual NUMBER;

Line 1242: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1238: x_security_deposit OUT NOCOPY NUMBER,
1239: x_interest_type OUT NOCOPY NUMBER)
1240: RETURN VARCHAR2 IS
1241: l_api_version NUMBER;
1242: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1243: l_msg_count NUMBER;
1244: l_msg_data VARCHAR2(2000);
1245:
1246: -- get advanced rent

Line 1330: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1326: AND SYSDATE BETWEEN IPYB.DATE_FROM AND IPYB.DATE_TO;
1327:
1328: l_insurance_lapse_yn VARCHAR2(1) := 'Y';
1329: l_api_version NUMBER;
1330: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1331: l_msg_count NUMBER;
1332: l_msg_data VARCHAR2(2000);
1333:
1334: BEGIN

Line 1375: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1371: AND status = 'CURES_IN_POSSESSION';
1372:
1373: l_unrefunded_cures NUMBER := 0;
1374: l_api_version NUMBER;
1375: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1376: l_msg_count NUMBER;
1377: l_msg_data VARCHAR2(2000);
1378:
1379: BEGIN

Line 1412: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1408: IS
1409:
1410: l_fair_market_value NUMBER;
1411: l_api_version NUMBER;
1412: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1413: l_msg_count NUMBER;
1414: l_msg_data VARCHAR2(2000);
1415:
1416: BEGIN

Line 1446: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1442: IS
1443:
1444: l_net_book_value NUMBER :=0;
1445: l_api_version NUMBER;
1446: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1447: l_msg_count NUMBER;
1448: l_msg_data VARCHAR2(2000);
1449:
1450:

Line 1516: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1512: IS
1513:
1514: l_interest NUMBER;
1515: l_api_version NUMBER;
1516: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1517: l_msg_count NUMBER;
1518: l_msg_data VARCHAR2(2000);
1519:
1520: BEGIN

Line 1553: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1549: IS
1550:
1551: l_value VARCHAR2(1);
1552: l_api_version NUMBER;
1553: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1554: l_msg_count NUMBER;
1555: l_msg_data VARCHAR2(2000);
1556:
1557: BEGIN

Line 1634: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1630: IS
1631:
1632: l_assignment_yn VARCHAR2(1);
1633: l_api_version NUMBER;
1634: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1635: l_msg_count NUMBER;
1636: l_msg_data VARCHAR2(2000);
1637:
1638: BEGIN