eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_QP_PKG dependencies on QP_PREQ_GRP

Line 92: p_modifier_details IN qp_preq_grp.line_detail_tbl_type,

88: END check_hdr_discount;
89:
90: PROCEDURE modifier_4_usg (
91: p_bsl_id IN NUMBER,
92: p_modifier_details IN qp_preq_grp.line_detail_tbl_type,
93: x_return_status OUT NOCOPY VARCHAR2
94: )
95: IS
96: l_api_name CONSTANT VARCHAR2 (30)

Line 224: p_modifier_details IN qp_preq_grp.line_detail_tbl_type,

220: END modifier_4_usg;
221:
222: PROCEDURE modifier_handling (
223: p_cle_id NUMBER,
224: p_modifier_details IN qp_preq_grp.line_detail_tbl_type,
225: x_return_status OUT NOCOPY VARCHAR2
226: )
227: IS
228: CURSOR cur_price (

Line 533: p_req_qual_tbl IN OUT NOCOPY qp_preq_grp.qual_tbl_type

529: p_cle_id IN NUMBER,
530: p_item_id IN NUMBER,
531: p_service_index IN NUMBER,
532: p_line_qual_tbl_ctr IN OUT NOCOPY NUMBER,
533: p_req_qual_tbl IN OUT NOCOPY qp_preq_grp.qual_tbl_type
534: )
535: IS
536: l_line_qual_tbl_ctr NUMBER;
537: l_req_qual_rec2 qp_preq_grp.qual_rec_type;

Line 537: l_req_qual_rec2 qp_preq_grp.qual_rec_type;

533: p_req_qual_tbl IN OUT NOCOPY qp_preq_grp.qual_tbl_type
534: )
535: IS
536: l_line_qual_tbl_ctr NUMBER;
537: l_req_qual_rec2 qp_preq_grp.qual_rec_type;
538: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
539: l_api_name CONSTANT VARCHAR2 (30) := 'BUILD_TOP_QA';
540:
541: CURSOR l_qual_csr

Line 538: l_req_qual_tbl qp_preq_grp.qual_tbl_type;

534: )
535: IS
536: l_line_qual_tbl_ctr NUMBER;
537: l_req_qual_rec2 qp_preq_grp.qual_rec_type;
538: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
539: l_api_name CONSTANT VARCHAR2 (30) := 'BUILD_TOP_QA';
540:
541: CURSOR l_qual_csr
542: IS

Line 618: p_req_line_detail_tbl IN OUT NOCOPY qp_preq_grp.line_detail_tbl_type

614: p_chr_id IN NUMBER,
615: p_item_id IN NUMBER,
616: p_service_index IN NUMBER,
617: p_line_detl_tbl_ctr IN OUT NOCOPY NUMBER,
618: p_req_line_detail_tbl IN OUT NOCOPY qp_preq_grp.line_detail_tbl_type
619: )
620: IS
621: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
622: l_line_detl_tbl_ctr NUMBER;

Line 621: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;

617: p_line_detl_tbl_ctr IN OUT NOCOPY NUMBER,
618: p_req_line_detail_tbl IN OUT NOCOPY qp_preq_grp.line_detail_tbl_type
619: )
620: IS
621: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
622: l_line_detl_tbl_ctr NUMBER;
623: l_api_name CONSTANT VARCHAR2 (30)
624: := 'BUILD_HDR_ADJ';
625:

Line 640: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;

636: WHERE chr_id = p_chr_id AND
637: cle_id IS NULL AND
638: NVL (automatic_flag, 'N') = 'N';
639:
640: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
641: l_adj_rec l_adj_csr%ROWTYPE;
642:
643: CURSOR l_qp_hdr_csr (
644: p_list_header_id NUMBER

Line 1022: p_req_line_detail_tbl IN OUT NOCOPY qp_preq_grp.line_detail_tbl_type

1018: p_cle_id IN NUMBER,
1019: p_item_id IN NUMBER,
1020: p_service_index IN NUMBER,
1021: p_line_detl_tbl_ctr IN OUT NOCOPY NUMBER,
1022: p_req_line_detail_tbl IN OUT NOCOPY qp_preq_grp.line_detail_tbl_type
1023: )
1024: IS
1025: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
1026: l_line_detl_tbl_ctr NUMBER;

Line 1025: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;

1021: p_line_detl_tbl_ctr IN OUT NOCOPY NUMBER,
1022: p_req_line_detail_tbl IN OUT NOCOPY qp_preq_grp.line_detail_tbl_type
1023: )
1024: IS
1025: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
1026: l_line_detl_tbl_ctr NUMBER;
1027: l_api_name CONSTANT VARCHAR2 (30)
1028: := 'BUILD_TOP_ADJ';
1029:

Line 1043: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;

