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 8800: IF NVL (x_price_details.status_code, qp_preq_grp.g_status_new) IN

8796: END IF;
8797: END IF;
8798:
8799: -- Bug fix for 3641535. Depending on this status code, Authoring decides whether or not to call Pricebreaks form.
8800: IF NVL (x_price_details.status_code, qp_preq_grp.g_status_new) IN
8801: (qp_preq_grp.g_status_updated,
8802: qp_preq_grp.g_status_system_generated,
8803: qp_preq_grp.g_by_engine,
8804: qp_preq_grp.g_status_unchanged,

Line 8801: (qp_preq_grp.g_status_updated,

8797: END IF;
8798:
8799: -- Bug fix for 3641535. Depending on this status code, Authoring decides whether or not to call Pricebreaks form.
8800: IF NVL (x_price_details.status_code, qp_preq_grp.g_status_new) IN
8801: (qp_preq_grp.g_status_updated,
8802: qp_preq_grp.g_status_system_generated,
8803: qp_preq_grp.g_by_engine,
8804: qp_preq_grp.g_status_unchanged,
8805: qp_preq_grp.g_status_new

Line 8802: qp_preq_grp.g_status_system_generated,

8798:
8799: -- Bug fix for 3641535. Depending on this status code, Authoring decides whether or not to call Pricebreaks form.
8800: IF NVL (x_price_details.status_code, qp_preq_grp.g_status_new) IN
8801: (qp_preq_grp.g_status_updated,
8802: qp_preq_grp.g_status_system_generated,
8803: qp_preq_grp.g_by_engine,
8804: qp_preq_grp.g_status_unchanged,
8805: qp_preq_grp.g_status_new
8806: )

Line 8803: qp_preq_grp.g_by_engine,

8799: -- Bug fix for 3641535. Depending on this status code, Authoring decides whether or not to call Pricebreaks form.
8800: IF NVL (x_price_details.status_code, qp_preq_grp.g_status_new) IN
8801: (qp_preq_grp.g_status_updated,
8802: qp_preq_grp.g_status_system_generated,
8803: qp_preq_grp.g_by_engine,
8804: qp_preq_grp.g_status_unchanged,
8805: qp_preq_grp.g_status_new
8806: )
8807: THEN

Line 8804: qp_preq_grp.g_status_unchanged,

8800: IF NVL (x_price_details.status_code, qp_preq_grp.g_status_new) IN
8801: (qp_preq_grp.g_status_updated,
8802: qp_preq_grp.g_status_system_generated,
8803: qp_preq_grp.g_by_engine,
8804: qp_preq_grp.g_status_unchanged,
8805: qp_preq_grp.g_status_new
8806: )
8807: THEN
8808: x_price_details.status_code := 'OKS_S';

Line 8805: qp_preq_grp.g_status_new

8801: (qp_preq_grp.g_status_updated,
8802: qp_preq_grp.g_status_system_generated,
8803: qp_preq_grp.g_by_engine,
8804: qp_preq_grp.g_status_unchanged,
8805: qp_preq_grp.g_status_new
8806: )
8807: THEN
8808: x_price_details.status_code := 'OKS_S';
8809: ELSE

Line 8935: qp_preq_grp.g_pbh_line

8931: IF l_top_ctr IS NOT NULL
8932: THEN
8933: LOOP
8934: IF lx_req_related_lines_tbl (l_top_ctr).relationship_type_code =
8935: qp_preq_grp.g_pbh_line
8936: THEN
8937: l_rel_index :=
8938: lx_req_related_lines_tbl (l_top_ctr).related_line_detail_index;
8939: l_lin_index :=