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 3209: PROCEDURE create_fa_mass_additions

3205: END update_asset_lines;
3206:
3207: -- Procedure to create mass addition lines
3208:
3209: PROCEDURE create_fa_mass_additions
3210: (x_accounting_date IN DATE,
3211: x_add_to_asset_id IN NUMBER,
3212: x_amortize_flag IN VARCHAR2,
3213: x_asset_category_id IN NUMBER,

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

3283:
3284: BEGIN
3285: -- Inventorial Flag is taken from FA_CATEGOIRES
3286: -- if the asset line is associated with asset category
3287: -- else insert 'YES' inot inventorial column of fa_mass_additions
3288:
3289: SELECT inventorial
3290: INTO x_inventorial_flag
3291: FROM fa_categories

Line 3327: fa_mass_additions_s.nextval

3323:
3324: -- Get the mass_additions_id
3325:
3326: SELECT
3327: fa_mass_additions_s.nextval
3328: INTO
3329: x_mass_addition_id
3330: FROM
3331: SYS.DUAL;

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

3360: and fdp.period_close_date is null;
3361: EXCEPTION
3362: WHEN NO_DATA_FOUND THEN
3363: IF G_debug_mode = 'Y' THEN
3364: pa_debug.debug('create_fa_mass_additions: ' || 'Current Deprn. Period not found for book = '||x_book_type_code);
3365: END IF;
3366: l_amortization_start_date:= NULL;
3367: END;
3368: END IF;

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

3371:
3372: -- Added by tiwang for CRL Projects
3373: /* Bug 3224283. Restructured the code because of the data corruption that
3374: might occur if the profile option is incorrectly set.
3375: The strategy is to insert the records into fa_mass_additions irrespective
3376: of whether the profile option PA: Licensed to Use CRL Projects is set or not.
3377: And if it is set, update the CRL specific columns in IPAFAXB.pls
3378: Refer 3224283 and 3224294 */
3379: /* Commented the following code for the above reason and added it after the

Line 3380: insert into fa_mass_additions statement

3376: of whether the profile option PA: Licensed to Use CRL Projects is set or not.
3377: And if it is set, update the CRL specific columns in IPAFAXB.pls
3378: Refer 3224283 and 3224294 */
3379: /* Commented the following code for the above reason and added it after the
3380: insert into fa_mass_additions statement
3381: if (PA_INSTALL.is_product_installed('IPA')) then --CRL Installed
3382: PA_CRL_FAXFACE.create_crl_fa_mass_additions
3383: (x_accounting_date ,
3384: x_add_to_asset_id ,

Line 3382: PA_CRL_FAXFACE.create_crl_fa_mass_additions

3378: Refer 3224283 and 3224294 */
3379: /* Commented the following code for the above reason and added it after the
3380: insert into fa_mass_additions statement
3381: if (PA_INSTALL.is_product_installed('IPA')) then --CRL Installed
3382: PA_CRL_FAXFACE.create_crl_fa_mass_additions
3383: (x_accounting_date ,
3384: x_add_to_asset_id ,
3385: x_amortize_flag ,
3386: x_asset_category_id ,

Line 3435: INSERT INTO FA_MASS_ADDITIONS(

3431: x_err_code );
3432:
3433: else
3434: Commented code for bug#3224283 ends here */
3435: INSERT INTO FA_MASS_ADDITIONS(
3436: ACCOUNTING_DATE,
3437: ADD_TO_ASSET_ID,
3438: AMORTIZE_FLAG,
3439: AMORTIZATION_START_DATE, /* added for bug # 2540723 */

Line 3567: record into fa_mass_additions */

3563: x_tag_number
3564: FROM SYS.DUAL;
3565:
3566: /* Bug#3224283. Added Call to pa_crl_faxface after inserting the
3567: record into fa_mass_additions */
3568: if (PA_INSTALL.is_product_installed('IPA')) then --CRL Installed
3569: PA_CRL_FAXFACE.create_crl_fa_mass_additions
3570: (x_accounting_date ,
3571: x_add_to_asset_id ,

Line 3569: PA_CRL_FAXFACE.create_crl_fa_mass_additions

3565:
3566: /* Bug#3224283. Added Call to pa_crl_faxface after inserting the
3567: record into fa_mass_additions */
3568: if (PA_INSTALL.is_product_installed('IPA')) then --CRL Installed
3569: PA_CRL_FAXFACE.create_crl_fa_mass_additions
3570: (x_accounting_date ,
3571: x_add_to_asset_id ,
3572: /* x_amortize_flag , */
3573: x_amort_flag , /*bug 4349574 */

Line 3623: create_alc_fa_mass_additions (x_project_asset_line_id => x_project_asset_line_id,

3619: x_err_code );
3620: end if; /* If CRL Installed */
3621:
3622: IF l_mrc_flag = 'Y' THEN
3623: create_alc_fa_mass_additions (x_project_asset_line_id => x_project_asset_line_id,
3624: x_mass_addition_id => x_mass_addition_id,
3625: x_parent_mass_addition_id => x_parent_mass_addition_id,
3626: x_fixed_assets_cost => x_fixed_assets_cost);
3627: END IF;

Line 3633: END create_fa_mass_additions;

3629: EXCEPTION
3630: WHEN OTHERS THEN
3631: x_err_code := SQLCODE;
3632: RAISE;
3633: END create_fa_mass_additions;
3634:
3635: -- Procedure for transferring asset lines
3636: -- The paramater x_asset_type can have the following values:
3637: -- 'N' -- New asset being transferred for the first time

Line 3768: -- columns for FA_MASS_ADDITIONS

3764: fa_install_status VARCHAR2(1);
3765: fa_posted_count NUMBER;
3766: fa_date_placed_in_service DATE;
3767:
3768: -- columns for FA_MASS_ADDITIONS
3769:
3770: mass_addition_id NUMBER;
3771: parent_mass_addition_id NUMBER;
3772: posting_status fa_mass_additions.posting_status%TYPE;

Line 3772: posting_status fa_mass_additions.posting_status%TYPE;

3768: -- columns for FA_MASS_ADDITIONS
3769:
3770: mass_addition_id NUMBER;
3771: parent_mass_addition_id NUMBER;
3772: posting_status fa_mass_additions.posting_status%TYPE;
3773: queue_name fa_mass_additions.queue_name%TYPE;
3774: create_merged_line BOOLEAN;
3775: merge_code VARCHAR2(2);
3776: merged_cost pa_project_asset_lines.current_asset_cost%type;

Line 3773: queue_name fa_mass_additions.queue_name%TYPE;

3769:
3770: mass_addition_id NUMBER;
3771: parent_mass_addition_id NUMBER;
3772: posting_status fa_mass_additions.posting_status%TYPE;
3773: queue_name fa_mass_additions.queue_name%TYPE;
3774: create_merged_line BOOLEAN;
3775: merge_code VARCHAR2(2);
3776: merged_cost pa_project_asset_lines.current_asset_cost%type;
3777: req_flag varchar2(1);

Line 3999: create_fa_mass_additions

3995: l_vendor_number := assetlinerec.vendor_number;
3996: l_po_vendor_id := assetlinerec.po_vendor_id;
3997: end if;
3998:
3999: create_fa_mass_additions
4000: (sysdate, --x_accounting_date,
4001: NULL, --x_add_to_asset_id,
4002: assetlinerec.amortize_flag,
4003: assetlinerec.asset_category_id,

Line 4067: create_fa_mass_additions

4063: --create_fa_mass_addition for new line
4064:
4065: IF(asset_okay_for_interface and create_merged_line = TRUE) THEN
4066:
4067: create_fa_mass_additions
4068: (sysdate, --x_accounting_date,
4069: NULL, --x_add_to_asset_id,
4070: assetlinerec.amortize_flag,
4071: assetlinerec.asset_category_id,

Line 4155: FROM fa_mass_additions

4151: SELECT '1'
4152: INTO fa_posted_count
4153: FROM DUAL
4154: WHERE EXISTS (SELECT mass_addition_id
4155: FROM fa_mass_additions
4156: WHERE asset_number = assetlinerec.asset_number AND
4157: posting_status = 'POSTED');
4158: asset_okay_for_interface := TRUE;
4159: EXCEPTION

Line 4262: create_fa_mass_additions

4258: curr_new_master_flag := 'NO';
4259: END IF;
4260:
4261: -- Send this project asset line to FA as an adjustment
4262: create_fa_mass_additions
4263: (sysdate, --x_accounting_date,
4264: curr_add_to_asset_id, --x_add_to_asset_id,
4265: assetlinerec.amortize_flag,
4266: assetlinerec.asset_category_id,

Line 6608: PROCEDURE create_alc_fa_mass_additions (x_project_asset_line_id IN NUMBER,

6604: end update_alc_proj_asset_lines;
6605:
6606: ----------------------------------------------------------------------------------------------------------
6607:
6608: PROCEDURE create_alc_fa_mass_additions (x_project_asset_line_id IN NUMBER,
6609: x_mass_addition_id IN NUMBER,
6610: x_parent_mass_addition_id IN NUMBER,
6611: x_fixed_assets_cost IN NUMBER)
6612: IS

Line 6677: end create_alc_fa_mass_additions;

6673: exception
6674: when others then
6675: RAISE;
6676:
6677: end create_alc_fa_mass_additions;
6678:
6679: ----------------------------------------------------------------------------------------------------------
6680:
6681: -- Added procedure for bug 5401326