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.PA_FAXFACE dependencies on FA_MASS_ADDITIONS

Line 2876: PROCEDURE create_fa_mass_additions

2872: END update_asset_lines;
2873:
2874: -- Procedure to create mass addition lines
2875:
2876: PROCEDURE create_fa_mass_additions
2877: (x_accounting_date IN DATE,
2878: x_add_to_asset_id IN NUMBER,
2879: x_amortize_flag IN VARCHAR2,
2880: x_asset_category_id IN NUMBER,

Line 2950: -- else insert 'YES' inot inventorial column of fa_mass_additions

2946:
2947: BEGIN
2948: -- Inventorial Flag is taken from FA_CATEGOIRES
2949: -- if the asset line is associated with asset category
2950: -- else insert 'YES' inot inventorial column of fa_mass_additions
2951:
2952: SELECT inventorial
2953: INTO x_inventorial_flag
2954: FROM fa_categories

Line 2965: fa_mass_additions_s.nextval

2961:
2962: -- Get the mass_additions_id
2963:
2964: SELECT
2965: fa_mass_additions_s.nextval
2966: INTO
2967: x_mass_addition_id
2968: FROM
2969: SYS.DUAL;

Line 3002: pa_debug.debug('create_fa_mass_additions: ' || 'Current Deprn. Period not found for book = '||x_book_type_code);

2998: and fdp.period_close_date is null;
2999: EXCEPTION
3000: WHEN NO_DATA_FOUND THEN
3001: IF G_debug_mode = 'Y' THEN
3002: pa_debug.debug('create_fa_mass_additions: ' || 'Current Deprn. Period not found for book = '||x_book_type_code);
3003: END IF;
3004: l_amortization_start_date:= NULL;
3005: END;
3006: END IF;

Line 3013: The strategy is to insert the records into fa_mass_additions irrespective

3009:
3010: -- Added by tiwang for CRL Projects
3011: /* Bug 3224283. Restructured the code because of the data corruption that
3012: might occur if the profile option is incorrectly set.
3013: The strategy is to insert the records into fa_mass_additions irrespective
3014: of whether the profile option PA: Licensed to Use CRL Projects is set or not.
3015: And if it is set, update the CRL specific columns in IPAFAXB.pls
3016: Refer 3224283 and 3224294 */
3017: /* Commented the following code for the above reason and added it after the

Line 3018: insert into fa_mass_additions statement

3014: of whether the profile option PA: Licensed to Use CRL Projects is set or not.
3015: And if it is set, update the CRL specific columns in IPAFAXB.pls
3016: Refer 3224283 and 3224294 */
3017: /* Commented the following code for the above reason and added it after the
3018: insert into fa_mass_additions statement
3019: if (PA_INSTALL.is_product_installed('IPA')) then --CRL Installed
3020: PA_CRL_FAXFACE.create_crl_fa_mass_additions
3021: (x_accounting_date ,
3022: x_add_to_asset_id ,

Line 3020: PA_CRL_FAXFACE.create_crl_fa_mass_additions

3016: Refer 3224283 and 3224294 */
3017: /* Commented the following code for the above reason and added it after the
3018: insert into fa_mass_additions statement
3019: if (PA_INSTALL.is_product_installed('IPA')) then --CRL Installed
3020: PA_CRL_FAXFACE.create_crl_fa_mass_additions
3021: (x_accounting_date ,
3022: x_add_to_asset_id ,
3023: x_amortize_flag ,
3024: x_asset_category_id ,

Line 3073: INSERT INTO FA_MASS_ADDITIONS(

3069: x_err_code );
3070:
3071: else
3072: Commented code for bug#3224283 ends here */
3073: INSERT INTO FA_MASS_ADDITIONS(
3074: ACCOUNTING_DATE,
3075: ADD_TO_ASSET_ID,
3076: AMORTIZE_FLAG,
3077: AMORTIZATION_START_DATE, /* added for bug # 2540723 */

Line 3199: record into fa_mass_additions */

3195: x_tag_number
3196: FROM SYS.DUAL;
3197:
3198: /* Bug#3224283. Added Call to pa_crl_faxface after inserting the
3199: record into fa_mass_additions */
3200: if (PA_INSTALL.is_product_installed('IPA')) then --CRL Installed
3201: PA_CRL_FAXFACE.create_crl_fa_mass_additions
3202: (x_accounting_date ,
3203: x_add_to_asset_id ,

Line 3201: PA_CRL_FAXFACE.create_crl_fa_mass_additions

3197:
3198: /* Bug#3224283. Added Call to pa_crl_faxface after inserting the
3199: record into fa_mass_additions */
3200: if (PA_INSTALL.is_product_installed('IPA')) then --CRL Installed
3201: PA_CRL_FAXFACE.create_crl_fa_mass_additions
3202: (x_accounting_date ,
3203: x_add_to_asset_id ,
3204: /* x_amortize_flag , */
3205: x_amort_flag , /*bug 4349574 */

Line 3255: create_alc_fa_mass_additions (x_project_asset_line_id => x_project_asset_line_id,

3251: x_err_code );
3252: end if; /* If CRL Installed */
3253:
3254: IF l_mrc_flag = 'Y' THEN
3255: create_alc_fa_mass_additions (x_project_asset_line_id => x_project_asset_line_id,
3256: x_mass_addition_id => x_mass_addition_id,
3257: x_parent_mass_addition_id => x_parent_mass_addition_id,
3258: x_fixed_assets_cost => x_fixed_assets_cost);
3259: END IF;

Line 3265: END create_fa_mass_additions;

3261: EXCEPTION
3262: WHEN OTHERS THEN
3263: x_err_code := SQLCODE;
3264: RAISE;
3265: END create_fa_mass_additions;
3266:
3267: -- Procedure for transferring asset lines
3268: -- The paramater x_asset_type can have the following values:
3269: -- 'N' -- New asset being transferred for the first time

Line 3400: -- columns for FA_MASS_ADDITIONS

3396: fa_install_status VARCHAR2(1);
3397: fa_posted_count NUMBER;
3398: fa_date_placed_in_service DATE;
3399:
3400: -- columns for FA_MASS_ADDITIONS
3401:
3402: mass_addition_id NUMBER;
3403: parent_mass_addition_id NUMBER;
3404: posting_status fa_mass_additions.posting_status%TYPE;

Line 3404: posting_status fa_mass_additions.posting_status%TYPE;

3400: -- columns for FA_MASS_ADDITIONS
3401:
3402: mass_addition_id NUMBER;
3403: parent_mass_addition_id NUMBER;
3404: posting_status fa_mass_additions.posting_status%TYPE;
3405: queue_name fa_mass_additions.queue_name%TYPE;
3406: create_merged_line BOOLEAN;
3407: merge_code VARCHAR2(2);
3408: merged_cost pa_project_asset_lines.current_asset_cost%type;

Line 3405: queue_name fa_mass_additions.queue_name%TYPE;

3401:
3402: mass_addition_id NUMBER;
3403: parent_mass_addition_id NUMBER;
3404: posting_status fa_mass_additions.posting_status%TYPE;
3405: queue_name fa_mass_additions.queue_name%TYPE;
3406: create_merged_line BOOLEAN;
3407: merge_code VARCHAR2(2);
3408: merged_cost pa_project_asset_lines.current_asset_cost%type;
3409: req_flag varchar2(1);

Line 3615: create_fa_mass_additions

3611: merge_code := NULL;
3612: end if;
3613: ------endsaima
3614:
3615: create_fa_mass_additions
3616: (sysdate, --x_accounting_date,
3617: NULL, --x_add_to_asset_id,
3618: assetlinerec.amortize_flag,
3619: assetlinerec.asset_category_id,

Line 3683: create_fa_mass_additions

3679: --create_fa_mass_addition for new line
3680:
3681: IF(asset_okay_for_interface and create_merged_line = TRUE) THEN
3682:
3683: create_fa_mass_additions
3684: (sysdate, --x_accounting_date,
3685: NULL, --x_add_to_asset_id,
3686: assetlinerec.amortize_flag,
3687: assetlinerec.asset_category_id,

Line 3771: FROM fa_mass_additions

3767: SELECT '1'
3768: INTO fa_posted_count
3769: FROM DUAL
3770: WHERE EXISTS (SELECT mass_addition_id
3771: FROM fa_mass_additions
3772: WHERE asset_number = assetlinerec.asset_number AND
3773: posting_status = 'POSTED');
3774: asset_okay_for_interface := TRUE;
3775: EXCEPTION

Line 3878: create_fa_mass_additions

3874: curr_new_master_flag := 'NO';
3875: END IF;
3876:
3877: -- Send this project asset line to FA as an adjustment
3878: create_fa_mass_additions
3879: (sysdate, --x_accounting_date,
3880: curr_add_to_asset_id, --x_add_to_asset_id,
3881: assetlinerec.amortize_flag,
3882: assetlinerec.asset_category_id,

Line 6161: PROCEDURE create_alc_fa_mass_additions (x_project_asset_line_id IN NUMBER,

6157: end update_alc_proj_asset_lines;
6158:
6159: ----------------------------------------------------------------------------------------------------------
6160:
6161: PROCEDURE create_alc_fa_mass_additions (x_project_asset_line_id IN NUMBER,
6162: x_mass_addition_id IN NUMBER,
6163: x_parent_mass_addition_id IN NUMBER,
6164: x_fixed_assets_cost IN NUMBER)
6165: IS

Line 6230: end create_alc_fa_mass_additions;

6226: exception
6227: when others then
6228: RAISE;
6229:
6230: end create_alc_fa_mass_additions;
6231:
6232: ----------------------------------------------------------------------------------------------------------
6233:
6234: -- Added procedure for bug 5401326