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.

APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on FND_GLOBAL

Line 707: fnd_global.conc_request_id,

703: sum.resource_id,
704: sum.start_time,
705: TRUNC(sum.stop_time),
706: ''PENDING'',
707: fnd_global.conc_request_id,
708: fnd_global.user_id,
709: RETRIEVALPROCESS
710: FROM LATEST_DETAILS tbb,
711: hxc_time_building_blocks sum

Line 708: fnd_global.user_id,

704: sum.start_time,
705: TRUNC(sum.stop_time),
706: ''PENDING'',
707: fnd_global.conc_request_id,
708: fnd_global.user_id,
709: RETRIEVALPROCESS
710: FROM LATEST_DETAILS tbb,
711: hxc_time_building_blocks sum
712: WHERE sum.resource_id = tbb.resource_id

Line 737: WHERE request_id = FND_GLOBAL.conc_request_id;

733: -- Added for Rollback
734: CURSOR get_request_date
735: IS SELECT requested_start_date
736: FROM fnd_concurrent_requests
737: WHERE request_id = FND_GLOBAL.conc_request_id;
738:
739: l_request_date DATE;
740:
741:

Line 806: ,argument1 => FND_GLOBAL.conc_request_id);

802: l_request_id := FND_REQUEST.SUBMIT_REQUEST(application => 'HXC'
803: ,program => 'HXCRDBSNP'
804: ,description => NULL
805: ,sub_request => FALSE
806: ,argument1 => FND_GLOBAL.conc_request_id);
807:
808: COMMIT;
809: ELSE
810: INSERT INTO HXC_RDB_PENDING_PROCESSES

Line 815: VALUES ( FND_GLOBAL.conc_request_id,

811: ( request_id,
812: concurrent_program_id,
813: user_id,
814: status)
815: VALUES ( FND_GLOBAL.conc_request_id,
816: FND_GLOBAL.conc_program_id,
817: FND_GLOBAL.user_id,
818: 'PENDING_SNAPSHOT');
819: COMMIT;

Line 816: FND_GLOBAL.conc_program_id,

812: concurrent_program_id,
813: user_id,
814: status)
815: VALUES ( FND_GLOBAL.conc_request_id,
816: FND_GLOBAL.conc_program_id,
817: FND_GLOBAL.user_id,
818: 'PENDING_SNAPSHOT');
819: COMMIT;
820:

Line 817: FND_GLOBAL.user_id,

813: user_id,
814: status)
815: VALUES ( FND_GLOBAL.conc_request_id,
816: FND_GLOBAL.conc_program_id,
817: FND_GLOBAL.user_id,
818: 'PENDING_SNAPSHOT');
819: COMMIT;
820:
821: END IF;

Line 844: VALUES ( FND_GLOBAL.conc_request_id,

840: conc_program_id,
841: user_id,
842: request_date,
843: ret_trans_code)
844: VALUES ( FND_GLOBAL.conc_request_id,
845: FND_GLOBAL.conc_program_id,
846: FND_GLOBAL.user_id,
847: l_request_date,
848: g_params.p_transaction_code);

Line 845: FND_GLOBAL.conc_program_id,

841: user_id,
842: request_date,
843: ret_trans_code)
844: VALUES ( FND_GLOBAL.conc_request_id,
845: FND_GLOBAL.conc_program_id,
846: FND_GLOBAL.user_id,
847: l_request_date,
848: g_params.p_transaction_code);
849: COMMIT;

Line 846: FND_GLOBAL.user_id,

842: request_date,
843: ret_trans_code)
844: VALUES ( FND_GLOBAL.conc_request_id,
845: FND_GLOBAL.conc_program_id,
846: FND_GLOBAL.user_id,
847: l_request_date,
848: g_params.p_transaction_code);
849: COMMIT;
850:

Line 1913: FND_GLOBAL.user_ID,

1909: l_skipped_bb_id (i),
1910: l_skipped_bb_ovn(i),
1911: l_skipped_desc(i),
1912: 'OTL_PROC',
1913: FND_GLOBAL.user_ID,
1914: FND_GLOBAL.conc_request_id,
1915: g_params.p_process);
1916: END IF;
1917: put_log( ' ===============================================================================================');

Line 1914: FND_GLOBAL.conc_request_id,

