DBA Data[Home] [Help]

APPS.OKS_QP_INT_PVT dependencies on OKC_CONTRACT_PUB

Line 1763: l_clev_rec_in okc_contract_pub.clev_rec_type;

1759: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
1760: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
1761: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
1762: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
1763: l_clev_rec_in okc_contract_pub.clev_rec_type;
1764: l_clev_rec_out okc_contract_pub.clev_rec_type;
1765: l_scev_rec_in oks_subscr_elems_pub.scev_rec_type;
1766: l_scev_rec_out oks_subscr_elems_pub.scev_rec_type;
1767: l_qpprod_quantity NUMBER;

Line 1764: l_clev_rec_out okc_contract_pub.clev_rec_type;

1760: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
1761: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
1762: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
1763: l_clev_rec_in okc_contract_pub.clev_rec_type;
1764: l_clev_rec_out okc_contract_pub.clev_rec_type;
1765: l_scev_rec_in oks_subscr_elems_pub.scev_rec_type;
1766: l_scev_rec_out oks_subscr_elems_pub.scev_rec_type;
1767: l_qpprod_quantity NUMBER;
1768: l_qpprod_uom_code VARCHAR2 (240);

Line 2386: okc_contract_pub.update_contract_line

2382: p_type => g_okc_line,
2383: x_k_det_rec => l_k_det_rec
2384: );
2385: l_clev_rec_in.object_version_number := l_k_det_rec.object_version_number;
2386: okc_contract_pub.update_contract_line
2387: (p_api_version => l_api_version,
2388: p_init_msg_list => l_init_msg_list,
2389: x_return_status => x_return_status,
2390: x_msg_count => x_msg_count,

Line 2721: l_clev_rec_in okc_contract_pub.clev_rec_type;

2717: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
2718: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
2719: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
2720: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
2721: l_clev_rec_in okc_contract_pub.clev_rec_type;
2722: l_clev_rec_out okc_contract_pub.clev_rec_type;
2723: l_prod_qty NUMBER;
2724: l_serv_qty NUMBER;
2725: l_status VARCHAR2 (30); --3912685

Line 2722: l_clev_rec_out okc_contract_pub.clev_rec_type;

2718: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
2719: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
2720: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
2721: l_clev_rec_in okc_contract_pub.clev_rec_type;
2722: l_clev_rec_out okc_contract_pub.clev_rec_type;
2723: l_prod_qty NUMBER;
2724: l_serv_qty NUMBER;
2725: l_status VARCHAR2 (30); --3912685
2726: --new variables for partial periods

Line 3239: okc_contract_pub.update_contract_line

3235: p_type => g_okc_line,
3236: x_k_det_rec => l_k_det_rec
3237: );
3238: l_clev_rec_in.object_version_number := l_k_det_rec.object_version_number;
3239: okc_contract_pub.update_contract_line
3240: (p_api_version => l_api_version,
3241: p_init_msg_list => l_init_msg_list,
3242: x_return_status => x_return_status,
3243: x_msg_count => x_msg_count,

Line 3397: l_clev_rec_in okc_contract_pub.clev_rec_type;

3393: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
3394: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
3395: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
3396: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
3397: l_clev_rec_in okc_contract_pub.clev_rec_type;
3398: l_clev_rec_out okc_contract_pub.clev_rec_type;
3399: l_subs_item BOOLEAN := FALSE;
3400: l_clvl_name VARCHAR2 (240);
3401: l_clvl_desc VARCHAR2 (1000);

Line 3398: l_clev_rec_out okc_contract_pub.clev_rec_type;

3394: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
3395: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
3396: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
3397: l_clev_rec_in okc_contract_pub.clev_rec_type;
3398: l_clev_rec_out okc_contract_pub.clev_rec_type;
3399: l_subs_item BOOLEAN := FALSE;
3400: l_clvl_name VARCHAR2 (240);
3401: l_clvl_desc VARCHAR2 (1000);
3402: l_tlvl_name VARCHAR2 (800);

Line 3671: okc_contract_pub.update_contract_line

3667: x_k_det_rec => l_k_det_rec
3668: );
3669: l_clev_rec_in.object_version_number :=
3670: l_k_det_rec.object_version_number;
3671: okc_contract_pub.update_contract_line
3672: (p_api_version => l_api_version,
3673: p_init_msg_list => l_init_msg_list,
3674: x_return_status => x_return_status,
3675: x_msg_count => x_msg_count,

Line 3855: okc_contract_pub.update_contract_line

3851: p_type => g_okc_line,
3852: x_k_det_rec => l_k_det_rec
3853: );
3854: l_clev_rec_in.object_version_number := l_k_det_rec.object_version_number;
3855: okc_contract_pub.update_contract_line
3856: (p_api_version => l_api_version,
3857: p_init_msg_list => l_init_msg_list,
3858: x_return_status => x_return_status,
3859: x_msg_count => x_msg_count,

Line 4362: l_clev_rec_in okc_contract_pub.clev_rec_type;

4358: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
4359: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
4360: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
4361: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
4362: l_clev_rec_in okc_contract_pub.clev_rec_type;
4363: l_clev_rec_out okc_contract_pub.clev_rec_type;
4364: l_subs_item boolean := false;
4365: l_clvl_name varchar2 (240);
4366: l_clvl_desc varchar2 (1000);

Line 4363: l_clev_rec_out okc_contract_pub.clev_rec_type;

4359: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
4360: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
4361: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
4362: l_clev_rec_in okc_contract_pub.clev_rec_type;
4363: l_clev_rec_out okc_contract_pub.clev_rec_type;
4364: l_subs_item boolean := false;
4365: l_clvl_name varchar2 (240);
4366: l_clvl_desc varchar2 (1000);
4367: l_tlvl_name varchar2 (800);

Line 5828: okc_contract_pub.update_contract_line

5824: x_k_det_rec => l_k_det_rec
5825: );
5826: l_clev_rec_in.object_version_number :=
5827: l_k_det_rec.object_version_number;
5828: okc_contract_pub.update_contract_line
5829: (p_api_version => l_api_version,
5830: p_init_msg_list => l_init_msg_list,
5831: x_return_status => x_return_status,
5832: x_msg_count => x_msg_count,

Line 6019: okc_contract_pub.update_contract_line

6015: p_type => g_okc_line,
6016: x_k_det_rec => l_k_det_rec
6017: );
6018: l_clev_rec_in.object_version_number := l_k_det_rec.object_version_number;
6019: okc_contract_pub.update_contract_line
6020: (p_api_version => l_api_version,
6021: p_init_msg_list => l_init_msg_list,
6022: x_return_status => x_return_status,
6023: x_msg_count => x_msg_count,

Line 6119: l_chrv_rec_in okc_contract_pub.chrv_rec_type;

6115: AND date_terminated IS NULL -- bug 5504157
6116: ORDER BY line_number;
6117:
6118: l_input_details oks_qp_pkg.input_details;
6119: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
6120: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
6121: l_k_det_rec k_details_rec;
6122: BEGIN
6123: -- start debug log

Line 6120: l_chrv_rec_out okc_contract_pub.chrv_rec_type;

6116: ORDER BY line_number;
6117:
6118: l_input_details oks_qp_pkg.input_details;
6119: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
6120: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
6121: l_k_det_rec k_details_rec;
6122: BEGIN
6123: -- start debug log
6124: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 6279: okc_contract_pub.update_contract_header

6275: p_type => g_okc_hdr,
6276: x_k_det_rec => l_k_det_rec
6277: );
6278: l_chrv_rec_in.object_version_number := l_k_det_rec.object_version_number;
6279: okc_contract_pub.update_contract_header
6280: (p_api_version => l_api_version,
6281: p_init_msg_list => l_init_msg_list,
6282: x_return_status => x_return_status,
6283: x_msg_count => x_msg_count,

Line 6367: l_chrv_rec_in okc_contract_pub.chrv_rec_type;

6363: := 'compute_price';
6364: l_input_detail_rec oks_qp_pkg.input_details
6365: := p_detail_rec;
6366: l_k_det_rec k_details_rec;
6367: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
6368: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
6369: l_clev_rec_in okc_contract_pub.clev_rec_type;
6370: l_clev_rec_out okc_contract_pub.clev_rec_type;
6371: BEGIN

Line 6368: l_chrv_rec_out okc_contract_pub.chrv_rec_type;

6364: l_input_detail_rec oks_qp_pkg.input_details
6365: := p_detail_rec;
6366: l_k_det_rec k_details_rec;
6367: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
6368: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
6369: l_clev_rec_in okc_contract_pub.clev_rec_type;
6370: l_clev_rec_out okc_contract_pub.clev_rec_type;
6371: BEGIN
6372: -- start debug log

Line 6369: l_clev_rec_in okc_contract_pub.clev_rec_type;

6365: := p_detail_rec;
6366: l_k_det_rec k_details_rec;
6367: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
6368: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
6369: l_clev_rec_in okc_contract_pub.clev_rec_type;
6370: l_clev_rec_out okc_contract_pub.clev_rec_type;
6371: BEGIN
6372: -- start debug log
6373: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 6370: l_clev_rec_out okc_contract_pub.clev_rec_type;

6366: l_k_det_rec k_details_rec;
6367: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
6368: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
6369: l_clev_rec_in okc_contract_pub.clev_rec_type;
6370: l_clev_rec_out okc_contract_pub.clev_rec_type;
6371: BEGIN
6372: -- start debug log
6373: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
6374: THEN

Line 6601: okc_contract_pub.update_contract_header

6597: x_k_det_rec => l_k_det_rec
6598: );
6599: l_chrv_rec_in.object_version_number :=
6600: l_k_det_rec.object_version_number;
6601: okc_contract_pub.update_contract_header
6602: (p_api_version => l_api_version,
6603: p_init_msg_list => l_init_msg_list,
6604: x_return_status => x_return_status,
6605: x_msg_count => x_msg_count,

Line 6715: okc_contract_pub.update_contract_line

6711: x_k_det_rec => l_k_det_rec
6712: );
6713: l_clev_rec_in.object_version_number :=
6714: l_k_det_rec.object_version_number;
6715: okc_contract_pub.update_contract_line
6716: (p_api_version => l_api_version,
6717: p_init_msg_list => l_init_msg_list,
6718: x_return_status => x_return_status,
6719: x_msg_count => x_msg_count,

Line 6740: okc_contract_pub.update_contract_header

6736: x_k_det_rec => l_k_det_rec
6737: );
6738: l_chrv_rec_in.object_version_number :=
6739: l_k_det_rec.object_version_number;
6740: okc_contract_pub.update_contract_header
6741: (p_api_version => l_api_version,
6742: p_init_msg_list => l_init_msg_list,
6743: x_return_status => x_return_status,
6744: x_msg_count => x_msg_count,

Line 6884: okc_contract_pub.update_contract_header

6880: );
6881: END IF;
6882:
6883: -- errorout ('Amount = ' || l_chrv_rec_in.estimated_amount);
6884: okc_contract_pub.update_contract_header
6885: (p_api_version => l_api_version,
6886: p_init_msg_list => l_init_msg_list,
6887: x_return_status => x_return_status,
6888: x_msg_count => x_msg_count,

Line 6998: okc_contract_pub.update_contract_line

6994: x_k_det_rec => l_k_det_rec
6995: );
6996: l_clev_rec_in.object_version_number :=
6997: l_k_det_rec.object_version_number;
6998: okc_contract_pub.update_contract_line
6999: (p_api_version => l_api_version,
7000: p_init_msg_list => l_init_msg_list,
7001: x_return_status => x_return_status,
7002: x_msg_count => x_msg_count,

Line 7023: okc_contract_pub.update_contract_header

7019: x_k_det_rec => l_k_det_rec
7020: );
7021: l_chrv_rec_in.object_version_number :=
7022: l_k_det_rec.object_version_number;
7023: okc_contract_pub.update_contract_header
7024: (p_api_version => l_api_version,
7025: p_init_msg_list => l_init_msg_list,
7026: x_return_status => x_return_status,
7027: x_msg_count => x_msg_count,