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.XTR_IAC_TRANSFERS_PKG dependencies on DUAL

Line 377: p_dual_auth_by OUT NOCOPY VARCHAR2,

373: --********************************************************************************************
374: procedure VALIDATE_SETTLE_DDA (p_validate_flag IN BOOLEAN,
375: p_settle_flag IN BOOLEAN,
376: p_actual_settle IN DATE,
377: p_dual_auth_by OUT NOCOPY VARCHAR2,
378: p_dual_auth_on OUT NOCOPY DATE,
379: p_settle OUT NOCOPY VARCHAR2,
380: p_settle_no OUT NOCOPY NUMBER,
381: p_settle_no2 OUT NOCOPY NUMBER,

Line 378: p_dual_auth_on OUT NOCOPY DATE,

374: procedure VALIDATE_SETTLE_DDA (p_validate_flag IN BOOLEAN,
375: p_settle_flag IN BOOLEAN,
376: p_actual_settle IN DATE,
377: p_dual_auth_by OUT NOCOPY VARCHAR2,
378: p_dual_auth_on OUT NOCOPY DATE,
379: p_settle OUT NOCOPY VARCHAR2,
380: p_settle_no OUT NOCOPY NUMBER,
381: p_settle_no2 OUT NOCOPY NUMBER,
382: p_settle_auth OUT NOCOPY VARCHAR2,

Line 390: select XTR_SETTLEMENT_NUMBER_S.NEXTVAL into p_settle_no from DUAL;

386:
387: begin
388:
389: -- Bug 6738354 start
390: select XTR_SETTLEMENT_NUMBER_S.NEXTVAL into p_settle_no from DUAL;
391: select XTR_SETTLEMENT_NUMBER_S.NEXTVAL into p_settle_no2 from DUAL;
392: -- Bug 6738354 end
393:
394: -------------------------------------

Line 391: select XTR_SETTLEMENT_NUMBER_S.NEXTVAL into p_settle_no2 from DUAL;

387: begin
388:
389: -- Bug 6738354 start
390: select XTR_SETTLEMENT_NUMBER_S.NEXTVAL into p_settle_no from DUAL;
391: select XTR_SETTLEMENT_NUMBER_S.NEXTVAL into p_settle_no2 from DUAL;
392: -- Bug 6738354 end
393:
394: -------------------------------------
395: -- Dual Authorised Attributes

Line 395: -- Dual Authorised Attributes

391: select XTR_SETTLEMENT_NUMBER_S.NEXTVAL into p_settle_no2 from DUAL;
392: -- Bug 6738354 end
393:
394: -------------------------------------
395: -- Dual Authorised Attributes
396: -------------------------------------
397: if p_validate_flag then
398: p_dual_auth_by := G_iac_user;
399: p_dual_auth_on := G_iac_date;

Line 398: p_dual_auth_by := G_iac_user;

394: -------------------------------------
395: -- Dual Authorised Attributes
396: -------------------------------------
397: if p_validate_flag then
398: p_dual_auth_by := G_iac_user;
399: p_dual_auth_on := G_iac_date;
400: else
401: p_dual_auth_by := null;
402: p_dual_auth_on := null;

Line 399: p_dual_auth_on := G_iac_date;

395: -- Dual Authorised Attributes
396: -------------------------------------
397: if p_validate_flag then
398: p_dual_auth_by := G_iac_user;
399: p_dual_auth_on := G_iac_date;
400: else
401: p_dual_auth_by := null;
402: p_dual_auth_on := null;
403: end if;

Line 401: p_dual_auth_by := null;

397: if p_validate_flag then
398: p_dual_auth_by := G_iac_user;
399: p_dual_auth_on := G_iac_date;
400: else
401: p_dual_auth_by := null;
402: p_dual_auth_on := null;
403: end if;
404:
405: -------------------------------------

Line 402: p_dual_auth_on := null;

398: p_dual_auth_by := G_iac_user;
399: p_dual_auth_on := G_iac_date;
400: else
401: p_dual_auth_by := null;
402: p_dual_auth_on := null;
403: end if;
404:
405: -------------------------------------
406: -- Settlement Attributes

Line 411: select XTR_SETTLEMENT_NUMBER_S.NEXTVAL into p_settle_no from DUAL;

407: -------------------------------------
408: if p_settle_flag then
409:
410: /* Bug 6738354 start
411: select XTR_SETTLEMENT_NUMBER_S.NEXTVAL into p_settle_no from DUAL;
412: select XTR_SETTLEMENT_NUMBER_S.NEXTVAL into p_settle_no2 from DUAL;
413: Bug 6738354 end */
414: p_settle := 'Y';
415: p_settle_auth := G_iac_user;

Line 412: select XTR_SETTLEMENT_NUMBER_S.NEXTVAL into p_settle_no2 from DUAL;

408: if p_settle_flag then
409:
410: /* Bug 6738354 start
411: select XTR_SETTLEMENT_NUMBER_S.NEXTVAL into p_settle_no from DUAL;
412: select XTR_SETTLEMENT_NUMBER_S.NEXTVAL into p_settle_no2 from DUAL;
413: Bug 6738354 end */
414: p_settle := 'Y';
415: p_settle_auth := G_iac_user;
416: p_settle_date := p_actual_settle;

Line 451: l_dual_auth_by xtr_deal_date_amounts.DUAL_AUTHORISATION_BY%TYPE;

447: l_settle_no NUMBER := null;
448: l_settle_no2 NUMBER := null;
449: l_settle_auth xtr_deal_date_amounts.SETTLEMENT_AUTHORISED_BY%TYPE;
450: l_settle_date DATE;
451: l_dual_auth_by xtr_deal_date_amounts.DUAL_AUTHORISATION_BY%TYPE;
452: l_dual_auth_on DATE;
453: l_trans_mts VARCHAR2(1);
454: l_audit_indic VARCHAR2(1);
455: l_dummy_num NUMBER;

Line 452: l_dual_auth_on DATE;

448: l_settle_no2 NUMBER := null;
449: l_settle_auth xtr_deal_date_amounts.SETTLEMENT_AUTHORISED_BY%TYPE;
450: l_settle_date DATE;
451: l_dual_auth_by xtr_deal_date_amounts.DUAL_AUTHORISATION_BY%TYPE;
452: l_dual_auth_on DATE;
453: l_trans_mts VARCHAR2(1);
454: l_audit_indic VARCHAR2(1);
455: l_dummy_num NUMBER;
456:

Line 465: l_dual_auth_by,

461: -------------------------------------------------------------------------
462: VALIDATE_SETTLE_DDA (p_Validated,
463: p_Settled,
464: ARec_IAC.Transfer_date,
465: l_dual_auth_by,
466: l_dual_auth_on,
467: l_settle,
468: l_settle_no,
469: l_settle_no2,

Line 466: l_dual_auth_on,

462: VALIDATE_SETTLE_DDA (p_Validated,
463: p_Settled,
464: ARec_IAC.Transfer_date,
465: l_dual_auth_by,
466: l_dual_auth_on,
467: l_settle,
468: l_settle_no,
469: l_settle_no2,
470: l_settle_auth,

Line 485: limit_party, DUAL_AUTHORISATION_BY, DUAL_AUTHORISATION_ON,

481: currency, amount, hce_amount, amount_date,
482: cashflow_amount, company_code, account_no, action_code,
483: cparty_code, cparty_account_no, status_code,
484: exp_settle_reqd, deal_subtype, portfolio_code, dealer_code,
485: limit_party, DUAL_AUTHORISATION_BY, DUAL_AUTHORISATION_ON,
486: SETTLE, SETTLEMENT_NUMBER, SETTLEMENT_AUTHORISED_BY, ACTUAL_SETTLEMENT_DATE,
487: TRANS_MTS, AUDIT_INDICATOR)
488: values ( ARec_IAC.deal_type, 'AMOUNT', 'VALUE', ARec_IAC.PRODUCT_TYPE,
489: 0, p_tran_num, ARec_IAC.deal_date, -- per TD design

Line 494: p_From_Bank, l_dual_auth_by, l_dual_auth_on,

490: ARec_IAC.CURRENCY, ARec_IAC.TRANSFER_AMOUNT, 0, ARec_IAC.Transfer_date,
491: -ARec_IAC.TRANSFER_AMOUNT,ARec_IAC.COMPANY_CODE, ARec_IAC.ACCOUNT_NO_FROM, 'PAY',
492: ARec_IAC.COMPANY_CODE, ARec_IAC.ACCOUNT_NO_TO, ARec_IAC.STATUS_CODE,
493: 'Y', ARec_IAC.DEAL_SUBTYPE, ARec_IAC.PORTFOLIO_CODE, ARec_IAC.DEALER_CODE,
494: p_From_Bank, l_dual_auth_by, l_dual_auth_on,
495: l_settle, l_settle_no, l_settle_auth, l_settle_date,
496: l_trans_mts, l_audit_indic);
497:
498: -------------------------------------------------------------------------

Line 508: limit_party, DUAL_AUTHORISATION_BY, DUAL_AUTHORISATION_ON,

504: currency, amount, hce_amount, amount_date,
505: cashflow_amount, company_code, account_no, action_code,
506: cparty_code, cparty_account_no, status_code,
507: exp_settle_reqd, deal_subtype, portfolio_code, dealer_code,
508: limit_party, DUAL_AUTHORISATION_BY, DUAL_AUTHORISATION_ON,
509: SETTLE, SETTLEMENT_NUMBER, SETTLEMENT_AUTHORISED_BY, ACTUAL_SETTLEMENT_DATE,
510: TRANS_MTS, AUDIT_INDICATOR)
511: values ( ARec_IAC.deal_type, 'AMOUNT', 'VALUE', ARec_IAC.PRODUCT_TYPE,
512: 0, p_tran_num, ARec_IAC.deal_date, -- per TD design

Line 517: p_To_Bank, l_dual_auth_by, l_dual_auth_on,

513: ARec_IAC.CURRENCY, ARec_IAC.TRANSFER_AMOUNT, 0, ARec_IAC.TRANSFER_DATE,
514: ARec_IAC.TRANSFER_AMOUNT, ARec_IAC.COMPANY_CODE, ARec_IAC.ACCOUNT_NO_TO, 'REC',
515: ARec_IAC.COMPANY_CODE, ARec_IAC.ACCOUNT_NO_FROM, ARec_IAC.STATUS_CODE,
516: 'Y', ARec_IAC.DEAL_SUBTYPE, ARec_IAC.PORTFOLIO_CODE, ARec_IAC.DEALER_CODE,
517: p_To_Bank, l_dual_auth_by, l_dual_auth_on,
518: l_settle, l_settle_no2, l_settle_auth, l_settle_date,
519: l_trans_mts, l_audit_indic);
520:
521: -------------------------------------------------

Line 572: from DUAL;

568: p_tran_num IN NUMBER) is
569: -----------------------------------------------------------------------------------------------------
570: cursor EXP_TRANS_NUM is
571: select XTR_EXPOSURE_TRANS_S.NEXTVAL
572: from DUAL;
573:
574: l_dual_dealer XTR_INTERACCT_TRANSFERS.DEALER_CODE%TYPE;
575: l_dual_date DATE;
576:

Line 574: l_dual_dealer XTR_INTERACCT_TRANSFERS.DEALER_CODE%TYPE;

570: cursor EXP_TRANS_NUM is
571: select XTR_EXPOSURE_TRANS_S.NEXTVAL
572: from DUAL;
573:
574: l_dual_dealer XTR_INTERACCT_TRANSFERS.DEALER_CODE%TYPE;
575: l_dual_date DATE;
576:
577: begin
578: /*

Line 575: l_dual_date DATE;

571: select XTR_EXPOSURE_TRANS_S.NEXTVAL
572: from DUAL;
573:
574: l_dual_dealer XTR_INTERACCT_TRANSFERS.DEALER_CODE%TYPE;
575: l_dual_date DATE;
576:
577: begin
578: /*
579: open EXP_TRANS_NUM;

Line 585: l_dual_dealer := ARec_IAC.DEALER_CODE;

581: close EXP_TRANS_NUM;
582: */
583:
584: if p_Validated then
585: l_dual_dealer := ARec_IAC.DEALER_CODE;
586: l_dual_date := G_sys_date;
587: else
588: l_dual_dealer := null;
589: l_dual_date := null;

Line 586: l_dual_date := G_sys_date;

582: */
583:
584: if p_Validated then
585: l_dual_dealer := ARec_IAC.DEALER_CODE;
586: l_dual_date := G_sys_date;
587: else
588: l_dual_dealer := null;
589: l_dual_date := null;
590: end if;

Line 588: l_dual_dealer := null;

584: if p_Validated then
585: l_dual_dealer := ARec_IAC.DEALER_CODE;
586: l_dual_date := G_sys_date;
587: else
588: l_dual_dealer := null;
589: l_dual_date := null;
590: end if;
591:
592: Insert into XTR_INTERACCT_TRANSFERS(

Line 589: l_dual_date := null;

585: l_dual_dealer := ARec_IAC.DEALER_CODE;
586: l_dual_date := G_sys_date;
587: else
588: l_dual_dealer := null;
589: l_dual_date := null;
590: end if;
591:
592: Insert into XTR_INTERACCT_TRANSFERS(
593: ACCOUNT_NO_FROM,

Line 610: DUAL_AUTHORISATION_BY,

606: CREATED_BY,
607: LAST_UPDATED_BY,
608: LAST_UPDATE_DATE,
609: LAST_UPDATE_LOGIN,
610: DUAL_AUTHORISATION_BY,
611: DUAL_AUTHORISATION_ON,
612: DEAL_DATE,
613: DEALER_CODE,
614: REQUEST_ID,

Line 611: DUAL_AUTHORISATION_ON,

607: LAST_UPDATED_BY,
608: LAST_UPDATE_DATE,
609: LAST_UPDATE_LOGIN,
610: DUAL_AUTHORISATION_BY,
611: DUAL_AUTHORISATION_ON,
612: DEAL_DATE,
613: DEALER_CODE,
614: REQUEST_ID,
615: PROGRAM_APPLICATION_ID,

Line 636: l_dual_dealer, -- DUAL_AUTHORIZATION_BY

632: fnd_global.user_id, -- CREATED_BY
633: fnd_global.user_id, -- LAST_UPDATED_BY
634: G_sys_date, -- LAST_UPDATE_DATE
635: fnd_global.user_id, -- LAST_UPDATE_LOGIN
636: l_dual_dealer, -- DUAL_AUTHORIZATION_BY
637: l_dual_date, -- DUAL_AUTHORIZATION_ON
638: ARec_IAC.DEAL_DATE, -- DEAL DATE
639: ARec_IAC.DEALER_CODE, -- DEALER_CODE
640: fnd_global.conc_request_id,

Line 637: l_dual_date, -- DUAL_AUTHORIZATION_ON

633: fnd_global.user_id, -- LAST_UPDATED_BY
634: G_sys_date, -- LAST_UPDATE_DATE
635: fnd_global.user_id, -- LAST_UPDATE_LOGIN
636: l_dual_dealer, -- DUAL_AUTHORIZATION_BY
637: l_dual_date, -- DUAL_AUTHORIZATION_ON
638: ARec_IAC.DEAL_DATE, -- DEAL DATE
639: ARec_IAC.DEALER_CODE, -- DEALER_CODE
640: fnd_global.conc_request_id,
641: fnd_global.prog_appl_id,

Line 673: from DUAL;

669: and party_code = l_comp;
670:
671: cursor EXP_TRANS_NUM is
672: select XTR_EXPOSURE_TRANS_S.NEXTVAL
673: from DUAL;
674:
675: l_dummy NUMBER;
676: l_bank_code_from xtr_deal_date_amounts.limit_party%TYPE;
677: l_bank_code_to xtr_deal_date_amounts.limit_party%TYPE;

Line 695: From Dual;

691: close FIND_USER;
692:
693: Select sysdate, trunc(sysdate)
694: into G_sys_date, G_iac_date
695: From Dual;
696:
697: ----------------------------------------------------------------------------------------------------
698: --* The following code checks if user has permissions to transfer the deal (company authorization)
699: ----------------------------------------------------------------------------------------------------