APPS.OKS_SUBSCRIPTION_PVT dependencies on OKS_SUBSCR_HEADER_B

Line 444: From oks_subscr_header_b

440: instance_id,
441: frequency,
442: fulfillment_channel,
443: offset
444: From oks_subscr_header_b
445: Where cle_id = p_cle_id;
446:
447: Cursor unitprice_cur Is
448: Select NVL(amount,0)/quantity unitprice, uom_code

Line 931: FROM oks_subscr_header_b

927: l_instance_id Number;
928: l_item_type Varchar2(10);
929: CURSOR osh_cur IS
930: SELECT id,item_type
931: FROM oks_subscr_header_b
932: WHERE cle_id = p_cle_id;
933: gen_exit EXCEPTION;
934: Begin
935: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 977: 'oks_subscr_header_b(id = '||l_osh_id||', instance_id = '||l_instance_id||')');

973: Raise gen_exit;
974: End If;
975: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
976: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.recreate_instance.updhdr.before',
977: 'oks_subscr_header_b(id = '||l_osh_id||', instance_id = '||l_instance_id||')');
978: END IF;
979: UPDATE oks_subscr_header_b
980: SET instance_id = l_instance_id
981: WHERE id = l_osh_id;

Line 979: UPDATE oks_subscr_header_b

975: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
976: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.recreate_instance.updhdr.before',
977: 'oks_subscr_header_b(id = '||l_osh_id||', instance_id = '||l_instance_id||')');
978: END IF;
979: UPDATE oks_subscr_header_b
980: SET instance_id = l_instance_id
981: WHERE id = l_osh_id;
982: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
983: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.recreate_instance.updhdr.after',' ');

Line 1298: From oks_subscr_header_b

1294:
1295: Procedure delete_cii Is
1296: Cursor schv_cur Is
1297: Select id, instance_id, fulfillment_channel
1298: From oks_subscr_header_b
1299: Where cle_id = p_cle_id;
1300: /* No Item instance deletion for release 11.5.9 and 11.5.10
1301: l_instance_id Number;
1302: Cursor other_osh_inst Is

Line 1304: From oks_subscr_header_b

1300: /* No Item instance deletion for release 11.5.9 and 11.5.10
1301: l_instance_id Number;
1302: Cursor other_osh_inst Is
1303: Select Null
1304: From oks_subscr_header_b
1305: Where instance_id = l_instance_id
1306: And cle_id <> p_cle_id;
1307: l_dummy Number;
1308: */

Line 1668: From oks_subscr_header_b

1664: From okc_k_items
1665: Where cle_id = p_cle_id;
1666: Cursor subs_hdr Is
1667: Select item_type, frequency
1668: From oks_subscr_header_b
1669: Where cle_id = p_cle_id;
1670: Cursor subs_qty Is
1671: Select sum(quantity)
1672: From oks_subscr_elements

Line 1864: From oks_subscr_header_b

1860: Where id = p_cle_id
1861: And lse_id = 46;
1862: Cursor osh_cur Is
1863: Select item_type, frequency
1864: From oks_subscr_header_b
1865: Where cle_id = p_cle_id;
1866: Cursor trmn_amt_cur Is
1867: Select sum(amount)
1868: From oks_subscr_elements

Line 2076: Select item_type From oks_subscr_header_b Where cle_id = p_cle_id;

2072: Function is_subs_tangible
2073: ( p_cle_id IN NUMBER
2074: ) Return BOOLEAN IS
2075: Cursor subs_hdr Is
2076: Select item_type From oks_subscr_header_b Where cle_id = p_cle_id;
2077: l_type Varchar2(240);
2078: l_tangible Boolean := FALSE;
2079: Begin
2080: Open subs_hdr;