APPS.OKS_BILL_SCH dependencies on OKS_SLL_PVT

Line 5: l_strm_lvl_tbl_in oks_sll_pvt.sllv_tbl_type;

1: Package Body OKS_BILL_SCH AS
2: /* $Header: OKSBLSHB.pls 120.46.12020000.8 2013/05/10 13:58:30 spingali ship $ */
3:
4:
5: l_strm_lvl_tbl_in oks_sll_pvt.sllv_tbl_type;
6: l_strm_lvl_tbl_out oks_sll_pvt.sllv_tbl_type;
7: l_lvl_ele_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
8: l_lvl_ele_tbl_out oks_bill_level_elements_pvt.letv_tbl_type;
9: l_fnd_lvl_in_rec oks_bill_util_pub.bill_det_inp_rec;

Line 6: l_strm_lvl_tbl_out oks_sll_pvt.sllv_tbl_type;

2: /* $Header: OKSBLSHB.pls 120.46.12020000.8 2013/05/10 13:58:30 spingali ship $ */
3:
4:
5: l_strm_lvl_tbl_in oks_sll_pvt.sllv_tbl_type;
6: l_strm_lvl_tbl_out oks_sll_pvt.sllv_tbl_type;
7: l_lvl_ele_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
8: l_lvl_ele_tbl_out oks_bill_level_elements_pvt.letv_tbl_type;
9: l_fnd_lvl_in_rec oks_bill_util_pub.bill_det_inp_rec;
10: l_fnd_lvl_out_rec oks_bill_util_pub.bill_sch_rec;

Line 2214: OKS_SLL_PVT.insert_row(

2210: END IF;
2211:
2212: IF (l_sll_id IS NULL) THEN
2213:
2214: OKS_SLL_PVT.insert_row(
2215: p_api_version => l_api_version,
2216: p_init_msg_list => l_init_msg_list,
2217: x_return_status => x_return_status,
2218: x_msg_count => l_msg_count,

Line 2225: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status

2221: x_sllv_tbl => l_strm_lvl_tbl_out);
2222:
2223: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2224: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.insert',
2225: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
2226: ||', sll id created = '||l_strm_lvl_tbl_out(1).id ||')');
2227: END IF;
2228:
2229: -----errorout_ad('SllCREATED : '|| x_return_status);

Line 2243: OKS_SLL_PVT.update_row(

2239: ELSE --sll id not null
2240: l_strm_lvl_tbl_in(1).id := l_sll_id;
2241: l_strm_lvl_tbl_in(1).object_version_number := l_obj_version;
2242:
2243: OKS_SLL_PVT.update_row(
2244: p_api_version => l_api_version,
2245: p_init_msg_list => l_init_msg_list,
2246: x_return_status => x_return_status,
2247: x_msg_count => l_msg_count,

Line 2254: 'OKS_SLL_PVT.update_row(x_return_status = '||x_return_status

2250: x_sllv_tbl => l_strm_lvl_tbl_out);
2251:
2252: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2253: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.update',
2254: 'OKS_SLL_PVT.update_row(x_return_status = '||x_return_status
2255: ||', sll id updated = '||l_strm_lvl_tbl_out(1).id ||')');
2256: END IF;
2257:
2258: -----errorout_ad('STREAM LEVEL RULE updated : '|| x_return_status);

Line 6185: OKS_SLL_PVT.delete_row(

6181:
6182: IF l_strm_lvl_tbl_in.COUNT > 0 THEN
6183:
6184:
6185: OKS_SLL_PVT.delete_row(
6186: p_api_version => l_api_version,
6187: p_init_msg_list => l_msg_list,
6188: x_return_status => x_return_status,
6189: x_msg_count => x_msg_count,

Line 6195: 'oks_sll_pvt.delete_row(x_return_status = '||x_return_status

6191: p_sllv_tbl => l_strm_lvl_tbl_in);
6192:
6193: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6194: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_sll',
6195: 'oks_sll_pvt.delete_row(x_return_status = '||x_return_status
6196: ||', sll passed for delete = '|| l_strm_lvl_tbl_in.count ||')');
6197: END IF;
6198:
6199:

Line 11754: OKS_SLL_PVT.insert_row(

11750: END LOOP;
11751:
11752: IF l_strm_lvl_tbl_in.COUNT > 0 THEN
11753:
11754: OKS_SLL_PVT.insert_row(
11755: p_api_version => l_api_version,
11756: p_init_msg_list => l_init_msg_list,
11757: x_return_status => x_return_status,
11758: x_msg_count => x_msg_count,

Line 11765: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status

11761: x_sllv_tbl => l_strm_lvl_tbl_out);
11762:
11763: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11764: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.insert_sll',
11765: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
11766: ||', sll tbl out count = '||l_strm_lvl_tbl_out.count||')');
11767: END IF;
11768:
11769: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN

Line 12431: OKS_SLL_PVT.insert_row(

12427:
12428: END LOOP;
12429:
12430:
12431: OKS_SLL_PVT.insert_row(
12432: p_api_version => l_api_version,
12433: p_init_msg_list => l_init_msg_list,
12434: x_return_status => x_return_status,
12435: x_msg_count => x_msg_count,

Line 12442: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status

12438: x_sllv_tbl => l_strm_lvl_tbl_out);
12439:
12440: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12441: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.insert_sll',
12442: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
12443: ||', sll tbl out count = '||l_strm_lvl_tbl_out.count||')');
12444: END IF;
12445:
12446: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN