DBA Data[Home] [Help]

APPS.CST_PL_IMPORT dependencies on QP_PREQ_GRP

Line 32: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

28: -- 2 Specific item
29: -- 5 category
30: --
31:
32: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
33: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
34: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
35: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 33: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

29: -- 5 category
30: --
31:
32: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
33: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
34: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
35: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 34: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

30: --
31:
32: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
33: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
34: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
35: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 35: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

31:
32: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
33: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
34: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
35: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

Line 36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

32: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
33: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
34: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
35: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

Line 37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

33: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
34: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
35: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;

Line 38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

34: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
35: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

Line 39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

35: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
43: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

Line 40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
43: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
44: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;

37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
43: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
44: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
45: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
43: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
44: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
45: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
46: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 43: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
43: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
44: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
45: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
46: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
47: x_return_status VARCHAR2(240);

Line 44: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
43: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
44: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
45: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
46: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
47: x_return_status VARCHAR2(240);
48: x_return_status_text VARCHAR2(240);

Line 45: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
43: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
44: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
45: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
46: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
47: x_return_status VARCHAR2(240);
48: x_return_status_text VARCHAR2(240);
49: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;

Line 46: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
43: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
44: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
45: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
46: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
47: x_return_status VARCHAR2(240);
48: x_return_status_text VARCHAR2(240);
49: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
50: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;

Line 49: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;

45: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
46: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
47: x_return_status VARCHAR2(240);
48: x_return_status_text VARCHAR2(240);
49: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
50: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
51: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
52: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
53:

Line 50: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;

46: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
47: x_return_status VARCHAR2(240);
48: x_return_status_text VARCHAR2(240);
49: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
50: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
51: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
52: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
53:
54: I BINARY_INTEGER;

Line 51: line_rec QP_PREQ_GRP.LINE_REC_TYPE;

47: x_return_status VARCHAR2(240);
48: x_return_status_text VARCHAR2(240);
49: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
50: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
51: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
52: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
53:
54: I BINARY_INTEGER;
55: J BINARY_INTEGER;

Line 52: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;

48: x_return_status_text VARCHAR2(240);
49: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
50: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
51: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
52: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
53:
54: I BINARY_INTEGER;
55: J BINARY_INTEGER;
56: l_version VARCHAR2(240);

Line 396: l_version := QP_PREQ_GRP.GET_VERSION;

392: FND_FILE.put_line(fnd_file.log,'No matching items found for specified parameters') ;
393: RETURN;
394: End if ;
395:
396: l_version := QP_PREQ_GRP.GET_VERSION;
397: FND_FILE.put_line( fnd_file.log , 'Testing version '|| l_version);
398:
399: l_stmt_num := 60 ;
400: QP_PREQ_GRP.PRICE_REQUEST

Line 400: QP_PREQ_GRP.PRICE_REQUEST

396: l_version := QP_PREQ_GRP.GET_VERSION;
397: FND_FILE.put_line( fnd_file.log , 'Testing version '|| l_version);
398:
399: l_stmt_num := 60 ;
400: QP_PREQ_GRP.PRICE_REQUEST
401: (p_line_tbl,
402: p_qual_tbl,
403: p_line_attr_tbl,
404: p_line_detail_tbl,