DBA Data[Home] [Help]

APPS.OKS_MASSCHANGE_PVT dependencies on OKC_CTC_PVT

Line 7181: l_ctcv_rec_in okc_ctc_pvt.ctcv_rec_type;

7177:
7178: l_klnv_tbl_type_in oks_contract_line_pub.klnv_tbl_type ;
7179: l_klnv_tbl_type_out oks_contract_line_pub.klnv_tbl_type ;
7180:
7181: l_ctcv_rec_in okc_ctc_pvt.ctcv_rec_type;
7182: l_ctcv_rec_out okc_ctc_pvt.ctcv_rec_type;
7183:
7184: l_ctcv_tbl_in okc_ctc_pvt.ctcv_tbl_type;
7185: l_ctcv_tbl_out okc_ctc_pvt.ctcv_tbl_type;

Line 7182: l_ctcv_rec_out okc_ctc_pvt.ctcv_rec_type;

7178: l_klnv_tbl_type_in oks_contract_line_pub.klnv_tbl_type ;
7179: l_klnv_tbl_type_out oks_contract_line_pub.klnv_tbl_type ;
7180:
7181: l_ctcv_rec_in okc_ctc_pvt.ctcv_rec_type;
7182: l_ctcv_rec_out okc_ctc_pvt.ctcv_rec_type;
7183:
7184: l_ctcv_tbl_in okc_ctc_pvt.ctcv_tbl_type;
7185: l_ctcv_tbl_out okc_ctc_pvt.ctcv_tbl_type;
7186:

Line 7184: l_ctcv_tbl_in okc_ctc_pvt.ctcv_tbl_type;

7180:
7181: l_ctcv_rec_in okc_ctc_pvt.ctcv_rec_type;
7182: l_ctcv_rec_out okc_ctc_pvt.ctcv_rec_type;
7183:
7184: l_ctcv_tbl_in okc_ctc_pvt.ctcv_tbl_type;
7185: l_ctcv_tbl_out okc_ctc_pvt.ctcv_tbl_type;
7186:
7187: l_rdsv_rec_in oks_rev_distr_pub.rdsv_rec_type;
7188: l_rdsv_rec_out oks_rev_distr_pub.rdsv_rec_type;

Line 7185: l_ctcv_tbl_out okc_ctc_pvt.ctcv_tbl_type;

7181: l_ctcv_rec_in okc_ctc_pvt.ctcv_rec_type;
7182: l_ctcv_rec_out okc_ctc_pvt.ctcv_rec_type;
7183:
7184: l_ctcv_tbl_in okc_ctc_pvt.ctcv_tbl_type;
7185: l_ctcv_tbl_out okc_ctc_pvt.ctcv_tbl_type;
7186:
7187: l_rdsv_rec_in oks_rev_distr_pub.rdsv_rec_type;
7188: l_rdsv_rec_out oks_rev_distr_pub.rdsv_rec_type;
7189:

