DBA Data[Home] [Help]

APPS.FA_CHK_BOOKSTS_PKG dependencies on FND_GLOBAL

Line 515: h_conc_request_id NUMBER := fnd_global.conc_request_id;

511: X_txn_status IN OUT NOCOPY BOOLEAN,
512: X_close_period IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
513: return BOOLEAN is
514:
515: h_conc_request_id NUMBER := fnd_global.conc_request_id;
516: h_request_id NUMBER := 0; -- set to non-zero if there is non-complete running process
517: h_ca_request_id NUMBER := 0; -- set to non-zero if there is non-complete running create accounting process
518: h_tmp BOOLEAN;
519:

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

553: -- do not do it for each transaction called from a mass process
554: -- this will allow mass transactions like FAMAPT after a deprn run
555: -- on a line by line basis
556:
557: if (((nvl(fnd_global.conc_request_id, -1) >= 0) and
558: (X_asset_id = 0)) or
559: ((nvl(fnd_global.conc_request_id, -1) < 0) and
560: (X_asset_id <> 0))) then
561:

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

555: -- on a line by line basis
556:
557: if (((nvl(fnd_global.conc_request_id, -1) >= 0) and
558: (X_asset_id = 0)) or
559: ((nvl(fnd_global.conc_request_id, -1) < 0) and
560: (X_asset_id <> 0))) then
561:
562: select deprn_status,
563: deprn_request_id,

Line 951: h_conc_req_id := fnd_global.conc_request_id;

947: BEGIN
948:
949: X_request_id := 0;
950: h_mass_req_id := fa_cache_pkg.fazcbc_record.mass_request_id;
951: h_conc_req_id := fnd_global.conc_request_id;
952:
953: if (h_mass_req_id IS NOT NULL) then
954:
955: if (h_mass_req_id <> h_conc_req_id) then

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

1361: -- BUG# 3315327
1362: -- conditionally use NOWAIT for non-mass requests
1363: -- wait when it is a mass request to see if we avoid
1364: -- block contention here
1365: if (nvl(fnd_global.conc_request_id, -1) > 1) then
1366: OPEN lock_asset_mass;
1367: FETCH lock_asset_mass into h_trx_id_out, h_adj_req_status;
1368: CLOSE lock_asset_mass;
1369: else