APPS.OKL_STRY_CALL_CO_PUB dependencies on OKL_CONTRACT_INFO

Line 141: l_status := okl_contract_info.

137: where cas_id =p_case_id ;
138: BEGIN
139: FOR c_rec in c_contracts(p_case_id)
140: LOOP
141: l_status := okl_contract_info.
142: get_days_past_due(c_rec.object_id,x_days);
143: if x_days >= x_greatest THEN
144: x_contract_id :=c_rec.object_id;
145: x_greatest := x_days;

Line 223: l_return_status := OKL_CONTRACT_INFO.get_rule_value(

219: BEGIN
220: --get sendto_third_party flag
221: FOR cur_khr IN l_khr_csr(p_case_number) LOOP
222: FOR cur_rule IN l_rule_csr(cur_khr.contract_number) LOOP
223: l_return_status := OKL_CONTRACT_INFO.get_rule_value(
224: p_contract_id => cur_rule.program_id
225: ,p_rule_group_code => 'COAGRM'
226: ,p_rule_code => 'COVNAG'
227: -- ,p_rule_name => 'Vendor location'

Line 651: l_return_status := OKL_CONTRACT_INFO.get_rule_value(

647: aname => 'DELINQUENCY_ID');
648: --get vendorapproval flag
649: FOR cur_khr IN l_khr_csr(l_delinquency_id) LOOP
650: FOR cur_rule IN l_rule_csr(cur_khr.contract_number) LOOP
651: l_return_status := OKL_CONTRACT_INFO.get_rule_value(
652: p_contract_id => cur_rule.program_id
653: ,p_rule_group_code => 'COAGRM'
654: ,p_rule_code => 'COCALL'
655: -- ,p_rule_name =>

Line 747: l_return_status := OKL_CONTRACT_INFO.get_rule_value(

743: set_wait_period(itemtype,itemkey);
744: --get notification_flag
745: FOR cur_khr IN l_khr_csr(l_delinquency_id) LOOP
746: FOR cur_rule IN l_rule_csr(cur_khr.contract_number) LOOP
747: l_return_status := OKL_CONTRACT_INFO.get_rule_value(
748: p_contract_id => cur_rule.program_id
749: ,p_rule_group_code => 'COAGRM'
750: ,p_rule_code => 'COCALL'
751: -- ,p_rule_name =>

Line 863: l_return_status := OKL_CONTRACT_INFO.get_rule_value(

859:
860: --get no of days
861: FOR cur_khr IN l_khr_csr(l_delinquency_id) LOOP
862: FOR cur_rule IN l_rule_csr(cur_khr.contract_number) LOOP
863: l_return_status := OKL_CONTRACT_INFO.get_rule_value(
864: p_contract_id => cur_rule.program_id
865: ,p_rule_group_code => 'COAGRM'
866: ,p_rule_code => 'COCALL'
867: --,p_rule_name =>

Line 893: l_return_status := OKL_CONTRACT_INFO.get_rule_value(

889: --get no of days after getting vendor approval
890: --send this number in the agents email
891: FOR cur_khr IN l_khr_csr(l_delinquency_id) LOOP
892: FOR cur_rule IN l_rule_csr(cur_khr.contract_number) LOOP
893: l_return_status := OKL_CONTRACT_INFO.get_rule_value(
894: p_contract_id => cur_rule.program_id
895: ,p_rule_group_code => 'COAGRM'
896: ,p_rule_code => 'COCALL'
897: --,p_rule_name =>

Line 986: l_return_status := OKL_CONTRACT_INFO.get_rule_value(

982:
983: --get lessor_flag
984: FOR cur_khr IN l_khr_csr(l_delinquency_id) LOOP
985: FOR cur_rule IN l_rule_csr(cur_khr.contract_number) LOOP
986: l_return_status := OKL_CONTRACT_INFO.get_rule_value(
987: p_contract_id => cur_rule.program_id
988: ,p_rule_group_code => 'COAGRM'
989: ,p_rule_code => 'COVIST'
990: -- ,p_rule_name =>

Line 1081: l_return_status := OKL_CONTRACT_INFO.get_rule_value(

1077:
1078: --get Customer_flag
1079: FOR cur_khr IN l_khr_csr(l_delinquency_id) LOOP
1080: FOR cur_rule IN l_rule_csr(cur_khr.contract_number) LOOP
1081: l_return_status := OKL_CONTRACT_INFO.get_rule_value(
1082: p_contract_id => cur_rule.program_id
1083: ,p_rule_group_code => 'COAGRM'
1084: ,p_rule_code => 'COVIST'
1085: --,p_rule_name =>

Line 1174: l_return_status := OKL_CONTRACT_INFO.get_rule_value(

1170:
1171: --get Vendor_Customer_flag
1172: FOR cur_khr IN l_khr_csr(l_delinquency_id) LOOP
1173: FOR cur_rule IN l_rule_csr(cur_khr.contract_number) LOOP
1174: l_return_status := OKL_CONTRACT_INFO.get_rule_value(
1175: p_contract_id => cur_rule.program_id
1176: ,p_rule_group_code => 'COAGRM'
1177: ,p_rule_code => 'COVIST'
1178: --,p_rule_name =>

Line 1269: l_return_status := OKL_CONTRACT_INFO.get_rule_value(

1265:
1266: --get Vend_cust_notify_flag
1267: FOR cur_khr IN l_khr_csr(l_delinquency_id) LOOP
1268: FOR cur_rule IN l_rule_csr(cur_khr.contract_number) LOOP
1269: l_return_status := OKL_CONTRACT_INFO.get_rule_value(
1270: p_contract_id => cur_rule.program_id
1271: ,p_rule_group_code => 'COAGRM'
1272: ,p_rule_code => 'COVIST'
1273: --,p_rule_name =>

Line 1399: l_status := okl_contract_info.

1395: get_delinquent_contract (l_case_id,l_contract_id,l_actualdays);
1396:
1397: set_wait_period(itemtype,itemkey);
1398:
1399: l_status := okl_contract_info.
1400: get_syndicate_flag(l_contract_id, x_syndicate_flag);
1401:
1402: IF l_status = 'Y' THEN
1403: --get no of days

Line 1406: l_return_status := OKL_CONTRACT_INFO.get_rule_value(

1402: IF l_status = 'Y' THEN
1403: --get no of days
1404: FOR cur_khr IN l_khr_csr(l_delinquency_id) LOOP
1405: FOR cur_rule IN l_rule_csr(cur_khr.contract_number) LOOP
1406: l_return_status := OKL_CONTRACT_INFO.get_rule_value(
1407: p_contract_id => cur_rule.program_id
1408: ,p_rule_group_code => 'COAGRM'
1409: ,p_rule_code => 'COWRIT'
1410: --,p_rule_name =>