1910: l_skipped_bb_ovn(i),
1911: l_skipped_desc(i),
1912: 'OTL_PROC',
1913: FND_GLOBAL.user_ID,
1914: FND_GLOBAL.conc_request_id,
1915: g_params.p_process);
1916: END IF;
1917: put_log( ' ===============================================================================================');
1918: put_log(' ');

Line 2825: AND request_id = FND_GLOBAL.CONC_REQUEST_ID

2821: (tx_error),1,149),
2822: skip_level = 'REC_PROC'
2823: WHERE detail_id = hxc_generic_retrieval_pkg.t_tx_error_bb_id
2824: (tx_error)
2825: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
2826: AND process = g_params.p_process
2827: AND ret_user_id = FND_global.user_id
2828: RETURNING timecard_id
2829: BULK COLLECT INTO g_temp_tc_list ;

Line 2827: AND ret_user_id = FND_global.user_id

2823: WHERE detail_id = hxc_generic_retrieval_pkg.t_tx_error_bb_id
2824: (tx_error)
2825: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
2826: AND process = g_params.p_process
2827: AND ret_user_id = FND_global.user_id
2828: RETURNING timecard_id
2829: BULK COLLECT INTO g_temp_tc_list ;
2830:
2831: FORALL i IN g_temp_tc_list.FIRST..g_temp_tc_list.LAST

Line 2835: AND request_id = FND_GLOBAL.CONC_REQUEST_ID

2831: FORALL i IN g_temp_tc_list.FIRST..g_temp_tc_list.LAST
2832: UPDATE hxc_rdb_process_timecards
2833: SET stage = 'ERRORED'
2834: WHERE timecard_id = g_temp_tc_list(i)
2835: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
2836: AND process = g_params.p_process;
2837:
2838:
2839: -- given we are only going to do this once and the recipient app does not need

Line 4499: WHERE ret_user_id = FND_GLOBAL.user_id

4495: BEGIN
4496:
4497: UPDATE hxc_rdb_process_timecards
4498: SET stage = 'SKIPPED'
4499: WHERE ret_user_id = FND_GLOBAL.user_id
4500: AND request_id = FND_GLOBAL.conc_request_id
4501: AND process = g_params.p_process
4502: AND stage = 'PENDING';
4503:

Line 4500: AND request_id = FND_GLOBAL.conc_request_id

4496:
4497: UPDATE hxc_rdb_process_timecards
4498: SET stage = 'SKIPPED'
4499: WHERE ret_user_id = FND_GLOBAL.user_id
4500: AND request_id = FND_GLOBAL.conc_request_id
4501: AND process = g_params.p_process
4502: AND stage = 'PENDING';
4503:
4504: COMMIT;

Line 8691: FND_GLOBAL.user_ID,

8687: l_skipped_bb_id (i),
8688: l_skipped_bb_ovn(i),
8689: l_skipped_desc(i),
8690: 'OTL_PROC',
8691: FND_GLOBAL.user_ID,
8692: FND_GLOBAL.conc_request_id,
8693: g_params.p_process);
8694:
8695: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 8692: FND_GLOBAL.conc_request_id,

8688: l_skipped_bb_ovn(i),
8689: l_skipped_desc(i),
8690: 'OTL_PROC',
8691: FND_GLOBAL.user_ID,
8692: FND_GLOBAL.conc_request_id,
8693: g_params.p_process);
8694:
8695: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
8696:

Line 8818: FND_GLOBAL.user_ID,

8814: l_skipped_bb_id (i),
8815: l_skipped_bb_ovn(i),
8816: l_skipped_desc(i),
8817: 'OTL_PROC',
8818: FND_GLOBAL.user_ID,
8819: FND_GLOBAL.conc_request_id,
8820: g_params.p_process);
8821:
8822:

Line 8819: FND_GLOBAL.conc_request_id,

8815: l_skipped_bb_ovn(i),
8816: l_skipped_desc(i),
8817: 'OTL_PROC',
8818: FND_GLOBAL.user_ID,
8819: FND_GLOBAL.conc_request_id,
8820: g_params.p_process);
8821:
8822:
8823: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 9329: request_id = FND_GLOBAL.conc_request_id

9325: business_group_id = t_l_business_group_id(i),
9326: org_id = t_l_org_id(i),
9327: approval_status = t_l_approval_status(i),
9328: old_request_id = request_id,
9329: request_id = FND_GLOBAL.conc_request_id
9330: WHERE time_building_block_id = t_l_time_building_block_id(i)
9331: RETURNING time_building_block_id
9332: BULK COLLECT INTO l_old_tbb;
9333:

