DBA Data[Home] [Help]

APPS.XTR_IAC_TRANSFERS_PKG dependencies on XTR_SETTLEMENT_NUMBER_S

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 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;