[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT CURRENCY_CODE
INTO l_currency_code
FROM GL_SETS_OF_BOOKS
WHERE SET_OF_BOOKS_ID = l_set_of_books_id;
select qp_list_headers_b_s.nextval into l_list_header_id
from dual;
select currency_header_id
into l_currency_header_id
from qp_currency_lists_vl
where base_currency_code = g_PRICE_LIST_rec.currency_code
and BASE_ROUNDING_FACTOR = g_PRICE_LIST_rec.rounding_factor
and name like 'Generated Currency Conversion For%'
and rownum < 2;
SELECT QP_CURRENCY_LISTS_B_S.NEXTVAL
INTO ll_currency_header_id
FROM dual;
INSERT INTO QP_CURRENCY_LISTS_B
( ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, BASE_CURRENCY_CODE
, CONTEXT
, CREATED_BY
, CREATION_DATE
, CURRENCY_HEADER_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
)
VALUES
( null -- attribute1
, null -- attribute10
, null -- attribute11
, null -- attribute12
, null -- attribute13
, null -- attribute14
, null -- attribute15
, null -- attribute2
, null -- attribute3
, null -- attribute4
, null -- attribute5
, null -- attribute6
, null -- attribute7
, null -- attribute8
, null -- attribute9
, g_price_list_rec.CURRENCY_CODE -- base_currency_code
, null -- context
, FND_GLOBAL.USER_ID -- created_by
, SYSDATE -- creation_date
, ll_CURRENCY_HEADER_ID --currency_header_id
, FND_GLOBAL.USER_ID -- last_updated_by
, SYSDATE -- last_update_date
, FND_GLOBAL.LOGIN_ID -- last_update_login
, FND_GLOBAL.PROG_APPL_ID -- program_application_id
, FND_GLOBAL.CONC_PROGRAM_ID -- program_id
, SYSDATE -- program_update_date
, FND_GLOBAL.CONC_REQUEST_ID -- request_id
);
INSERT INTO QP_CURRENCY_DETAILS
( ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, CONTEXT
, CONVERSION_DATE
, CONVERSION_DATE_TYPE
, CONVERSION_TYPE
, CREATED_BY
, CREATION_DATE
, CURRENCY_DETAIL_ID
, CURRENCY_HEADER_ID
, END_DATE_ACTIVE
, FIXED_VALUE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, MARKUP_FORMULA_ID
, MARKUP_OPERATOR
, MARKUP_VALUE
, PRICE_FORMULA_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, SELLING_ROUNDING_FACTOR
, START_DATE_ACTIVE
, TO_CURRENCY_CODE
)
VALUES
( null -- attribute1
, null -- attribute10
, null -- attribute11
, null -- attribute12
, null -- attribute13
, null -- attribute14
, null -- attribute15
, null -- attribute2
, null -- attribute3
, null -- attribute4
, null -- attribute5
, null -- attribute6
, null -- attribute7
, null -- attribute8
, null -- attribute9
, null -- context
, null -- conversion_date
, null -- conversion_date_type
, null -- conversion_type
, FND_GLOBAL.USER_ID -- created_by
, SYSDATE -- creation_date
, QP_CURRENCY_DETAILS_S.nextval -- currency_detail_id
, ll_CURRENCY_HEADER_ID -- currency_header_id
, null -- end_date_active
, null -- fixed_value
, FND_GLOBAL.USER_ID -- last_updated_by
, SYSDATE -- last_update_date
, FND_GLOBAL.LOGIN_ID -- last_update_login
, null -- base_markup_formula_id
, null -- base_markup_operator
, null -- base_markup_value
, null -- price_formula_id
, FND_GLOBAL.PROG_APPL_ID -- program_application_id
, FND_GLOBAL.CONC_PROGRAM_ID -- program_id
, SYSDATE -- program_update_date
, FND_GLOBAL.CONC_REQUEST_ID -- request_id
, g_price_list_rec.ROUNDING_FACTOR -- base_rounding_factor
, null -- start_date_active
, g_price_list_rec.CURRENCY_CODE -- base_currency_code
);
INSERT INTO QP_CURRENCY_LISTS_TL
( CURRENCY_HEADER_ID
, NAME
, DESCRIPTION
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LANGUAGE
, SOURCE_LANG
)
select
ll_currency_header_id --CURRENCY_HEADER_ID
, 'Generated Currency Conversion For '|| g_price_list_rec.currency_code||' '||ll_currency_header_id -- NAME
, 'Generated Currency Conversion For '|| g_price_list_rec.currency_code||' '||ll_currency_header_id -- DESCRIPTION
, SYSDATE -- CREATION_DATE
, FND_GLOBAL.USER_ID -- CREATED_BY
, SYSDATE -- LAST_UPDATE_DATE
, FND_GLOBAL.USER_ID -- LAST_UPDATED_BY
, FND_GLOBAL.LOGIN_ID -- LAST_UPDATE_LOGIN
, L.LANGUAGE_CODE -- LANGUAGE
, userenv('LANG') -- SOURCE_LANG
from fnd_languages l
where l.installed_flag IN ('I','B');
SELECT -1*PRECISION,
-1*EXTENDED_PRECISION
INTO l_precision,
l_extended_precision
FROM FND_CURRENCIES
WHERE CURRENCY_CODE = G_PRICE_LIST_REC.CURRENCY_CODE;
SELECT TRUNC(SYSDATE)
INTO l_sysdate
FROM DUAL;
IF g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
g_PRICE_LIST_rec.last_updated_by := NULL;
IF g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
g_PRICE_LIST_rec.last_update_date := NULL;
IF g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
g_PRICE_LIST_rec.last_update_login := NULL;
IF g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
g_PRICE_LIST_rec.program_update_date := NULL;
OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
OR g_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM
OR g_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR
OR g_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR
OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
OR g_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR
OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
OR g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM
THEN
oe_debug_pub.add('redefault attributes 1');