1039: FROM okc_price_adjustments
1040: WHERE cle_id = p_cle_id AND
1041: NVL (automatic_flag, 'N') = 'N';
1042:
1043: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
1044: l_adj_rec l_adj_csr%ROWTYPE;
1045:
1046: CURSOR l_qp_hdr_csr (
1047: p_list_header_id NUMBER

Line 1228: px_req_line_attr_tbl IN OUT NOCOPY qp_preq_grp.line_attr_tbl_type

1224: PROCEDURE build_cp_pa (
1225: p_inst_id IN NUMBER,
1226: p_service_index IN NUMBER,
1227: px_line_attr_tbl_ctr IN OUT NOCOPY NUMBER,
1228: px_req_line_attr_tbl IN OUT NOCOPY qp_preq_grp.line_attr_tbl_type
1229: )
1230: IS
1231: CURSOR l_topline_pa_csr
1232: IS

Line 1339: l_req_line_attr_rec2 qp_preq_grp.line_attr_rec_type;

1335: WHERE a.instance_id = p_inst_id;
1336:
1337: l_line_attr_tbl_ctr NUMBER;
1338: l_srv_csrrec l_topline_pa_csr%ROWTYPE;
1339: l_req_line_attr_rec2 qp_preq_grp.line_attr_rec_type;
1340: l_api_name CONSTANT VARCHAR2 (30) := 'BUILD_CP_PA';
1341: BEGIN
1342: -- start debug log
1343: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 2883: px_req_line_attr_tbl IN OUT NOCOPY qp_preq_grp.line_attr_tbl_type

2879: PROCEDURE build_top_pa (
2880: p_cle_id IN NUMBER,
2881: p_service_index IN NUMBER,
2882: px_line_attr_tbl_ctr IN OUT NOCOPY NUMBER,
2883: px_req_line_attr_tbl IN OUT NOCOPY qp_preq_grp.line_attr_tbl_type
2884: )
2885: IS
2886: -- bug 4650072 (forward port bug 4884329), added function trim for all attributes as null was saved as a space character
2887: CURSOR l_topline_pa_csr

Line 2995: l_req_line_attr_rec2 qp_preq_grp.line_attr_rec_type;

2991: WHERE a.cle_id = p_cle_id;
2992:
2993: l_line_attr_tbl_ctr NUMBER;
2994: l_srv_csrrec l_topline_pa_csr%ROWTYPE;
2995: l_req_line_attr_rec2 qp_preq_grp.line_attr_rec_type;
2996: l_api_name CONSTANT VARCHAR2 (30) := 'BUILD_TOP_PA';
2997: BEGIN
2998: -- start debug log
2999: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 4599: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,

4595:
4596: PROCEDURE calc_price (
4597: p_detail_rec IN input_details,
4598: x_price_details OUT NOCOPY price_details,
4599: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
4600: x_price_break_details OUT NOCOPY g_price_break_tbl_type,
4601: x_return_status OUT NOCOPY VARCHAR2,
4602: x_msg_count OUT NOCOPY NUMBER,
4603: x_msg_data OUT NOCOPY VARCHAR2

Line 4608: l_control_rec qp_preq_grp.control_record_type;

4604: )
4605: IS
4606: l_api_name CONSTANT VARCHAR2 (30) := 'CALC_PRICE';
4607: --QP Variables
4608: l_control_rec qp_preq_grp.control_record_type;
4609: l_req_line_tbl qp_preq_grp.line_tbl_type;
4610: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4611: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4612: l_req_qual_tbl qp_preq_grp.qual_tbl_type;

Line 4609: l_req_line_tbl qp_preq_grp.line_tbl_type;

4605: IS
4606: l_api_name CONSTANT VARCHAR2 (30) := 'CALC_PRICE';
4607: --QP Variables
4608: l_control_rec qp_preq_grp.control_record_type;
4609: l_req_line_tbl qp_preq_grp.line_tbl_type;
4610: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4611: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4612: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
4613: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

Line 4610: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;

4606: l_api_name CONSTANT VARCHAR2 (30) := 'CALC_PRICE';
4607: --QP Variables
4608: l_control_rec qp_preq_grp.control_record_type;
4609: l_req_line_tbl qp_preq_grp.line_tbl_type;
4610: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4611: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4612: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
4613: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4614: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

Line 4611: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;

4607: --QP Variables
4608: l_control_rec qp_preq_grp.control_record_type;
4609: l_req_line_tbl qp_preq_grp.line_tbl_type;
4610: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4611: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4612: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
4613: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4614: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4615: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;

Line 4612: l_req_qual_tbl qp_preq_grp.qual_tbl_type;

4608: l_control_rec qp_preq_grp.control_record_type;
4609: l_req_line_tbl qp_preq_grp.line_tbl_type;
4610: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4611: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4612: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
4613: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4614: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4615: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4616: l_req_line_rec qp_preq_grp.line_rec_type;

Line 4613: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

4609: l_req_line_tbl qp_preq_grp.line_tbl_type;
4610: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4611: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4612: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
4613: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4614: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4615: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4616: l_req_line_rec qp_preq_grp.line_rec_type;
4617: l_req_line_rec2 qp_preq_grp.line_rec_type;

Line 4614: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

4610: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4611: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4612: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
4613: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4614: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4615: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4616: l_req_line_rec qp_preq_grp.line_rec_type;
4617: l_req_line_rec2 qp_preq_grp.line_rec_type;
4618: l_req_line_rec3 qp_preq_grp.line_rec_type;

Line 4615: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;

4611: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4612: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
4613: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4614: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4615: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4616: l_req_line_rec qp_preq_grp.line_rec_type;
4617: l_req_line_rec2 qp_preq_grp.line_rec_type;
4618: l_req_line_rec3 qp_preq_grp.line_rec_type;
4619: l_req_line_rec4 qp_preq_grp.line_rec_type;

Line 4616: l_req_line_rec qp_preq_grp.line_rec_type;

4612: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
4613: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4614: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4615: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4616: l_req_line_rec qp_preq_grp.line_rec_type;
4617: l_req_line_rec2 qp_preq_grp.line_rec_type;
4618: l_req_line_rec3 qp_preq_grp.line_rec_type;
4619: l_req_line_rec4 qp_preq_grp.line_rec_type;
4620: l_req_qual_rec qp_preq_grp.qual_rec_type;

Line 4617: l_req_line_rec2 qp_preq_grp.line_rec_type;

4613: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4614: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4615: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4616: l_req_line_rec qp_preq_grp.line_rec_type;
4617: l_req_line_rec2 qp_preq_grp.line_rec_type;
4618: l_req_line_rec3 qp_preq_grp.line_rec_type;
4619: l_req_line_rec4 qp_preq_grp.line_rec_type;
4620: l_req_qual_rec qp_preq_grp.qual_rec_type;
4621: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;

Line 4618: l_req_line_rec3 qp_preq_grp.line_rec_type;

4614: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4615: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4616: l_req_line_rec qp_preq_grp.line_rec_type;
4617: l_req_line_rec2 qp_preq_grp.line_rec_type;
4618: l_req_line_rec3 qp_preq_grp.line_rec_type;
4619: l_req_line_rec4 qp_preq_grp.line_rec_type;
4620: l_req_qual_rec qp_preq_grp.qual_rec_type;
4621: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
4622: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;

Line 4619: l_req_line_rec4 qp_preq_grp.line_rec_type;

4615: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4616: l_req_line_rec qp_preq_grp.line_rec_type;
4617: l_req_line_rec2 qp_preq_grp.line_rec_type;
4618: l_req_line_rec3 qp_preq_grp.line_rec_type;
4619: l_req_line_rec4 qp_preq_grp.line_rec_type;
4620: l_req_qual_rec qp_preq_grp.qual_rec_type;
4621: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
4622: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
4623: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;

Line 4620: l_req_qual_rec qp_preq_grp.qual_rec_type;

4616: l_req_line_rec qp_preq_grp.line_rec_type;
4617: l_req_line_rec2 qp_preq_grp.line_rec_type;
4618: l_req_line_rec3 qp_preq_grp.line_rec_type;
4619: l_req_line_rec4 qp_preq_grp.line_rec_type;
4620: l_req_qual_rec qp_preq_grp.qual_rec_type;
4621: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
4622: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
4623: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
4624: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;

Line 4621: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;

4617: l_req_line_rec2 qp_preq_grp.line_rec_type;
4618: l_req_line_rec3 qp_preq_grp.line_rec_type;
4619: l_req_line_rec4 qp_preq_grp.line_rec_type;
4620: l_req_qual_rec qp_preq_grp.qual_rec_type;
4621: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
4622: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
4623: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
4624: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
4625: lx_req_line_tbl qp_preq_grp.line_tbl_type;

Line 4622: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;

4618: l_req_line_rec3 qp_preq_grp.line_rec_type;
4619: l_req_line_rec4 qp_preq_grp.line_rec_type;
4620: l_req_qual_rec qp_preq_grp.qual_rec_type;
4621: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
4622: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
4623: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
4624: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
4625: lx_req_line_tbl qp_preq_grp.line_tbl_type;
4626: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;

Line 4623: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;

4619: l_req_line_rec4 qp_preq_grp.line_rec_type;
4620: l_req_qual_rec qp_preq_grp.qual_rec_type;
4621: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
4622: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
4623: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
4624: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
4625: lx_req_line_tbl qp_preq_grp.line_tbl_type;
4626: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
4627: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

Line 4624: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;

4620: l_req_qual_rec qp_preq_grp.qual_rec_type;
4621: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
4622: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
4623: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
4624: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
4625: lx_req_line_tbl qp_preq_grp.line_tbl_type;
4626: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
4627: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4628: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;

Line 4625: lx_req_line_tbl qp_preq_grp.line_tbl_type;

4621: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
4622: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
4623: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
4624: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
4625: lx_req_line_tbl qp_preq_grp.line_tbl_type;
4626: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
4627: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4628: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4629: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

Line 4626: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;

4622: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
4623: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
4624: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
4625: lx_req_line_tbl qp_preq_grp.line_tbl_type;
4626: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
4627: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4628: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4629: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4630: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;

Line 4627: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

4623: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
4624: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
4625: lx_req_line_tbl qp_preq_grp.line_tbl_type;
4626: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
4627: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4628: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4629: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4630: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4631: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;

Line 4628: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;

4624: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
4625: lx_req_line_tbl qp_preq_grp.line_tbl_type;
4626: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
4627: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4628: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4629: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4630: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4631: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4632: lx_return_status VARCHAR2 (1);

Line 4629: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

4625: lx_req_line_tbl qp_preq_grp.line_tbl_type;
4626: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
4627: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4628: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4629: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4630: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4631: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4632: lx_return_status VARCHAR2 (1);
4633: lx_return_status_text VARCHAR2 (2000);

Line 4630: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;

4626: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
4627: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4628: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4629: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4630: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4631: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4632: lx_return_status VARCHAR2 (1);
4633: lx_return_status_text VARCHAR2 (2000);
4634: --General Variables;

Line 4631: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;

4627: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4628: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4629: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4630: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4631: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4632: lx_return_status VARCHAR2 (1);
4633: lx_return_status_text VARCHAR2 (2000);
4634: --General Variables;
4635: l_ctr NUMBER;

Line 8814: IF NVL (x_price_details.status_code, qp_preq_grp.g_status_new) IN

8810: END IF;
8811: END IF;
8812:
8813: -- Bug fix for 3641535. Depending on this status code, Authoring decides whether or not to call Pricebreaks form.
8814: IF NVL (x_price_details.status_code, qp_preq_grp.g_status_new) IN
8815: (qp_preq_grp.g_status_updated,
8816: qp_preq_grp.g_status_system_generated,
8817: qp_preq_grp.g_by_engine,
8818: qp_preq_grp.g_status_unchanged,

Line 8815: (qp_preq_grp.g_status_updated,

8811: END IF;
8812:
8813: -- Bug fix for 3641535. Depending on this status code, Authoring decides whether or not to call Pricebreaks form.
8814: IF NVL (x_price_details.status_code, qp_preq_grp.g_status_new) IN
8815: (qp_preq_grp.g_status_updated,
8816: qp_preq_grp.g_status_system_generated,
8817: qp_preq_grp.g_by_engine,
8818: qp_preq_grp.g_status_unchanged,
8819: qp_preq_grp.g_status_new

Line 8816: qp_preq_grp.g_status_system_generated,

8812:
8813: -- Bug fix for 3641535. Depending on this status code, Authoring decides whether or not to call Pricebreaks form.
8814: IF NVL (x_price_details.status_code, qp_preq_grp.g_status_new) IN
8815: (qp_preq_grp.g_status_updated,
8816: qp_preq_grp.g_status_system_generated,
8817: qp_preq_grp.g_by_engine,
8818: qp_preq_grp.g_status_unchanged,
8819: qp_preq_grp.g_status_new
8820: )

Line 8817: qp_preq_grp.g_by_engine,

8813: -- Bug fix for 3641535. Depending on this status code, Authoring decides whether or not to call Pricebreaks form.
8814: IF NVL (x_price_details.status_code, qp_preq_grp.g_status_new) IN
8815: (qp_preq_grp.g_status_updated,
8816: qp_preq_grp.g_status_system_generated,
8817: qp_preq_grp.g_by_engine,
8818: qp_preq_grp.g_status_unchanged,
8819: qp_preq_grp.g_status_new
8820: )
8821: THEN

Line 8818: qp_preq_grp.g_status_unchanged,

8814: IF NVL (x_price_details.status_code, qp_preq_grp.g_status_new) IN
8815: (qp_preq_grp.g_status_updated,
8816: qp_preq_grp.g_status_system_generated,
8817: qp_preq_grp.g_by_engine,
8818: qp_preq_grp.g_status_unchanged,
8819: qp_preq_grp.g_status_new
8820: )
8821: THEN
8822: x_price_details.status_code := 'OKS_S';

Line 8819: qp_preq_grp.g_status_new

8815: (qp_preq_grp.g_status_updated,
8816: qp_preq_grp.g_status_system_generated,
8817: qp_preq_grp.g_by_engine,
8818: qp_preq_grp.g_status_unchanged,
8819: qp_preq_grp.g_status_new
8820: )
8821: THEN
8822: x_price_details.status_code := 'OKS_S';
8823: ELSE

Line 8958: qp_preq_grp.g_pbh_line

8954: IF l_top_ctr IS NOT NULL
8955: THEN
8956: LOOP
8957: IF lx_req_related_lines_tbl (l_top_ctr).relationship_type_code =
8958: qp_preq_grp.g_pbh_line
8959: THEN
8960: l_rel_index :=
8961: lx_req_related_lines_tbl (l_top_ctr).related_line_detail_index;
8962: l_lin_index :=

Line 9343: l_control_rec OUT NOCOPY qp_preq_grp.control_record_type,

9339:
9340: /*skuchima Proceure to do preprocessing before QP call Bug:7539977 */
9341: PROCEDURE calc_price_pre (
9342: p_detail_rec IN input_details,
9343: l_control_rec OUT NOCOPY qp_preq_grp.control_record_type,
9344: l_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,
9345: l_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
9346: l_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
9347: l_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,

Line 9344: l_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,

9340: /*skuchima Proceure to do preprocessing before QP call Bug:7539977 */
9341: PROCEDURE calc_price_pre (
9342: p_detail_rec IN input_details,
9343: l_control_rec OUT NOCOPY qp_preq_grp.control_record_type,
9344: l_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,
9345: l_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
9346: l_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
9347: l_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
9348: l_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,

Line 9345: l_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,

9341: PROCEDURE calc_price_pre (
9342: p_detail_rec IN input_details,
9343: l_control_rec OUT NOCOPY qp_preq_grp.control_record_type,
9344: l_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,
9345: l_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
9346: l_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
9347: l_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
9348: l_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,
9349: l_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,

Line 9346: l_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,

9342: p_detail_rec IN input_details,
9343: l_control_rec OUT NOCOPY qp_preq_grp.control_record_type,
9344: l_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,
9345: l_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
9346: l_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
9347: l_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
9348: l_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,
9349: l_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,
9350: l_req_related_lines_tbl OUT NOCOPY qp_preq_grp.related_lines_tbl_type,

Line 9347: l_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,

9343: l_control_rec OUT NOCOPY qp_preq_grp.control_record_type,
9344: l_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,
9345: l_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
9346: l_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
9347: l_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
9348: l_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,
9349: l_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,
9350: l_req_related_lines_tbl OUT NOCOPY qp_preq_grp.related_lines_tbl_type,
9351: x_return_status OUT NOCOPY VARCHAR2

Line 9348: l_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,

9344: l_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,
9345: l_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
9346: l_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
9347: l_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
9348: l_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,
9349: l_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,
9350: l_req_related_lines_tbl OUT NOCOPY qp_preq_grp.related_lines_tbl_type,
9351: x_return_status OUT NOCOPY VARCHAR2
9352: )

Line 9349: l_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,

9345: l_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
9346: l_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
9347: l_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
9348: l_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,
9349: l_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,
9350: l_req_related_lines_tbl OUT NOCOPY qp_preq_grp.related_lines_tbl_type,
9351: x_return_status OUT NOCOPY VARCHAR2
9352: )
9353: IS

Line 9350: l_req_related_lines_tbl OUT NOCOPY qp_preq_grp.related_lines_tbl_type,

9346: l_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
9347: l_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
9348: l_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,
9349: l_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,
9350: l_req_related_lines_tbl OUT NOCOPY qp_preq_grp.related_lines_tbl_type,
9351: x_return_status OUT NOCOPY VARCHAR2
9352: )
9353: IS
9354: l_api_name CONSTANT VARCHAR2 (30) := 'CALC_PRICE_PRE';

Line 9356: /* l_control_rec qp_preq_grp.control_record_type;

9352: )
9353: IS
9354: l_api_name CONSTANT VARCHAR2 (30) := 'CALC_PRICE_PRE';
9355: --QP Variables
9356: /* l_control_rec qp_preq_grp.control_record_type;
9357: l_req_line_tbl qp_preq_grp.line_tbl_type;
9358: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
9359: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
9360: l_req_qual_tbl qp_preq_grp.qual_tbl_type;

Line 9357: l_req_line_tbl qp_preq_grp.line_tbl_type;

9353: IS
9354: l_api_name CONSTANT VARCHAR2 (30) := 'CALC_PRICE_PRE';
9355: --QP Variables
9356: /* l_control_rec qp_preq_grp.control_record_type;
9357: l_req_line_tbl qp_preq_grp.line_tbl_type;
9358: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
9359: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
9360: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
9361: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

Line 9358: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;

9354: l_api_name CONSTANT VARCHAR2 (30) := 'CALC_PRICE_PRE';
9355: --QP Variables
9356: /* l_control_rec qp_preq_grp.control_record_type;
9357: l_req_line_tbl qp_preq_grp.line_tbl_type;
9358: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
9359: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
9360: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
9361: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
9362: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

Line 9359: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;

9355: --QP Variables
9356: /* l_control_rec qp_preq_grp.control_record_type;
9357: l_req_line_tbl qp_preq_grp.line_tbl_type;
9358: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
9359: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
9360: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
9361: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
9362: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
9363: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/

Line 9360: l_req_qual_tbl qp_preq_grp.qual_tbl_type;

9356: /* l_control_rec qp_preq_grp.control_record_type;
9357: l_req_line_tbl qp_preq_grp.line_tbl_type;
9358: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
9359: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
9360: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
9361: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
9362: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
9363: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/
9364: l_req_line_rec qp_preq_grp.line_rec_type;

Line 9361: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

9357: l_req_line_tbl qp_preq_grp.line_tbl_type;
9358: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
9359: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
9360: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
9361: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
9362: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
9363: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/
9364: l_req_line_rec qp_preq_grp.line_rec_type;
9365: l_req_line_rec2 qp_preq_grp.line_rec_type;

Line 9362: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

9358: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
9359: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
9360: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
9361: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
9362: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
9363: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/
9364: l_req_line_rec qp_preq_grp.line_rec_type;
9365: l_req_line_rec2 qp_preq_grp.line_rec_type;
9366: l_req_line_rec3 qp_preq_grp.line_rec_type;

Line 9363: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/

9359: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
9360: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
9361: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
9362: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
9363: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/
9364: l_req_line_rec qp_preq_grp.line_rec_type;
9365: l_req_line_rec2 qp_preq_grp.line_rec_type;
9366: l_req_line_rec3 qp_preq_grp.line_rec_type;
9367: l_req_line_rec4 qp_preq_grp.line_rec_type;

Line 9364: l_req_line_rec qp_preq_grp.line_rec_type;

9360: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
9361: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
9362: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
9363: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/
9364: l_req_line_rec qp_preq_grp.line_rec_type;
9365: l_req_line_rec2 qp_preq_grp.line_rec_type;
9366: l_req_line_rec3 qp_preq_grp.line_rec_type;
9367: l_req_line_rec4 qp_preq_grp.line_rec_type;
9368: l_req_qual_rec qp_preq_grp.qual_rec_type;

Line 9365: l_req_line_rec2 qp_preq_grp.line_rec_type;

9361: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
9362: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
9363: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/
9364: l_req_line_rec qp_preq_grp.line_rec_type;
9365: l_req_line_rec2 qp_preq_grp.line_rec_type;
9366: l_req_line_rec3 qp_preq_grp.line_rec_type;
9367: l_req_line_rec4 qp_preq_grp.line_rec_type;
9368: l_req_qual_rec qp_preq_grp.qual_rec_type;
9369: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;

Line 9366: l_req_line_rec3 qp_preq_grp.line_rec_type;

9362: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
9363: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/
9364: l_req_line_rec qp_preq_grp.line_rec_type;
9365: l_req_line_rec2 qp_preq_grp.line_rec_type;
9366: l_req_line_rec3 qp_preq_grp.line_rec_type;
9367: l_req_line_rec4 qp_preq_grp.line_rec_type;
9368: l_req_qual_rec qp_preq_grp.qual_rec_type;
9369: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
9370: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;

Line 9367: l_req_line_rec4 qp_preq_grp.line_rec_type;

9363: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/
9364: l_req_line_rec qp_preq_grp.line_rec_type;
9365: l_req_line_rec2 qp_preq_grp.line_rec_type;
9366: l_req_line_rec3 qp_preq_grp.line_rec_type;
9367: l_req_line_rec4 qp_preq_grp.line_rec_type;
9368: l_req_qual_rec qp_preq_grp.qual_rec_type;
9369: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
9370: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
9371: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;

Line 9368: l_req_qual_rec qp_preq_grp.qual_rec_type;

9364: l_req_line_rec qp_preq_grp.line_rec_type;
9365: l_req_line_rec2 qp_preq_grp.line_rec_type;
9366: l_req_line_rec3 qp_preq_grp.line_rec_type;
9367: l_req_line_rec4 qp_preq_grp.line_rec_type;
9368: l_req_qual_rec qp_preq_grp.qual_rec_type;
9369: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
9370: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
9371: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
9372: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;

Line 9369: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;

9365: l_req_line_rec2 qp_preq_grp.line_rec_type;
9366: l_req_line_rec3 qp_preq_grp.line_rec_type;
9367: l_req_line_rec4 qp_preq_grp.line_rec_type;
9368: l_req_qual_rec qp_preq_grp.qual_rec_type;
9369: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
9370: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
9371: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
9372: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
9373: lx_req_line_tbl qp_preq_grp.line_tbl_type;

Line 9370: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;

9366: l_req_line_rec3 qp_preq_grp.line_rec_type;
9367: l_req_line_rec4 qp_preq_grp.line_rec_type;
9368: l_req_qual_rec qp_preq_grp.qual_rec_type;
9369: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
9370: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
9371: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
9372: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
9373: lx_req_line_tbl qp_preq_grp.line_tbl_type;
9374: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;

Line 9371: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;

9367: l_req_line_rec4 qp_preq_grp.line_rec_type;
9368: l_req_qual_rec qp_preq_grp.qual_rec_type;
9369: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
9370: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
9371: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
9372: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
9373: lx_req_line_tbl qp_preq_grp.line_tbl_type;
9374: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
9375: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

Line 9372: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;

9368: l_req_qual_rec qp_preq_grp.qual_rec_type;
9369: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
9370: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
9371: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
9372: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
9373: lx_req_line_tbl qp_preq_grp.line_tbl_type;
9374: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
9375: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
9376: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;

Line 9373: lx_req_line_tbl qp_preq_grp.line_tbl_type;

9369: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
9370: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
9371: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
9372: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
9373: lx_req_line_tbl qp_preq_grp.line_tbl_type;
9374: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
9375: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
9376: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
9377: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

Line 9374: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;

9370: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
9371: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
9372: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
9373: lx_req_line_tbl qp_preq_grp.line_tbl_type;
9374: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
9375: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
9376: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
9377: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
9378: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;

Line 9375: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

9371: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
9372: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
9373: lx_req_line_tbl qp_preq_grp.line_tbl_type;
9374: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
9375: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
9376: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
9377: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
9378: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
9379: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;

Line 9376: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;

9372: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
9373: lx_req_line_tbl qp_preq_grp.line_tbl_type;
9374: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
9375: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
9376: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
9377: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
9378: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
9379: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
9380: lx_return_status VARCHAR2 (1);

Line 9377: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

9373: lx_req_line_tbl qp_preq_grp.line_tbl_type;
9374: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
9375: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
9376: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
9377: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
9378: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
9379: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
9380: lx_return_status VARCHAR2 (1);
9381: lx_return_status_text VARCHAR2 (2000);

Line 9378: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;

9374: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
9375: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
9376: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
9377: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
9378: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
9379: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
9380: lx_return_status VARCHAR2 (1);
9381: lx_return_status_text VARCHAR2 (2000);
9382: --General Variables;

Line 9379: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;

9375: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
9376: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
9377: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
9378: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
9379: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
9380: lx_return_status VARCHAR2 (1);
9381: lx_return_status_text VARCHAR2 (2000);
9382: --General Variables;
9383: l_ctr NUMBER;

Line 12593: lx_req_line_tbl in qp_preq_grp.line_tbl_type,

12589: END calc_price_pre;
12590:
12591: /*skuchima Proceure to do postprocessing after QP call Bug:7539977 */
12592: PROCEDURE calc_price_post(p_detail_rec IN input_details,
12593: lx_req_line_tbl in qp_preq_grp.line_tbl_type,
12594: lx_req_qual_tbl in qp_preq_grp.qual_tbl_type,
12595: lx_req_line_attr_tbl in qp_preq_grp.line_attr_tbl_type,
12596: lx_req_line_detail_tbl in qp_preq_grp.line_detail_tbl_type,
12597: lx_req_line_detail_qual_tbl in qp_preq_grp.line_detail_qual_tbl_type,

Line 12594: lx_req_qual_tbl in qp_preq_grp.qual_tbl_type,

12590:
12591: /*skuchima Proceure to do postprocessing after QP call Bug:7539977 */
12592: PROCEDURE calc_price_post(p_detail_rec IN input_details,
12593: lx_req_line_tbl in qp_preq_grp.line_tbl_type,
12594: lx_req_qual_tbl in qp_preq_grp.qual_tbl_type,
12595: lx_req_line_attr_tbl in qp_preq_grp.line_attr_tbl_type,
12596: lx_req_line_detail_tbl in qp_preq_grp.line_detail_tbl_type,
12597: lx_req_line_detail_qual_tbl in qp_preq_grp.line_detail_qual_tbl_type,
12598: lx_req_line_detail_attr_tbl in qp_preq_grp.line_detail_attr_tbl_type,

Line 12595: lx_req_line_attr_tbl in qp_preq_grp.line_attr_tbl_type,

12591: /*skuchima Proceure to do postprocessing after QP call Bug:7539977 */
12592: PROCEDURE calc_price_post(p_detail_rec IN input_details,
12593: lx_req_line_tbl in qp_preq_grp.line_tbl_type,
12594: lx_req_qual_tbl in qp_preq_grp.qual_tbl_type,
12595: lx_req_line_attr_tbl in qp_preq_grp.line_attr_tbl_type,
12596: lx_req_line_detail_tbl in qp_preq_grp.line_detail_tbl_type,
12597: lx_req_line_detail_qual_tbl in qp_preq_grp.line_detail_qual_tbl_type,
12598: lx_req_line_detail_attr_tbl in qp_preq_grp.line_detail_attr_tbl_type,
12599: lx_req_related_lines_tbl in qp_preq_grp.related_lines_tbl_type,

Line 12596: lx_req_line_detail_tbl in qp_preq_grp.line_detail_tbl_type,

12592: PROCEDURE calc_price_post(p_detail_rec IN input_details,
12593: lx_req_line_tbl in qp_preq_grp.line_tbl_type,
12594: lx_req_qual_tbl in qp_preq_grp.qual_tbl_type,
12595: lx_req_line_attr_tbl in qp_preq_grp.line_attr_tbl_type,
12596: lx_req_line_detail_tbl in qp_preq_grp.line_detail_tbl_type,
12597: lx_req_line_detail_qual_tbl in qp_preq_grp.line_detail_qual_tbl_type,
12598: lx_req_line_detail_attr_tbl in qp_preq_grp.line_detail_attr_tbl_type,
12599: lx_req_related_lines_tbl in qp_preq_grp.related_lines_tbl_type,
12600: x_price_details OUT NOCOPY price_details,

Line 12597: lx_req_line_detail_qual_tbl in qp_preq_grp.line_detail_qual_tbl_type,

12593: lx_req_line_tbl in qp_preq_grp.line_tbl_type,
12594: lx_req_qual_tbl in qp_preq_grp.qual_tbl_type,
12595: lx_req_line_attr_tbl in qp_preq_grp.line_attr_tbl_type,
12596: lx_req_line_detail_tbl in qp_preq_grp.line_detail_tbl_type,
12597: lx_req_line_detail_qual_tbl in qp_preq_grp.line_detail_qual_tbl_type,
12598: lx_req_line_detail_attr_tbl in qp_preq_grp.line_detail_attr_tbl_type,
12599: lx_req_related_lines_tbl in qp_preq_grp.related_lines_tbl_type,
12600: x_price_details OUT NOCOPY price_details,
12601: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,

Line 12598: lx_req_line_detail_attr_tbl in qp_preq_grp.line_detail_attr_tbl_type,

12594: lx_req_qual_tbl in qp_preq_grp.qual_tbl_type,
12595: lx_req_line_attr_tbl in qp_preq_grp.line_attr_tbl_type,
12596: lx_req_line_detail_tbl in qp_preq_grp.line_detail_tbl_type,
12597: lx_req_line_detail_qual_tbl in qp_preq_grp.line_detail_qual_tbl_type,
12598: lx_req_line_detail_attr_tbl in qp_preq_grp.line_detail_attr_tbl_type,
12599: lx_req_related_lines_tbl in qp_preq_grp.related_lines_tbl_type,
12600: x_price_details OUT NOCOPY price_details,
12601: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
12602: x_price_break_details OUT NOCOPY g_price_break_tbl_type,

Line 12599: lx_req_related_lines_tbl in qp_preq_grp.related_lines_tbl_type,

12595: lx_req_line_attr_tbl in qp_preq_grp.line_attr_tbl_type,
12596: lx_req_line_detail_tbl in qp_preq_grp.line_detail_tbl_type,
12597: lx_req_line_detail_qual_tbl in qp_preq_grp.line_detail_qual_tbl_type,
12598: lx_req_line_detail_attr_tbl in qp_preq_grp.line_detail_attr_tbl_type,
12599: lx_req_related_lines_tbl in qp_preq_grp.related_lines_tbl_type,
12600: x_price_details OUT NOCOPY price_details,
12601: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
12602: x_price_break_details OUT NOCOPY g_price_break_tbl_type,
12603: x_return_status OUT NOCOPY VARCHAR2,

Line 12601: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,

12597: lx_req_line_detail_qual_tbl in qp_preq_grp.line_detail_qual_tbl_type,
12598: lx_req_line_detail_attr_tbl in qp_preq_grp.line_detail_attr_tbl_type,
12599: lx_req_related_lines_tbl in qp_preq_grp.related_lines_tbl_type,
12600: x_price_details OUT NOCOPY price_details,
12601: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
12602: x_price_break_details OUT NOCOPY g_price_break_tbl_type,
12603: x_return_status OUT NOCOPY VARCHAR2,
12604: x_msg_count OUT NOCOPY NUMBER,
12605: x_msg_data OUT NOCOPY VARCHAR2

Line 12609: /* l_control_rec qp_preq_grp.control_record_type;

12605: x_msg_data OUT NOCOPY VARCHAR2
12606: ) IS
12607: l_api_name CONSTANT VARCHAR2 (30) := 'CALC_PRICE_POST';
12608: --QP Variables
12609: /* l_control_rec qp_preq_grp.control_record_type;
12610: l_req_line_tbl qp_preq_grp.line_tbl_type;
12611: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
12612: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
12613: l_req_qual_tbl qp_preq_grp.qual_tbl_type;

Line 12610: l_req_line_tbl qp_preq_grp.line_tbl_type;

12606: ) IS
12607: l_api_name CONSTANT VARCHAR2 (30) := 'CALC_PRICE_POST';
12608: --QP Variables
12609: /* l_control_rec qp_preq_grp.control_record_type;
12610: l_req_line_tbl qp_preq_grp.line_tbl_type;
12611: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
12612: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
12613: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
12614: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

Line 12611: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;

12607: l_api_name CONSTANT VARCHAR2 (30) := 'CALC_PRICE_POST';
12608: --QP Variables
12609: /* l_control_rec qp_preq_grp.control_record_type;
12610: l_req_line_tbl qp_preq_grp.line_tbl_type;
12611: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
12612: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
12613: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
12614: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
12615: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

Line 12612: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;

12608: --QP Variables
12609: /* l_control_rec qp_preq_grp.control_record_type;
12610: l_req_line_tbl qp_preq_grp.line_tbl_type;
12611: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
12612: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
12613: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
12614: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
12615: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
12616: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/

Line 12613: l_req_qual_tbl qp_preq_grp.qual_tbl_type;

12609: /* l_control_rec qp_preq_grp.control_record_type;
12610: l_req_line_tbl qp_preq_grp.line_tbl_type;
12611: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
12612: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
12613: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
12614: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
12615: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
12616: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/
12617: l_req_line_rec qp_preq_grp.line_rec_type;

Line 12614: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

12610: l_req_line_tbl qp_preq_grp.line_tbl_type;
12611: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
12612: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
12613: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
12614: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
12615: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
12616: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/
12617: l_req_line_rec qp_preq_grp.line_rec_type;
12618: l_req_line_rec2 qp_preq_grp.line_rec_type;

Line 12615: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

12611: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
12612: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
12613: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
12614: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
12615: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
12616: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/
12617: l_req_line_rec qp_preq_grp.line_rec_type;
12618: l_req_line_rec2 qp_preq_grp.line_rec_type;
12619: l_req_line_rec3 qp_preq_grp.line_rec_type;

Line 12616: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/

12612: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
12613: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
12614: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
12615: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
12616: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/
12617: l_req_line_rec qp_preq_grp.line_rec_type;
12618: l_req_line_rec2 qp_preq_grp.line_rec_type;
12619: l_req_line_rec3 qp_preq_grp.line_rec_type;
12620: l_req_line_rec4 qp_preq_grp.line_rec_type;

Line 12617: l_req_line_rec qp_preq_grp.line_rec_type;

12613: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
12614: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
12615: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
12616: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/
12617: l_req_line_rec qp_preq_grp.line_rec_type;
12618: l_req_line_rec2 qp_preq_grp.line_rec_type;
12619: l_req_line_rec3 qp_preq_grp.line_rec_type;
12620: l_req_line_rec4 qp_preq_grp.line_rec_type;
12621: l_req_qual_rec qp_preq_grp.qual_rec_type;

Line 12618: l_req_line_rec2 qp_preq_grp.line_rec_type;

12614: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
12615: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
12616: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/
12617: l_req_line_rec qp_preq_grp.line_rec_type;
12618: l_req_line_rec2 qp_preq_grp.line_rec_type;
12619: l_req_line_rec3 qp_preq_grp.line_rec_type;
12620: l_req_line_rec4 qp_preq_grp.line_rec_type;
12621: l_req_qual_rec qp_preq_grp.qual_rec_type;
12622: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;

Line 12619: l_req_line_rec3 qp_preq_grp.line_rec_type;

12615: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
12616: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/
12617: l_req_line_rec qp_preq_grp.line_rec_type;
12618: l_req_line_rec2 qp_preq_grp.line_rec_type;
12619: l_req_line_rec3 qp_preq_grp.line_rec_type;
12620: l_req_line_rec4 qp_preq_grp.line_rec_type;
12621: l_req_qual_rec qp_preq_grp.qual_rec_type;
12622: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
12623: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;

Line 12620: l_req_line_rec4 qp_preq_grp.line_rec_type;

12616: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;*/
12617: l_req_line_rec qp_preq_grp.line_rec_type;
12618: l_req_line_rec2 qp_preq_grp.line_rec_type;
12619: l_req_line_rec3 qp_preq_grp.line_rec_type;
12620: l_req_line_rec4 qp_preq_grp.line_rec_type;
12621: l_req_qual_rec qp_preq_grp.qual_rec_type;
12622: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
12623: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
12624: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;

Line 12621: l_req_qual_rec qp_preq_grp.qual_rec_type;

12617: l_req_line_rec qp_preq_grp.line_rec_type;
12618: l_req_line_rec2 qp_preq_grp.line_rec_type;
12619: l_req_line_rec3 qp_preq_grp.line_rec_type;
12620: l_req_line_rec4 qp_preq_grp.line_rec_type;
12621: l_req_qual_rec qp_preq_grp.qual_rec_type;
12622: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
12623: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
12624: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
12625: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;

Line 12622: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;

12618: l_req_line_rec2 qp_preq_grp.line_rec_type;
12619: l_req_line_rec3 qp_preq_grp.line_rec_type;
12620: l_req_line_rec4 qp_preq_grp.line_rec_type;
12621: l_req_qual_rec qp_preq_grp.qual_rec_type;
12622: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
12623: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
12624: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
12625: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
12626: /*lx_req_line_tbl qp_preq_grp.line_tbl_type;

Line 12623: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;

12619: l_req_line_rec3 qp_preq_grp.line_rec_type;
12620: l_req_line_rec4 qp_preq_grp.line_rec_type;
12621: l_req_qual_rec qp_preq_grp.qual_rec_type;
12622: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
12623: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
12624: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
12625: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
12626: /*lx_req_line_tbl qp_preq_grp.line_tbl_type;
12627: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;

Line 12624: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;

12620: l_req_line_rec4 qp_preq_grp.line_rec_type;
12621: l_req_qual_rec qp_preq_grp.qual_rec_type;
12622: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
12623: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
12624: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
12625: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
12626: /*lx_req_line_tbl qp_preq_grp.line_tbl_type;
12627: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
12628: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

Line 12625: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;

12621: l_req_qual_rec qp_preq_grp.qual_rec_type;
12622: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
12623: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
12624: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
12625: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
12626: /*lx_req_line_tbl qp_preq_grp.line_tbl_type;
12627: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
12628: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
12629: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;

Line 12626: /*lx_req_line_tbl qp_preq_grp.line_tbl_type;

12622: l_req_line_attr_rec qp_preq_grp.line_attr_rec_type;
12623: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
12624: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
12625: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
12626: /*lx_req_line_tbl qp_preq_grp.line_tbl_type;
12627: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
12628: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
12629: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
12630: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

Line 12627: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;

12623: l_req_line_detail_rec qp_preq_grp.line_detail_rec_type;
12624: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
12625: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
12626: /*lx_req_line_tbl qp_preq_grp.line_tbl_type;
12627: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
12628: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
12629: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
12630: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
12631: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;

Line 12628: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

12624: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;
12625: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
12626: /*lx_req_line_tbl qp_preq_grp.line_tbl_type;
12627: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
12628: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
12629: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
12630: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
12631: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
12632: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;*/

Line 12629: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;

12625: l_req_related_lines_rec qp_preq_grp.related_lines_rec_type;
12626: /*lx_req_line_tbl qp_preq_grp.line_tbl_type;
12627: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
12628: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
12629: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
12630: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
12631: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
12632: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;*/
12633: lx_return_status VARCHAR2 (1);

Line 12630: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

12626: /*lx_req_line_tbl qp_preq_grp.line_tbl_type;
12627: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
12628: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
12629: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
12630: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
12631: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
12632: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;*/
12633: lx_return_status VARCHAR2 (1);
12634: lx_return_status_text VARCHAR2 (2000);

Line 12631: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;

12627: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
12628: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
12629: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
12630: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
12631: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
12632: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;*/
12633: lx_return_status VARCHAR2 (1);
12634: lx_return_status_text VARCHAR2 (2000);
12635: --General Variables;

Line 12632: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;*/

12628: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
12629: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
12630: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
12631: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
12632: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;*/
12633: lx_return_status VARCHAR2 (1);
12634: lx_return_status_text VARCHAR2 (2000);
12635: --General Variables;
12636: l_ctr NUMBER;

Line 13691: IF NVL (x_price_details.status_code, qp_preq_grp.g_status_new) IN

13687: END IF;
13688: END IF;
13689:
13690: -- Bug fix for 3641535. Depending on this status code, Authoring decides whether or not to call Pricebreaks form.
13691: IF NVL (x_price_details.status_code, qp_preq_grp.g_status_new) IN
13692: (qp_preq_grp.g_status_updated,
13693: qp_preq_grp.g_status_system_generated,
13694: qp_preq_grp.g_by_engine,
13695: qp_preq_grp.g_status_unchanged,

Line 13692: (qp_preq_grp.g_status_updated,

13688: END IF;
13689:
13690: -- Bug fix for 3641535. Depending on this status code, Authoring decides whether or not to call Pricebreaks form.
13691: IF NVL (x_price_details.status_code, qp_preq_grp.g_status_new) IN
13692: (qp_preq_grp.g_status_updated,
13693: qp_preq_grp.g_status_system_generated,
13694: qp_preq_grp.g_by_engine,
13695: qp_preq_grp.g_status_unchanged,
13696: qp_preq_grp.g_status_new

Line 13693: qp_preq_grp.g_status_system_generated,

13689:
13690: -- Bug fix for 3641535. Depending on this status code, Authoring decides whether or not to call Pricebreaks form.
13691: IF NVL (x_price_details.status_code, qp_preq_grp.g_status_new) IN
13692: (qp_preq_grp.g_status_updated,
13693: qp_preq_grp.g_status_system_generated,
13694: qp_preq_grp.g_by_engine,
13695: qp_preq_grp.g_status_unchanged,
13696: qp_preq_grp.g_status_new
13697: )

Line 13694: qp_preq_grp.g_by_engine,

13690: -- Bug fix for 3641535. Depending on this status code, Authoring decides whether or not to call Pricebreaks form.
13691: IF NVL (x_price_details.status_code, qp_preq_grp.g_status_new) IN
13692: (qp_preq_grp.g_status_updated,
13693: qp_preq_grp.g_status_system_generated,
13694: qp_preq_grp.g_by_engine,
13695: qp_preq_grp.g_status_unchanged,
13696: qp_preq_grp.g_status_new
13697: )
13698: THEN

Line 13695: qp_preq_grp.g_status_unchanged,

13691: IF NVL (x_price_details.status_code, qp_preq_grp.g_status_new) IN
13692: (qp_preq_grp.g_status_updated,
13693: qp_preq_grp.g_status_system_generated,
13694: qp_preq_grp.g_by_engine,
13695: qp_preq_grp.g_status_unchanged,
13696: qp_preq_grp.g_status_new
13697: )
13698: THEN
13699: x_price_details.status_code := 'OKS_S';

Line 13696: qp_preq_grp.g_status_new

13692: (qp_preq_grp.g_status_updated,
13693: qp_preq_grp.g_status_system_generated,
13694: qp_preq_grp.g_by_engine,
13695: qp_preq_grp.g_status_unchanged,
13696: qp_preq_grp.g_status_new
13697: )
13698: THEN
13699: x_price_details.status_code := 'OKS_S';
13700: ELSE

Line 13826: qp_preq_grp.g_pbh_line

13822: IF l_top_ctr IS NOT NULL
13823: THEN
13824: LOOP
13825: IF lx_req_related_lines_tbl (l_top_ctr).relationship_type_code =
13826: qp_preq_grp.g_pbh_line
13827: THEN
13828: l_rel_index :=
13829: lx_req_related_lines_tbl (l_top_ctr).related_line_detail_index;
13830: l_lin_index :=