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.AR_UPGHARNESS_PKG dependencies on XLA_UPGRADE_REQUESTS

Line 21: (p_ins_rec IN xla_upgrade_requests%ROWTYPE,

17: (p_request_id IN NUMBER
18: ,p_status IN VARCHAR2);
19:
20: PROCEDURE insert_req_control
21: (p_ins_rec IN xla_upgrade_requests%ROWTYPE,
22: x_request_control_id OUT NOCOPY NUMBER);
23:
24: PROCEDURE update_req_control
25: (p_request_control_id IN NUMBER,

Line 412: FROM xla_upgrade_requests

408: x_request_control_id OUT NOCOPY NUMBER)
409: IS
410: CURSOR c_child_req IS
411: SELECT request_control_id
412: FROM xla_upgrade_requests
413: WHERE table_name = p_table_name
414: AND script_name = p_script_name
415: AND workers_num = p_num_workers
416: AND worker_id = p_worker_id

Line 431: FROM xla_upgrade_requests

427: ,batch_size
428: ,batch_id
429: ,start_date
430: ,end_date
431: FROM xla_upgrade_requests
432: WHERE phase_num = 0
433: AND status_code <> 'S'
434: AND program_code = 'XLA_UPG'
435: AND application_id = 222;

Line 437: l_rec xla_upgrade_requests%ROWTYPE;

433: AND status_code <> 'S'
434: AND program_code = 'XLA_UPG'
435: AND application_id = 222;
436:
437: l_rec xla_upgrade_requests%ROWTYPE;
438: l_ins_rec xla_upgrade_requests%ROWTYPE;
439:
440: CURSOR c_ord_num IS
441: SELECT order_num

Line 438: l_ins_rec xla_upgrade_requests%ROWTYPE;

434: AND program_code = 'XLA_UPG'
435: AND application_id = 222;
436:
437: l_rec xla_upgrade_requests%ROWTYPE;
438: l_ins_rec xla_upgrade_requests%ROWTYPE;
439:
440: CURSOR c_ord_num IS
441: SELECT order_num
442: FROM ar_submission_ctrl_gt

Line 494: x_return_msg := 'The xla_upgrade_requests record exist-request_control_id:'||l_request_control_id;

490: l_ins_rec.phase_num := p_phase;
491:
492: insert_req_control(l_ins_rec,x_request_control_id);
493: ELSE
494: x_return_msg := 'The xla_upgrade_requests record exist-request_control_id:'||l_request_control_id;
495:
496: update_req_control(l_request_control_id,p_status);
497:
498: x_request_control_id := l_request_control_id;

Line 519: (p_ins_rec IN xla_upgrade_requests%ROWTYPE,

515: END;
516:
517:
518: PROCEDURE insert_req_control
519: (p_ins_rec IN xla_upgrade_requests%ROWTYPE,
520: x_request_control_id OUT NOCOPY NUMBER)
521: IS
522: l_request_control_id NUMBER;
523: BEGIN

Line 525: SELECT xla_upgrade_requests_s.NEXTVAL

521: IS
522: l_request_control_id NUMBER;
523: BEGIN
524: log( message => 'Inserting a record in ar_reqrest_control');
525: SELECT xla_upgrade_requests_s.NEXTVAL
526: INTO l_request_control_id
527: FROM DUAL;
528: log('request_control_id:'|| l_request_control_id);
529: log('parent_request_control_id:'||p_ins_rec.parent_request_control_id);

Line 546: INSERT INTO xla_upgrade_requests(

542: log('order_num :'||p_ins_rec.order_num);
543: log('start_date :'||p_ins_rec.start_date);
544: log('end_date :'||p_ins_rec.end_date);
545:
546: INSERT INTO xla_upgrade_requests(
547: request_control_id
548: ,parent_request_control_id
549: ,phase_num
550: ,program_code

Line 607: UPDATE xla_upgrade_requests

603: IS
604: BEGIN
605: log( message => 'Updating control record with request_control_id :'||p_request_control_id||'
606: by setting the status to:'||p_status);
607: UPDATE xla_upgrade_requests
608: SET status_code = p_status
609: ,LAST_UPDATE_DATE = SYSDATE
610: ,LAST_UPDATED_BY = nvl(FND_GLOBAL.user_id,-1)
611: ,LAST_UPDATE_LOGIN = nvl(FND_GLOBAL.conc_login_id,FND_GLOBAL.login_id)

Line 723: FROM xla_upgrade_requests

719: END IF;
720:
721: SELECT batch_id
722: INTO l_batch_id
723: FROM xla_upgrade_requests
724: WHERE worker_id = l_worker_id
725: AND script_name = l_script_name
726: AND table_name = l_table_name ;
727:

Line 1008: FROM xla_upgrade_requests

1004: 'INSERTED',
1005: order_num,
1006: request_control_id,
1007: table_name
1008: FROM xla_upgrade_requests
1009: WHERE batch_id = p_batch_id
1010: AND parent_request_control_id = p_parent_req_control_id
1011: AND phase_num = l_phase
1012: AND program_code = l_program_code

Line 1493: FROM xla_upgrade_requests b

1489:
1490: CURSOR c_ar_xla_dates IS
1491: SELECT b.start_date,
1492: b.end_date
1493: FROM xla_upgrade_requests b
1494: WHERE b.ledger_id = p_ledger_id
1495: AND b.program_code = 'XLA_UPG'
1496: AND b.status_code = 'S'
1497: AND b.phase_num = 0

Line 1888: FROM xla_upgrade_requests

1884:
1885: CURSOR exist_xla_active(p_ledger_id IN NUMBER)
1886: IS
1887: SELECT *
1888: FROM xla_upgrade_requests
1889: WHERE program_code = 'XLA_UPG'
1890: AND phase_num = 0
1891: AND status_code = 'A'
1892: AND ledger_id = p_ledger_id

Line 1895: l_xla_upg_rec xla_upgrade_requests%ROWTYPE;

1891: AND status_code = 'A'
1892: AND ledger_id = p_ledger_id
1893: AND application_id = 222;
1894:
1895: l_xla_upg_rec xla_upgrade_requests%ROWTYPE;
1896:
1897: CURSOR child_reexc_request(p_ledger_id IN NUMBER,
1898: p_batch_id IN NUMBER)
1899: IS

Line 1905: FROM xla_upgrade_requests

1901: 'GIR_UPG' ,'GL' , --GIR
1902: 'MRC_UPG','MRC',
1903: 'JL_UPG' ,'JL',
1904: 'PSA_UPG','PSA')
1905: FROM xla_upgrade_requests
1906: WHERE program_code <> 'XLA_UPG'
1907: AND phase_num <> 0
1908: AND status_code = 'A'
1909: AND ledger_id = p_ledger_id