Line 8503: OKC_CTC_PVT.lock_row(

8499: END LOOP;
8500:
8501: IF l_ctcv_rec_in.id is NOT NULL
8502: AND l_ctcv_rec_in.id <> OKC_API.G_MISS_NUM then
8503: OKC_CTC_PVT.lock_row(
8504: p_api_version => l_api_version,
8505: p_init_msg_list => l_init_msg_list,
8506: x_return_status => l_return_status,
8507: x_msg_count => l_msg_count,

Line 8519: OKC_CTC_PVT.update_row(

8515: (p_salesrep_id => l_new_value_id,
8516: p_org_id => Okc_context.get_okc_org_id,
8517: p_date => l_start_date);
8518:
8519: OKC_CTC_PVT.update_row(
8520: p_api_version => l_api_version,
8521: p_init_msg_list => l_init_msg_list,
8522: x_return_status => l_return_status,
8523: x_msg_count => l_msg_count,

Line 8741: OKC_CTC_PVT.lock_row(

8737: l_ctcv_rec_in.id := contact_rec.id;
8738: l_ctcv_rec_in.object_version_number := contact_rec.object_version_number;
8739: END LOOP;
8740: If l_ctcv_rec_in.id Is Not null Then
8741: OKC_CTC_PVT.lock_row(
8742: p_api_version => l_api_version,
8743: p_init_msg_list => l_init_msg_list,
8744: x_return_status => l_return_status,
8745: x_msg_count => l_msg_count,

Line 8753: OKC_CTC_PVT.update_row(

8749: IF l_return_status = G_RET_STS_SUCCESS THEN
8750:
8751: l_ctcv_rec_in.object1_id1 := l_new_value_id;
8752:
8753: OKC_CTC_PVT.update_row(
8754: p_api_version => l_api_version,
8755: p_init_msg_list => l_init_msg_list,
8756: x_return_status => l_return_status,
8757: x_msg_count => l_msg_count,

Line 8814: OKC_CTC_PVT.lock_row(

8810: l_ctcv_rec_in.object_version_number := contact_rec.object_version_number;
8811: LOG_MESSAGES('Inside PARTY_BILLING_CONTACT:'||l_ctcv_rec_in.id);
8812: END LOOP;
8813: If l_ctcv_rec_in.id is not null Then
8814: OKC_CTC_PVT.lock_row(
8815: p_api_version => l_api_version,
8816: p_init_msg_list => l_init_msg_list,
8817: x_return_status => l_return_status,
8818: x_msg_count => l_msg_count,

Line 8822: LOG_MESSAGES('After OKC_CTC_PVT.lock_row, status:'||l_return_status);

8818: x_msg_count => l_msg_count,
8819: x_msg_data => l_msg_data,
8820: p_ctcv_rec => l_ctcv_rec_in);
8821:
8822: LOG_MESSAGES('After OKC_CTC_PVT.lock_row, status:'||l_return_status);
8823: IF l_return_status = G_RET_STS_SUCCESS THEN
8824:
8825: l_ctcv_rec_in.object1_id1 := l_new_value_id;
8826: l_return_status := NULL;

Line 8827: OKC_CTC_PVT.update_row(

8823: IF l_return_status = G_RET_STS_SUCCESS THEN
8824:
8825: l_ctcv_rec_in.object1_id1 := l_new_value_id;
8826: l_return_status := NULL;
8827: OKC_CTC_PVT.update_row(
8828: p_api_version => l_api_version,
8829: p_init_msg_list => l_init_msg_list,
8830: x_return_status => l_return_status,
8831: x_msg_count => l_msg_count,

Line 8835: LOG_MESSAGES('After OKC_CTC_PVT.update_row, status:'||l_return_status);

8831: x_msg_count => l_msg_count,
8832: x_msg_data => l_msg_data,
8833: p_ctcv_rec => l_ctcv_rec_in,
8834: x_ctcv_rec => l_ctcv_rec_out);
8835: LOG_MESSAGES('After OKC_CTC_PVT.update_row, status:'||l_return_status);
8836: IF l_return_status = G_RET_STS_SUCCESS THEN
8837: LOG_MESSAGES('PARTY_BILLING_CONTACT update status: '||l_return_status);
8838:
8839: ELSE

Line 8895: OKC_CTC_PVT.lock_row(

8891: l_ctcv_tbl_in(cnt).object1_id1 := l_new_value_id ;
8892: cnt := cnt + 1 ;
8893: END LOOP;
8894: If l_ctcv_tbl_in.count > 0 Then
8895: OKC_CTC_PVT.lock_row(
8896: p_api_version => l_api_version,
8897: p_init_msg_list => l_init_msg_list,
8898: x_return_status => l_return_status,
8899: x_msg_count => l_msg_count,

Line 8907: OKC_CTC_PVT.update_row(

8903: IF l_return_status = G_RET_STS_SUCCESS THEN
8904:
8905: -- l_ctcv_rec_in.object1_id1 := l_new_value_id;
8906:
8907: OKC_CTC_PVT.update_row(
8908: p_api_version => l_api_version,
8909: p_init_msg_list => l_init_msg_list,
8910: x_return_status => l_return_status,
8911: x_msg_count => l_msg_count,

Line 8973: OKC_CTC_PVT.lock_row(

8969: l_ctcv_tbl_in(cnt).object1_id1 := l_new_value_id;
8970: cnt := cnt + 1 ;
8971: END LOOP;
8972: If l_ctcv_tbl_in.count > 0 Then
8973: OKC_CTC_PVT.lock_row(
8974: p_api_version => l_api_version,
8975: p_init_msg_list => l_init_msg_list,
8976: x_return_status => l_return_status,
8977: x_msg_count => l_msg_count,

Line 8985: OKC_CTC_PVT.update_row(

8981: IF l_return_status = G_RET_STS_SUCCESS THEN
8982:
8983: -- l_ctcv_rec_in.object1_id1 := l_new_value_id;
8984: -- l_return_status := NULL;
8985: OKC_CTC_PVT.update_row(
8986: p_api_version => l_api_version,
8987: p_init_msg_list => l_init_msg_list,
8988: x_return_status => l_return_status,
8989: x_msg_count => l_msg_count,

Line 9986: OKC_CTC_PVT.lock_row(

9982: l_ctcv_tbl_in(cnt).object1_id1 := l_new_value_id;
9983: cnt := cnt + 1 ;
9984: END LOOP;
9985: If l_ctcv_tbl_in.count > 0 Then
9986: OKC_CTC_PVT.lock_row(
9987: p_api_version => l_api_version,
9988: p_init_msg_list => l_init_msg_list,
9989: x_return_status => l_return_status,
9990: x_msg_count => l_msg_count,

Line 9999: OKC_CTC_PVT.update_row(

9995:
9996: -- l_ctcv_rec_in.object1_id1 := l_new_value_id;
9997: -- l_return_status := NULL;
9998:
9999: OKC_CTC_PVT.update_row(
10000: p_api_version => l_api_version,
10001: p_init_msg_list => l_init_msg_list,
10002: x_return_status => l_return_status,
10003: x_msg_count => l_msg_count,

Line 10066: OKC_CTC_PVT.lock_row(

10062: l_ctcv_tbl_in(cnt).object1_id1 := l_new_value_id;
10063: cnt := cnt + 1 ;
10064: END LOOP;
10065: If l_ctcv_tbl_in.count > 0 Then
10066: OKC_CTC_PVT.lock_row(
10067: p_api_version => l_api_version,
10068: p_init_msg_list => l_init_msg_list,
10069: x_return_status => l_return_status,
10070: x_msg_count => l_msg_count,

Line 10076: OKC_CTC_PVT.update_row(

10072: p_ctcv_tbl => l_ctcv_tbl_in);
10073:
10074: IF l_return_status = G_RET_STS_SUCCESS THEN
10075:
10076: OKC_CTC_PVT.update_row(
10077: p_api_version => l_api_version,
10078: p_init_msg_list => l_init_msg_list,
10079: x_return_status => l_return_status,
10080: x_msg_count => l_msg_count,