APPS.PA_MASS_ADDITIONS_CREATE_PKG dependencies on FA_MASS_ADDITIONS_GT

Line 654: write_to_log(FND_LOG.LEVEL_STATEMENT, '10:PA Insert_mass', 'FA_MASS_ADDITIONS_GT Count:'||l_eiIDtab.count) ;

650: AND line_num = Flag_no_lineNumTab(i);
651: END IF ;
652:
653: IF l_eiIDtab.count > 0 THEN
654: write_to_log(FND_LOG.LEVEL_STATEMENT, '10:PA Insert_mass', 'FA_MASS_ADDITIONS_GT Count:'||l_eiIDtab.count) ;
655:
656: FORALL i in l_eiIDtab.FIRST..l_eiIDtab.LAST
657: INSERT INTO FA_MASS_ADDITIONS_GT(
658: mass_addition_id,

Line 657: INSERT INTO FA_MASS_ADDITIONS_GT(

653: IF l_eiIDtab.count > 0 THEN
654: write_to_log(FND_LOG.LEVEL_STATEMENT, '10:PA Insert_mass', 'FA_MASS_ADDITIONS_GT Count:'||l_eiIDtab.count) ;
655:
656: FORALL i in l_eiIDtab.FIRST..l_eiIDtab.LAST
657: INSERT INTO FA_MASS_ADDITIONS_GT(
658: mass_addition_id,
659: description,
660: asset_category_id,
661: manufacturer_name,

Line 818: -- as asset in FA_MASS_ADDITIONS_GT table

814: --
815: END Insert_Mass;
816:
817: -- Procedure will Insert Discount related to distributions that are tracked
818: -- as asset in FA_MASS_ADDITIONS_GT table
819: --
820: PROCEDURE Insert_Discounts(p_api_version IN number,
821: p_init_msg_list IN varchar2 default FND_API.G_FALSE,
822: p_commit IN varchar2 default FND_API.G_FALSE,

Line 1274: INSERT INTO FA_MASS_ADDITIONS_GT(

1270: IF l_eiIDtab.count > 0 THEN
1271: write_to_log(FND_LOG.LEVEL_STATEMENT, '40:INSERT_DISCOUNTS', 'eiIDTab.COUNT:'||l_eiIDTab.COUNT) ;
1272:
1273: FORALL i in l_eiIDtab.FIRST..l_eiIDtab.LAST
1274: INSERT INTO FA_MASS_ADDITIONS_GT(
1275: mass_addition_id,
1276: description,
1277: asset_category_id,
1278: manufacturer_name,

Line 1498: FROM fa_mass_additions_gt

1494: request_id = p_request_id
1495: where si_assets_addition_flag = ('T')
1496: AND (expenditure_item_id, line_num ) in
1497: (SELECT expenditure_item_id, line_num
1498: FROM fa_mass_additions_gt
1499: WHERE line_status = 'PROCESSED') ;
1500:
1501: IF (g_debug_mode = 'Y') THEN
1502: write_to_log(FND_LOG.LEVEL_STATEMENT,'50:UPDATE_MASS','UPDATE MASS Record processed:'||SQL%ROWCOUNT );

Line 1519: FROM fa_mass_additions_gt

1515: request_id = p_request_id
1516: where si_assets_addition_flag = ('T')
1517: AND (expenditure_item_id, line_num ) in
1518: (SELECT expenditure_item_id, line_num
1519: FROM fa_mass_additions_gt
1520: WHERE line_status = 'REJECTED') ;
1521:
1522: IF (g_debug_mode = 'Y') THEN
1523: write_to_log(FND_LOG.LEVEL_STATEMENT,'50:UPDATE_MASS', 'UPDATE MASS Record processed with N-status:'||SQL%ROWCOUNT);

Line 1878: INSERT INTO FA_MASS_ADDITIONS_GT(

1874: IF l_eiIDtab.count > 0 THEN
1875: write_to_log(FND_LOG.LEVEL_STATEMENT, '50:PA INSERT_RECEIPT',
1876: 'l_eiIDtab.count:'||l_eiIDtab.count) ;
1877: FORALL i in l_eiIDtab.FIRST..l_eiIDtab.LAST
1878: INSERT INTO FA_MASS_ADDITIONS_GT(
1879: mass_addition_id,
1880: description,
1881: asset_category_id,
1882: manufacturer_name,