APPS.QP_CURR_LISTS_UTIL dependencies on QP_CURRENCY_LISTS_TL

Line 955: update QP_CURRENCY_LISTS_TL set

951:
952: -- oe_debug_pub.add('After Update of B');
953:
954: -- Added by Sunil
955: update QP_CURRENCY_LISTS_TL set
956: NAME = p_CURR_LISTS_rec.NAME
957: , DESCRIPTION = p_CURR_LISTS_rec.DESCRIPTION
958: , LAST_UPDATE_DATE = p_CURR_LISTS_rec.LAST_UPDATE_DATE
959: , LAST_UPDATED_BY = p_CURR_LISTS_rec.LAST_UPDATED_BY

Line 1130: Insert into QP_CURRENCY_LISTS_TL

1126: -- Added by Sunil Pandey 10/01/01
1127:
1128: -- Added by Sunil
1129: BEGIN
1130: Insert into QP_CURRENCY_LISTS_TL
1131: ( CURRENCY_HEADER_ID
1132: , NAME
1133: , DESCRIPTION
1134: , CREATION_DATE

Line 1155: (select NULL from QP_CURRENCY_LISTS_TL T

1151: , userenv('LANG')
1152: from FND_LANGUAGES L
1153: where L.INSTALLED_FLAG in ('I','B')
1154: and not exists
1155: (select NULL from QP_CURRENCY_LISTS_TL T
1156: where T.CURRENCY_HEADER_ID = p_CURR_LISTS_rec.CURRENCY_HEADER_ID
1157: and T.LANGUAGE = L.LANGUAGE_CODE);
1158:
1159: Exception

Line 1270: DELETE FROM QP_CURRENCY_LISTS_TL

1266: WHERE CURRENCY_HEADER_ID = p_currency_header_id
1267: ;
1268:
1269: -- Added by Sunil
1270: DELETE FROM QP_CURRENCY_LISTS_TL
1271: WHERE CURRENCY_HEADER_ID = p_currency_header_id;
1272:
1273: EXCEPTION
1274:

Line 1368: FROM QP_CURRENCY_LISTS_TL

1364: SELECT NAME
1365: , DESCRIPTION
1366: INTO l_CURR_LISTS_rec.name
1367: , l_CURR_LISTS_rec.description
1368: FROM QP_CURRENCY_LISTS_TL
1369: WHERE CURRENCY_HEADER_ID = p_currency_header_id
1370: AND LANGUAGE = userenv('LANG');
1371:
1372: -- oe_debug_pub.add('Inside Query_Row of QPXUCURB; p_currency_header_id: '||p_currency_header_id);

Line 1492: FROM QP_CURRENCY_LISTS_TL

1488: SELECT NAME
1489: , DESCRIPTION
1490: INTO l_CURR_LISTS_rec.name
1491: , l_CURR_LISTS_rec.description
1492: FROM QP_CURRENCY_LISTS_TL
1493: WHERE CURRENCY_HEADER_ID = p_CURR_LISTS_rec.CURRENCY_HEADER_ID
1494: AND LANGUAGE = userenv('LANG');
1495:
1496: -- Added by Sunil Pandey 10/01/01