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.45 2007/12/24 11:51:51 harlaksh noship $ */
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.45 2007/12/24 11:51:51 harlaksh noship $ */
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 2197: OKS_SLL_PVT.insert_row(

2193: END IF;
2194:
2195: IF (l_sll_id IS NULL) THEN
2196:
2197: OKS_SLL_PVT.insert_row(
2198: p_api_version => l_api_version,
2199: p_init_msg_list => l_init_msg_list,
2200: x_return_status => x_return_status,
2201: x_msg_count => l_msg_count,

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

2204: x_sllv_tbl => l_strm_lvl_tbl_out);
2205:
2206: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2207: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.insert',
2208: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
2209: ||', sll id created = '||l_strm_lvl_tbl_out(1).id ||')');
2210: END IF;
2211:
2212: -----errorout_ad('SllCREATED : '|| x_return_status);

Line 2226: OKS_SLL_PVT.update_row(

2222: ELSE --sll id not null
2223: l_strm_lvl_tbl_in(1).id := l_sll_id;
2224: l_strm_lvl_tbl_in(1).object_version_number := l_obj_version;
2225:
2226: OKS_SLL_PVT.update_row(
2227: p_api_version => l_api_version,
2228: p_init_msg_list => l_init_msg_list,
2229: x_return_status => x_return_status,
2230: x_msg_count => l_msg_count,

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

2233: x_sllv_tbl => l_strm_lvl_tbl_out);
2234:
2235: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2236: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.update',
2237: 'OKS_SLL_PVT.update_row(x_return_status = '||x_return_status
2238: ||', sll id updated = '||l_strm_lvl_tbl_out(1).id ||')');
2239: END IF;
2240:
2241: -----errorout_ad('STREAM LEVEL RULE updated : '|| x_return_status);

Line 6062: OKS_SLL_PVT.delete_row(

6058:
6059: IF l_strm_lvl_tbl_in.COUNT > 0 THEN
6060:
6061:
6062: OKS_SLL_PVT.delete_row(
6063: p_api_version => l_api_version,
6064: p_init_msg_list => l_msg_list,
6065: x_return_status => x_return_status,
6066: x_msg_count => x_msg_count,

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

6068: p_sllv_tbl => l_strm_lvl_tbl_in);
6069:
6070: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6071: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_sll',
6072: 'oks_sll_pvt.delete_row(x_return_status = '||x_return_status
6073: ||', sll passed for delete = '|| l_strm_lvl_tbl_in.count ||')');
6074: END IF;
6075:
6076:

Line 11511: OKS_SLL_PVT.insert_row(

11507: END LOOP;
11508:
11509: IF l_strm_lvl_tbl_in.COUNT > 0 THEN
11510:
11511: OKS_SLL_PVT.insert_row(
11512: p_api_version => l_api_version,
11513: p_init_msg_list => l_init_msg_list,
11514: x_return_status => x_return_status,
11515: x_msg_count => x_msg_count,

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

11518: x_sllv_tbl => l_strm_lvl_tbl_out);
11519:
11520: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11521: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.insert_sll',
11522: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
11523: ||', sll tbl out count = '||l_strm_lvl_tbl_out.count||')');
11524: END IF;
11525:
11526: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN

Line 12165: OKS_SLL_PVT.insert_row(

12161:
12162: END LOOP;
12163:
12164:
12165: OKS_SLL_PVT.insert_row(
12166: p_api_version => l_api_version,
12167: p_init_msg_list => l_init_msg_list,
12168: x_return_status => x_return_status,
12169: x_msg_count => x_msg_count,

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

12172: x_sllv_tbl => l_strm_lvl_tbl_out);
12173:
12174: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12175: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.insert_sll',
12176: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
12177: ||', sll tbl out count = '||l_strm_lvl_tbl_out.count||')');
12178: END IF;
12179:
12180: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN