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.GMF_PERIODCLOSE_PVT dependencies on GMF_PERIOD_BALANCES

Line 182: DELETE FROM gmf_period_balances

178: END IF;
179:
180: /* Bug#5652481 ANTHIYAG 09-Nov-2006 Start */
181: /* if there are already some prelim rows from some prior prelim close -- delete them*/
182: DELETE FROM gmf_period_balances
183: WHERE acct_period_id = p_closing_acct_period_id
184: AND organization_id = p_organization_id;
185: IF (SQL%NOTFOUND) THEN
186: NULL;

Line 187: Log_Msg(C_LOG_FILE,' No rows found in gmf_period_balances to delete.');

183: WHERE acct_period_id = p_closing_acct_period_id
184: AND organization_id = p_organization_id;
185: IF (SQL%NOTFOUND) THEN
186: NULL;
187: Log_Msg(C_LOG_FILE,' No rows found in gmf_period_balances to delete.');
188: ELSE
189: Log_Msg(C_LOG_FILE,' Deleted '||SQL%ROWCOUNT||' rows from gmf_period_balances.');
190: END IF;
191: /* Bug#5652481 ANTHIYAG 09-Nov-2006 End */

Line 189: Log_Msg(C_LOG_FILE,' Deleted '||SQL%ROWCOUNT||' rows from gmf_period_balances.');

185: IF (SQL%NOTFOUND) THEN
186: NULL;
187: Log_Msg(C_LOG_FILE,' No rows found in gmf_period_balances to delete.');
188: ELSE
189: Log_Msg(C_LOG_FILE,' Deleted '||SQL%ROWCOUNT||' rows from gmf_period_balances.');
190: END IF;
191: /* Bug#5652481 ANTHIYAG 09-Nov-2006 End */
192:
193: Log_Msg(C_LOG_FILE,'Beginning Inventory Balance compilation for ');

Line 407: gmf_period_balances_gt pbt

403: pbt.lot_number,
404: SUM(pbt.primary_quantity) pri_qty,
405: SUM(NVL(pbt.secondary_quantity,0)) sec_qty
406: FROM
407: gmf_period_balances_gt pbt
408: WHERE
409: organization_id = p_organization_id /* Bug#5652481 ANTHIYAG 09-Nov-2006 */
410: AND acct_period_id = p_acct_period_id /* Bug#5652481 ANTHIYAG 09-Nov-2006 */
411: GROUP BY

Line 460: INSERT INTO gmf_period_balances_gt (

456: FETCH c_onhand INTO r_onhand;
457: EXIT WHEN c_onhand%NOTFOUND;
458:
459: /* insert into balances table */
460: INSERT INTO gmf_period_balances_gt (
461: source_type_id,
462: acct_period_id,
463: organization_id,
464: cost_group_id,

Line 507: INSERT INTO gmf_period_balances_gt (

503: LOOP
504: FETCH c_txns INTO r_txns;
505: EXIT WHEN c_txns%NOTFOUND;
506:
507: INSERT INTO gmf_period_balances_gt (
508: source_type_id,
509: acct_period_id,
510: organization_id,
511: cost_group_id,

Line 552: INSERT INTO gmf_period_balances (

548:
549: FOR r_bal_tmp IN c_bal_tmp (p_organization_id => p_organization_id, p_acct_period_id => p_closing_acct_period_id) /* Bug#5652481 ANTHIYAG 09-Nov-2006 */
550: LOOP
551:
552: INSERT INTO gmf_period_balances (
553: period_balance_id,
554: acct_period_id,
555: organization_id,
556: cost_group_id,

Line 581: gmf_period_balances_s.nextval,

577: period_close_status
578: )
579: VALUES
580: (
581: gmf_period_balances_s.nextval,
582: p_closing_acct_period_id,
583: p_organization_id,
584: r_bal_tmp.cost_group_id,
585: r_bal_tmp.subinventory_code,

Line 1071: DELETE FROM gmf_period_balances

1067: END IF;
1068: END IF;
1069:
1070: /* if there are already some prelim rows from some prior prelim close -- delete them*/
1071: DELETE FROM gmf_period_balances
1072: WHERE acct_period_id = l_acct_period_id
1073: AND organization_id = l_organization_id;
1074: IF (SQL%NOTFOUND) THEN
1075: NULL;

Line 1076: Log_Msg(C_LOG_FILE,' No rows found in gmf_period_balances to delete.');

1072: WHERE acct_period_id = l_acct_period_id
1073: AND organization_id = l_organization_id;
1074: IF (SQL%NOTFOUND) THEN
1075: NULL;
1076: Log_Msg(C_LOG_FILE,' No rows found in gmf_period_balances to delete.');
1077: ELSE
1078: Log_Msg(C_LOG_FILE,' Deleted '||SQL%ROWCOUNT||' rows from gmf_period_balances.');
1079: END IF;
1080:

Line 1078: Log_Msg(C_LOG_FILE,' Deleted '||SQL%ROWCOUNT||' rows from gmf_period_balances.');

1074: IF (SQL%NOTFOUND) THEN
1075: NULL;
1076: Log_Msg(C_LOG_FILE,' No rows found in gmf_period_balances to delete.');
1077: ELSE
1078: Log_Msg(C_LOG_FILE,' Deleted '||SQL%ROWCOUNT||' rows from gmf_period_balances.');
1079: END IF;
1080:
1081: Log_Msg(C_LOG_FILE,' Beginning Inventory Balance compilation for Organization: ' || org_rec.organization_code || ' Period: ' ||l_period_name);
1082: