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.IGI_IAC_PROJ_PKG dependencies on IGI_IAC_PROJECTIONS

Line 19: PROCEDURE Update_Status(x_projection_id igi_iac_projections.projection_id%TYPE,

15:
16: -- ===================================================================
17: -- PROCEDURE Update_Status:
18: -- ===================================================================
19: PROCEDURE Update_Status(x_projection_id igi_iac_projections.projection_id%TYPE,
20: x_status igi_iac_projections.status%TYPE
21: )
22: IS
23:

Line 20: x_status igi_iac_projections.status%TYPE

16: -- ===================================================================
17: -- PROCEDURE Update_Status:
18: -- ===================================================================
19: PROCEDURE Update_Status(x_projection_id igi_iac_projections.projection_id%TYPE,
20: x_status igi_iac_projections.status%TYPE
21: )
22: IS
23:
24:

Line 26: UPDATE igi_iac_projections

22: IS
23:
24:
25: BEGIN
26: UPDATE igi_iac_projections
27: SET status = x_status
28: WHERE projection_id = x_projection_id;
29:
30: END Update_Status;

Line 92: PROCEDURE submit_report_request(p_projection_id IN igi_iac_projections.projection_id%type,

88: -- ===================================================================
89: -- PROCEDURE Submit_Report_Request: Procedure to submit the
90: -- concurrent request for running the Projections report
91: -- ===================================================================
92: PROCEDURE submit_report_request(p_projection_id IN igi_iac_projections.projection_id%type,
93: p_book_type_code IN fa_books.book_type_code%type,
94: p_reval_period_num IN igi_iac_projections.revaluation_period%type,
95: p_concat_cat IN varchar2,
96: p_start_period_name IN varchar2,

Line 94: p_reval_period_num IN igi_iac_projections.revaluation_period%type,

90: -- concurrent request for running the Projections report
91: -- ===================================================================
92: PROCEDURE submit_report_request(p_projection_id IN igi_iac_projections.projection_id%type,
93: p_book_type_code IN fa_books.book_type_code%type,
94: p_reval_period_num IN igi_iac_projections.revaluation_period%type,
95: p_concat_cat IN varchar2,
96: p_start_period_name IN varchar2,
97: p_end_period_name IN varchar2,
98: p_rx_attribute_set IN fa_rx_attrsets_b.attribute_set%TYPE,

Line 556: p_projection_id IN igi_iac_projections.projection_id%TYPE,

552: -- This procedure has been rewritten for the Projections enhancement project
553: PROCEDURE Do_Proj_Calc(
554: errbuf OUT NOCOPY VARCHAR2,
555: retcode OUT NOCOPY VARCHAR2,
556: p_projection_id IN igi_iac_projections.projection_id%TYPE,
557: p_rx_attribute_set IN fa_rx_attrsets_b.attribute_set%TYPE,
558: p_rx_output_format IN fnd_lookups.lookup_code%TYPE
559: ) IS
560:

Line 571: FROM igi_iac_projections

567: end_period,
568: category_id,
569: revaluation_period,
570: status
571: FROM igi_iac_projections
572: WHERE projection_id = n_projection_id;
573:
574:
575: -- Get all the assets that should be considered for projection

Line 579: n_category_id igi_iac_projections.category_id%TYPE DEFAULT NULL,

575: -- Get all the assets that should be considered for projection
576: -- this query should include non depreciating assets as well
577: -- and excludes all fully retired assets for a category
578: CURSOR c_get_assets_one_cat(n_book_code fa_books.book_type_code%TYPE,
579: n_category_id igi_iac_projections.category_id%TYPE DEFAULT NULL,
580: n_period_counter fa_deprn_summary.period_counter%TYPE)
581: IS
582: SELECT DISTINCT fh.asset_id asset_id
583: FROM fa_books fb,

Line 901: l_book_type_code igi_iac_projections.book_type_code%TYPE;

897: l_assets_list asset_id_type;
898: l_asset_count NUMBER;
899: l_asset_id fa_books.asset_id%TYPE;
900:
901: l_book_type_code igi_iac_projections.book_type_code%TYPE;
902: l_start_period_counter igi_iac_projections.start_period_counter%TYPE;
903: l_reval_period_ctr igi_iac_projections.start_period_counter%TYPE;
904:
905: l_end_period_counter igi_iac_projections.end_period%TYPE;

Line 902: l_start_period_counter igi_iac_projections.start_period_counter%TYPE;

898: l_asset_count NUMBER;
899: l_asset_id fa_books.asset_id%TYPE;
900:
901: l_book_type_code igi_iac_projections.book_type_code%TYPE;
902: l_start_period_counter igi_iac_projections.start_period_counter%TYPE;
903: l_reval_period_ctr igi_iac_projections.start_period_counter%TYPE;
904:
905: l_end_period_counter igi_iac_projections.end_period%TYPE;
906: l_category_id igi_iac_projections.category_id%TYPE;

Line 903: l_reval_period_ctr igi_iac_projections.start_period_counter%TYPE;

899: l_asset_id fa_books.asset_id%TYPE;
900:
901: l_book_type_code igi_iac_projections.book_type_code%TYPE;
902: l_start_period_counter igi_iac_projections.start_period_counter%TYPE;
903: l_reval_period_ctr igi_iac_projections.start_period_counter%TYPE;
904:
905: l_end_period_counter igi_iac_projections.end_period%TYPE;
906: l_category_id igi_iac_projections.category_id%TYPE;
907: l_reval_period_num igi_iac_projections.revaluation_period%TYPE;

Line 905: l_end_period_counter igi_iac_projections.end_period%TYPE;

901: l_book_type_code igi_iac_projections.book_type_code%TYPE;
902: l_start_period_counter igi_iac_projections.start_period_counter%TYPE;
903: l_reval_period_ctr igi_iac_projections.start_period_counter%TYPE;
904:
905: l_end_period_counter igi_iac_projections.end_period%TYPE;
906: l_category_id igi_iac_projections.category_id%TYPE;
907: l_reval_period_num igi_iac_projections.revaluation_period%TYPE;
908: l_status igi_iac_projections.status%TYPE;
909:

Line 906: l_category_id igi_iac_projections.category_id%TYPE;

902: l_start_period_counter igi_iac_projections.start_period_counter%TYPE;
903: l_reval_period_ctr igi_iac_projections.start_period_counter%TYPE;
904:
905: l_end_period_counter igi_iac_projections.end_period%TYPE;
906: l_category_id igi_iac_projections.category_id%TYPE;
907: l_reval_period_num igi_iac_projections.revaluation_period%TYPE;
908: l_status igi_iac_projections.status%TYPE;
909:
910: l_sob_id fa_book_controls.set_of_books_id%TYPE;

Line 907: l_reval_period_num igi_iac_projections.revaluation_period%TYPE;

903: l_reval_period_ctr igi_iac_projections.start_period_counter%TYPE;
904:
905: l_end_period_counter igi_iac_projections.end_period%TYPE;
906: l_category_id igi_iac_projections.category_id%TYPE;
907: l_reval_period_num igi_iac_projections.revaluation_period%TYPE;
908: l_status igi_iac_projections.status%TYPE;
909:
910: l_sob_id fa_book_controls.set_of_books_id%TYPE;
911: l_get_asset_bal_rec c_get_asset_all%ROWTYPE;

Line 908: l_status igi_iac_projections.status%TYPE;

904:
905: l_end_period_counter igi_iac_projections.end_period%TYPE;
906: l_category_id igi_iac_projections.category_id%TYPE;
907: l_reval_period_num igi_iac_projections.revaluation_period%TYPE;
908: l_status igi_iac_projections.status%TYPE;
909:
910: l_sob_id fa_book_controls.set_of_books_id%TYPE;
911: l_get_asset_bal_rec c_get_asset_all%ROWTYPE;
912: l_asset_dpis_date fa_books.date_placed_in_service%TYPE;

Line 914: l_next_period_ctr igi_iac_projections.start_period_counter%TYPE := 0;

910: l_sob_id fa_book_controls.set_of_books_id%TYPE;
911: l_get_asset_bal_rec c_get_asset_all%ROWTYPE;
912: l_asset_dpis_date fa_books.date_placed_in_service%TYPE;
913:
914: l_next_period_ctr igi_iac_projections.start_period_counter%TYPE := 0;
915: l_period_info_rec igi_iac_types.prd_rec;
916: l_dpis_info_rec igi_iac_types.prd_rec;
917: l_ret_flag BOOLEAN;
918: l_fully_rsvd fa_books.period_counter_fully_reserved%TYPE;

Line 1438: p_from_projection IN igi_iac_projections.projection_id%TYPE,

1434: END Do_Proj_Calc;
1435:
1436: -- 15-May-2003, add new procedure to delete projections for a range of projection ids
1437: PROCEDURE Delete_Projections(
1438: p_from_projection IN igi_iac_projections.projection_id%TYPE,
1439: p_to_projection IN igi_iac_projections.projection_id%TYPE
1440: ) IS
1441:
1442: BEGIN

Line 1439: p_to_projection IN igi_iac_projections.projection_id%TYPE

1435:
1436: -- 15-May-2003, add new procedure to delete projections for a range of projection ids
1437: PROCEDURE Delete_Projections(
1438: p_from_projection IN igi_iac_projections.projection_id%TYPE,
1439: p_to_projection IN igi_iac_projections.projection_id%TYPE
1440: ) IS
1441:
1442: BEGIN
1443:

Line 1447: DELETE FROM igi_iac_projections

1443:
1444: DELETE FROM igi_iac_proj_details
1445: WHERE projection_id BETWEEN p_from_projection AND p_to_projection;
1446:
1447: DELETE FROM igi_iac_projections
1448: WHERE projection_id BETWEEN p_from_projection AND p_to_projection;
1449:
1450: DELETE FROM igi_iac_proj_rep_itf
1451: WHERE projection_id BETWEEN p_from_projection AND p_to_projection;