302: , null -- attribute8
303: , null -- attribute9
304: , g_price_list_rec.CURRENCY_CODE -- base_currency_code
305: , null -- context
306: , FND_GLOBAL.USER_ID -- created_by
307: , SYSDATE -- creation_date
308: , ll_CURRENCY_HEADER_ID --currency_header_id
309: , FND_GLOBAL.USER_ID -- last_updated_by
310: , SYSDATE -- last_update_date
305: , null -- context
306: , FND_GLOBAL.USER_ID -- created_by
307: , SYSDATE -- creation_date
308: , ll_CURRENCY_HEADER_ID --currency_header_id
309: , FND_GLOBAL.USER_ID -- last_updated_by
310: , SYSDATE -- last_update_date
311: , FND_GLOBAL.LOGIN_ID -- last_update_login
312: , FND_GLOBAL.PROG_APPL_ID -- program_application_id
313: , FND_GLOBAL.CONC_PROGRAM_ID -- program_id
307: , SYSDATE -- creation_date
308: , ll_CURRENCY_HEADER_ID --currency_header_id
309: , FND_GLOBAL.USER_ID -- last_updated_by
310: , SYSDATE -- last_update_date
311: , FND_GLOBAL.LOGIN_ID -- last_update_login
312: , FND_GLOBAL.PROG_APPL_ID -- program_application_id
313: , FND_GLOBAL.CONC_PROGRAM_ID -- program_id
314: , SYSDATE -- program_update_date
315: , FND_GLOBAL.CONC_REQUEST_ID -- request_id
308: , ll_CURRENCY_HEADER_ID --currency_header_id
309: , FND_GLOBAL.USER_ID -- last_updated_by
310: , SYSDATE -- last_update_date
311: , FND_GLOBAL.LOGIN_ID -- last_update_login
312: , FND_GLOBAL.PROG_APPL_ID -- program_application_id
313: , FND_GLOBAL.CONC_PROGRAM_ID -- program_id
314: , SYSDATE -- program_update_date
315: , FND_GLOBAL.CONC_REQUEST_ID -- request_id
316: );
309: , FND_GLOBAL.USER_ID -- last_updated_by
310: , SYSDATE -- last_update_date
311: , FND_GLOBAL.LOGIN_ID -- last_update_login
312: , FND_GLOBAL.PROG_APPL_ID -- program_application_id
313: , FND_GLOBAL.CONC_PROGRAM_ID -- program_id
314: , SYSDATE -- program_update_date
315: , FND_GLOBAL.CONC_REQUEST_ID -- request_id
316: );
317:
311: , FND_GLOBAL.LOGIN_ID -- last_update_login
312: , FND_GLOBAL.PROG_APPL_ID -- program_application_id
313: , FND_GLOBAL.CONC_PROGRAM_ID -- program_id
314: , SYSDATE -- program_update_date
315: , FND_GLOBAL.CONC_REQUEST_ID -- request_id
316: );
317:
318: -- Insert into qp_currency_details
319:
377: , null -- context
378: , null -- conversion_date
379: , null -- conversion_date_type
380: , null -- conversion_type
381: , FND_GLOBAL.USER_ID -- created_by
382: , SYSDATE -- creation_date
383: , QP_CURRENCY_DETAILS_S.nextval -- currency_detail_id
384: , ll_CURRENCY_HEADER_ID -- currency_header_id
385: , null -- end_date_active
383: , QP_CURRENCY_DETAILS_S.nextval -- currency_detail_id
384: , ll_CURRENCY_HEADER_ID -- currency_header_id
385: , null -- end_date_active
386: , null -- fixed_value
387: , FND_GLOBAL.USER_ID -- last_updated_by
388: , SYSDATE -- last_update_date
389: , FND_GLOBAL.LOGIN_ID -- last_update_login
390: , null -- base_markup_formula_id
391: , null -- base_markup_operator
385: , null -- end_date_active
386: , null -- fixed_value
387: , FND_GLOBAL.USER_ID -- last_updated_by
388: , SYSDATE -- last_update_date
389: , FND_GLOBAL.LOGIN_ID -- last_update_login
390: , null -- base_markup_formula_id
391: , null -- base_markup_operator
392: , null -- base_markup_value
393: , null -- price_formula_id
390: , null -- base_markup_formula_id
391: , null -- base_markup_operator
392: , null -- base_markup_value
393: , null -- price_formula_id
394: , FND_GLOBAL.PROG_APPL_ID -- program_application_id
395: , FND_GLOBAL.CONC_PROGRAM_ID -- program_id
396: , SYSDATE -- program_update_date
397: , FND_GLOBAL.CONC_REQUEST_ID -- request_id
398: , g_price_list_rec.ROUNDING_FACTOR -- base_rounding_factor
391: , null -- base_markup_operator
392: , null -- base_markup_value
393: , null -- price_formula_id
394: , FND_GLOBAL.PROG_APPL_ID -- program_application_id
395: , FND_GLOBAL.CONC_PROGRAM_ID -- program_id
396: , SYSDATE -- program_update_date
397: , FND_GLOBAL.CONC_REQUEST_ID -- request_id
398: , g_price_list_rec.ROUNDING_FACTOR -- base_rounding_factor
399: , null -- start_date_active
393: , null -- price_formula_id
394: , FND_GLOBAL.PROG_APPL_ID -- program_application_id
395: , FND_GLOBAL.CONC_PROGRAM_ID -- program_id
396: , SYSDATE -- program_update_date
397: , FND_GLOBAL.CONC_REQUEST_ID -- request_id
398: , g_price_list_rec.ROUNDING_FACTOR -- base_rounding_factor
399: , null -- start_date_active
400: , g_price_list_rec.CURRENCY_CODE -- base_currency_code
401: );
418: ll_currency_header_id --CURRENCY_HEADER_ID
419: , 'Generated Currency Conversion For '|| g_price_list_rec.currency_code||' '||ll_currency_header_id -- NAME
420: , 'Generated Currency Conversion For '|| g_price_list_rec.currency_code||' '||ll_currency_header_id -- DESCRIPTION
421: , SYSDATE -- CREATION_DATE
422: , FND_GLOBAL.USER_ID -- CREATED_BY
423: , SYSDATE -- LAST_UPDATE_DATE
424: , FND_GLOBAL.USER_ID -- LAST_UPDATED_BY
425: , FND_GLOBAL.LOGIN_ID -- LAST_UPDATE_LOGIN
426: , L.LANGUAGE_CODE -- LANGUAGE
420: , 'Generated Currency Conversion For '|| g_price_list_rec.currency_code||' '||ll_currency_header_id -- DESCRIPTION
421: , SYSDATE -- CREATION_DATE
422: , FND_GLOBAL.USER_ID -- CREATED_BY
423: , SYSDATE -- LAST_UPDATE_DATE
424: , FND_GLOBAL.USER_ID -- LAST_UPDATED_BY
425: , FND_GLOBAL.LOGIN_ID -- LAST_UPDATE_LOGIN
426: , L.LANGUAGE_CODE -- LANGUAGE
427: , userenv('LANG') -- SOURCE_LANG
428: from fnd_languages l
421: , SYSDATE -- CREATION_DATE
422: , FND_GLOBAL.USER_ID -- CREATED_BY
423: , SYSDATE -- LAST_UPDATE_DATE
424: , FND_GLOBAL.USER_ID -- LAST_UPDATED_BY
425: , FND_GLOBAL.LOGIN_ID -- LAST_UPDATE_LOGIN
426: , L.LANGUAGE_CODE -- LANGUAGE
427: , userenv('LANG') -- SOURCE_LANG
428: from fnd_languages l
429: where l.installed_flag IN ('I','B');