APPS.HXT_RETRO_MIX dependencies on FND_GLOBAL

Line 3531: FND_GLOBAL.conc_request_id request_id,

3527: NULL old_attribute3,
3528: det.retro_pbl_line_id pbl_id,
3529: NULL retro_pbl_id,
3530: NULL old_pbl_id,
3531: FND_GLOBAL.conc_request_id request_id,
3532: NULL old_request_id,
3533: det.retro_batch_id batch_id,
3534: NULL retro_batch_id,
3535: NULL old_batch_id,

Line 3587: FND_GLOBAL.conc_request_id,

3583: ret.old_attribute3,
3584: det.retro_pbl_line_id,
3585: ret.retro_pbl_id,
3586: ret.old_pbl_id,
3587: FND_GLOBAL.conc_request_id,
3588: ret.old_request_id,
3589: det.retro_batch_id,
3590: ret.retro_batch_id,
3591: ret.old_batch_id,

Line 3629: request_id = FND_GLOBAL.conc_request_id

3625: FORALL i IN ret_pbl_tab.FIRST..ret_pbl_tab.LAST
3626: UPDATE hxc_ret_pay_latest_details
3627: SET retro_batch_id = ret_batch_tab(i),
3628: retro_pbl_id = ret_pbl_tab(i),
3629: request_id = FND_GLOBAL.conc_request_id
3630: WHERE ROWID = CHARTOROWID(rowtab(i));
3631:
3632: -- Case 2
3633: -- Next, pick up those entries which are backed out not because

Line 3660: request_id = FND_GLOBAL.conc_request_id,

3656: attribute1 = NULL,
3657: attribute2 = NULL,
3658: measure = NULL,
3659: pbl_id = NULL,
3660: request_id = FND_GLOBAL.conc_request_id,
3661: batch_id = NULL
3662: WHERE ROWID = CHARTOROWID(rowtab(i));
3663:
3664:

Line 3695: request_id = fnd_global.conc_request_id

3691: SET batch_id = ret_batch_tab(i),
3692: pbl_id = ret_pbl_tab(i),
3693: attribute1 = old_attribute1,
3694: measure = hrs_tab(i),
3695: request_id = fnd_global.conc_request_id
3696: WHERE ROWID = CHARTOROWID(rowtab(i));
3697:
3698:
3699: -- Case 4

Line 3981: AND ret.request_id <> FND_GLOBAL.conc_request_id ;

3977: AND sum.time_building_block_ovn = ret.object_version_number
3978: AND det.element_type_id = ret.old_attribute1
3979: AND ret.batch_id = p_batch_id
3980: AND ret.pbl_id IS NULL
3981: AND ret.request_id <> FND_GLOBAL.conc_request_id ;
3982:
3983:
3984: TYPE VARCHARTAB IS TABLE OF VARCHAR2(100);
3985: TYPE NUMBERTAB IS TABLE OF NUMBER;

Line 4047: FND_GLOBAL.conc_request_id request_id,

4043: NULL old_attribute3,
4044: det.retro_pbl_line_id pbl_id,
4045: NULL retro_pbl_id,
4046: NULL old_pbl_id,
4047: FND_GLOBAL.conc_request_id request_id,
4048: NULL old_request_id,
4049: det.retro_batch_id batch_id,
4050: NULL retro_batch_id,
4051: NULL old_batch_id,

Line 4084: AND ret.request_id <> FND_GLOBAL.conc_request_id

4080: hxc_ret_pay_latest_details ret
4081: WHERE sum.tim_id = p_tim_id
4082: AND ret.time_building_block_id = sum.time_building_block_id
4083: AND ret.batch_id = p_batch_id
4084: AND ret.request_id <> FND_GLOBAL.conc_request_id
4085: AND ret.pbl_id IS NULL;
4086:
4087:
4088:

Line 4138: request_id = FND_global.conc_request_id,

4134: old_pbl_id = pbl_id,
4135: old_request_id = request_id,
4136: old_attribute1= attribute1,
4137: old_measure = measure,
4138: request_id = FND_global.conc_request_id,
4139: attribute1 = NULL,
4140: attribute2 = NULL,
4141: measure = NULL,
4142: pbl_id = NULL,

Line 4183: request_id = FND_global.conc_request_id,

4179: SET retro_batch_id = p_batch_id,
4180: retro_pbl_id = l_line_tab(i),
4181: hxt_request_id = request_id,
4182: hxt_batch_id = p_batch_id,
4183: request_id = FND_global.conc_request_id,
4184: hxt_measure = measure,
4185: measure = NULL,
4186: batch_id = NULL,
4187: hxt_element_id = attribute1,

Line 4371: FND_GLOBAL.conc_request_id,

4367: NULL,
4368: pbl_id_tab(i),
4369: NULL,
4370: NULL,
4371: FND_GLOBAL.conc_request_id,
4372: NULL,
4373: p_batch_id,
4374: NULL,
4375: NULL,

Line 4388: AND request_id <> FND_GLOBAL.conc_request_id

4384: -- Meanwhile, collect the actual attributes, measure, batch_id etc created by Xfer time process.
4385: /*
4386: DELETE FROM hxc_ret_pay_latest_details
4387: WHERE batch_id = p_batch_id
4388: AND request_id <> FND_GLOBAL.conc_request_id
4389: AND pbl_id IS NULL
4390: RETURNING time_building_block_id,
4391: object_version_number,
4392: request_id,