DBA Data[Home] [Help]

APPS.OKS_SUBSCRIPTION_PVT dependencies on OKS_SUBSCR_ELEMS_PUB

Line 320: 'oks_subscr_elems_pub.insert_row');

316: END LOOP;
317: tot_qty := i * l_qty;
318: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
319: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.create_default_schedule.external_call.before',
320: 'oks_subscr_elems_pub.insert_row');
321: END IF;
322: OKS_SUBSCR_ELEMS_PUB.insert_row
323: (
324: p_api_version => p_api_version,

Line 322: OKS_SUBSCR_ELEMS_PUB.insert_row

318: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
319: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.create_default_schedule.external_call.before',
320: 'oks_subscr_elems_pub.insert_row');
321: END IF;
322: OKS_SUBSCR_ELEMS_PUB.insert_row
323: (
324: p_api_version => p_api_version,
325: p_init_msg_list => p_init_msg_list,
326: x_return_status => x_return_status,

Line 334: 'oks_subscr_elems_pub.insert_row(x_return_status = '||x_return_status||')');

330: x_scev_tbl => l_elems_tbl_out
331: );
332: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
333: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.create_default_schedule.external_call.after',
334: 'oks_subscr_elems_pub.insert_row(x_return_status = '||x_return_status||')');
335: END IF;
336: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then
337: Raise gen_exit;
338: end if;

Line 789: 'oks_subscr_elems_pub.delete_row');

785: -- DELETE UNWANTED SCHEDULE ELEMENTS --
786: If l_elems_tbl_del_in.COUNT <> 0 Then
787: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
788: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_schedule.external_call.before',
789: 'oks_subscr_elems_pub.delete_row');
790: END IF;
791: OKS_SUBSCR_ELEMS_PUB.delete_row
792: (
793: p_api_version => p_api_version,

Line 791: OKS_SUBSCR_ELEMS_PUB.delete_row

787: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
788: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_schedule.external_call.before',
789: 'oks_subscr_elems_pub.delete_row');
790: END IF;
791: OKS_SUBSCR_ELEMS_PUB.delete_row
792: (
793: p_api_version => p_api_version,
794: p_init_msg_list => p_init_msg_list,
795: x_return_status => x_return_status,

Line 802: 'oks_subscr_elems_pub.delete_row(x_return_status = '||x_return_status||')');

798: p_scev_tbl => l_elems_tbl_del_in
799: );
800: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
801: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_schedule.external_call.after',
802: 'oks_subscr_elems_pub.delete_row(x_return_status = '||x_return_status||')');
803: END IF;
804: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then
805: Raise gen_exit;
806: end if;

Line 813: 'oks_subscr_elems_pub.update_row');

809: -- UPDATE CHANGED SCHEDULE ELEMENTS --
810: If l_elems_tbl_upd_in.COUNT <> 0 Then
811: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
812: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_schedule.external_call.before',
813: 'oks_subscr_elems_pub.update_row');
814: END IF;
815: OKS_SUBSCR_ELEMS_PUB.update_row
816: (
817: p_api_version => p_api_version,

Line 815: OKS_SUBSCR_ELEMS_PUB.update_row

811: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
812: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_schedule.external_call.before',
813: 'oks_subscr_elems_pub.update_row');
814: END IF;
815: OKS_SUBSCR_ELEMS_PUB.update_row
816: (
817: p_api_version => p_api_version,
818: p_init_msg_list => p_init_msg_list,
819: x_return_status => x_return_status,

Line 827: 'oks_subscr_elems_pub.update_row(x_return_status = '||x_return_status||')');

823: x_scev_tbl => l_elems_tbl_out
824: );
825: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
826: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_schedule.external_call.after',
827: 'oks_subscr_elems_pub.update_row(x_return_status = '||x_return_status||')');
828: END IF;
829: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then
830: Raise gen_exit;
831: end if;

Line 838: 'oks_subscr_elems_pub.insert_row');

834: -- INSERT NEW SCHEDULE ELEMENTS --
835: If l_elems_tbl_ins_in.COUNT <> 0 Then
836: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
837: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_schedule.external_call.before',
838: 'oks_subscr_elems_pub.insert_row');
839: END IF;
840: OKS_SUBSCR_ELEMS_PUB.insert_row
841: (
842: p_api_version => p_api_version,

Line 840: OKS_SUBSCR_ELEMS_PUB.insert_row

836: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
837: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_schedule.external_call.before',
838: 'oks_subscr_elems_pub.insert_row');
839: END IF;
840: OKS_SUBSCR_ELEMS_PUB.insert_row
841: (
842: p_api_version => p_api_version,
843: p_init_msg_list => p_init_msg_list,
844: x_return_status => x_return_status,

Line 852: 'oks_subscr_elems_pub.insert_row(x_return_status = '||x_return_status||')');

848: x_scev_tbl => l_elems_tbl_out
849: );
850: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
851: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_schedule.external_call.after',
852: 'oks_subscr_elems_pub.insert_row(x_return_status = '||x_return_status||')');
853: END IF;
854: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then
855: Raise gen_exit;
856: end if;

Line 1405: l_scev_tbl OKS_SUBSCR_ELEMS_PUB.scev_tbl_type;

1401: Cursor scev_cur Is
1402: Select id
1403: From oks_subscr_elements
1404: Where dnz_cle_id = p_cle_id;
1405: l_scev_tbl OKS_SUBSCR_ELEMS_PUB.scev_tbl_type;
1406: i Number := 0;
1407: Begin
1408: For scev_rec In scev_cur
1409: Loop

Line 1415: 'oks_subscr_elems_pub.delete_row(p_scev_tbl.COUNT = '||i||')');

1411: l_scev_tbl(i).id := scev_rec.id;
1412: End Loop;
1413: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1414: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.undo_subscription.delete_ose.external_call.before',
1415: 'oks_subscr_elems_pub.delete_row(p_scev_tbl.COUNT = '||i||')');
1416: END IF;
1417: OKS_SUBSCR_ELEMS_PUB.delete_row
1418: ( p_api_version => p_api_version,
1419: p_init_msg_list => p_init_msg_list,

Line 1417: OKS_SUBSCR_ELEMS_PUB.delete_row

1413: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1414: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.undo_subscription.delete_ose.external_call.before',
1415: 'oks_subscr_elems_pub.delete_row(p_scev_tbl.COUNT = '||i||')');
1416: END IF;
1417: OKS_SUBSCR_ELEMS_PUB.delete_row
1418: ( p_api_version => p_api_version,
1419: p_init_msg_list => p_init_msg_list,
1420: x_return_status => x_return_status,
1421: x_msg_count => x_msg_count,

Line 1427: 'oks_subscr_elems_pub.delete_row(x_return_status = '||x_return_status||')');

1423: p_scev_tbl => l_scev_tbl
1424: );
1425: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1426: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.undo_subscription.delete_ose.external_call.after',
1427: 'oks_subscr_elems_pub.delete_row(x_return_status = '||x_return_status||')');
1428: END IF;
1429: End delete_ose;
1430: Begin
1431: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN