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_INT_PVT dependencies on QP_PREQ_GRP

Line 15: g_req_line_tbl_blk qp_preq_grp.line_tbl_type;

11: l_api_version CONSTANT NUMBER := 1.0;
12: l_init_msg_list CONSTANT VARCHAR2 (1) := 'F';
13:
14: /* added for Repricing in a bulk method skuchima Bug:7539977*/
15: g_req_line_tbl_blk qp_preq_grp.line_tbl_type;
16: g_req_line_detail_tbl_blk qp_preq_grp.line_detail_tbl_type;
17: g_req_related_lines_tbl_blk qp_preq_grp.related_lines_tbl_type;
18: g_req_qual_tbl_blk qp_preq_grp.qual_tbl_type;
19: g_req_line_attr_tbl_blk qp_preq_grp.line_attr_tbl_type;

Line 16: g_req_line_detail_tbl_blk qp_preq_grp.line_detail_tbl_type;

12: l_init_msg_list CONSTANT VARCHAR2 (1) := 'F';
13:
14: /* added for Repricing in a bulk method skuchima Bug:7539977*/
15: g_req_line_tbl_blk qp_preq_grp.line_tbl_type;
16: g_req_line_detail_tbl_blk qp_preq_grp.line_detail_tbl_type;
17: g_req_related_lines_tbl_blk qp_preq_grp.related_lines_tbl_type;
18: g_req_qual_tbl_blk qp_preq_grp.qual_tbl_type;
19: g_req_line_attr_tbl_blk qp_preq_grp.line_attr_tbl_type;
20: g_req_line_detail_qual_tbl_blk qp_preq_grp.line_detail_qual_tbl_type;

Line 17: g_req_related_lines_tbl_blk qp_preq_grp.related_lines_tbl_type;

13:
14: /* added for Repricing in a bulk method skuchima Bug:7539977*/
15: g_req_line_tbl_blk qp_preq_grp.line_tbl_type;
16: g_req_line_detail_tbl_blk qp_preq_grp.line_detail_tbl_type;
17: g_req_related_lines_tbl_blk qp_preq_grp.related_lines_tbl_type;
18: g_req_qual_tbl_blk qp_preq_grp.qual_tbl_type;
19: g_req_line_attr_tbl_blk qp_preq_grp.line_attr_tbl_type;
20: g_req_line_detail_qual_tbl_blk qp_preq_grp.line_detail_qual_tbl_type;
21: g_req_line_detail_attr_tbl_blk qp_preq_grp.line_detail_attr_tbl_type;

Line 18: g_req_qual_tbl_blk qp_preq_grp.qual_tbl_type;

14: /* added for Repricing in a bulk method skuchima Bug:7539977*/
15: g_req_line_tbl_blk qp_preq_grp.line_tbl_type;
16: g_req_line_detail_tbl_blk qp_preq_grp.line_detail_tbl_type;
17: g_req_related_lines_tbl_blk qp_preq_grp.related_lines_tbl_type;
18: g_req_qual_tbl_blk qp_preq_grp.qual_tbl_type;
19: g_req_line_attr_tbl_blk qp_preq_grp.line_attr_tbl_type;
20: g_req_line_detail_qual_tbl_blk qp_preq_grp.line_detail_qual_tbl_type;
21: g_req_line_detail_attr_tbl_blk qp_preq_grp.line_detail_attr_tbl_type;
22: g_line_tbl_ctr NUMBER:=0;

Line 19: g_req_line_attr_tbl_blk qp_preq_grp.line_attr_tbl_type;

15: g_req_line_tbl_blk qp_preq_grp.line_tbl_type;
16: g_req_line_detail_tbl_blk qp_preq_grp.line_detail_tbl_type;
17: g_req_related_lines_tbl_blk qp_preq_grp.related_lines_tbl_type;
18: g_req_qual_tbl_blk qp_preq_grp.qual_tbl_type;
19: g_req_line_attr_tbl_blk qp_preq_grp.line_attr_tbl_type;
20: g_req_line_detail_qual_tbl_blk qp_preq_grp.line_detail_qual_tbl_type;
21: g_req_line_detail_attr_tbl_blk qp_preq_grp.line_detail_attr_tbl_type;
22: g_line_tbl_ctr NUMBER:=0;
23: g_qual_tbl_ctr NUMBER:=0;

Line 20: g_req_line_detail_qual_tbl_blk qp_preq_grp.line_detail_qual_tbl_type;

16: g_req_line_detail_tbl_blk qp_preq_grp.line_detail_tbl_type;
17: g_req_related_lines_tbl_blk qp_preq_grp.related_lines_tbl_type;
18: g_req_qual_tbl_blk qp_preq_grp.qual_tbl_type;
19: g_req_line_attr_tbl_blk qp_preq_grp.line_attr_tbl_type;
20: g_req_line_detail_qual_tbl_blk qp_preq_grp.line_detail_qual_tbl_type;
21: g_req_line_detail_attr_tbl_blk qp_preq_grp.line_detail_attr_tbl_type;
22: g_line_tbl_ctr NUMBER:=0;
23: g_qual_tbl_ctr NUMBER:=0;
24: g_line_attr_tbl_ctr NUMBER:=0;

Line 21: g_req_line_detail_attr_tbl_blk qp_preq_grp.line_detail_attr_tbl_type;

17: g_req_related_lines_tbl_blk qp_preq_grp.related_lines_tbl_type;
18: g_req_qual_tbl_blk qp_preq_grp.qual_tbl_type;
19: g_req_line_attr_tbl_blk qp_preq_grp.line_attr_tbl_type;
20: g_req_line_detail_qual_tbl_blk qp_preq_grp.line_detail_qual_tbl_type;
21: g_req_line_detail_attr_tbl_blk qp_preq_grp.line_detail_attr_tbl_type;
22: g_line_tbl_ctr NUMBER:=0;
23: g_qual_tbl_ctr NUMBER:=0;
24: g_line_attr_tbl_ctr NUMBER:=0;
25: g_line_detail_tbl_ctr NUMBER:=0;

Line 28: gx_req_line_tbl qp_preq_grp.line_tbl_type;

24: g_line_attr_tbl_ctr NUMBER:=0;
25: g_line_detail_tbl_ctr NUMBER:=0;
26: g_related_lines_tbl_ctr NUMBER:=0;
27:
28: gx_req_line_tbl qp_preq_grp.line_tbl_type;
29: gx_req_qual_tbl qp_preq_grp.qual_tbl_type;
30: gx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
31: gx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
32: gx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

Line 29: gx_req_qual_tbl qp_preq_grp.qual_tbl_type;

25: g_line_detail_tbl_ctr NUMBER:=0;
26: g_related_lines_tbl_ctr NUMBER:=0;
27:
28: gx_req_line_tbl qp_preq_grp.line_tbl_type;
29: gx_req_qual_tbl qp_preq_grp.qual_tbl_type;
30: gx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
31: gx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
32: gx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
33: gx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;

Line 30: gx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

26: g_related_lines_tbl_ctr NUMBER:=0;
27:
28: gx_req_line_tbl qp_preq_grp.line_tbl_type;
29: gx_req_qual_tbl qp_preq_grp.qual_tbl_type;
30: gx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
31: gx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
32: gx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
33: gx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
34: gx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;

Line 31: gx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;

27:
28: gx_req_line_tbl qp_preq_grp.line_tbl_type;
29: gx_req_qual_tbl qp_preq_grp.qual_tbl_type;
30: gx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
31: gx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
32: gx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
33: gx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
34: gx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
35:

Line 32: gx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

28: gx_req_line_tbl qp_preq_grp.line_tbl_type;
29: gx_req_qual_tbl qp_preq_grp.qual_tbl_type;
30: gx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
31: gx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
32: gx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
33: gx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
34: gx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
35:
36: FUNCTION get_line_no (

Line 33: gx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;

29: gx_req_qual_tbl qp_preq_grp.qual_tbl_type;
30: gx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
31: gx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
32: gx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
33: gx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
34: gx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
35:
36: FUNCTION get_line_no (
37: p_line_id IN NUMBER

Line 34: gx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;

30: gx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
31: gx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
32: gx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
33: gx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
34: gx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
35:
36: FUNCTION get_line_no (
37: p_line_id IN NUMBER
38: )

Line 1691: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,

1687:
1688: PROCEDURE calculate_subscription_price (
1689: p_detail_rec IN oks_qp_pkg.input_details,
1690: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
1691: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
1692: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
1693: x_return_status OUT NOCOPY VARCHAR2,
1694: x_msg_count OUT NOCOPY NUMBER,
1695: x_msg_data OUT NOCOPY VARCHAR2

Line 2644: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,

2640:
2641: PROCEDURE calculate_subline_price (
2642: p_detail_rec IN oks_qp_pkg.input_details,
2643: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
2644: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
2645: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
2646: x_return_status OUT NOCOPY VARCHAR2,
2647: x_msg_count OUT NOCOPY NUMBER,
2648: x_msg_data OUT NOCOPY VARCHAR2

Line 3365: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,

3361:
3362: PROCEDURE calculate_topline_price (
3363: p_detail_rec IN oks_qp_pkg.input_details,
3364: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
3365: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
3366: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
3367: x_return_status OUT NOCOPY VARCHAR2,
3368: x_msg_count OUT NOCOPY NUMBER,
3369: x_msg_data OUT NOCOPY VARCHAR2

Line 3927: p_req_line_tbl IN qp_preq_grp.line_tbl_type,

3923: END calculate_topline_price;
3924:
3925: /* skuchima procedure changes the single input to bulk input bug:7539977*/
3926: PROCEDURE single_to_bulk_input(
3927: p_req_line_tbl IN qp_preq_grp.line_tbl_type,
3928: p_req_qual_tbl IN qp_preq_grp.qual_tbl_type,
3929: p_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
3930: p_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
3931: p_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,

Line 3928: p_req_qual_tbl IN qp_preq_grp.qual_tbl_type,

3924:
3925: /* skuchima procedure changes the single input to bulk input bug:7539977*/
3926: PROCEDURE single_to_bulk_input(
3927: p_req_line_tbl IN qp_preq_grp.line_tbl_type,
3928: p_req_qual_tbl IN qp_preq_grp.qual_tbl_type,
3929: p_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
3930: p_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
3931: p_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
3932: p_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,

Line 3929: p_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,

3925: /* skuchima procedure changes the single input to bulk input bug:7539977*/
3926: PROCEDURE single_to_bulk_input(
3927: p_req_line_tbl IN qp_preq_grp.line_tbl_type,
3928: p_req_qual_tbl IN qp_preq_grp.qual_tbl_type,
3929: p_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
3930: p_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
3931: p_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
3932: p_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,
3933: p_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type ,

Line 3930: p_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,

3926: PROCEDURE single_to_bulk_input(
3927: p_req_line_tbl IN qp_preq_grp.line_tbl_type,
3928: p_req_qual_tbl IN qp_preq_grp.qual_tbl_type,
3929: p_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
3930: p_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
3931: p_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
3932: p_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,
3933: p_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type ,
3934: p_visit_cnt IN NUMBER

Line 3931: p_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,

3927: p_req_line_tbl IN qp_preq_grp.line_tbl_type,
3928: p_req_qual_tbl IN qp_preq_grp.qual_tbl_type,
3929: p_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
3930: p_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
3931: p_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
3932: p_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,
3933: p_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type ,
3934: p_visit_cnt IN NUMBER
3935: )IS

Line 3932: p_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,

3928: p_req_qual_tbl IN qp_preq_grp.qual_tbl_type,
3929: p_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
3930: p_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
3931: p_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
3932: p_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,
3933: p_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type ,
3934: p_visit_cnt IN NUMBER
3935: )IS
3936:

Line 3933: p_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type ,

3929: p_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
3930: p_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
3931: p_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
3932: p_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,
3933: p_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type ,
3934: p_visit_cnt IN NUMBER
3935: )IS
3936:
3937: p NUMBER;

Line 4084: lx_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,

4080:
4081: /* skuchima Procedure changes the bulk output to single output for post processing of the data Bug:7539977*/
4082: PROCEDURE bulk_to_single_output(
4083: p_sub_line_id IN NUMBER,
4084: lx_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,
4085: lx_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
4086: lx_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
4087: lx_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
4088: lx_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,

Line 4085: lx_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,

4081: /* skuchima Procedure changes the bulk output to single output for post processing of the data Bug:7539977*/
4082: PROCEDURE bulk_to_single_output(
4083: p_sub_line_id IN NUMBER,
4084: lx_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,
4085: lx_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
4086: lx_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
4087: lx_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
4088: lx_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,
4089: lx_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,

Line 4086: lx_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,

4082: PROCEDURE bulk_to_single_output(
4083: p_sub_line_id IN NUMBER,
4084: lx_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,
4085: lx_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
4086: lx_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
4087: lx_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
4088: lx_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,
4089: lx_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,
4090: lx_req_related_lines_tbl OUT NOCOPY qp_preq_grp.related_lines_tbl_type

Line 4087: lx_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,

4083: p_sub_line_id IN NUMBER,
4084: lx_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,
4085: lx_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
4086: lx_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
4087: lx_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
4088: lx_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,
4089: lx_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,
4090: lx_req_related_lines_tbl OUT NOCOPY qp_preq_grp.related_lines_tbl_type
4091: ) is

Line 4088: lx_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,

4084: lx_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,
4085: lx_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
4086: lx_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
4087: lx_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
4088: lx_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,
4089: lx_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,
4090: lx_req_related_lines_tbl OUT NOCOPY qp_preq_grp.related_lines_tbl_type
4091: ) is
4092: p NUMBER;

Line 4089: lx_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,

4085: lx_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
4086: lx_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
4087: lx_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
4088: lx_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,
4089: lx_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,
4090: lx_req_related_lines_tbl OUT NOCOPY qp_preq_grp.related_lines_tbl_type
4091: ) is
4092: p NUMBER;
4093: q NUMBER;

Line 4090: lx_req_related_lines_tbl OUT NOCOPY qp_preq_grp.related_lines_tbl_type

4086: lx_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
4087: lx_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
4088: lx_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,
4089: lx_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,
4090: lx_req_related_lines_tbl OUT NOCOPY qp_preq_grp.related_lines_tbl_type
4091: ) is
4092: p NUMBER;
4093: q NUMBER;
4094: l_sub_line_index NUMBER;

Line 4330: x_modifier_details out nocopy qp_preq_grp.line_detail_tbl_type,

4326: /*skuchima :Bug:7539977 --Copied the CALCULATE_TOPLINE_PRICE Procedure to make changes to call the QP in bulk mode*/
4327: PROCEDURE calculate_topline_price_bulk (
4328: p_detail_rec in oks_qp_pkg.input_details,
4329: x_price_details out nocopy oks_qp_pkg.price_details,
4330: x_modifier_details out nocopy qp_preq_grp.line_detail_tbl_type,
4331: x_price_break_details out nocopy oks_qp_pkg.g_price_break_tbl_type,
4332: x_return_status out nocopy varchar2,
4333: x_msg_count out nocopy number,
4334: x_msg_data out nocopy varchar2

Line 4373: l_control_rec qp_preq_grp.control_record_type;

4369: l_line_no varchar2 (300);
4370: l_status varchar2 (30); --3912685
4371:
4372:
4373: l_control_rec qp_preq_grp.control_record_type;
4374: l_req_line_tbl qp_preq_grp.line_tbl_type;
4375: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4376: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4377: l_req_qual_tbl qp_preq_grp.qual_tbl_type;

Line 4374: l_req_line_tbl qp_preq_grp.line_tbl_type;

4370: l_status varchar2 (30); --3912685
4371:
4372:
4373: l_control_rec qp_preq_grp.control_record_type;
4374: l_req_line_tbl qp_preq_grp.line_tbl_type;
4375: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4376: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4377: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
4378: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

Line 4375: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;

4371:
4372:
4373: l_control_rec qp_preq_grp.control_record_type;
4374: l_req_line_tbl qp_preq_grp.line_tbl_type;
4375: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4376: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4377: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
4378: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4379: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

Line 4376: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;

4372:
4373: l_control_rec qp_preq_grp.control_record_type;
4374: l_req_line_tbl qp_preq_grp.line_tbl_type;
4375: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4376: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4377: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
4378: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4379: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4380: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;

Line 4377: l_req_qual_tbl qp_preq_grp.qual_tbl_type;

4373: l_control_rec qp_preq_grp.control_record_type;
4374: l_req_line_tbl qp_preq_grp.line_tbl_type;
4375: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4376: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4377: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
4378: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4379: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4380: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4381:

Line 4378: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

4374: l_req_line_tbl qp_preq_grp.line_tbl_type;
4375: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4376: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4377: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
4378: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4379: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4380: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4381:
4382: lx_req_line_tbl qp_preq_grp.line_tbl_type;

Line 4379: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

4375: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4376: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4377: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
4378: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4379: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4380: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4381:
4382: lx_req_line_tbl qp_preq_grp.line_tbl_type;
4383: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;

Line 4380: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;

4376: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4377: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
4378: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4379: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4380: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4381:
4382: lx_req_line_tbl qp_preq_grp.line_tbl_type;
4383: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
4384: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

Line 4382: lx_req_line_tbl qp_preq_grp.line_tbl_type;

4378: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4379: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4380: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4381:
4382: lx_req_line_tbl qp_preq_grp.line_tbl_type;
4383: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
4384: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4385: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4386: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

Line 4383: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;

4379: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4380: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4381:
4382: lx_req_line_tbl qp_preq_grp.line_tbl_type;
4383: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
4384: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4385: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4386: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4387: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;

Line 4384: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

4380: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4381:
4382: lx_req_line_tbl qp_preq_grp.line_tbl_type;
4383: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
4384: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4385: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4386: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4387: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4388: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;

Line 4385: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;

4381:
4382: lx_req_line_tbl qp_preq_grp.line_tbl_type;
4383: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
4384: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4385: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4386: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4387: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4388: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4389: lx_return_status varchar2 (1);

Line 4386: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

4382: lx_req_line_tbl qp_preq_grp.line_tbl_type;
4383: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
4384: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4385: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4386: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4387: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4388: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4389: lx_return_status varchar2 (1);
4390: lx_return_status_text varchar2 (2000);

Line 4387: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;

4383: lx_req_qual_tbl qp_preq_grp.qual_tbl_type;
4384: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4385: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4386: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4387: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4388: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4389: lx_return_status varchar2 (1);
4390: lx_return_status_text varchar2 (2000);
4391:

Line 4388: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;

4384: lx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
4385: lx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
4386: lx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
4387: lx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
4388: lx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
4389: lx_return_status varchar2 (1);
4390: lx_return_status_text varchar2 (2000);
4391:
4392: p number;

Line 6093: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,

6089:
6090: PROCEDURE calculate_hdr_price (
6091: p_detail_rec IN oks_qp_pkg.input_details,
6092: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
6093: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
6094: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
6095: x_return_status OUT NOCOPY VARCHAR2,
6096: x_msg_count OUT NOCOPY NUMBER,
6097: x_msg_data OUT NOCOPY VARCHAR2

Line 6355: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,

6351: p_api_version IN NUMBER,
6352: p_init_msg_list IN VARCHAR2,
6353: p_detail_rec IN oks_qp_pkg.input_details,
6354: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
6355: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
6356: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
6357: x_return_status OUT NOCOPY VARCHAR2,
6358: x_msg_count OUT NOCOPY NUMBER,
6359: x_msg_data OUT NOCOPY VARCHAR2

Line 7156: l_modif_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

7152: )
7153: IS
7154: l_input_details OKS_QP_PKG.INPUT_DETAILS;
7155: l_output_details OKS_QP_PKG.PRICE_DETAILS;
7156: l_modif_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7157: l_pb_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
7158: l_return_status VARCHAR2(20);
7159: l_msg_count NUMBER;
7160: l_msg_data VARCHAR2(2000);