DBA Data[Home] [Help]

APPS.OKS_MASS_UPDATE_PVT dependencies on OKS_IB_UTIL_PVT

Line 4229: oks_ib_util_pvt.check_termcancel_lines

4225: l_chrv_tbl_in.DELETE;
4226:
4227: IF get_ste_code(p_Contract_Status) = 'ENTERED'
4228: THEN
4229: oks_ib_util_pvt.check_termcancel_lines
4230: (p_line_id => contract_id,
4231: p_line_type => 'TL',
4232: p_txn_type => 'C',
4233: x_date => l_cancel_date

Line 4266: oks_ib_util_pvt.check_termcancel_lines

4262: END IF;
4263:
4264: END IF;
4265: ELSE
4266: oks_ib_util_pvt.check_termcancel_lines
4267: (p_line_id => Contract_id,
4268: p_line_type => 'TL',
4269: p_txn_type => 'T',
4270: x_date => l_term_date

Line 4365: oks_ib_util_pvt.check_termcancel_lines

4361: l_return_status := FND_API.G_RET_STS_SUCCESS;
4362:
4363: IF get_ste_code(line_status)= 'ENTERED'
4364: THEN
4365: oks_ib_util_pvt.check_termcancel_lines
4366: (p_line_id => Service_line_id,
4367: p_line_type => 'SL',
4368: p_txn_type => 'C',
4369: x_date => l_cancel_date

Line 4401: oks_ib_util_pvt.check_termcancel_lines

4397: End if;
4398:
4399: END IF;
4400: ELSE
4401: oks_ib_util_pvt.check_termcancel_lines
4402: (p_line_id => Service_line_id,
4403: p_line_type => 'SL',
4404: p_txn_type => 'T',
4405: x_date => l_term_date

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

6130: tmp.transaction_date,
6131: Party.object1_id1,
6132: Kh.authoring_org_id,
6133: NVL(P_credit_option
6134: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6135: Kh.inv_organization_id
6136: FROM okc_k_items ki,
6137: okc_k_headers_all_b kh,
6138: oks_k_headers_b ks,

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

6220: ki.number_of_items,
6221: tmp.transaction_date,
6222: Kh.authoring_org_id,
6223: NVL(P_credit_option
6224: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6225: Kh.inv_organization_id
6226:
6227: FROM okc_k_items ki,
6228: okc_k_headers_all_b kh,

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

6301: kl.price_negotiated AS price_negotiated,
6302: party.object1_id1 party_id,
6303: kh.authoring_org_id,
6304: NVL(P_credit_option
6305: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6306: Kh.inv_organization_id
6307: FROM okc_k_items ki,
6308: okc_k_headers_all_b kh,
6309: okc_k_lines_b kl,

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

6362: kl.price_negotiated AS price_negotiated,
6363: party.object1_id1 party_id,
6364: kh.authoring_org_id,
6365: NVL(P_credit_option
6366: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6367: Kh.inv_organization_id
6368:
6369:
6370:

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

7676: Update okc_k_lines_b set date_renewed = trf_date(1)
7677: Where id = l_object_line_id
7678: And date_renewed is null;
7679:
7680: L_line_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_Sublines(l_object_line_id);
7681: Update okc_k_lines_b set date_renewed = l_line_date_renewed
7682: Where id = (select cle_id from okc_k_lines_b where id = l_object_line_id)
7683: And date_renewed Is Null;
7684:

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

7681: Update okc_k_lines_b set date_renewed = l_line_date_renewed
7682: Where id = (select cle_id from okc_k_lines_b where id = l_object_line_id)
7683: And date_renewed Is Null;
7684:
7685: l_hdr_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_lines(l_object_line_id);
7686: Update okc_k_headers_all_b set date_renewed = l_line_date_renewed
7687: Where id = (select dnz_chr_id from okc_k_lines_b where id = l_object_line_id)
7688: And date_renewed Is Null;
7689: