DBA Data[Home] [Help]

APPS.JAI_BOE_GENERAL_PKG dependencies on FND_GLOBAL

Line 484: ,hdr.last_update_login = fnd_global.login_id

480: ,hdr.AMOUNT_APPLIED = 0
481: ,hdr.AMOUNT_WRITTEN_OFF = 0
482: ,hdr.DEPB_AMOUNT = 0
483: ,hdr.last_update_date = SYSDATE
484: ,hdr.last_update_login = fnd_global.login_id
485: ,hdr.last_updated_by = fnd_global.user_id
486: WHERE hdr.boe_id = pn_boe_id;
487:
488:

Line 485: ,hdr.last_updated_by = fnd_global.user_id

481: ,hdr.AMOUNT_WRITTEN_OFF = 0
482: ,hdr.DEPB_AMOUNT = 0
483: ,hdr.last_update_date = SYSDATE
484: ,hdr.last_update_login = fnd_global.login_id
485: ,hdr.last_updated_by = fnd_global.user_id
486: WHERE hdr.boe_id = pn_boe_id;
487:
488:
489: UPDATE JAI_BOE_ROUNDINGS jbr

Line 493: ,jbr.last_update_login = fnd_global.login_id

489: UPDATE JAI_BOE_ROUNDINGS jbr
490: SET jbr.TAX_AMOUNT = 0
491: ,jbr.TOTAL_AMOUNT = 0
492: ,jbr.last_update_date = SYSDATE
493: ,jbr.last_update_login = fnd_global.login_id
494: ,jbr.last_updated_by = fnd_global.user_id
495: WHERE jbr.boe_id = pn_boe_id;
496:
497: UPDATE JAI_BOE_DETAILS jbd

Line 494: ,jbr.last_updated_by = fnd_global.user_id

490: SET jbr.TAX_AMOUNT = 0
491: ,jbr.TOTAL_AMOUNT = 0
492: ,jbr.last_update_date = SYSDATE
493: ,jbr.last_update_login = fnd_global.login_id
494: ,jbr.last_updated_by = fnd_global.user_id
495: WHERE jbr.boe_id = pn_boe_id;
496:
497: UPDATE JAI_BOE_DETAILS jbd
498: SET jbd.quantity = 0

Line 503: ,jbd.last_update_login = fnd_global.login_id

499: ,jbd.line_amount = 0
500: ,jbd.tax_amount = 0
501: ,jbd.assessable_value = 0
502: ,jbd.last_update_date = SYSDATE
503: ,jbd.last_update_login = fnd_global.login_id
504: ,jbd.last_updated_by = fnd_global.user_id
505: WHERE jbd.boe_id = pn_boe_id;
506:
507: UPDATE JAI_BOE_DETAIL_TAXES jbdt

Line 504: ,jbd.last_updated_by = fnd_global.user_id

500: ,jbd.tax_amount = 0
501: ,jbd.assessable_value = 0
502: ,jbd.last_update_date = SYSDATE
503: ,jbd.last_update_login = fnd_global.login_id
504: ,jbd.last_updated_by = fnd_global.user_id
505: WHERE jbd.boe_id = pn_boe_id;
506:
507: UPDATE JAI_BOE_DETAIL_TAXES jbdt
508: SET jbdt.tax_amount = 0

Line 514: ,jbdt.last_update_login = fnd_global.login_id

510: ,jbdt.func_tax_amount = 0
511: ,jbdt.applied_amount = 0
512: ,jbdt.assessable_value = 0
513: ,jbdt.last_update_date = SYSDATE
514: ,jbdt.last_update_login = fnd_global.login_id
515: ,jbdt.last_updated_by = fnd_global.user_id
516: WHERE EXISTS
517: (
518: SELECT 'x'

Line 515: ,jbdt.last_updated_by = fnd_global.user_id

511: ,jbdt.applied_amount = 0
512: ,jbdt.assessable_value = 0
513: ,jbdt.last_update_date = SYSDATE
514: ,jbdt.last_update_login = fnd_global.login_id
515: ,jbdt.last_updated_by = fnd_global.user_id
516: WHERE EXISTS
517: (
518: SELECT 'x'
519: FROM JAI_BOE_DETAILS jbd