Line 9419: FND_GLOBAL.conc_request_id);

9415: l_attribute2(i),
9416: l_attribute3(i),
9417: l_measure(i),
9418: l_object_version_number(i),
9419: FND_GLOBAL.conc_request_id);
9420:
9421:
9422: END IF;
9423:

Line 9444: AND request_id = FND_GLOBAL.CONC_REQUEST_ID

9440: DELETE FROM hxc_rdb_process_details
9441: WHERE detail_id = hxc_generic_retrieval_pkg.t_tx_detail_bb_id(tx_error)
9442: AND hxc_generic_retrieval_pkg.t_tx_detail_status
9443: (tx_error) = 'SUCCESS'
9444: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
9445: AND ret_user_id = FND_global.user_id
9446: AND process = g_params.p_process
9447: RETURNING timecard_id
9448: BULK

Line 9445: AND ret_user_id = FND_global.user_id

9441: WHERE detail_id = hxc_generic_retrieval_pkg.t_tx_detail_bb_id(tx_error)
9442: AND hxc_generic_retrieval_pkg.t_tx_detail_status
9443: (tx_error) = 'SUCCESS'
9444: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
9445: AND ret_user_id = FND_global.user_id
9446: AND process = g_params.p_process
9447: RETURNING timecard_id
9448: BULK
9449: COLLECT INTO l_success_tc ;

Line 9465: AND request_id = FND_GLOBAL.CONC_REQUEST_ID

9461: (tx_error),1,149)
9462: WHERE detail_id = hxc_generic_retrieval_pkg.t_tx_detail_bb_id(tx_error)
9463: AND hxc_generic_retrieval_pkg.t_tx_detail_status
9464: (tx_error) = 'ERRORS'
9465: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
9466: AND ret_user_id = FND_global.user_id
9467: AND process = g_params.p_process
9468: RETURNING timecard_id
9469: BULK

Line 9466: AND ret_user_id = FND_global.user_id

9462: WHERE detail_id = hxc_generic_retrieval_pkg.t_tx_detail_bb_id(tx_error)
9463: AND hxc_generic_retrieval_pkg.t_tx_detail_status
9464: (tx_error) = 'ERRORS'
9465: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
9466: AND ret_user_id = FND_global.user_id
9467: AND process = g_params.p_process
9468: RETURNING timecard_id
9469: BULK
9470: COLLECT INTO l_error_tc ;

Line 9584: request_id = FND_global.conc_request_id,

9580: org_id = t_l_org_id(i),
9581: approval_status = t_l_approval_status(i),
9582: old_request_id = request_id,
9583: old_batch_id = batch_id,
9584: request_id = FND_global.conc_request_id,
9585: application_set_id = t_l_application_set_id(i)
9586: WHERE time_building_block_id = t_l_time_building_block_id(i)
9587: AND old_batch_id IS NULL
9588: RETURNING time_building_block_id

Line 9610: request_id = FND_global.conc_request_id,

9606: org_id = t_l_org_id(i),
9607: approval_status = t_l_approval_status(i),
9608: old_request_id = request_id,
9609: old_batch_id = batch_id,
9610: request_id = FND_global.conc_request_id,
9611: application_set_id = t_l_application_set_id(i)
9612: WHERE time_building_block_id = t_l_time_building_block_id(i)
9613: RETURNING time_building_block_id
9614: BULK COLLECT INTO l_old_tbb;

Line 9708: FND_GLOBAL.conc_request_id,

9704: l_attribute2(i),
9705: l_attribute3(i),
9706: l_measure(i),
9707: l_object_version_number(i),
9708: FND_GLOBAL.conc_request_id,
9709: l_application_set_id(i));
9710:
9711: -- Bug 12919783
9712: -- HXC_RET_PAY_DETAILS is our Dump to hold all retrievals done ever

Line 9745: FND_GLOBAL.conc_request_id);

9741: t_l_attribute2(i),
9742: t_l_attribute3(i),
9743: t_l_measure(i),
9744: t_l_object_version_number(i),
9745: FND_GLOBAL.conc_request_id);
9746:
9747:
9748: -- This is payroll specific code.
9749: -- Picking up the batch id information back on to the table.

Line 9797: FND_GLOBAL.conc_request_id);

