DBA Data[Home] [Help]

APPS.OKS_MASS_UPDATE_PVT dependencies on OKS_IB_UTIL_PVT

Line 4224: oks_ib_util_pvt.check_termcancel_lines

4220: l_chrv_tbl_in.DELETE;
4221:
4222: IF get_ste_code(p_Contract_Status) = 'ENTERED'
4223: THEN
4224: oks_ib_util_pvt.check_termcancel_lines
4225: (p_line_id => contract_id,
4226: p_line_type => 'TL',
4227: p_txn_type => 'C',
4228: x_date => l_cancel_date

Line 4261: oks_ib_util_pvt.check_termcancel_lines

4257: END IF;
4258:
4259: END IF;
4260: ELSE
4261: oks_ib_util_pvt.check_termcancel_lines
4262: (p_line_id => Contract_id,
4263: p_line_type => 'TL',
4264: p_txn_type => 'T',
4265: x_date => l_term_date

Line 4360: oks_ib_util_pvt.check_termcancel_lines

4356: l_return_status := FND_API.G_RET_STS_SUCCESS;
4357:
4358: IF get_ste_code(line_status)= 'ENTERED'
4359: THEN
4360: oks_ib_util_pvt.check_termcancel_lines
4361: (p_line_id => Service_line_id,
4362: p_line_type => 'SL',
4363: p_txn_type => 'C',
4364: x_date => l_cancel_date

Line 4396: oks_ib_util_pvt.check_termcancel_lines

4392: End if;
4393:
4394: END IF;
4395: ELSE
4396: oks_ib_util_pvt.check_termcancel_lines
4397: (p_line_id => Service_line_id,
4398: p_line_type => 'SL',
4399: p_txn_type => 'T',
4400: x_date => l_term_date

Line 6117: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),

6113: tmp.transaction_date,
6114: Party.object1_id1,
6115: Kh.authoring_org_id,
6116: NVL(P_credit_option
6117: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6118: Kh.inv_organization_id
6119: FROM okc_k_items ki,
6120: okc_k_headers_all_b kh,
6121: oks_k_headers_b ks,

Line 6207: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),

6203: ki.number_of_items,
6204: tmp.transaction_date,
6205: Kh.authoring_org_id,
6206: NVL(P_credit_option
6207: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6208: Kh.inv_organization_id
6209:
6210: FROM okc_k_items ki,
6211: okc_k_headers_all_b kh,

Line 6288: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),

6284: kl.price_negotiated AS price_negotiated,
6285: party.object1_id1 party_id,
6286: kh.authoring_org_id,
6287: NVL(P_credit_option
6288: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6289: Kh.inv_organization_id
6290: FROM okc_k_items ki,
6291: okc_k_headers_all_b kh,
6292: okc_k_lines_b kl,

Line 6349: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),

6345: kl.price_negotiated AS price_negotiated,
6346: party.object1_id1 party_id,
6347: kh.authoring_org_id,
6348: NVL(P_credit_option
6349: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6350: Kh.inv_organization_id
6351:
6352:
6353:

Line 7663: L_line_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_Sublines(l_object_line_id);

7659: Update okc_k_lines_b set date_renewed = trf_date(1)
7660: Where id = l_object_line_id
7661: And date_renewed is null;
7662:
7663: L_line_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_Sublines(l_object_line_id);
7664: Update okc_k_lines_b set date_renewed = l_line_date_renewed
7665: Where id = (select cle_id from okc_k_lines_b where id = l_object_line_id)
7666: And date_renewed Is Null;
7667:

Line 7668: l_hdr_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_lines(l_object_line_id);

7664: Update okc_k_lines_b set date_renewed = l_line_date_renewed
7665: Where id = (select cle_id from okc_k_lines_b where id = l_object_line_id)
7666: And date_renewed Is Null;
7667:
7668: l_hdr_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_lines(l_object_line_id);
7669: Update okc_k_headers_all_b set date_renewed = l_line_date_renewed
7670: Where id = (select dnz_chr_id from okc_k_lines_b where id = l_object_line_id)
7671: And date_renewed Is Null;
7672: