APPS.GMF_PERIODCLOSE_PVT dependencies on GMF_PERIOD_BALANCES

Line 197: DELETE FROM gmf_period_balances

193: END IF;
194:
195: /* Bug#5652481 ANTHIYAG 09-Nov-2006 Start */
196: /* if there are already some prelim rows from some prior prelim close -- delete them*/
197: DELETE FROM gmf_period_balances
198: WHERE acct_period_id = p_closing_acct_period_id
199: AND organization_id = p_organization_id;
200: IF (SQL%NOTFOUND) THEN
201: NULL;

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

198: WHERE acct_period_id = p_closing_acct_period_id
199: AND organization_id = p_organization_id;
200: IF (SQL%NOTFOUND) THEN
201: NULL;
202: Log_Msg(C_LOG_FILE,' No rows found in gmf_period_balances to delete.');
203: ELSE
204: Log_Msg(C_LOG_FILE,' Deleted '||SQL%ROWCOUNT||' rows from gmf_period_balances.');
205: END IF;
206: /* Bug#5652481 ANTHIYAG 09-Nov-2006 End */

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

200: IF (SQL%NOTFOUND) THEN
201: NULL;
202: Log_Msg(C_LOG_FILE,' No rows found in gmf_period_balances to delete.');
203: ELSE
204: Log_Msg(C_LOG_FILE,' Deleted '||SQL%ROWCOUNT||' rows from gmf_period_balances.');
205: END IF;
206: /* Bug#5652481 ANTHIYAG 09-Nov-2006 End */
207:
208: Log_Msg(C_LOG_FILE,'Beginning Inventory Balance compilation for ');

Line 436: gmf_period_balances_gt pbt

432: pbt.lot_number,
433: SUM(pbt.primary_quantity) pri_qty,
434: SUM(NVL(pbt.secondary_quantity,0)) sec_qty
435: FROM
436: gmf_period_balances_gt pbt
437: WHERE
438: organization_id = p_organization_id /* Bug#5652481 ANTHIYAG 09-Nov-2006 */
439: AND acct_period_id = p_acct_period_id /* Bug#5652481 ANTHIYAG 09-Nov-2006 */
440: GROUP BY

Line 489: INSERT INTO gmf_period_balances_gt (

485: FETCH c_onhand INTO r_onhand;
486: EXIT WHEN c_onhand%NOTFOUND;
487:
488: /* insert into balances table */
489: INSERT INTO gmf_period_balances_gt (
490: source_type_id,
491: acct_period_id,
492: organization_id,
493: cost_group_id,

Line 536: INSERT INTO gmf_period_balances_gt (

532: LOOP
533: FETCH c_txns INTO r_txns;
534: EXIT WHEN c_txns%NOTFOUND;
535:
536: INSERT INTO gmf_period_balances_gt (
537: source_type_id,
538: acct_period_id,
539: organization_id,
540: cost_group_id,

Line 581: INSERT INTO gmf_period_balances (

577:
578: 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 */
579: LOOP
580:
581: INSERT INTO gmf_period_balances (
582: period_balance_id,
583: acct_period_id,
584: organization_id,
585: cost_group_id,

Line 610: gmf_period_balances_s.nextval,

606: period_close_status
607: )
608: VALUES
609: (
610: gmf_period_balances_s.nextval,
611: p_closing_acct_period_id,
612: p_organization_id,
613: r_bal_tmp.cost_group_id,
614: r_bal_tmp.subinventory_code,

Line 1140: DELETE FROM gmf_period_balances

1136:
1137: END IF;
1138:
1139: /* if there are already some prelim rows from some prior prelim close -- delete them*/
1140: DELETE FROM gmf_period_balances
1141: WHERE acct_period_id = l_acct_period_id
1142: AND organization_id = l_organization_id;
1143: IF (SQL%NOTFOUND) THEN
1144: NULL;

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

1141: WHERE acct_period_id = l_acct_period_id
1142: AND organization_id = l_organization_id;
1143: IF (SQL%NOTFOUND) THEN
1144: NULL;
1145: Log_Msg(C_LOG_FILE,' No rows found in gmf_period_balances to delete.');
1146: ELSE
1147: Log_Msg(C_LOG_FILE,' Deleted '||SQL%ROWCOUNT||' rows from gmf_period_balances.');
1148: END IF;
1149:

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

1143: IF (SQL%NOTFOUND) THEN
1144: NULL;
1145: Log_Msg(C_LOG_FILE,' No rows found in gmf_period_balances to delete.');
1146: ELSE
1147: Log_Msg(C_LOG_FILE,' Deleted '||SQL%ROWCOUNT||' rows from gmf_period_balances.');
1148: END IF;
1149:
1150: Log_Msg(C_LOG_FILE,' Beginning Inventory Balance compilation for Organization: ' || org_rec.organization_code || ' Period: ' ||l_period_name);
1151: