DBA Data[Home] [Help]

APPS.OKS_SUBSCRIPTION_PVT dependencies on OKS_SUBSCR_HDR_PUB

Line 194: 'oks_subscr_hdr_pub.insert_row');

190: End If;
191: l_hdr_tbl_in(1).status := 'A';
192: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
193: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.create_default_schedule.external_call.before',
194: 'oks_subscr_hdr_pub.insert_row');
195: END IF;
196: OKS_SUBSCR_HDR_PUB.insert_row
197: (
198: p_api_version => p_api_version,

Line 196: OKS_SUBSCR_HDR_PUB.insert_row

192: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
193: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.create_default_schedule.external_call.before',
194: 'oks_subscr_hdr_pub.insert_row');
195: END IF;
196: OKS_SUBSCR_HDR_PUB.insert_row
197: (
198: p_api_version => p_api_version,
199: p_init_msg_list => p_init_msg_list,
200: x_return_status => x_return_status,

Line 208: 'oks_subscr_hdr_pub.insert_row(x_return_status = '||x_return_status||')');

204: x_schv_tbl => l_hdr_tbl_out
205: );
206: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
207: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.create_default_schedule.external_call.after',
208: 'oks_subscr_hdr_pub.insert_row(x_return_status = '||x_return_status||')');
209: END IF;
210: If NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS Then
211: Raise gen_exit;
212: End If;

Line 1044: l_schv_tbl_in OKS_SUBSCR_HDR_PUB.schv_tbl_type;

1040: l_dummy Number;
1041: l_intent Varchar2(20);
1042: gen_exit EXCEPTION;
1043: Procedure copy_osh Is
1044: l_schv_tbl_in OKS_SUBSCR_HDR_PUB.schv_tbl_type;
1045: l_schv_tbl_out OKS_SUBSCR_HDR_PUB.schv_tbl_type;
1046: Cursor src_osh_cur Is
1047: select name, description, instance_id, subscription_type, media_type, frequency,
1048: fulfillment_channel, offset, comments, item_type

Line 1045: l_schv_tbl_out OKS_SUBSCR_HDR_PUB.schv_tbl_type;

1041: l_intent Varchar2(20);
1042: gen_exit EXCEPTION;
1043: Procedure copy_osh Is
1044: l_schv_tbl_in OKS_SUBSCR_HDR_PUB.schv_tbl_type;
1045: l_schv_tbl_out OKS_SUBSCR_HDR_PUB.schv_tbl_type;
1046: Cursor src_osh_cur Is
1047: select name, description, instance_id, subscription_type, media_type, frequency,
1048: fulfillment_channel, offset, comments, item_type
1049: from oks_subscr_header_v

Line 1100: 'oks_subscr_hdr_pub.insert_row');

1096: End If;
1097: END IF;
1098: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1099: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.copy_subscription.copy_osh.external_call.before',
1100: 'oks_subscr_hdr_pub.insert_row');
1101: END IF;
1102: OKS_SUBSCR_HDR_PUB.insert_row
1103: ( p_api_version => p_api_version,
1104: p_init_msg_list => p_init_msg_list,

Line 1102: OKS_SUBSCR_HDR_PUB.insert_row

1098: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1099: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.copy_subscription.copy_osh.external_call.before',
1100: 'oks_subscr_hdr_pub.insert_row');
1101: END IF;
1102: OKS_SUBSCR_HDR_PUB.insert_row
1103: ( p_api_version => p_api_version,
1104: p_init_msg_list => p_init_msg_list,
1105: x_return_status => x_return_status,
1106: x_msg_count => x_msg_count,

Line 1112: 'oks_subscr_hdr_pub.insert_row(x_return_status = '||x_return_status||')');

1108: p_schv_tbl => l_schv_tbl_in,
1109: x_schv_tbl => l_schv_tbl_out);
1110: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1111: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.copy_subscription.copy_osh.external_call.after',
1112: 'oks_subscr_hdr_pub.insert_row(x_return_status = '||x_return_status||')');
1113: END IF;
1114: If x_return_status = OKC_API.G_RET_STS_SUCCESS Then
1115: g_osh_id := l_schv_tbl_out(1).id;
1116: End If;

Line 1348: l_schv_tbl OKS_SUBSCR_HDR_PUB.schv_tbl_type;

1344: */
1345: End delete_cii;
1346:
1347: Procedure delete_osh Is
1348: l_schv_tbl OKS_SUBSCR_HDR_PUB.schv_tbl_type;
1349: Begin
1350: l_schv_tbl(1).id := l_osh_id;
1351: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1352: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.undo_subscription.delete_osh.external_call.before',

Line 1353: 'oks_subscr_hdr_pub.delete_row(p_schv_tbl(1).id = '||l_schv_tbl(1).id||')');

1349: Begin
1350: l_schv_tbl(1).id := l_osh_id;
1351: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1352: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.undo_subscription.delete_osh.external_call.before',
1353: 'oks_subscr_hdr_pub.delete_row(p_schv_tbl(1).id = '||l_schv_tbl(1).id||')');
1354: END IF;
1355: OKS_SUBSCR_HDR_PUB.delete_row
1356: ( p_api_version => p_api_version,
1357: p_init_msg_list => p_init_msg_list,

Line 1355: OKS_SUBSCR_HDR_PUB.delete_row

1351: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1352: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.undo_subscription.delete_osh.external_call.before',
1353: 'oks_subscr_hdr_pub.delete_row(p_schv_tbl(1).id = '||l_schv_tbl(1).id||')');
1354: END IF;
1355: OKS_SUBSCR_HDR_PUB.delete_row
1356: ( p_api_version => p_api_version,
1357: p_init_msg_list => p_init_msg_list,
1358: x_return_status => x_return_status,
1359: x_msg_count => x_msg_count,

Line 1365: 'oks_subscr_hdr_pub.delete_row(x_return_status = '||x_return_status||')');

1361: p_schv_tbl => l_schv_tbl
1362: );
1363: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1364: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.undo_subscription.delete_osh.external_call.after',
1365: 'oks_subscr_hdr_pub.delete_row(x_return_status = '||x_return_status||')');
1366: END IF;
1367: End delete_osh;
1368:
1369: Procedure delete_osp Is