DBA Data[Home] [Help]

APPS.FTE_RATE_CHART_PKG dependencies on QP_LIST_HEADERS

Line 243: FROM qp_list_headers_tl l, qp_list_headers_b b

239:
240: IF (p_carrier_id IS NULL) THEN
241: SELECT l.list_header_id, nvl(b.attribute1, 'FTE_RATE_CHART')
242: INTO l_list_header_id, l_attribute1
243: FROM qp_list_headers_tl l, qp_list_headers_b b
244: WHERE l.list_header_id = b.list_header_id
245: AND l.name = p_name
246: AND l.language = userenv('LANG');
247: ELSE

Line 250: FROM qp_list_headers_tl l, qp_list_headers_b b, qp_qualifiers q

246: AND l.language = userenv('LANG');
247: ELSE
248: SELECT l.list_header_id, nvl(b.attribute1, 'FTE_RATE_CHART')
249: INTO l_list_header_id, l_attribute1
250: FROM qp_list_headers_tl l, qp_list_headers_b b, qp_qualifiers q
251: WHERE l.list_header_id = b.list_header_id
252: AND l.name = p_name
253: AND l.list_header_id = q.list_header_id
254: AND q.qualifier_context = 'PARTY'

Line 301: l_list_header_id qp_list_headers_b.list_header_id%TYPE;

297: x_status OUT NOCOPY NUMBER,
298: x_error_msg OUT NOCOPY VARCHAR2) RETURN STRINGARRAY IS
299:
300: l_result STRINGARRAY;
301: l_list_header_id qp_list_headers_b.list_header_id%TYPE;
302: l_name qp_list_headers_tl.name%TYPE;
303: l_start_date VARCHAR2(50);
304: l_end_date VARCHAR2(50);
305: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.GET_RATE_CHART_INFO';

Line 302: l_name qp_list_headers_tl.name%TYPE;

298: x_error_msg OUT NOCOPY VARCHAR2) RETURN STRINGARRAY IS
299:
300: l_result STRINGARRAY;
301: l_list_header_id qp_list_headers_b.list_header_id%TYPE;
302: l_name qp_list_headers_tl.name%TYPE;
303: l_start_date VARCHAR2(50);
304: l_end_date VARCHAR2(50);
305: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.GET_RATE_CHART_INFO';
306:

Line 309: FROM qp_list_headers_b l, qp_qualifiers q, qp_list_headers_tl ltl

305: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.GET_RATE_CHART_INFO';
306:
307: CURSOR GET_CHART_INFO(p_name IN VARCHAR2, p_carrier_id IN NUMBER) IS
308: SELECT l.list_header_id, ltl.name, to_char(l.start_date_active,'YYYY-MM-DD'), to_char(l.end_date_active,'YYYY-MM-DD')
309: FROM qp_list_headers_b l, qp_qualifiers q, qp_list_headers_tl ltl
310: WHERE ltl.name = p_name
311: AND l.list_header_id=q.list_header_id
312: AND ltl.list_header_id = l.list_header_id
313: AND q.qualifier_context = 'PARTY'

Line 557: delete from qp_list_headers_b

553: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
554: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Deleted ' || sql%rowcount || ' qualifiers.');
555: END IF;
556:
557: delete from qp_list_headers_b
558: where list_header_id =l_list_header_id;
559:
560: delete from qp_list_headers_tl
561: where list_header_id = l_list_header_id;

Line 560: delete from qp_list_headers_tl

556:
557: delete from qp_list_headers_b
558: where list_header_id =l_list_header_id;
559:
560: delete from qp_list_headers_tl
561: where list_header_id = l_list_header_id;
562:
563: --For Facility Modifiers, delete stuff from fte_prc_parameters
564: IF (g_chart_type = 'FAC_MODIFIER') THEN

Line 645: FROM qp_list_headers_b hb, qp_list_headers_tl tl

641:
642: BEGIN
643: SELECT hb.list_header_id, hb.start_date_active, hb.end_date_active
644: INTO l_new_id, l_new_start_date, l_new_end_date
645: FROM qp_list_headers_b hb, qp_list_headers_tl tl
646: WHERE hb.list_header_id = tl.list_header_id
647: AND tl.name = p_new_name
648: AND tl.language = userenv('LANG');
649:

Line 680: -- Update QP_LIST_HEADERS_B

676: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
677: WHERE list_header_id = p_old_id
678: AND lane_id = l_lane_id;
679:
680: -- Update QP_LIST_HEADERS_B
681: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
682: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Update expiry date of old rate chart');
683: END IF;
684:

Line 685: UPDATE qp_list_headers_b

681: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
682: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Update expiry date of old rate chart');
683: END IF;
684:
685: UPDATE qp_list_headers_b
686: SET end_date_active = LEAST(end_date_active, l_new_start_date-0.00001),
687: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
688: LAST_UPDATE_DATE = sysdate,
689: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

Line 1341: FROM qp_list_headers_tl rc, qp_list_headers_b b,

1337: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.GET_ASSOC_MODIFIERS';
1338:
1339: CURSOR Get_Modifiers_With_Name IS
1340: SELECT modc.list_header_id
1341: FROM qp_list_headers_tl rc, qp_list_headers_b b,
1342: qp_list_headers_tl modc, qp_list_headers_b b2,
1343: qp_qualifiers mod_qual
1344: WHERE rc.list_header_id = b.list_header_id
1345: AND modc.list_header_id = b2.list_header_id

Line 1342: qp_list_headers_tl modc, qp_list_headers_b b2,

