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

Line 170: FROM FA_MASS_ADDITIONS

166: nvl(FIXED_ASSETS_UNITS, 0),
167: Merged_Code,
168: merge_parent_mass_additions_id,
169: Mass_Addition_ID
170: FROM FA_MASS_ADDITIONS
171: WHERE Merge_Parent_MASS_ADDITIONs_ID = X_mass_addition_id
172: and Book_Type_Code = X_Book_Type_Code
173: and MERGED_CODE = 'MC'
174: For UPDATE ;

Line 177: CURSOR C2 is Select Fa_MAss_Additions_S.nextval From sys.dual;

173: and MERGED_CODE = 'MC'
174: For UPDATE ;
175:
176:
177: CURSOR C2 is Select Fa_MAss_Additions_S.nextval From sys.dual;
178:
179: FA_NO_MERGED_CHILDREN Exception;
180:
181: Begin

Line 190: From FA_MASS_ADDITIONS

186:
187: If (X_Merged_Code = 'MP') then
188: -- Get the total number of child records
189: Select count(*) into Total_Child_Records
190: From FA_MASS_ADDITIONS
191: Where Merge_Parent_MASS_ADDITIONS_ID = x_mass_addition_id
192: and MERGED_CODE = 'MC';
193:
194: if Total_Child_Records = 0 then

Line 206: FROM fa_mass_additions

202:
203: If (X_Merged_Code = 'MP') then
204:
205: SELECT sum_units into Y_Sum_Units
206: FROM fa_mass_additions
207: WHERE mass_addition_id = x_mass_addition_id;
208:
209: if (Y_Sum_Units = 'YES') then
210:

Line 212: FROM fa_mass_additions

208:
209: if (Y_Sum_Units = 'YES') then
210:
211: SELECT sum(fixed_assets_units) into Y_Merged_Child_FA_Units
212: FROM fa_mass_additions
213: WHERE merge_parent_mass_additions_id = x_mass_addition_id
214: AND merged_code = 'MC';
215:
216: else

Line 255: From FA_MAss_Additions ma

251: Total_Merged_Rev_Amort_B, Total_Merged_Reval_Reserve,
252: Total_Merged_Unrev_Cost, Total_Merged_Ytd_RDE,
253: Total_Merged_Deprn_Reserve, Total_Merged_YTD_Deprn,
254: Total_Merged_Beginning_NBV
255: From FA_MAss_Additions ma
256: where ma.merge_parent_mass_additions_id = x_mass_addition_id;
257:
258: Total_Asset_Cost_Fa := Total_Merged_Children_Cost_fa + X_Parent_Unit_Cost_Fa;
259: Total_Asset_Cost_Ap := Total_Merged_Children_cost_ap + X_Parent_Unit_Cost_Ap;

Line 604: UPDATE FA_MASS_ADDITIONS

600:
601:
602: -- Update the Parent Mass Addition
603:
604: UPDATE FA_MASS_ADDITIONS
605: SET
606: SPLIT_CODE = 'SP',
607: SPLIT_MERGED_CODE = NVL(MERGED_CODE, 'SP'),
608: POSTING_STATUS = 'SPLIT'

Line 614: UPDATE FA_MASS_ADDITIONS

610: MASS_ADDITION_ID = X_mass_addition_id;
611:
612: -- Check if it is a MErge-Split case
613: if (X_Merged_Code = 'MP') then
614: UPDATE FA_MASS_ADDITIONS
615: SET
616: SPLIT_CODE = 'SP',
617: SPLIT_MERGED_CODE = NVL(MERGED_CODE, 'SP'),
618: POSTING_STATUS = 'SPLIT'

Line 702: INSERT INTO FA_MASS_ADDITIONS

