DBA Data[Home] [Help]

APPS.OKS_QP_INT_PVT dependencies on OKC_CONTRACT_PUB

Line 1741: l_clev_rec_in okc_contract_pub.clev_rec_type;

1737: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
1738: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
1739: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
1740: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
1741: l_clev_rec_in okc_contract_pub.clev_rec_type;
1742: l_clev_rec_out okc_contract_pub.clev_rec_type;
1743: l_scev_rec_in oks_subscr_elems_pub.scev_rec_type;
1744: l_scev_rec_out oks_subscr_elems_pub.scev_rec_type;
1745: l_qpprod_quantity NUMBER;

Line 1742: l_clev_rec_out okc_contract_pub.clev_rec_type;

1738: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
1739: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
1740: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
1741: l_clev_rec_in okc_contract_pub.clev_rec_type;
1742: l_clev_rec_out okc_contract_pub.clev_rec_type;
1743: l_scev_rec_in oks_subscr_elems_pub.scev_rec_type;
1744: l_scev_rec_out oks_subscr_elems_pub.scev_rec_type;
1745: l_qpprod_quantity NUMBER;
1746: l_qpprod_uom_code VARCHAR2 (240);

Line 2350: okc_contract_pub.update_contract_line

2346: p_type => g_okc_line,
2347: x_k_det_rec => l_k_det_rec
2348: );
2349: l_clev_rec_in.object_version_number := l_k_det_rec.object_version_number;
2350: okc_contract_pub.update_contract_line
2351: (p_api_version => l_api_version,
2352: p_init_msg_list => l_init_msg_list,
2353: x_return_status => x_return_status,
2354: x_msg_count => x_msg_count,

Line 2685: l_clev_rec_in okc_contract_pub.clev_rec_type;

2681: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
2682: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
2683: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
2684: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
2685: l_clev_rec_in okc_contract_pub.clev_rec_type;
2686: l_clev_rec_out okc_contract_pub.clev_rec_type;
2687: l_prod_qty NUMBER;
2688: l_serv_qty NUMBER;
2689: l_status VARCHAR2 (30); --3912685

Line 2686: l_clev_rec_out okc_contract_pub.clev_rec_type;

2682: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
2683: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
2684: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
2685: l_clev_rec_in okc_contract_pub.clev_rec_type;
2686: l_clev_rec_out okc_contract_pub.clev_rec_type;
2687: l_prod_qty NUMBER;
2688: l_serv_qty NUMBER;
2689: l_status VARCHAR2 (30); --3912685
2690: --new variables for partial periods

Line 3200: okc_contract_pub.update_contract_line

3196: p_type => g_okc_line,
3197: x_k_det_rec => l_k_det_rec
3198: );
3199: l_clev_rec_in.object_version_number := l_k_det_rec.object_version_number;
3200: okc_contract_pub.update_contract_line
3201: (p_api_version => l_api_version,
3202: p_init_msg_list => l_init_msg_list,
3203: x_return_status => x_return_status,
3204: x_msg_count => x_msg_count,

Line 3358: l_clev_rec_in okc_contract_pub.clev_rec_type;

3354: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
3355: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
3356: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
3357: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
3358: l_clev_rec_in okc_contract_pub.clev_rec_type;
3359: l_clev_rec_out okc_contract_pub.clev_rec_type;
3360: l_subs_item BOOLEAN := FALSE;
3361: l_clvl_name VARCHAR2 (240);
3362: l_clvl_desc VARCHAR2 (1000);

Line 3359: l_clev_rec_out okc_contract_pub.clev_rec_type;

3355: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
3356: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
3357: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
3358: l_clev_rec_in okc_contract_pub.clev_rec_type;
3359: l_clev_rec_out okc_contract_pub.clev_rec_type;
3360: l_subs_item BOOLEAN := FALSE;
3361: l_clvl_name VARCHAR2 (240);
3362: l_clvl_desc VARCHAR2 (1000);
3363: l_tlvl_name VARCHAR2 (800);

Line 3632: okc_contract_pub.update_contract_line

3628: x_k_det_rec => l_k_det_rec
3629: );
3630: l_clev_rec_in.object_version_number :=
3631: l_k_det_rec.object_version_number;
3632: okc_contract_pub.update_contract_line
3633: (p_api_version => l_api_version,
3634: p_init_msg_list => l_init_msg_list,
3635: x_return_status => x_return_status,
3636: x_msg_count => x_msg_count,

Line 3816: okc_contract_pub.update_contract_line

3812: p_type => g_okc_line,
3813: x_k_det_rec => l_k_det_rec
3814: );
3815: l_clev_rec_in.object_version_number := l_k_det_rec.object_version_number;
3816: okc_contract_pub.update_contract_line
3817: (p_api_version => l_api_version,
3818: p_init_msg_list => l_init_msg_list,
3819: x_return_status => x_return_status,
3820: x_msg_count => x_msg_count,

Line 3915: l_chrv_rec_in okc_contract_pub.chrv_rec_type;

3911: AND date_terminated IS NULL -- bug 5504157
3912: ORDER BY line_number;
3913:
3914: l_input_details oks_qp_pkg.input_details;
3915: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
3916: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
3917: l_k_det_rec k_details_rec;
3918: BEGIN
3919: -- start debug log

Line 3916: l_chrv_rec_out okc_contract_pub.chrv_rec_type;

3912: ORDER BY line_number;
3913:
3914: l_input_details oks_qp_pkg.input_details;
3915: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
3916: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
3917: l_k_det_rec k_details_rec;
3918: BEGIN
3919: -- start debug log
3920: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 4054: okc_contract_pub.update_contract_header

4050: p_type => g_okc_hdr,
4051: x_k_det_rec => l_k_det_rec
4052: );
4053: l_chrv_rec_in.object_version_number := l_k_det_rec.object_version_number;
4054: okc_contract_pub.update_contract_header
4055: (p_api_version => l_api_version,
4056: p_init_msg_list => l_init_msg_list,
4057: x_return_status => x_return_status,
4058: x_msg_count => x_msg_count,

Line 4142: l_chrv_rec_in okc_contract_pub.chrv_rec_type;

4138: := 'compute_price';
4139: l_input_detail_rec oks_qp_pkg.input_details
4140: := p_detail_rec;
4141: l_k_det_rec k_details_rec;
4142: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
4143: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
4144: l_clev_rec_in okc_contract_pub.clev_rec_type;
4145: l_clev_rec_out okc_contract_pub.clev_rec_type;
4146: BEGIN

Line 4143: l_chrv_rec_out okc_contract_pub.chrv_rec_type;

4139: l_input_detail_rec oks_qp_pkg.input_details
4140: := p_detail_rec;
4141: l_k_det_rec k_details_rec;
4142: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
4143: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
4144: l_clev_rec_in okc_contract_pub.clev_rec_type;
4145: l_clev_rec_out okc_contract_pub.clev_rec_type;
4146: BEGIN
4147: -- start debug log

Line 4144: l_clev_rec_in okc_contract_pub.clev_rec_type;

4140: := p_detail_rec;
4141: l_k_det_rec k_details_rec;
4142: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
4143: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
4144: l_clev_rec_in okc_contract_pub.clev_rec_type;
4145: l_clev_rec_out okc_contract_pub.clev_rec_type;
4146: BEGIN
4147: -- start debug log
4148: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 4145: l_clev_rec_out okc_contract_pub.clev_rec_type;

4141: l_k_det_rec k_details_rec;
4142: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
4143: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
4144: l_clev_rec_in okc_contract_pub.clev_rec_type;
4145: l_clev_rec_out okc_contract_pub.clev_rec_type;
4146: BEGIN
4147: -- start debug log
4148: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4149: THEN

Line 4358: okc_contract_pub.update_contract_header

4354: x_k_det_rec => l_k_det_rec
4355: );
4356: l_chrv_rec_in.object_version_number :=
4357: l_k_det_rec.object_version_number;
4358: okc_contract_pub.update_contract_header
4359: (p_api_version => l_api_version,
4360: p_init_msg_list => l_init_msg_list,
4361: x_return_status => x_return_status,
4362: x_msg_count => x_msg_count,

Line 4472: okc_contract_pub.update_contract_line

4468: x_k_det_rec => l_k_det_rec
4469: );
4470: l_clev_rec_in.object_version_number :=
4471: l_k_det_rec.object_version_number;
4472: okc_contract_pub.update_contract_line
4473: (p_api_version => l_api_version,
4474: p_init_msg_list => l_init_msg_list,
4475: x_return_status => x_return_status,
4476: x_msg_count => x_msg_count,

Line 4497: okc_contract_pub.update_contract_header

4493: x_k_det_rec => l_k_det_rec
4494: );
4495: l_chrv_rec_in.object_version_number :=
4496: l_k_det_rec.object_version_number;
4497: okc_contract_pub.update_contract_header
4498: (p_api_version => l_api_version,
4499: p_init_msg_list => l_init_msg_list,
4500: x_return_status => x_return_status,
4501: x_msg_count => x_msg_count,

Line 4641: okc_contract_pub.update_contract_header

4637: );
4638: END IF;
4639:
4640: -- errorout ('Amount = ' || l_chrv_rec_in.estimated_amount);
4641: okc_contract_pub.update_contract_header
4642: (p_api_version => l_api_version,
4643: p_init_msg_list => l_init_msg_list,
4644: x_return_status => x_return_status,
4645: x_msg_count => x_msg_count,

Line 4755: okc_contract_pub.update_contract_line

4751: x_k_det_rec => l_k_det_rec
4752: );
4753: l_clev_rec_in.object_version_number :=
4754: l_k_det_rec.object_version_number;
4755: okc_contract_pub.update_contract_line
4756: (p_api_version => l_api_version,
4757: p_init_msg_list => l_init_msg_list,
4758: x_return_status => x_return_status,
4759: x_msg_count => x_msg_count,

Line 4780: okc_contract_pub.update_contract_header

4776: x_k_det_rec => l_k_det_rec
4777: );
4778: l_chrv_rec_in.object_version_number :=
4779: l_k_det_rec.object_version_number;
4780: okc_contract_pub.update_contract_header
4781: (p_api_version => l_api_version,
4782: p_init_msg_list => l_init_msg_list,
4783: x_return_status => x_return_status,
4784: x_msg_count => x_msg_count,