eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_SUBSCRIPTION_PVT dependencies on OKS_SUBSCRIPTION_SCH_PVT

Line 46: l_pattern_tbl OKS_SUBSCRIPTION_SCH_PVT.pattern_tbl;

42: l_ptrns_tbl_in OKS_SUBSCR_PTRNS_PVT.scpv_tbl_type;
43: l_ptrns_tbl_out OKS_SUBSCR_PTRNS_PVT.scpv_tbl_type;
44: l_elems_tbl_in OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;
45: l_elems_tbl_out OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;
46: l_pattern_tbl OKS_SUBSCRIPTION_SCH_PVT.pattern_tbl;
47: l_delivery_tbl OKS_SUBSCRIPTION_SCH_PVT.del_tbl;
48: -- Pricing Parameters
49: l_price_details_in OKS_QP_PKG.INPUT_DETAILS;
50: x_price_details_out OKS_QP_PKG.PRICE_DETAILS;

Line 47: l_delivery_tbl OKS_SUBSCRIPTION_SCH_PVT.del_tbl;

43: l_ptrns_tbl_out OKS_SUBSCR_PTRNS_PVT.scpv_tbl_type;
44: l_elems_tbl_in OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;
45: l_elems_tbl_out OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;
46: l_pattern_tbl OKS_SUBSCRIPTION_SCH_PVT.pattern_tbl;
47: l_delivery_tbl OKS_SUBSCRIPTION_SCH_PVT.del_tbl;
48: -- Pricing Parameters
49: l_price_details_in OKS_QP_PKG.INPUT_DETAILS;
50: x_price_details_out OKS_QP_PKG.PRICE_DETAILS;
51: x_mo_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

Line 279: 'oks_subscription_sch_pvt.calc_delivery_date');

275: l_pattern_tbl(1).wday_pattern := l_ptrns_tbl_out(1).week_day;
276: l_pattern_tbl(1).day_pattern := l_ptrns_tbl_out(1).day;
277: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
278: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.create_default_schedule.external_call.before',
279: 'oks_subscription_sch_pvt.calc_delivery_date');
280: END IF;
281: OKS_SUBSCRIPTION_SCH_PVT.calc_delivery_date
282: (
283: p_start_dt => l_start_date,

Line 281: OKS_SUBSCRIPTION_SCH_PVT.calc_delivery_date

277: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
278: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.create_default_schedule.external_call.before',
279: 'oks_subscription_sch_pvt.calc_delivery_date');
280: END IF;
281: OKS_SUBSCRIPTION_SCH_PVT.calc_delivery_date
282: (
283: p_start_dt => l_start_date,
284: p_end_dt => l_end_date,
285: p_offset_dy => NULL,

Line 293: 'oks_subscription_sch_pvt.calc_delivery_date(x_return_status = '||x_return_status||')');

289: x_return_status => x_return_status
290: );
291: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
292: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.create_default_schedule.external_call.after',
293: 'oks_subscription_sch_pvt.calc_delivery_date(x_return_status = '||x_return_status||')');
294: END IF;
295: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then
296: Raise gen_exit;
297: end if;

Line 475: l_pattern_tbl OKS_SUBSCRIPTION_SCH_PVT.pattern_tbl;

471: l_elems_tbl_ins_in OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;
472: l_elems_tbl_upd_in OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;
473: l_elems_tbl_del_in OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;
474: l_elems_tbl_out OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;
475: l_pattern_tbl OKS_SUBSCRIPTION_SCH_PVT.pattern_tbl;
476: l_delivery_tbl OKS_SUBSCRIPTION_SCH_PVT.del_tbl;
477: l_hdr_tbl_in OKS_SUBSCR_HDR_PVT.schv_tbl_type;
478: l_hdr_tbl_out OKS_SUBSCR_HDR_PVT.schv_tbl_type;
479: tmp_elem_tbl tel_tbl_type;

Line 476: l_delivery_tbl OKS_SUBSCRIPTION_SCH_PVT.del_tbl;

