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.QP_PS_ATTR_GRP_PVT dependencies on QP_LIST_HEADERS

Line 39: FROM qp_list_lines qpl, qp_list_headers_all_b qph

35: -- Price List Lines
36: SELECT /*+ ordered USE_NL(qpl qph) */
37: qpl.pricing_phase_id, qpl.pattern_id, qpl.START_DATE_ACTIVE sda,
38: qpl.END_DATE_ACTIVE eda, qph.active_flag
39: FROM qp_list_lines qpl, qp_list_headers_all_b qph
40: WHERE pricing_phase_id = 1
41: AND qph.list_header_id = qpl.list_header_id
42: UNION ALL
43: -- Price List headers

Line 88: FROM qp_list_lines qpl, qp_list_headers_all_b qph

84: -- Price List Lines
85: SELECT /*+ ordered USE_NL(qpl qph) index(qpl QP_LIST_LINES_N1) */
86: qpl.pricing_phase_id, qpl.pattern_id, qpl.START_DATE_ACTIVE sda,
87: qpl.END_DATE_ACTIVE eda, qph.active_flag
88: FROM qp_list_lines qpl, qp_list_headers_all_b qph
89: WHERE pricing_phase_id = 1
90: AND qpl.list_header_id = p_list_header_id --NVL(p_list_header_id, qpl.list_header_id)
91: AND qph.list_header_id = qpl.list_header_id
92: UNION ALL

Line 137: FROM qp_list_lines qpl, qp_list_headers_all_b qph

133: -- Price List Lines
134: SELECT /*+ ordered */
135: qpl.pricing_phase_id, qpl.pattern_id, qpl.START_DATE_ACTIVE sda,
136: qpl.END_DATE_ACTIVE eda, qph.active_flag
137: FROM qp_list_lines qpl, qp_list_headers_all_b qph
138: WHERE pricing_phase_id = 1
139: AND qph.list_header_id = qpl.list_header_id
140: UNION ALL
141: -- Price List headers

Line 199: FROM qp_list_lines qpl, qp_list_headers_all_b qph

195: l_start_date_tbl,
196: l_end_date_tbl,
197: l_active_flag_tbl
198: --bug 9594320 end
199: FROM qp_list_lines qpl, qp_list_headers_all_b qph
200: WHERE qpl.list_line_id = p_min_list_line_id
201: AND qph.list_header_id = qpl.list_header_id;
202:
203: ELSIF g_qp_pattern_search IN ('M','B') AND g_list_type NOT IN ('PRL','AGR','PML') THEN -- IF 1.1

Line 649: from qp_list_lines qpl, qp_list_headers_all_b qph

645: union all
646: -- Price List Lines
647: select /*+ ordered */ qpl.pricing_phase_id, qpl.pattern_id, qpl.START_DATE_ACTIVE sda,
648: qpl.END_DATE_ACTIVE eda, qph.active_flag
649: from qp_list_lines qpl, qp_list_headers_all_b qph
650: where pricing_phase_id = 1
651: and qph.list_header_id = qpl.list_header_id
652: union ALL
653: -- Price List headers

Line 718: SELECT list_type_code INTO g_list_type FROM qp_list_headers WHERE list_header_id = p_list_header_id;

714: g_qp_pattern_search := FND_PROFILE.VALUE('QP_PATTERN_SEARCH');
715: END IF;
716:
717: IF p_list_header_id IS NOT NULL THEN
718: SELECT list_type_code INTO g_list_type FROM qp_list_headers WHERE list_header_id = p_list_header_id;
719: ELSIF g_qp_pattern_search = 'P' THEN
720: g_list_type := 'PRL';
721: ELSE
722: g_list_type := 'JP'; --- 'JP' is a dummy value

Line 1124: qp_list_headers_all_b qph

