DBA Data[Home] [Help]

APPS.ECE_AR_TRANSACTION dependencies on DUAL

Line 91: FROM DUAL;

87:
88: xProgress := 'INO-10-1015';
89: BEGIN
90: SELECT ece_output_runs_s.NEXTVAL INTO iRun_id
91: FROM DUAL;
92:
93: EXCEPTION
94: WHEN NO_DATA_FOUND THEN
95: ec_debug.pl(1,

Line 112: FROM DUAL;

108:
109: xProgress := 'INO-10-1030';
110: BEGIN
111: SELECT SYSDATE INTO dTransaction_date
112: FROM DUAL;
113:
114: EXCEPTION
115: WHEN NO_DATA_FOUND THEN
116: ec_debug.pl(1,

Line 122: 'DUAL');

118: 'ECE_GET_SYSDATE_FAILED',
119: 'PROGRESS_LEVEL',
120: xProgress,
121: 'TABLE_NAME',
122: 'DUAL');
123:
124: END;
125: ec_debug.pl(3,'dTransaction_date: ',dTransaction_date);
126:

Line 4369: FROM sys.dual;

4365: xProgress := '2570-70';
4366: BEGIN
4367: SELECT ece_ar_trx_headers_s.nextval
4368: INTO l_header_fkey
4369: FROM sys.dual;
4370: EXCEPTION
4371: WHEN NO_DATA_FOUND THEN
4372: ec_debug.pl ( 1,
4373: 'EC',

Line 4629: FROM sys.dual;

4625: xProgress := '2690-70';
4626: BEGIN
4627: SELECT ece_ar_trx_header_1_s.nextval
4628: INTO l_header_1_fkey
4629: FROM sys.dual;
4630: EXCEPTION
4631: WHEN NO_DATA_FOUND THEN
4632: ec_debug.pl ( 1,
4633: 'EC',

Line 4947: FROM sys.dual;

4943: xProgress := '2840-70';
4944: BEGIN
4945: SELECT ece_ar_trx_allowance_charges_s.nextval
4946: INTO l_alw_chg_fkey
4947: FROM sys.dual;
4948: EXCEPTION
4949: WHEN NO_DATA_FOUND THEN
4950: ec_debug.pl ( 1,
4951: 'EC',

Line 5084: FROM sys.dual;

5080: xProgress := '2920-70';
5081: BEGIN
5082: SELECT ece_ar_trx_lines_s.nextval
5083: INTO l_line_fkey
5084: FROM sys.dual;
5085: EXCEPTION
5086: WHEN NO_DATA_FOUND THEN
5087: ec_debug.pl ( 1,
5088: 'EC',

Line 5291: FROM sys.dual;

5287: xProgress := '3010-70';
5288: BEGIN
5289: SELECT ece_ar_trx_line_tax_s.nextval
5290: INTO l_line_t_fkey
5291: FROM sys.dual;
5292: EXCEPTION
5293: WHEN NO_DATA_FOUND THEN
5294: ec_debug.pl ( 1,
5295: 'EC',