eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AP_APPROVAL_PKG dependencies on FND_GLOBAL

Line 2782: p_user_id := FND_GLOBAL.user_id;

2778:
2779: END IF;
2780:
2781: p_system_user := 5;
2782: p_user_id := FND_GLOBAL.user_id;
2783:
2784: l_debug_info := 'Retrieving tolerances for validation';
2785: -- Print_Debug(l_debug_loc, l_debug_info);
2786: IF g_debug_mode = 'Y' THEN

Line 5073: AIL.last_updated_by = FND_GLOBAL.user_id,

5069: ap_utilities_pkg.ap_round_currency(
5070: amount * p_exchange_rate,
5071: p_base_currency_code)),
5072: AIL.last_update_date = SYSDATE,
5073: AIL.last_updated_by = FND_GLOBAL.user_id,
5074: AIL.last_update_login = FND_GLOBAL.login_id
5075: WHERE AIL.invoice_id = p_invoice_id
5076: AND AIL.LINE_TYPE_LOOKUP_CODE not in ('TAX', 'AWT') -- bug 9582952 --bug16090813
5077: -- Bug 6621883

Line 5074: AIL.last_update_login = FND_GLOBAL.login_id

5070: amount * p_exchange_rate,
5071: p_base_currency_code)),
5072: AIL.last_update_date = SYSDATE,
5073: AIL.last_updated_by = FND_GLOBAL.user_id,
5074: AIL.last_update_login = FND_GLOBAL.login_id
5075: WHERE AIL.invoice_id = p_invoice_id
5076: AND AIL.LINE_TYPE_LOOKUP_CODE not in ('TAX', 'AWT') -- bug 9582952 --bug16090813
5077: -- Bug 6621883
5078: AND (EXISTS ( SELECT 'NOT POSTED'

Line 5166: last_updated_by = FND_GLOBAL.user_id,

5162: UPDATE AP_INVOICE_LINES
5163: SET base_amount = l_base_amt,
5164: rounding_amt = ABS( NVL(l_modified_line_rounding_amt, 0) ),
5165: last_update_date = SYSDATE,
5166: last_updated_by = FND_GLOBAL.user_id,
5167: last_update_login = FND_GLOBAL.login_id
5168: WHERE invoice_id = p_invoice_id
5169: AND line_number = l_round_inv_line_numbers(i)
5170: AND line_type_lookup_code <> 'TAX'; -- bug 9582952

Line 5167: last_update_login = FND_GLOBAL.login_id

5163: SET base_amount = l_base_amt,
5164: rounding_amt = ABS( NVL(l_modified_line_rounding_amt, 0) ),
5165: last_update_date = SYSDATE,
5166: last_updated_by = FND_GLOBAL.user_id,
5167: last_update_login = FND_GLOBAL.login_id
5168: WHERE invoice_id = p_invoice_id
5169: AND line_number = l_round_inv_line_numbers(i)
5170: AND line_type_lookup_code <> 'TAX'; -- bug 9582952
5171: ELSE--adjustment not required or there are no lines that can be adjusted

Line 5271: last_updated_by = FND_GLOBAL.user_id,

5267: NULL, ap_utilities_pkg.ap_round_currency(
5268: amount * p_invoice_exchange_rate,
5269: p_base_currency_code)),
5270: last_update_date = SYSDATE,
5271: last_updated_by = FND_GLOBAL.user_id,
5272: last_update_login = FND_GLOBAL.login_id
5273: WHERE invoice_id = p_invoice_id
5274: AND invoice_line_number = p_invoice_line_number
5275: AND NVL(posted_flag,'N') = 'N'

Line 5272: last_update_login = FND_GLOBAL.login_id

5268: amount * p_invoice_exchange_rate,
5269: p_base_currency_code)),
5270: last_update_date = SYSDATE,
5271: last_updated_by = FND_GLOBAL.user_id,
5272: last_update_login = FND_GLOBAL.login_id
5273: WHERE invoice_id = p_invoice_id
5274: AND invoice_line_number = p_invoice_line_number
5275: AND NVL(posted_flag,'N') = 'N'
5276: AND NVL(reversal_flag, 'N') = 'N' -- Bug 9178329

Line 5332: last_updated_by = FND_GLOBAL.user_id,

5328: UPDATE AP_INVOICE_DISTRIBUTIONS
5329: SET base_amount = l_base_amt,
5330: rounding_amt = ABS( l_modified_dist_rounding_amt ),
5331: last_update_date = SYSDATE,
5332: last_updated_by = FND_GLOBAL.user_id,
5333: last_update_login = FND_GLOBAL.login_id
5334: WHERE invoice_distribution_id = l_round_dist_id_list(i)
5335: AND line_type_lookup_code NOT IN ('NONREC_TAX','REC_TAX','TRV','TERV','TIPV'); -- bug 9582952
5336:

Line 5333: last_update_login = FND_GLOBAL.login_id

5329: SET base_amount = l_base_amt,
5330: rounding_amt = ABS( l_modified_dist_rounding_amt ),
5331: last_update_date = SYSDATE,
5332: last_updated_by = FND_GLOBAL.user_id,
5333: last_update_login = FND_GLOBAL.login_id
5334: WHERE invoice_distribution_id = l_round_dist_id_list(i)
5335: AND line_type_lookup_code NOT IN ('NONREC_TAX','REC_TAX','TRV','TERV','TIPV'); -- bug 9582952
5336:
5337: ELSE

Line 6265: program_application_id = decode(fnd_global.prog_appl_id,

6261: UPDATE ap_invoice_distributions_all D
6262: SET match_status_flag = 'T',
6263: last_update_date = SYSDATE,
6264: last_updated_by = p_user_id,
6265: program_application_id = decode(fnd_global.prog_appl_id,
6266: -1,null,
6267: fnd_global.prog_appl_id),
6268: request_id = decode(fnd_global.conc_request_id,
6269: -1,null, fnd_global.conc_request_id),

Line 6267: fnd_global.prog_appl_id),

6263: last_update_date = SYSDATE,
6264: last_updated_by = p_user_id,
6265: program_application_id = decode(fnd_global.prog_appl_id,
6266: -1,null,
6267: fnd_global.prog_appl_id),
6268: request_id = decode(fnd_global.conc_request_id,
6269: -1,null, fnd_global.conc_request_id),
6270: program_id = decode(fnd_global.conc_program_id,
6271: -1,null, fnd_global.conc_program_id),

Line 6268: request_id = decode(fnd_global.conc_request_id,

6264: last_updated_by = p_user_id,
6265: program_application_id = decode(fnd_global.prog_appl_id,
6266: -1,null,
6267: fnd_global.prog_appl_id),
6268: request_id = decode(fnd_global.conc_request_id,
6269: -1,null, fnd_global.conc_request_id),
6270: program_id = decode(fnd_global.conc_program_id,
6271: -1,null, fnd_global.conc_program_id),
6272: program_update_date = decode(fnd_global.conc_program_id,

Line 6269: -1,null, fnd_global.conc_request_id),

6265: program_application_id = decode(fnd_global.prog_appl_id,
6266: -1,null,
6267: fnd_global.prog_appl_id),
6268: request_id = decode(fnd_global.conc_request_id,
6269: -1,null, fnd_global.conc_request_id),
6270: program_id = decode(fnd_global.conc_program_id,
6271: -1,null, fnd_global.conc_program_id),
6272: program_update_date = decode(fnd_global.conc_program_id,
6273: -1,null, SYSDATE)

Line 6270: program_id = decode(fnd_global.conc_program_id,

6266: -1,null,
6267: fnd_global.prog_appl_id),
6268: request_id = decode(fnd_global.conc_request_id,
6269: -1,null, fnd_global.conc_request_id),
6270: program_id = decode(fnd_global.conc_program_id,
6271: -1,null, fnd_global.conc_program_id),
6272: program_update_date = decode(fnd_global.conc_program_id,
6273: -1,null, SYSDATE)
6274: WHERE match_status_flag = 'S'

Line 6271: -1,null, fnd_global.conc_program_id),

6267: fnd_global.prog_appl_id),
6268: request_id = decode(fnd_global.conc_request_id,
6269: -1,null, fnd_global.conc_request_id),
6270: program_id = decode(fnd_global.conc_program_id,
6271: -1,null, fnd_global.conc_program_id),
6272: program_update_date = decode(fnd_global.conc_program_id,
6273: -1,null, SYSDATE)
6274: WHERE match_status_flag = 'S'
6275: AND D.invoice_id = p_invoice_id;