9793: batch_id,
9794: request_id)
9795: VALUES ( g_params.p_transaction_code,
9796: l_batch_id(i),
9797: FND_GLOBAL.conc_request_id);
9798: EXCEPTION
9799: WHEN OTHERS
9800: THEN
9801: NULL;

Line 9846: AND request_id = FND_GLOBAL.conc_request_id ;

9842: SET retro_pbl_id = l_rec_id(i),
9843: retro_batch_id = l_batch_id(i),
9844: old_ovn = l_rec_ovn(i)
9845: WHERE time_building_block_id = l_rec_bb_id(i)
9846: AND request_id = FND_GLOBAL.conc_request_id ;
9847:
9848: BEGIN
9849: l_batch_id := SET(l_batch_id);
9850: FORALL i IN l_batch_id.FIRST..l_batch_id.LAST SAVE EXCEPTIONS

Line 9857: FND_GLOBAL.conc_request_id);

9853: batch_id,
9854: request_id)
9855: VALUES ( g_params.p_transaction_code,
9856: l_batch_id(i),
9857: FND_GLOBAL.conc_request_id);
9858: EXCEPTION
9859: WHEN OTHERS
9860: THEN
9861: NULL;

Line 9881: AND request_id = FND_GLOBAL.CONC_REQUEST_ID

9877: DELETE FROM hxc_rdb_process_details
9878: WHERE detail_id = hxc_generic_retrieval_pkg.t_tx_detail_bb_id(tx_error)
9879: AND hxc_generic_retrieval_pkg.t_tx_detail_status
9880: (tx_error) = 'SUCCESS'
9881: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
9882: AND ret_user_id = FND_global.user_id
9883: AND process = g_params.p_process
9884: RETURNING timecard_id
9885: BULK

Line 9882: AND ret_user_id = FND_global.user_id

9878: WHERE detail_id = hxc_generic_retrieval_pkg.t_tx_detail_bb_id(tx_error)
9879: AND hxc_generic_retrieval_pkg.t_tx_detail_status
9880: (tx_error) = 'SUCCESS'
9881: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
9882: AND ret_user_id = FND_global.user_id
9883: AND process = g_params.p_process
9884: RETURNING timecard_id
9885: BULK
9886: COLLECT INTO l_success_tc ;

Line 9900: SET request_id = FND_Global.conc_request_id

9896: THEN
9897:
9898: FORALL rlbk IN l_success_tc.FIRST..l_success_tc.LAST
9899: UPDATE hxc_ld_rollback_timecards_all
9900: SET request_id = FND_Global.conc_request_id
9901: WHERE timecard_id = l_success_tc(rlbk)
9902: RETURNING timecard_id BULK COLLECT INTO l_rlbk_elig_tc1;
9903:
9904: l_rlbk_elig_tc2 := l_success_tc MULTISET EXCEPT l_rlbk_elig_tc1;

Line 9909: VALUES (l_rlbk_elig_tc2(rlbk),FND_GLOBAL.conc_request_id);

9905:
9906: FORALL rlbk IN l_rlbk_elig_tc2.FIRST..l_rlbk_elig_tc2.LAST
9907: INSERT INTO hxc_ld_rollback_timecards_all
9908: (timecard_id, request_id)
9909: VALUES (l_rlbk_elig_tc2(rlbk),FND_GLOBAL.conc_request_id);
9910:
9911: END IF;
9912:
9913: -- Bug : 9948863

Line 9923: AND request_id = FND_GLOBAL.CONC_REQUEST_ID

9919: (tx_error),1,149)
9920: WHERE detail_id = hxc_generic_retrieval_pkg.t_tx_detail_bb_id(tx_error)
9921: AND hxc_generic_retrieval_pkg.t_tx_detail_status
9922: (tx_error) = 'ERRORS'
9923: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
9924: AND ret_user_id = FND_global.user_id
9925: AND process = g_params.p_process
9926: RETURNING timecard_id
9927: BULK

Line 9924: AND ret_user_id = FND_global.user_id

9920: WHERE detail_id = hxc_generic_retrieval_pkg.t_tx_detail_bb_id(tx_error)
9921: AND hxc_generic_retrieval_pkg.t_tx_detail_status
9922: (tx_error) = 'ERRORS'
9923: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
9924: AND ret_user_id = FND_global.user_id
9925: AND process = g_params.p_process
9926: RETURNING timecard_id
9927: BULK
9928: COLLECT INTO l_error_tc ;