472: l_elems_tbl_upd_in OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;
473: l_elems_tbl_del_in OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;
474: l_elems_tbl_out OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;
475: l_pattern_tbl OKS_SUBSCRIPTION_SCH_PVT.pattern_tbl;
476: l_delivery_tbl OKS_SUBSCRIPTION_SCH_PVT.del_tbl;
477: l_hdr_tbl_in OKS_SUBSCR_HDR_PVT.schv_tbl_type;
478: l_hdr_tbl_out OKS_SUBSCR_HDR_PVT.schv_tbl_type;
479: tmp_elem_tbl tel_tbl_type;
480: -- Pricing Parameters

Line 692: 'oks_subscription_sch_pvt.calc_delivery_date');

688: end if;
689: End If;
690: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
691: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_schedule.external_call.before',
692: 'oks_subscription_sch_pvt.calc_delivery_date');
693: END IF;
694: OKS_SUBSCRIPTION_SCH_PVT.calc_delivery_date
695: (
696: p_start_dt => l_start_date,

Line 694: OKS_SUBSCRIPTION_SCH_PVT.calc_delivery_date

690: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
691: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_schedule.external_call.before',
692: 'oks_subscription_sch_pvt.calc_delivery_date');
693: END IF;
694: OKS_SUBSCRIPTION_SCH_PVT.calc_delivery_date
695: (
696: p_start_dt => l_start_date,
697: p_end_dt => l_end_date,
698: p_offset_dy => l_offset,

Line 706: 'oks_subscription_sch_pvt.calc_delivery_date(x_return_status = '||x_return_status||')');

702: x_return_status => x_return_status
703: );
704: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
705: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_schedule.external_call.after',
706: 'oks_subscription_sch_pvt.calc_delivery_date(x_return_status = '||x_return_status||')');
707: END IF;
708: If nvl(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS Then
709: Raise gen_exit;
710: End If;

Line 2163: l_pattern_tbl OKS_SUBSCRIPTION_SCH_PVT.pattern_tbl;

2159:
2160: l_sub_template_rec get_template_dtls_csr%RowTYPE;
2161: l_subscription_template_id NUMBER;
2162: l_sub_template_id NUMBER;
2163: l_pattern_tbl OKS_SUBSCRIPTION_SCH_PVT.pattern_tbl;
2164: l_delivery_tbl OKS_SUBSCRIPTION_SCH_PVT.del_tbl;
2165: l_subscription_factor NUMBER;
2166: l_return_status VARCHAR2(100);
2167: l_pricing_method VARCHAR2(1000);

Line 2164: l_delivery_tbl OKS_SUBSCRIPTION_SCH_PVT.del_tbl;

2160: l_sub_template_rec get_template_dtls_csr%RowTYPE;
2161: l_subscription_template_id NUMBER;
2162: l_sub_template_id NUMBER;
2163: l_pattern_tbl OKS_SUBSCRIPTION_SCH_PVT.pattern_tbl;
2164: l_delivery_tbl OKS_SUBSCRIPTION_SCH_PVT.del_tbl;
2165: l_subscription_factor NUMBER;
2166: l_return_status VARCHAR2(100);
2167: l_pricing_method VARCHAR2(1000);
2168: l_start_date DATE;

Line 2241: /* IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.create_default_schedule.external_call.before', 'oks_subscription_sch_pvt.calc_delivery_date');

2237: l_pattern_tbl(1).day_pattern := '*';
2238:
2239: END IF;
2240:
2241: /* IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.create_default_schedule.external_call.before', 'oks_subscription_sch_pvt.calc_delivery_date');
2242:
2243: END IF; */
2244:
2245: OKS_SUBSCRIPTION_SCH_PVT.calc_delivery_date ( p_start_dt => Trunc(To_Date(p_start_date)),

Line 2245: OKS_SUBSCRIPTION_SCH_PVT.calc_delivery_date ( p_start_dt => Trunc(To_Date(p_start_date)),

2241: /* IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.create_default_schedule.external_call.before', 'oks_subscription_sch_pvt.calc_delivery_date');
2242:
2243: END IF; */
2244:
2245: OKS_SUBSCRIPTION_SCH_PVT.calc_delivery_date ( p_start_dt => Trunc(To_Date(p_start_date)),
2246: p_end_dt => Trunc(To_Date(p_end_date)),
2247: p_offset_dy => NULL,
2248: p_freq => l_sub_template_rec.frequency,
2249: p_pattern_tbl => l_pattern_tbl,