355: -- PROCEDURE get_fee_rec
356: ------------------------
357: PROCEDURE get_fee_rec (
358: p_fee_id IN NUMBER
359: ,x_fee_rec OUT NOCOPY okl_fee_pvt.feev_rec_type
360: ,x_return_status OUT NOCOPY VARCHAR2
361: ) IS
362:
363: l_program_name CONSTANT VARCHAR2(30) := 'get_fee_rec';
1063: --------------------------
1064: -- PROCEDURE create_header
1065: --------------------------
1066: PROCEDURE create_header (
1067: p_fee_rec IN okl_fee_pvt.feev_rec_type
1068: ,x_fee_id OUT NOCOPY NUMBER
1069: ,x_return_status OUT NOCOPY VARCHAR2
1070: ,x_msg_count OUT NOCOPY NUMBER
1071: ,x_msg_data OUT NOCOPY VARCHAR2
1073:
1074: l_program_name CONSTANT VARCHAR2(30) := 'create_header';
1075: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
1076:
1077: l_fee_rec okl_fee_pvt.feev_rec_type;
1078:
1079: BEGIN
1080:
1081: okl_fee_pvt.insert_row (
1077: l_fee_rec okl_fee_pvt.feev_rec_type;
1078:
1079: BEGIN
1080:
1081: okl_fee_pvt.insert_row (
1082: p_api_version => G_API_VERSION
1083: ,p_init_msg_list => G_FALSE
1084: ,x_return_status => x_return_status
1085: ,x_msg_count => x_msg_count
1122: --------------------------
1123: -- PROCEDURE update_header
1124: --------------------------
1125: PROCEDURE update_header (
1126: p_fee_rec IN okl_fee_pvt.feev_rec_type
1127: ,x_return_status OUT NOCOPY VARCHAR2
1128: ,x_msg_count OUT NOCOPY NUMBER
1129: ,x_msg_data OUT NOCOPY VARCHAR2
1130: ) IS
1131:
1132: l_program_name CONSTANT VARCHAR2(30) := 'update_header';
1133: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
1134:
1135: l_fee_rec okl_fee_pvt.feev_rec_type;
1136:
1137: BEGIN
1138:
1139: okl_fee_pvt.update_row (
1135: l_fee_rec okl_fee_pvt.feev_rec_type;
1136:
1137: BEGIN
1138:
1139: okl_fee_pvt.update_row (
1140: p_api_version => G_API_VERSION
1141: ,p_init_msg_list => G_FALSE
1142: ,x_return_status => x_return_status
1143: ,x_msg_count => x_msg_count
2479:
2480: l_program_name CONSTANT VARCHAR2(30) := 'duplicate_fee';
2481: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2482:
2483: l_fee_rec okl_fee_pvt.feev_rec_type;
2484: lx_fee_rec okl_fee_pvt.feev_rec_type;
2485:
2486: lb_copy_cashflow BOOLEAN := TRUE;
2487: lb_config_fee BOOLEAN := FALSE;
2480: l_program_name CONSTANT VARCHAR2(30) := 'duplicate_fee';
2481: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2482:
2483: l_fee_rec okl_fee_pvt.feev_rec_type;
2484: lx_fee_rec okl_fee_pvt.feev_rec_type;
2485:
2486: lb_copy_cashflow BOOLEAN := TRUE;
2487: lb_config_fee BOOLEAN := FALSE;
2488: lv_pricing_type_equal VARCHAR2(1) := 'Y';
2760: END IF;
2761:
2762: l_fee_rec.id := p_fee_id;
2763:
2764: okl_fee_pvt.delete_row (
2765: p_api_version => G_API_VERSION
2766: ,p_init_msg_list => G_FALSE
2767: ,x_return_status => x_return_status
2768: ,x_msg_count => x_msg_count