[Home] [Help]
973:
974: BEGIN
975: select hsecs
976: into G_START_TIME
977: from v$timer;
978:
979: /*------------------------------------+
980: | Standard start of API savepoint |
981: +------------------------------------*/
1258: END IF;
1259:
1260: select TO_CHAR( (hsecs - G_START_TIME) / 100)
1261: into l_hsec
1262: from v$timer;
1263:
1264: IF PG_DEBUG in ('Y', 'C') THEN
1265: arp_util.debug('Create_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds', G_MSG_LOW);
1266: END IF;
1400:
1401: BEGIN
1402: select hsecs
1403: into G_START_TIME
1404: from v$timer;
1405:
1406: /*------------------------------------+
1407: | Standard start of API savepoint |
1408: +------------------------------------*/
1672: END IF;
1673:
1674: select TO_CHAR( (hsecs - G_START_TIME) / 100)
1675: into l_hsec
1676: from v$timer;
1677:
1678: IF PG_DEBUG in ('Y', 'C') THEN
1679: arp_util.debug('Modify_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds', G_MSG_LOW);
1680: END IF;
1814:
1815: BEGIN
1816: select hsecs
1817: into G_START_TIME
1818: from v$timer;
1819:
1820: /*------------------------------------+
1821: | Standard start of API savepoint |
1822: +------------------------------------*/
2091: END IF;
2092:
2093: select TO_CHAR( (hsecs - G_START_TIME) / 100)
2094: into l_hsec
2095: from v$timer;
2096:
2097: IF PG_DEBUG in ('Y', 'C') THEN
2098: arp_util.debug('Reverse_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds', G_MSG_LOW);
2099: END IF;
2234:
2235: BEGIN
2236: select hsecs
2237: into G_START_TIME
2238: from v$timer;
2239:
2240: /*------------------------------------+
2241: | Standard start of API savepoint |
2242: +------------------------------------*/
2510: END IF;
2511:
2512: select TO_CHAR( (hsecs - G_START_TIME) / 100)
2513: into l_hsec
2514: from v$timer;
2515:
2516: IF PG_DEBUG in ('Y', 'C') THEN
2517: arp_util.debug('Approve_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds', G_MSG_LOW);
2518: END IF;