1120: qpq.qualifier_datatype attribute_datatype,
1121: qpq.qualifier_attr_value attribute_value,
1122: 'QUAL' attribute_type
1123: from qp_qualifiers qpq,
1124: qp_list_headers_all_b qph
1125: where qpq.list_line_id = -1
1126: and qph.list_header_id = qpq.list_header_id
1127: and qpq.list_header_id = nvl(p_list_header_id, qpq.list_header_id)
1128: and ((p_qualifier_group is not null and qpq.qualifier_grouping_no in (-1, p_qualifier_group))

Line 1182: from qp_list_headers_all_b qph

1178: null modifier_level_code,
1179: 'C' attribute_datatype,--qpq.qualifier_datatype attribute_datatype,
1180: NULL attribute_value, --qpq.qualifier_attr_value attribute_value,
1181: 'BLIN' attribute_type
1182: from qp_list_headers_all_b qph
1183: where
1184: qph.list_header_id = nvl(p_list_header_id, qph.list_header_id)
1185: AND NOT EXISTS ( SELECT 1
1186: FROM qp_qualifiers qpq

Line 1322: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_qualifiers qpq

1318: qpl.modifier_level_code modifier_level_code,
1319: qpq.qualifier_datatype attribute_datatype,
1320: qpq.qualifier_attr_value attribute_value,
1321: 'QUAL' attribute_type
1322: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_qualifiers qpq
1323: where qph.list_header_id = p_list_header_id
1324: AND qpl.list_header_id = qph.list_header_id
1325: and qph.list_header_id = qpq.list_header_id
1326: and qpl.list_line_id = qpq.list_line_id

Line 1382: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_pricing_attributes qpa

1378: qpl.modifier_level_code modifier_level_code,
1379: qpa.product_attribute_datatype attribute_datatype,
1380: qpa.product_attr_value attribute_value,
1381: 'PROD' attribute_type
1382: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_pricing_attributes qpa
1383: where qph.list_header_id = p_list_header_id
1384: AND qpl.list_header_id = qph.list_header_id
1385: and qpl.list_line_id = qpa.list_line_id
1386: and qpa.excluder_flag = 'N'

Line 1441: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_pricing_attributes qpa

1437: qpl.modifier_level_code modifier_level_code,
1438: qpa.pricing_attribute_datatype attribute_datatype,
1439: qpa.pricing_attr_value_from attribute_value,
1440: 'PRIC' attribute_type
1441: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_pricing_attributes qpa
1442: where qph.list_header_id = p_list_header_id
1443: AND qph.list_header_id = qpl.list_header_id
1444: and qpl.list_line_id = qpa.list_line_id
1445: and qpl.pricing_phase_id > 1

Line 1498: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_qualifiers qpq

1494: qpl.modifier_level_code modifier_level_code,
1495: qpq.qualifier_datatype attribute_datatype,
1496: qpq.qualifier_attr_value attribute_value,
1497: 'QUAL' attribute_type
1498: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_qualifiers qpq
1499: where qpl.list_header_id = qph.list_header_id
1500: and qph.list_header_id = qpq.list_header_id
1501: and qpl.list_line_id = qpq.list_line_id
1502: AND qpq.list_line_id <> -1

Line 1557: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_pricing_attributes qpa

1553: qpl.modifier_level_code modifier_level_code,
1554: qpa.product_attribute_datatype attribute_datatype,
1555: qpa.product_attr_value attribute_value,
1556: 'PROD' attribute_type
1557: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_pricing_attributes qpa
1558: where qpl.list_header_id = qph.list_header_id
1559: and qpl.list_line_id = qpa.list_line_id
1560: and qpa.excluder_flag = 'N'
1561: and qpl.pricing_phase_id > 1

Line 1615: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_pricing_attributes qpa

1611: qpl.modifier_level_code modifier_level_code,
1612: qpa.pricing_attribute_datatype attribute_datatype,
1613: qpa.pricing_attr_value_from attribute_value,
1614: 'PRIC' attribute_type
1615: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_pricing_attributes qpa
1616: where qph.list_header_id = qpl.list_header_id
1617: and qpl.list_line_id = qpa.list_line_id
1618: and qpl.pricing_phase_id > 1
1619: and qpl.qualification_ind in (8,10,12,14,28,30)

Line 1798: from qp_list_headers_all_b qph,

1794:
1795: ---- Added for PL/SQL Pattern Search
1796:
1797: 'PROD' attribute_type
1798: from qp_list_headers_all_b qph,
1799: qp_list_lines qpl,
1800: qp_pricing_attributes qpa
1801: where qph.list_header_id = p_list_header_id
1802: AND qph.list_header_id = qpl.list_header_id

Line 1861: from qp_list_headers_all_b qph,

1857:
1858: ---- Added for PL/SQL Pattern Search
1859:
1860: 'PRIC' attribute_type
1861: from qp_list_headers_all_b qph,
1862: qp_list_lines qpl,
1863: qp_pricing_attributes qpa
1864: where qph.list_header_id = p_list_header_id
1865: AND qpl.list_header_id = qph.list_header_id

Line 1921: from qp_list_headers_all_b qph,

1917:
1918: ---- Added for PL/SQL Pattern Search
1919:
1920: 'BLIN' attribute_type
1921: from qp_list_headers_all_b qph,
1922: qp_list_lines qpl
1923: where qph.list_header_id = p_list_header_id
1924: AND qpl.list_header_id = qph.list_header_id
1925: and qpl.qualification_ind in (0,2)

Line 1979: from qp_list_headers_all_b qph,

1975: qpl.automatic_flag,
1976:
1977: ---- Added for PL/SQL Pattern Search
1978: 'PROD' attribute_type
1979: from qp_list_headers_all_b qph,
1980: qp_list_lines qpl,
1981: qp_pricing_attributes qpa
1982: where qph.list_header_id = qpl.list_header_id
1983: AND qpl.list_line_id = qpa.list_line_id

Line 2039: from qp_list_headers_all_b qph,

2035: qpl.list_line_type_code,
2036: qpl.automatic_flag,
2037: ---- Added for PL/SQL Pattern Search
2038: 'PRIC' attribute_type
2039: from qp_list_headers_all_b qph,
2040: qp_list_lines qpl,
2041: qp_pricing_attributes qpa
2042: where qpl.list_header_id = qph.list_header_id
2043: AND qpl.list_line_id = qpa.list_line_id

Line 2095: from qp_list_headers_all_b qph,

2091: qpl.list_line_type_code,
2092: qpl.automatic_flag,
2093: ---- Added for PL/SQL Pattern Search
2094: 'BLIN' attribute_type
2095: from qp_list_headers_all_b qph,
2096: qp_list_lines qpl
2097: where qpl.list_header_id = qph.list_header_id
2098: and qpl.qualification_ind in (0,2)
2099: and qpl.list_line_id between p_low_list_line_id and p_high_list_line_id

Line 4160: from qp_list_headers_all_b

4156:
4157: if l_prl_flag='N' then
4158:
4159: select list_type_code into l_list_type
4160: from qp_list_headers_all_b
4161: where list_header_id = p_list_header_id;
4162:
4163: if l_list_type = 'PRL' then
4164: begin

Line 4302: l_ACTIVE_FLAG qp_list_headers_all_b.active_flag%type;

4298: l_status_code VARCHAR2(30) := NULL;
4299: l_status_text VARCHAR2(2000) := NULL;
4300: l_pattern_id NUMBER;
4301: l_qual_exists VARCHAR2(1) := 'N';
4302: l_ACTIVE_FLAG qp_list_headers_all_b.active_flag%type;
4303: l_LIST_TYPE_CODE qp_list_headers_all_b.list_type_code%type;
4304: l_CURRENCY_CODE qp_list_headers_all_b.CURRENCY_CODE%type;
4305: l_ASK_FOR_FLAG qp_list_headers_all_b.ASK_FOR_FLAG%type;
4306: l_HEADER_LIMIT_EXISTS qp_list_headers_all_b.LIMIT_EXISTS_FLAG%type;

Line 4303: l_LIST_TYPE_CODE qp_list_headers_all_b.list_type_code%type;

4299: l_status_text VARCHAR2(2000) := NULL;
4300: l_pattern_id NUMBER;
4301: l_qual_exists VARCHAR2(1) := 'N';
4302: l_ACTIVE_FLAG qp_list_headers_all_b.active_flag%type;
4303: l_LIST_TYPE_CODE qp_list_headers_all_b.list_type_code%type;
4304: l_CURRENCY_CODE qp_list_headers_all_b.CURRENCY_CODE%type;
4305: l_ASK_FOR_FLAG qp_list_headers_all_b.ASK_FOR_FLAG%type;
4306: l_HEADER_LIMIT_EXISTS qp_list_headers_all_b.LIMIT_EXISTS_FLAG%type;
4307: l_SOURCE_SYSTEM_CODE qp_list_headers_all_b.SOURCE_SYSTEM_CODE%type;

Line 4304: l_CURRENCY_CODE qp_list_headers_all_b.CURRENCY_CODE%type;

4300: l_pattern_id NUMBER;
4301: l_qual_exists VARCHAR2(1) := 'N';
4302: l_ACTIVE_FLAG qp_list_headers_all_b.active_flag%type;
4303: l_LIST_TYPE_CODE qp_list_headers_all_b.list_type_code%type;
4304: l_CURRENCY_CODE qp_list_headers_all_b.CURRENCY_CODE%type;
4305: l_ASK_FOR_FLAG qp_list_headers_all_b.ASK_FOR_FLAG%type;
4306: l_HEADER_LIMIT_EXISTS qp_list_headers_all_b.LIMIT_EXISTS_FLAG%type;
4307: l_SOURCE_SYSTEM_CODE qp_list_headers_all_b.SOURCE_SYSTEM_CODE%type;
4308: l_END_DATE_ACTIVE qp_list_headers_all_b.END_DATE_ACTIVE%type;

Line 4305: l_ASK_FOR_FLAG qp_list_headers_all_b.ASK_FOR_FLAG%type;

4301: l_qual_exists VARCHAR2(1) := 'N';
4302: l_ACTIVE_FLAG qp_list_headers_all_b.active_flag%type;
4303: l_LIST_TYPE_CODE qp_list_headers_all_b.list_type_code%type;
4304: l_CURRENCY_CODE qp_list_headers_all_b.CURRENCY_CODE%type;
4305: l_ASK_FOR_FLAG qp_list_headers_all_b.ASK_FOR_FLAG%type;
4306: l_HEADER_LIMIT_EXISTS qp_list_headers_all_b.LIMIT_EXISTS_FLAG%type;
4307: l_SOURCE_SYSTEM_CODE qp_list_headers_all_b.SOURCE_SYSTEM_CODE%type;
4308: l_END_DATE_ACTIVE qp_list_headers_all_b.END_DATE_ACTIVE%type;
4309: l_START_DATE_ACTIVE qp_list_headers_all_b.START_DATE_ACTIVE%type;

Line 4306: l_HEADER_LIMIT_EXISTS qp_list_headers_all_b.LIMIT_EXISTS_FLAG%type;

4302: l_ACTIVE_FLAG qp_list_headers_all_b.active_flag%type;
4303: l_LIST_TYPE_CODE qp_list_headers_all_b.list_type_code%type;
4304: l_CURRENCY_CODE qp_list_headers_all_b.CURRENCY_CODE%type;
4305: l_ASK_FOR_FLAG qp_list_headers_all_b.ASK_FOR_FLAG%type;
4306: l_HEADER_LIMIT_EXISTS qp_list_headers_all_b.LIMIT_EXISTS_FLAG%type;
4307: l_SOURCE_SYSTEM_CODE qp_list_headers_all_b.SOURCE_SYSTEM_CODE%type;
4308: l_END_DATE_ACTIVE qp_list_headers_all_b.END_DATE_ACTIVE%type;
4309: l_START_DATE_ACTIVE qp_list_headers_all_b.START_DATE_ACTIVE%type;
4310: l_START_DATE_ACTIVE_FIRST qp_list_headers_all_b.START_DATE_ACTIVE_FIRST%type;

Line 4307: l_SOURCE_SYSTEM_CODE qp_list_headers_all_b.SOURCE_SYSTEM_CODE%type;

4303: l_LIST_TYPE_CODE qp_list_headers_all_b.list_type_code%type;
4304: l_CURRENCY_CODE qp_list_headers_all_b.CURRENCY_CODE%type;
4305: l_ASK_FOR_FLAG qp_list_headers_all_b.ASK_FOR_FLAG%type;
4306: l_HEADER_LIMIT_EXISTS qp_list_headers_all_b.LIMIT_EXISTS_FLAG%type;
4307: l_SOURCE_SYSTEM_CODE qp_list_headers_all_b.SOURCE_SYSTEM_CODE%type;
4308: l_END_DATE_ACTIVE qp_list_headers_all_b.END_DATE_ACTIVE%type;
4309: l_START_DATE_ACTIVE qp_list_headers_all_b.START_DATE_ACTIVE%type;
4310: l_START_DATE_ACTIVE_FIRST qp_list_headers_all_b.START_DATE_ACTIVE_FIRST%type;
4311: l_END_DATE_ACTIVE_FIRST qp_list_headers_all_b.END_DATE_ACTIVE_FIRST%type;

Line 4308: l_END_DATE_ACTIVE qp_list_headers_all_b.END_DATE_ACTIVE%type;

4304: l_CURRENCY_CODE qp_list_headers_all_b.CURRENCY_CODE%type;
4305: l_ASK_FOR_FLAG qp_list_headers_all_b.ASK_FOR_FLAG%type;
4306: l_HEADER_LIMIT_EXISTS qp_list_headers_all_b.LIMIT_EXISTS_FLAG%type;
4307: l_SOURCE_SYSTEM_CODE qp_list_headers_all_b.SOURCE_SYSTEM_CODE%type;
4308: l_END_DATE_ACTIVE qp_list_headers_all_b.END_DATE_ACTIVE%type;
4309: l_START_DATE_ACTIVE qp_list_headers_all_b.START_DATE_ACTIVE%type;
4310: l_START_DATE_ACTIVE_FIRST qp_list_headers_all_b.START_DATE_ACTIVE_FIRST%type;
4311: l_END_DATE_ACTIVE_FIRST qp_list_headers_all_b.END_DATE_ACTIVE_FIRST%type;
4312: l_ACTIVE_DATE_FIRST_TYPE qp_list_headers_all_b.ACTIVE_DATE_FIRST_TYPE%type;

Line 4309: l_START_DATE_ACTIVE qp_list_headers_all_b.START_DATE_ACTIVE%type;

4305: l_ASK_FOR_FLAG qp_list_headers_all_b.ASK_FOR_FLAG%type;
4306: l_HEADER_LIMIT_EXISTS qp_list_headers_all_b.LIMIT_EXISTS_FLAG%type;
4307: l_SOURCE_SYSTEM_CODE qp_list_headers_all_b.SOURCE_SYSTEM_CODE%type;
4308: l_END_DATE_ACTIVE qp_list_headers_all_b.END_DATE_ACTIVE%type;
4309: l_START_DATE_ACTIVE qp_list_headers_all_b.START_DATE_ACTIVE%type;
4310: l_START_DATE_ACTIVE_FIRST qp_list_headers_all_b.START_DATE_ACTIVE_FIRST%type;
4311: l_END_DATE_ACTIVE_FIRST qp_list_headers_all_b.END_DATE_ACTIVE_FIRST%type;
4312: l_ACTIVE_DATE_FIRST_TYPE qp_list_headers_all_b.ACTIVE_DATE_FIRST_TYPE%type;
4313: l_START_DATE_ACTIVE_SECOND qp_list_headers_all_b.START_DATE_ACTIVE_SECOND%type;

Line 4310: l_START_DATE_ACTIVE_FIRST qp_list_headers_all_b.START_DATE_ACTIVE_FIRST%type;

4306: l_HEADER_LIMIT_EXISTS qp_list_headers_all_b.LIMIT_EXISTS_FLAG%type;
4307: l_SOURCE_SYSTEM_CODE qp_list_headers_all_b.SOURCE_SYSTEM_CODE%type;
4308: l_END_DATE_ACTIVE qp_list_headers_all_b.END_DATE_ACTIVE%type;
4309: l_START_DATE_ACTIVE qp_list_headers_all_b.START_DATE_ACTIVE%type;
4310: l_START_DATE_ACTIVE_FIRST qp_list_headers_all_b.START_DATE_ACTIVE_FIRST%type;
4311: l_END_DATE_ACTIVE_FIRST qp_list_headers_all_b.END_DATE_ACTIVE_FIRST%type;
4312: l_ACTIVE_DATE_FIRST_TYPE qp_list_headers_all_b.ACTIVE_DATE_FIRST_TYPE%type;
4313: l_START_DATE_ACTIVE_SECOND qp_list_headers_all_b.START_DATE_ACTIVE_SECOND%type;
4314: l_END_DATE_ACTIVE_SECOND qp_list_headers_all_b.END_DATE_ACTIVE_SECOND%type;

Line 4311: l_END_DATE_ACTIVE_FIRST qp_list_headers_all_b.END_DATE_ACTIVE_FIRST%type;

4307: l_SOURCE_SYSTEM_CODE qp_list_headers_all_b.SOURCE_SYSTEM_CODE%type;
4308: l_END_DATE_ACTIVE qp_list_headers_all_b.END_DATE_ACTIVE%type;
4309: l_START_DATE_ACTIVE qp_list_headers_all_b.START_DATE_ACTIVE%type;
4310: l_START_DATE_ACTIVE_FIRST qp_list_headers_all_b.START_DATE_ACTIVE_FIRST%type;
4311: l_END_DATE_ACTIVE_FIRST qp_list_headers_all_b.END_DATE_ACTIVE_FIRST%type;
4312: l_ACTIVE_DATE_FIRST_TYPE qp_list_headers_all_b.ACTIVE_DATE_FIRST_TYPE%type;
4313: l_START_DATE_ACTIVE_SECOND qp_list_headers_all_b.START_DATE_ACTIVE_SECOND%type;
4314: l_END_DATE_ACTIVE_SECOND qp_list_headers_all_b.END_DATE_ACTIVE_SECOND%type;
4315: l_ACTIVE_DATE_SECOND_TYPE qp_list_headers_all_b.ACTIVE_DATE_SECOND_TYPE%type;

Line 4312: l_ACTIVE_DATE_FIRST_TYPE qp_list_headers_all_b.ACTIVE_DATE_FIRST_TYPE%type;

4308: l_END_DATE_ACTIVE qp_list_headers_all_b.END_DATE_ACTIVE%type;
4309: l_START_DATE_ACTIVE qp_list_headers_all_b.START_DATE_ACTIVE%type;
4310: l_START_DATE_ACTIVE_FIRST qp_list_headers_all_b.START_DATE_ACTIVE_FIRST%type;
4311: l_END_DATE_ACTIVE_FIRST qp_list_headers_all_b.END_DATE_ACTIVE_FIRST%type;
4312: l_ACTIVE_DATE_FIRST_TYPE qp_list_headers_all_b.ACTIVE_DATE_FIRST_TYPE%type;
4313: l_START_DATE_ACTIVE_SECOND qp_list_headers_all_b.START_DATE_ACTIVE_SECOND%type;
4314: l_END_DATE_ACTIVE_SECOND qp_list_headers_all_b.END_DATE_ACTIVE_SECOND%type;
4315: l_ACTIVE_DATE_SECOND_TYPE qp_list_headers_all_b.ACTIVE_DATE_SECOND_TYPE%type;
4316: l_GLOBAL_FLAG qp_list_headers_all_b.GLOBAL_FLAG%type;

Line 4313: l_START_DATE_ACTIVE_SECOND qp_list_headers_all_b.START_DATE_ACTIVE_SECOND%type;

4309: l_START_DATE_ACTIVE qp_list_headers_all_b.START_DATE_ACTIVE%type;
4310: l_START_DATE_ACTIVE_FIRST qp_list_headers_all_b.START_DATE_ACTIVE_FIRST%type;
4311: l_END_DATE_ACTIVE_FIRST qp_list_headers_all_b.END_DATE_ACTIVE_FIRST%type;
4312: l_ACTIVE_DATE_FIRST_TYPE qp_list_headers_all_b.ACTIVE_DATE_FIRST_TYPE%type;
4313: l_START_DATE_ACTIVE_SECOND qp_list_headers_all_b.START_DATE_ACTIVE_SECOND%type;
4314: l_END_DATE_ACTIVE_SECOND qp_list_headers_all_b.END_DATE_ACTIVE_SECOND%type;
4315: l_ACTIVE_DATE_SECOND_TYPE qp_list_headers_all_b.ACTIVE_DATE_SECOND_TYPE%type;
4316: l_GLOBAL_FLAG qp_list_headers_all_b.GLOBAL_FLAG%type;
4317:

Line 4314: l_END_DATE_ACTIVE_SECOND qp_list_headers_all_b.END_DATE_ACTIVE_SECOND%type;

4310: l_START_DATE_ACTIVE_FIRST qp_list_headers_all_b.START_DATE_ACTIVE_FIRST%type;
4311: l_END_DATE_ACTIVE_FIRST qp_list_headers_all_b.END_DATE_ACTIVE_FIRST%type;
4312: l_ACTIVE_DATE_FIRST_TYPE qp_list_headers_all_b.ACTIVE_DATE_FIRST_TYPE%type;
4313: l_START_DATE_ACTIVE_SECOND qp_list_headers_all_b.START_DATE_ACTIVE_SECOND%type;
4314: l_END_DATE_ACTIVE_SECOND qp_list_headers_all_b.END_DATE_ACTIVE_SECOND%type;
4315: l_ACTIVE_DATE_SECOND_TYPE qp_list_headers_all_b.ACTIVE_DATE_SECOND_TYPE%type;
4316: l_GLOBAL_FLAG qp_list_headers_all_b.GLOBAL_FLAG%type;
4317:
4318:

Line 4315: l_ACTIVE_DATE_SECOND_TYPE qp_list_headers_all_b.ACTIVE_DATE_SECOND_TYPE%type;

4311: l_END_DATE_ACTIVE_FIRST qp_list_headers_all_b.END_DATE_ACTIVE_FIRST%type;
4312: l_ACTIVE_DATE_FIRST_TYPE qp_list_headers_all_b.ACTIVE_DATE_FIRST_TYPE%type;
4313: l_START_DATE_ACTIVE_SECOND qp_list_headers_all_b.START_DATE_ACTIVE_SECOND%type;
4314: l_END_DATE_ACTIVE_SECOND qp_list_headers_all_b.END_DATE_ACTIVE_SECOND%type;
4315: l_ACTIVE_DATE_SECOND_TYPE qp_list_headers_all_b.ACTIVE_DATE_SECOND_TYPE%type;
4316: l_GLOBAL_FLAG qp_list_headers_all_b.GLOBAL_FLAG%type;
4317:
4318:
4319: BEGIN

Line 4316: l_GLOBAL_FLAG qp_list_headers_all_b.GLOBAL_FLAG%type;

4312: l_ACTIVE_DATE_FIRST_TYPE qp_list_headers_all_b.ACTIVE_DATE_FIRST_TYPE%type;
4313: l_START_DATE_ACTIVE_SECOND qp_list_headers_all_b.START_DATE_ACTIVE_SECOND%type;
4314: l_END_DATE_ACTIVE_SECOND qp_list_headers_all_b.END_DATE_ACTIVE_SECOND%type;
4315: l_ACTIVE_DATE_SECOND_TYPE qp_list_headers_all_b.ACTIVE_DATE_SECOND_TYPE%type;
4316: l_GLOBAL_FLAG qp_list_headers_all_b.GLOBAL_FLAG%type;
4317:
4318:
4319: BEGIN
4320: g_qp_pattern_search := FND_PROFILE.VALUE('QP_PATTERN_SEARCH');

Line 4335: SELECT list_type_code INTO g_list_type FROM qp_list_headers WHERE list_header_id = p_list_header_id;

4331: write_log( 'Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
4332: end if;
4333:
4334: IF p_list_header_id IS NOT NULL THEN
4335: SELECT list_type_code INTO g_list_type FROM qp_list_headers WHERE list_header_id = p_list_header_id;
4336: ELSIF g_qp_pattern_search = 'P' THEN
4337: g_list_type := 'PRL';
4338: ELSE
4339: g_list_type := 'JP';

Line 4454: from qp_list_headers_all_b

4450: l_START_DATE_ACTIVE_SECOND,
4451: l_END_DATE_ACTIVE_SECOND,
4452: l_ACTIVE_DATE_SECOND_TYPE,
4453: l_GLOBAL_FLAG
4454: from qp_list_headers_all_b
4455: where list_header_id = p_list_header_id;
4456:
4457: -- update header pattern records
4458: update qp_attribute_groups

Line 4611: SELECT list_type_code INTO g_list_type FROM qp_list_headers WHERE list_header_id = p_list_header_id;

4607: write_log( 'Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
4608: end if;
4609:
4610: IF p_list_header_id IS NOT NULL THEN
4611: SELECT list_type_code INTO g_list_type FROM qp_list_headers WHERE list_header_id = p_list_header_id;
4612: ELSIF g_qp_pattern_search = 'P' THEN
4613: g_list_type := 'PRL';
4614: ELSE
4615: g_list_type := 'JP';

Line 4861: SELECT list_type_code INTO g_list_type FROM qp_list_headers WHERE list_header_id = p_list_header_id;

4857: into l_qual_ind
4858: from qp_list_lines
4859: where list_line_id = p_list_line_id;
4860: IF p_list_header_id IS NOT NULL THEN
4861: SELECT list_type_code INTO g_list_type FROM qp_list_headers WHERE list_header_id = p_list_header_id;
4862: ELSIF g_qp_pattern_search = 'P' THEN
4863: g_list_type := 'PRL';
4864: ELSE
4865: g_list_type := 'JP';