[Home] [Help]
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,
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
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;
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
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
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;
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
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);
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
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)
962: 'INSERTED',
963: order_num,
964: request_control_id,
965: table_name
966: FROM xla_upgrade_requests
967: WHERE batch_id = p_batch_id
968: AND parent_request_control_id = p_parent_req_control_id
969: AND phase_num = l_phase
970: AND program_code = l_program_code
1431:
1432: CURSOR c_ar_xla_dates IS
1433: SELECT b.start_date,
1434: b.end_date
1435: FROM xla_upgrade_requests b
1436: WHERE b.ledger_id = p_ledger_id
1437: AND b.program_code = 'XLA_UPG'
1438: AND b.status_code = 'S'
1439: AND b.phase_num = 0
1768:
1769: CURSOR exist_xla_active(p_ledger_id IN NUMBER)
1770: IS
1771: SELECT *
1772: FROM xla_upgrade_requests
1773: WHERE program_code = 'XLA_UPG'
1774: AND phase_num = 0
1775: AND status_code = 'A'
1776: AND ledger_id = p_ledger_id
1775: AND status_code = 'A'
1776: AND ledger_id = p_ledger_id
1777: AND application_id = 222;
1778:
1779: l_xla_upg_rec xla_upgrade_requests%ROWTYPE;
1780:
1781: CURSOR child_reexc_request(p_ledger_id IN NUMBER,
1782: p_batch_id IN NUMBER)
1783: IS
1785: 'GIR_UPG' ,'GL' , --GIR
1786: 'MRC_UPG','MRC',
1787: 'JL_UPG' ,'JL',
1788: 'PSA_UPG','PSA')
1789: FROM xla_upgrade_requests
1790: WHERE program_code <> 'XLA_UPG'
1791: AND phase_num <> 0
1792: AND status_code = 'A'
1793: AND ledger_id = p_ledger_id