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_SUBSIDY_POOL_PVT dependencies on OKL_SIP_PVT

Line 148: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.insert_row ');

144: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
145: END IF;
146: IF(IS_DEBUG_PROCEDURE_ON) THEN
147: BEGIN
148: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.insert_row ');
149: END;
150: END IF;
151:
152: l_sub_pool_rec := p_sub_pool_rec;

Line 191: okl_sip_pvt.insert_row( l_api_version,

187: END IF;
188: l_sub_pool_rec.total_budgets := l_total_budgets;
189:
190: -- TAPI call to create a record for subsidy pool in table OKL_SUBSIDY_POOLS_B.
191: okl_sip_pvt.insert_row( l_api_version,
192: l_init_msg_list,
193: l_return_status,
194: l_msg_count,
195: l_msg_data,

Line 212: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.insert_row ');

208: x_msg_count := l_msg_count;
209:
210: IF(IS_DEBUG_PROCEDURE_ON) THEN
211: BEGIN
212: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.insert_row ');
213: END;
214: END IF;
215:
216: EXCEPTION

Line 333: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

329: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
330: END IF;
331: IF(IS_DEBUG_PROCEDURE_ON) THEN
332: BEGIN
333: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
334: END;
335: END IF;
336: l_sub_pool_rec := p_sub_pool_rec;
337: l_effective_to_date := l_sub_pool_rec.effective_to_date;

Line 428: okl_sip_pvt.update_row(l_api_version,

424: END IF;
425: END IF;
426:
427: -- TAPI call to update the subsidy pool in table OKL_SUBSIDY_POOLS_B.
428: okl_sip_pvt.update_row(l_api_version,
429: l_init_msg_list,
430: l_return_status,
431: l_msg_count,
432: l_msg_data,

Line 449: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

445: x_msg_count := l_msg_count;
446:
447: IF(IS_DEBUG_PROCEDURE_ON) THEN
448: BEGIN
449: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
450: END;
451: END IF;
452:
453: EXCEPTION

Line 545: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

541: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
542: END IF;
543: IF(IS_DEBUG_PROCEDURE_ON) THEN
544: BEGIN
545: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
546: END;
547: END IF;
548: l_subsidy_pool_id := p_subsidy_pool_id;
549: l_row_found := FALSE;

Line 579: okl_sip_pvt.update_row(l_api_version,

575: -- If a row exists then set the status of pool to "expired" and commit it.
576: -- this is an autonomous transaction and will get commited irrespective of the calling procedure.
577: IF l_row_found THEN
578: l_sub_pool_rec.decision_status_code := 'EXPIRED';
579: okl_sip_pvt.update_row(l_api_version,
580: l_init_msg_list,
581: l_return_status,
582: l_msg_count,
583: l_msg_data,

Line 600: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

596:
597: COMMIT;
598: IF(IS_DEBUG_PROCEDURE_ON) THEN
599: BEGIN
600: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
601: END;
602: END IF;
603:
604: EXCEPTION

Line 692: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

688: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
689: END IF;
690: IF(IS_DEBUG_PROCEDURE_ON) THEN
691: BEGIN
692: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
693: END;
694: END IF;
695: l_subsidy_pool_id := p_subsidy_pool_id;
696: l_row_found := FALSE;

Line 725: okl_sip_pvt.update_row(l_api_version,

721:
722: -- if row is found then update the total budget amount with the amount passed to it as a parameter.
723: IF l_row_found THEN
724: l_sub_pool_rec.total_budgets := p_total_budget_amt;
725: okl_sip_pvt.update_row(l_api_version,
726: l_init_msg_list,
727: l_return_status,
728: l_msg_count,
729: l_msg_data,

Line 745: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

741: x_msg_count := l_msg_count;
742:
743: IF(IS_DEBUG_PROCEDURE_ON) THEN
744: BEGIN
745: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
746: END;
747: END IF;
748:
749: EXCEPTION

Line 838: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

834: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
835: END IF;
836: IF(IS_DEBUG_PROCEDURE_ON) THEN
837: BEGIN
838: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
839: END;
840: END IF;
841: l_subsidy_pool_id := p_subsidy_pool_id;
842: l_row_found := FALSE;

Line 870: okl_sip_pvt.update_row(l_api_version,

866:
867: -- if a row is found then update the total subsidy amount to the amount passed.
868: IF l_row_found THEN
869: l_sub_pool_rec.total_subsidy_amount := p_total_subsidy_amt;
870: okl_sip_pvt.update_row(l_api_version,
871: l_init_msg_list,
872: l_return_status,
873: l_msg_count,
874: l_msg_data,

Line 890: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

886: x_msg_count := l_msg_count;
887:
888: IF(IS_DEBUG_PROCEDURE_ON) THEN
889: BEGIN
890: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
891: END;
892: END IF;
893:
894: EXCEPTION

Line 985: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

981: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
982: END IF;
983: IF(IS_DEBUG_PROCEDURE_ON) THEN
984: BEGIN
985: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
986: END;
987: END IF;
988: l_subsidy_pool_id := p_subsidy_pool_id;
989: l_row_found := FALSE;

Line 1018: okl_sip_pvt.update_row(l_api_version,

1014: -- update the status of the pool with the valus passed to it.
1015: IF l_row_found THEN
1016: l_sub_pool_rec.decision_status_code := p_decision_status_code;
1017: l_sub_pool_rec.decision_date := l_system_date;
1018: okl_sip_pvt.update_row(l_api_version,
1019: l_init_msg_list,
1020: l_return_status,
1021: l_msg_count,
1022: l_msg_data,

Line 1061: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

1057: x_msg_count := l_msg_count;
1058:
1059: IF(IS_DEBUG_PROCEDURE_ON) THEN
1060: BEGIN
1061: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
1062: END;
1063: END IF;
1064:
1065: EXCEPTION

Line 1143: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.validate_row ');

1139: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1140: END IF;
1141: IF(IS_DEBUG_PROCEDURE_ON) THEN
1142: BEGIN
1143: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.validate_row ');
1144: END;
1145: END IF;
1146: l_api_version := 1.0;
1147: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1171: okl_sip_pvt.validate_row(

1167:
1168: l_sub_pool_rec := p_sub_pool_rec;
1169:
1170: -- TAPI call to validate the records.
1171: okl_sip_pvt.validate_row(
1172: p_api_version => p_api_version,
1173: p_init_msg_list => p_init_msg_list,
1174: x_return_status => x_return_status,
1175: x_msg_count => x_msg_count,

Line 1191: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.validate_row ');

1187: x_msg_data => x_msg_data);
1188:
1189: IF(IS_DEBUG_PROCEDURE_ON) THEN
1190: BEGIN
1191: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.validate_row ');
1192: END;
1193: END IF;
1194:
1195: EXCEPTION