Line 6272: program_update_date = decode(fnd_global.conc_program_id,

6268: request_id = decode(fnd_global.conc_request_id,
6269: -1,null, fnd_global.conc_request_id),
6270: program_id = decode(fnd_global.conc_program_id,
6271: -1,null, fnd_global.conc_program_id),
6272: program_update_date = decode(fnd_global.conc_program_id,
6273: -1,null, SYSDATE)
6274: WHERE match_status_flag = 'S'
6275: AND D.invoice_id = p_invoice_id;
6276:

Line 6282: program_application_id = decode(fnd_global.prog_appl_id,

6278: UPDATE ap_self_assessed_tax_dist_all D
6279: SET match_status_flag = 'T',
6280: last_update_date = SYSDATE,
6281: last_updated_by = p_user_id,
6282: program_application_id = decode(fnd_global.prog_appl_id,
6283: -1,null,
6284: fnd_global.prog_appl_id),
6285: request_id = decode(fnd_global.conc_request_id,
6286: -1,null, fnd_global.conc_request_id),

Line 6284: fnd_global.prog_appl_id),

6280: last_update_date = SYSDATE,
6281: last_updated_by = p_user_id,
6282: program_application_id = decode(fnd_global.prog_appl_id,
6283: -1,null,
6284: fnd_global.prog_appl_id),
6285: request_id = decode(fnd_global.conc_request_id,
6286: -1,null, fnd_global.conc_request_id),
6287: program_id = decode(fnd_global.conc_program_id,
6288: -1,null, fnd_global.conc_program_id),

Line 6285: request_id = decode(fnd_global.conc_request_id,

6281: last_updated_by = p_user_id,
6282: program_application_id = decode(fnd_global.prog_appl_id,
6283: -1,null,
6284: fnd_global.prog_appl_id),
6285: request_id = decode(fnd_global.conc_request_id,
6286: -1,null, fnd_global.conc_request_id),
6287: program_id = decode(fnd_global.conc_program_id,
6288: -1,null, fnd_global.conc_program_id),
6289: program_update_date = decode(fnd_global.conc_program_id,

Line 6286: -1,null, fnd_global.conc_request_id),

6282: program_application_id = decode(fnd_global.prog_appl_id,
6283: -1,null,
6284: fnd_global.prog_appl_id),
6285: request_id = decode(fnd_global.conc_request_id,
6286: -1,null, fnd_global.conc_request_id),
6287: program_id = decode(fnd_global.conc_program_id,
6288: -1,null, fnd_global.conc_program_id),
6289: program_update_date = decode(fnd_global.conc_program_id,
6290: -1,null, SYSDATE)

Line 6287: program_id = decode(fnd_global.conc_program_id,

6283: -1,null,
6284: fnd_global.prog_appl_id),
6285: request_id = decode(fnd_global.conc_request_id,
6286: -1,null, fnd_global.conc_request_id),
6287: program_id = decode(fnd_global.conc_program_id,
6288: -1,null, fnd_global.conc_program_id),
6289: program_update_date = decode(fnd_global.conc_program_id,
6290: -1,null, SYSDATE)
6291: WHERE match_status_flag = 'S'

Line 6288: -1,null, fnd_global.conc_program_id),

6284: fnd_global.prog_appl_id),
6285: request_id = decode(fnd_global.conc_request_id,
6286: -1,null, fnd_global.conc_request_id),
6287: program_id = decode(fnd_global.conc_program_id,
6288: -1,null, fnd_global.conc_program_id),
6289: program_update_date = decode(fnd_global.conc_program_id,
6290: -1,null, SYSDATE)
6291: WHERE match_status_flag = 'S'
6292: AND D.invoice_id = p_invoice_id;

Line 6289: program_update_date = decode(fnd_global.conc_program_id,

6285: request_id = decode(fnd_global.conc_request_id,
6286: -1,null, fnd_global.conc_request_id),
6287: program_id = decode(fnd_global.conc_program_id,
6288: -1,null, fnd_global.conc_program_id),
6289: program_update_date = decode(fnd_global.conc_program_id,
6290: -1,null, SYSDATE)
6291: WHERE match_status_flag = 'S'
6292: AND D.invoice_id = p_invoice_id;
6293: --Bug6963908

Line 9051: l_dist_tab(i).created_by := FND_GLOBAL.user_id;

9047: l_dist_tab(i).awt_group_id := p_invoice_line_rec.awt_group_id;
9048: l_dist_tab(i).inventory_transfer_status := 'N';
9049: l_dist_tab(i).intended_use := p_invoice_line_rec.primary_intended_use;
9050: l_dist_tab(i).rcv_charge_addition_flag := 'N';
9051: l_dist_tab(i).created_by := FND_GLOBAL.user_id;
9052: l_dist_tab(i).creation_date := SYSDATE;
9053: l_dist_tab(i).last_update_date := SYSDATE;
9054: l_dist_tab(i).last_update_login := FND_GLOBAL.login_id;
9055: l_dist_tab(i).last_updated_by := FND_GLOBAL.user_id;

Line 9054: l_dist_tab(i).last_update_login := FND_GLOBAL.login_id;

9050: l_dist_tab(i).rcv_charge_addition_flag := 'N';
9051: l_dist_tab(i).created_by := FND_GLOBAL.user_id;
9052: l_dist_tab(i).creation_date := SYSDATE;
9053: l_dist_tab(i).last_update_date := SYSDATE;
9054: l_dist_tab(i).last_update_login := FND_GLOBAL.login_id;
9055: l_dist_tab(i).last_updated_by := FND_GLOBAL.user_id;
9056:
9057: END LOOP;
9058:

Line 9055: l_dist_tab(i).last_updated_by := FND_GLOBAL.user_id;

9051: l_dist_tab(i).created_by := FND_GLOBAL.user_id;
9052: l_dist_tab(i).creation_date := SYSDATE;
9053: l_dist_tab(i).last_update_date := SYSDATE;
9054: l_dist_tab(i).last_update_login := FND_GLOBAL.login_id;
9055: l_dist_tab(i).last_updated_by := FND_GLOBAL.user_id;
9056:
9057: END LOOP;
9058:
9059: END IF; /* If l_exp_report_dists_tab.count > 0 */

Line 11243: fnd_global.user_id User_Id

11239: nvl(fp.non_recoverable_tax_flag, 'N') non_recoverable_tax_flag,
11240: nvl(disc_is_inv_less_tax_flag,'N') disc_is_inv_less_tax_flag,
11241: fp.org_id org_id,
11242: 5 System_User,
11243: fnd_global.user_id User_Id
11244: FROM ap_system_parameters_all sp,
11245: financials_system_params_all fp,
11246: gl_sets_of_books gls,
11247: Mo_Glob_Org_Access_Tmp mo