DBA Data[Home] [Help]

APPS.FA_CHK_BOOKSTS_PKG dependencies on FND_GLOBAL

Line 531: h_conc_request_id NUMBER := fnd_global.conc_request_id;

527: X_close_period IN NUMBER,
528: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
529: return BOOLEAN is
530:
531: h_conc_request_id NUMBER := fnd_global.conc_request_id;
532: h_request_id NUMBER := 0; -- set to non-zero if there is non-complete running process
533: h_ca_request_id NUMBER := 0; -- set to non-zero if there is non-complete running create accounting process
534: h_tmp BOOLEAN;
535:

Line 574: if (((nvl(fnd_global.conc_request_id, -1) >= 0) and

570: -- do not do it for each transaction called from a mass process
571: -- this will allow mass transactions like FAMAPT after a deprn run
572: -- on a line by line basis
573:
574: if (((nvl(fnd_global.conc_request_id, -1) >= 0) and
575: (X_asset_id = 0)) or
576: ((nvl(fnd_global.conc_request_id, -1) < 0) and
577: (X_asset_id <> 0))) then
578:

Line 576: ((nvl(fnd_global.conc_request_id, -1) < 0) and

572: -- on a line by line basis
573:
574: if (((nvl(fnd_global.conc_request_id, -1) >= 0) and
575: (X_asset_id = 0)) or
576: ((nvl(fnd_global.conc_request_id, -1) < 0) and
577: (X_asset_id <> 0))) then
578:
579: select deprn_status,
580: deprn_request_id,

Line 979: h_conc_req_id := fnd_global.conc_request_id;

975: BEGIN
976:
977: X_request_id := 0;
978: h_mass_req_id := fa_cache_pkg.fazcbc_record.mass_request_id;
979: h_conc_req_id := fnd_global.conc_request_id;
980:
981: if (h_mass_req_id IS NOT NULL) then
982:
983: if (h_mass_req_id <> h_conc_req_id) then

Line 1406: if (nvl(fnd_global.conc_request_id, -1) > 1) then

1402: -- BUG# 3315327
1403: -- conditionally use NOWAIT for non-mass requests
1404: -- wait when it is a mass request to see if we avoid
1405: -- block contention here
1406: if (nvl(fnd_global.conc_request_id, -1) > 1) then
1407: OPEN lock_asset_mass;
1408: FETCH lock_asset_mass into h_trx_id_out, h_adj_req_status;
1409: CLOSE lock_asset_mass;
1410: else