1338:
1339: CURSOR Get_Modifiers_With_Name IS
1340: SELECT modc.list_header_id
1341: FROM qp_list_headers_tl rc, qp_list_headers_b b,
1342: qp_list_headers_tl modc, qp_list_headers_b b2,
1343: qp_qualifiers mod_qual
1344: WHERE rc.list_header_id = b.list_header_id
1345: AND modc.list_header_id = b2.list_header_id
1346: AND mod_qual.qualifier_context = 'MODLIST'

Line 1357: FROM qp_list_headers_tl rc, qp_list_headers_b b,

1353: ORDER BY rc.creation_date DESC;
1354:
1355: CURSOR Get_Modifiers_With_ID IS
1356: SELECT modc.list_header_id
1357: FROM qp_list_headers_tl rc, qp_list_headers_b b,
1358: qp_list_headers_tl modc, qp_list_headers_b b2,
1359: qp_qualifiers mod_qual
1360: WHERE rc.list_header_id = b.list_header_id
1361: AND modc.list_header_id = b2.list_header_id

Line 1358: qp_list_headers_tl modc, qp_list_headers_b b2,

1354:
1355: CURSOR Get_Modifiers_With_ID IS
1356: SELECT modc.list_header_id
1357: FROM qp_list_headers_tl rc, qp_list_headers_b b,
1358: qp_list_headers_tl modc, qp_list_headers_b b2,
1359: qp_qualifiers mod_qual
1360: WHERE rc.list_header_id = b.list_header_id
1361: AND modc.list_header_id = b2.list_header_id
1362: AND mod_qual.qualifier_context = 'MODLIST'

Line 1427: FROM qp_list_headers_tl rc, qp_list_headers_b b,

1423: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.GET_ASSOC_PRICELISTS';
1424:
1425: CURSOR Get_Pricelists_With_Name IS
1426: SELECT rc.list_header_id
1427: FROM qp_list_headers_tl rc, qp_list_headers_b b,
1428: qp_list_headers_tl modc, qp_list_headers_b b2,
1429: qp_qualifiers mod_qual
1430: WHERE rc.list_header_id = b.list_header_id
1431: AND modc.list_header_id = b2.list_header_id

Line 1428: qp_list_headers_tl modc, qp_list_headers_b b2,

1424:
1425: CURSOR Get_Pricelists_With_Name IS
1426: SELECT rc.list_header_id
1427: FROM qp_list_headers_tl rc, qp_list_headers_b b,
1428: qp_list_headers_tl modc, qp_list_headers_b b2,
1429: qp_qualifiers mod_qual
1430: WHERE rc.list_header_id = b.list_header_id
1431: AND modc.list_header_id = b2.list_header_id
1432: AND mod_qual.qualifier_context = 'MODLIST'

Line 1443: FROM qp_list_headers_tl rc, qp_list_headers_b b,

1439: ORDER BY rc.creation_date DESC;
1440:
1441: CURSOR Get_Pricelists_With_ID IS
1442: SELECT rc.list_header_id
1443: FROM qp_list_headers_tl rc, qp_list_headers_b b,
1444: qp_list_headers_tl modc, qp_list_headers_b b2,
1445: qp_qualifiers mod_qual
1446: WHERE rc.list_header_id = b.list_header_id
1447: AND modc.list_header_id = b2.list_header_id

Line 1444: qp_list_headers_tl modc, qp_list_headers_b b2,

1440:
1441: CURSOR Get_Pricelists_With_ID IS
1442: SELECT rc.list_header_id
1443: FROM qp_list_headers_tl rc, qp_list_headers_b b,
1444: qp_list_headers_tl modc, qp_list_headers_b b2,
1445: qp_qualifiers mod_qual
1446: WHERE rc.list_header_id = b.list_header_id
1447: AND modc.list_header_id = b2.list_header_id
1448: AND mod_qual.qualifier_context = 'MODLIST'

Line 1536: FROM qp_list_headers

1532: l_result VARCHAR2(10);
1533:
1534: CURSOR GET_CURRENCY_HEADER_ID(p_list_header_id IN NUMBER) IS
1535: SELECT currency_header_id
1536: FROM qp_list_headers
1537: WHERE list_header_id = p_list_header_id;
1538:
1539: CURSOR CONVERSION_EXIST(p_currency_header_id IN NUMBER, p_currency IN VARCHAR2) IS
1540: SELECT 'TRUE'

Line 1547: FROM qp_list_headers_tl lh,

1543: AND to_currency_code = p_currency;
1544:
1545: CURSOR GET_MOD_PRICELIST(p_name IN VARCHAR2) IS
1546: SELECT to_char(b.list_header_id)
1547: FROM qp_list_headers_tl lh,
1548: qp_list_headers_b b,
1549: qp_qualifiers qc,
1550: qp_qualifiers qs,
1551: qp_qualifiers qm,

Line 1548: qp_list_headers_b b,

1544:
1545: CURSOR GET_MOD_PRICELIST(p_name IN VARCHAR2) IS
1546: SELECT to_char(b.list_header_id)
1547: FROM qp_list_headers_tl lh,
1548: qp_list_headers_b b,
1549: qp_qualifiers qc,
1550: qp_qualifiers qs,
1551: qp_qualifiers qm,
1552: qp_list_headers_tl modlh,

Line 1552: qp_list_headers_tl modlh,

1548: qp_list_headers_b b,
1549: qp_qualifiers qc,
1550: qp_qualifiers qs,
1551: qp_qualifiers qm,
1552: qp_list_headers_tl modlh,
1553: qp_qualifiers modqs,
1554: qp_qualifiers modqc
1555: WHERE modlh.name = p_name AND
1556: modlh.list_header_id = modqs.list_header_id AND