DBA Data[Home] [Help]

APPS.QP_DEFAULT_PRICE_LIST dependencies on FND_GLOBAL

Line 306: , FND_GLOBAL.USER_ID -- created_by

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

Line 309: , FND_GLOBAL.USER_ID -- last_updated_by

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

Line 311: , FND_GLOBAL.LOGIN_ID -- last_update_login

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

Line 312: , FND_GLOBAL.PROG_APPL_ID -- program_application_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: );

Line 313: , FND_GLOBAL.CONC_PROGRAM_ID -- program_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: );
317:

Line 315: , FND_GLOBAL.CONC_REQUEST_ID -- request_id

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:

Line 381: , FND_GLOBAL.USER_ID -- created_by

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

Line 387: , FND_GLOBAL.USER_ID -- last_updated_by

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

Line 389: , FND_GLOBAL.LOGIN_ID -- last_update_login

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

Line 394: , FND_GLOBAL.PROG_APPL_ID -- program_application_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

Line 395: , FND_GLOBAL.CONC_PROGRAM_ID -- program_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
399: , null -- start_date_active

Line 397: , FND_GLOBAL.CONC_REQUEST_ID -- request_id

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: );

Line 422: , FND_GLOBAL.USER_ID -- CREATED_BY

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

Line 424: , FND_GLOBAL.USER_ID -- LAST_UPDATED_BY

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

Line 425: , FND_GLOBAL.LOGIN_ID -- LAST_UPDATE_LOGIN

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');