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.

[Home] [Help]

APPS.GMF_ALLOC_PROC dependencies on GL_ALOC_DTL

Line 56: * a)Modified procedure process_alloc_dtl() to merge records into gl_aloc_dtl

52: * initialize PL/SQL table x_segment.
53: * 26-JUL-2007 Himadri Chakroborty Bug #6133153
54: *changed the size of the variables l_fiscal_year and l_period_type to 15
55: * 09-Oct-2008 Pramod B.H. Bug 7458002
56: * a)Modified procedure process_alloc_dtl() to merge records into gl_aloc_dtl
57: * instead of deleting and inserting rows in gl_aloc_dtl.
58: * b)Modified procedure delete_allocations() to delete only obsoleted rows
59: * in gl_aloc_dtl.
60: ******************************************************************************/

Line 57: * instead of deleting and inserting rows in gl_aloc_dtl.

53: * 26-JUL-2007 Himadri Chakroborty Bug #6133153
54: *changed the size of the variables l_fiscal_year and l_period_type to 15
55: * 09-Oct-2008 Pramod B.H. Bug 7458002
56: * a)Modified procedure process_alloc_dtl() to merge records into gl_aloc_dtl
57: * instead of deleting and inserting rows in gl_aloc_dtl.
58: * b)Modified procedure delete_allocations() to delete only obsoleted rows
59: * in gl_aloc_dtl.
60: ******************************************************************************/
61: /* Package body global variables */

Line 59: * in gl_aloc_dtl.

55: * 09-Oct-2008 Pramod B.H. Bug 7458002
56: * a)Modified procedure process_alloc_dtl() to merge records into gl_aloc_dtl
57: * instead of deleting and inserting rows in gl_aloc_dtl.
58: * b)Modified procedure delete_allocations() to delete only obsoleted rows
59: * in gl_aloc_dtl.
60: ******************************************************************************/
61: /* Package body global variables */
62: g_calendar_code cm_cldr_hdr.calendar_code%type;
63: g_period_code cm_cldr_dtl.period_code%type;

Line 291: gl_aloc_dtl

287: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,c_module||l_local_module||'.begin','Deleting Allocations');
288: END IF;
289: /* Bug 7458002 - Commented
290: DELETE FROM
291: gl_aloc_dtl
292: WHERE
293: period_id = g_period_id AND
294: cost_type_id = g_cost_type_id
295: AND alloc_id IN (

Line 303: /* Bug 7458002 - To delete only obsoleted rows in gl_aloc_dtl */

299: AND alloc_code between nvl(v_from_alloc_code,alloc_code)
300: AND nvl(v_to_alloc_code,alloc_code)
301: ); */
302:
303: /* Bug 7458002 - To delete only obsoleted rows in gl_aloc_dtl */
304: DELETE FROM
305: gl_aloc_dtl
306: WHERE period_id = g_period_id
307: AND cost_type_id = g_cost_type_id

Line 305: gl_aloc_dtl

301: ); */
302:
303: /* Bug 7458002 - To delete only obsoleted rows in gl_aloc_dtl */
304: DELETE FROM
305: gl_aloc_dtl
306: WHERE period_id = g_period_id
307: AND cost_type_id = g_cost_type_id
308: AND (alloc_id,line_no) NOT IN (
309: SELECT b.alloc_id, b.line_no

Line 319: alloc_log_msg( C_LOG_FILE, TO_CHAR(SQL%ROWCOUNT) || ' Rows deleted from Allocations table gl_aloc_dtl' );

315: AND m.alloc_code BETWEEN nvl(v_from_alloc_code,m.alloc_code) and
316: nvl(v_to_alloc_code ,m.alloc_code)
317: );
318:
319: alloc_log_msg( C_LOG_FILE, TO_CHAR(SQL%ROWCOUNT) || ' Rows deleted from Allocations table gl_aloc_dtl' );
320:
321: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
322: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,c_module||l_local_module||'.end','Deleting Allocations');
323: END IF;

Line 327: alloc_log_msg(C_LOG_FILE, '0 Rows deleted from gl_aloc_dtl ');

323: END IF;
324:
325: EXCEPTION
326: WHEN NO_DATA_FOUND THEN
327: alloc_log_msg(C_LOG_FILE, '0 Rows deleted from gl_aloc_dtl ');
328: v_status := 0;
329: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
330: THEN
331: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,c_module||l_local_module,'0 Rows deleted from gl_aloc_dtl');

Line 331: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,c_module||l_local_module,'0 Rows deleted from gl_aloc_dtl');

327: alloc_log_msg(C_LOG_FILE, '0 Rows deleted from gl_aloc_dtl ');
328: v_status := 0;
329: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
330: THEN
331: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,c_module||l_local_module,'0 Rows deleted from gl_aloc_dtl');
332: END IF;
333:
334: WHEN OTHERS THEN
335: alloc_log_msg(C_LOG_FILE, to_char(SQLCODE) || ' ' || SQLERRM);

Line 1407: INSERT INTO gl_aloc_dtl

1403: alloc_log_msg(C_LOG_FILE, ' Line: '||to_char (cur_alocinp_tmp.line_no) || ', % = '||to_char(round(x_alloc_percent,4)) ||
1404: ', Allocated Expense = ' ||to_char(round(x_allocated_amount,4)));
1405:
1406: /* Bug 7458002 - Commented
1407: INSERT INTO gl_aloc_dtl
1408: (
1409: PERIOD_ID,
1410: COST_TYPE_ID,
1411: ALLOC_ID,

Line 1454: MERGE INTO gl_aloc_dtl gdtl

1450: P_program_id,
1451: SYSDATE
1452: ); */
1453: /* Bug 7458002 - replaced Insert with Merge */
1454: MERGE INTO gl_aloc_dtl gdtl
1455: USING ( SELECT g_period_id period_id,
1456: g_cost_type_id cost_type_id,
1457: cur_alocinp_tmp.alloc_id alloc_id,
1458: cur_alocinp_tmp.line_no line_no

Line 1532: /* Bug 7458002 - To delete obsoleted rows in gl_aloc_dtl (Start) */

1528: ;
1529: END IF;
1530: END LOOP;
1531:
1532: /* Bug 7458002 - To delete obsoleted rows in gl_aloc_dtl (Start) */
1533: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1534: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,g_calling_module||l_local_module||'.delete_allocations','deleting Allocations ...');
1535: END IF;
1536: delete_allocations(v_from_alloc_code, v_to_alloc_code, x_status);