698:
699:
700: Begin
701:
702: INSERT INTO FA_MASS_ADDITIONS
703: (MASS_ADDITION_ID,
704: ASSET_NUMBER, TAG_NUMBER,
705: DESCRIPTION, ASSET_CATEGORY_ID,
706: MANUFACTURER_NAME, SERIAL_NUMBER,

Line 856: FA_MASS_ADDITIONS

852: ALLOWED_DEPRN_LIMIT,
853: salvage_type,
854: PERCENT_SALVAGe_VALUE
855: FROM
856: FA_MASS_ADDITIONS
857: WHERE MASS_ADDITION_ID = I_Mass_Additions_ID;
858:
859: select fixed_assets_units into h_total_units from fa_mass_additions
860: where mass_addition_id = I_Split_Parent_Mass_Add_Id;

Line 859: select fixed_assets_units into h_total_units from fa_mass_additions

855: FROM
856: FA_MASS_ADDITIONS
857: WHERE MASS_ADDITION_ID = I_Mass_Additions_ID;
858:
859: select fixed_assets_units into h_total_units from fa_mass_additions
860: where mass_addition_id = I_Split_Parent_Mass_Add_Id;
861:
862: select count(*) into h_num_dists from fa_massadd_distributions
863: where mass_addition_id = I_Split_Parent_Mass_Add_Id;

Line 867: into h_child_total_units from fa_mass_additions

863: where mass_addition_id = I_Split_Parent_Mass_Add_Id;
864:
865: if (I_Sum_Units = 'YES') then
866: select round((FIXED_ASSETS_UNITS-I_Merge_Child_fa_Units)/I_Total_fa_Units,2)
867: into h_child_total_units from fa_mass_additions
868: WHERE MASS_ADDITION_ID = I_Mass_Additions_ID;
869: else
870: select fixed_assets_units into h_child_total_units from fa_mass_additions
871: where mass_addition_id = I_New_MASS_ADDITION_ID;

Line 870: select fixed_assets_units into h_child_total_units from fa_mass_additions

866: select round((FIXED_ASSETS_UNITS-I_Merge_Child_fa_Units)/I_Total_fa_Units,2)
867: into h_child_total_units from fa_mass_additions
868: WHERE MASS_ADDITION_ID = I_Mass_Additions_ID;
869: else
870: select fixed_assets_units into h_child_total_units from fa_mass_additions
871: where mass_addition_id = I_New_MASS_ADDITION_ID;
872:
873: end if;
874:

Line 931: From Fa_Mass_Additions

927: --FND_Message.Set_Name('OFA', 'FA_MASSADD_POSTED_CHILD') ;
928: -- FND_Message.Error;
929: -- APP_EXCEPTION.Raise_Exception;
930: Select Count(*) Into Child_records_Num
931: From Fa_Mass_Additions
932: Where POSTING_STATUS = 'POSTED'
933: And Split_parent_MAss_Additions_ID = X_Mass_Addition_ID
934: And Split_Code = 'SC';
935:

Line 945: From Fa_Mass_Additions

941: -- adding to prevent unspitting in cases where children
942: -- have been posted but also purged
943:
944: Select Count(*) Into Child_records_Num
945: From Fa_Mass_Additions
946: Where Split_parent_MAss_Additions_ID = X_Mass_Addition_ID
947: And Split_Code = 'SC';
948:
949: Select nvl(fixed_assets_units, 0) into h_units -- new variable

Line 950: from fa_mass_additions

946: Where Split_parent_MAss_Additions_ID = X_Mass_Addition_ID
947: And Split_Code = 'SC';
948:
949: Select nvl(fixed_assets_units, 0) into h_units -- new variable
950: from fa_mass_additions
951: where mass_addition_id = X_Mass_Addition_ID;
952:
953: If Child_Records_Num <> h_units then
954: Raise FA_MASSADD_POSTED_CHILD;

Line 961: Delete from FA_MAss_Additions

957: -- Delete all the split Children which also happen to be Merged records.
958: -- The ones with Split_Code = 'SC' and Merged_Code = 'MC'
959:
960: If (X_MERGED_CODE = 'MP') then
961: Delete from FA_MAss_Additions
962: Where Merge_Parent_Mass_Additions_Id In (Select Mass_Addition_ID
963: from FA_MAss_Additions
964: Where Split_Parent_Mass_Additions_Id = X_Mass_Addition_Id);
965: if (SQL%Notfound) then

Line 963: from FA_MAss_Additions

959:
960: If (X_MERGED_CODE = 'MP') then
961: Delete from FA_MAss_Additions
962: Where Merge_Parent_Mass_Additions_Id In (Select Mass_Addition_ID
963: from FA_MAss_Additions
964: Where Split_Parent_Mass_Additions_Id = X_Mass_Addition_Id);
965: if (SQL%Notfound) then
966: Raise NO_DATA_FOUND;
967: end if;

Line 973: Delete from FA_MAss_Additions

969: End if;
970:
971: -- Delete all the records which are split parents
972:
973: Delete from FA_MAss_Additions
974: Where Split_Parent_Mass_Additions_Id = X_Mass_Addition_Id;
975:
976: if (SQL%Notfound) then
977: Raise NO_DATA_FOUND;

Line 983: Update FA_MAss_Additions

979:
980: -- Update the Split_code of the Parent record
981:
982:
983: Update FA_MAss_Additions
984: Set Split_Code = NULL,
985: Split_Merged_Code = NVL(MERGED_CODE, NULL),
986: POSTING_STATUS = decode (QUEUE_NAME, 'NEW', 'NEW',
987: 'POST', 'POST',

Line 994: Update FA_MAss_Additions

990: 'ADD TO ASSET', 'POST', 'ON HOLD')
991: Where Mass_addition_ID = X_Mass_Addition_ID;
992:
993: if (X_Merged_Code = 'MP') then
994: Update FA_MAss_Additions
995: Set Split_Code = NULL,
996: Split_Merged_Code = NVL(MERGED_CODE, NULL),
997: POSTING_STATUS = 'MERGED'
998: Where merge_parent_Mass_additions_ID = X_Mass_Addition_ID;