[Home] [Help]
78: and vendor_id <> p_po_vendor_id
79: )
80: );
81:
82: cursor c_ja_in_fa_mass_additions(p_parent_request_id number) is
83: select count(1)
84: from JAI_FA_MASS_ADDITIONS
85: where create_batch_id = p_parent_request_id
86: and process_flag <> 'Y';
80: );
81:
82: cursor c_ja_in_fa_mass_additions(p_parent_request_id number) is
83: select count(1)
84: from JAI_FA_MASS_ADDITIONS
85: where create_batch_id = p_parent_request_id
86: and process_flag <> 'Y';
87:
88:
98:
99: BEGIN
100: pv_return_code := jai_constants.successful ;
101: /*------------------------------------------------------------------------------
102: Filename: ja_in_fa_mass_additions_boe3p_trg.sql
103:
104: CHANGE HISTORY:
105:
106: S.No dd/mm/yyyy Author and Details
117: become one or more 3rd party invoices where as BOE is
118: matched against the BOE invoice already raised.
119:
120: This trigger is populating data into the localization
121: fa mass additions table for invoices being processed
122: by base. Data in this table is further processed by
123: localization concurrent 'India Local Mass Additions'
124: to populate data on to the fa mass additions table
125: with references to PO/ Receipt and payable invoice.
120: This trigger is populating data into the localization
121: fa mass additions table for invoices being processed
122: by base. Data in this table is further processed by
123: localization concurrent 'India Local Mass Additions'
124: to populate data on to the fa mass additions table
125: with references to PO/ Receipt and payable invoice.
126:
127: 2. 29/11/2004 ssumaith - bug# 4037690 - File version 115.1
128: Check whether india localization is being used was done using a INR check in every trigger.
141: Removal of SQL LITERALs is done
142:
143: 6. 24-Jun-2005 rchandan for bug#4454657,File Version: 116.3
144: Modified the object as a part of AP LINES Impact Uptake
145: A column invoice_line_number ie added to jai_fa_mass_additions.
146: The ap_invoice_lines_all is used instead of ap_invoice_distributions_all while querying wherever applicable.
147:
148: Future Dependencies For the release Of this Object:-
149: (Please add a row in the section below only if your bug introduces a dependency due to spec change/ A new call to a object/
151: -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
152: Current Version Current Bug Dependent Files Version Author Date Remarks
153: Of File On Bug/Patchset Dependent On
154:
155: ja_in_fa_mass_additions_boe3p_trg.sql
156: ------------------------------------------------------------------------------------------------------------------------------------------------------------------------
157: 115.1 4037690 IN60105D2 ja_in_util_pkg_s.sql 115.0 ssumaith 29-Nov-2004 Call to this function.
158: ja_in_util_pkg_s.sql 115.0 ssumaith
159:
212: /* BOE or third party type of taxes do not exist for the item line */
213: return;
214: end if;
215:
216: insert into JAI_FA_MASS_ADDITIONS
217: (
218: mass_addition_id,
219: invoice_id,
220: distribution_line_number,
263: pr_new.last_updated_by,
264: pr_new.create_batch_id
265: );
266:
267: open c_ja_in_fa_mass_additions(pr_new.create_batch_id);
268: fetch c_ja_in_fa_mass_additions into ln_first_record;
269: close c_ja_in_fa_mass_additions;
270:
271: if nvl(ln_first_record, 0) > 1 then
264: pr_new.create_batch_id
265: );
266:
267: open c_ja_in_fa_mass_additions(pr_new.create_batch_id);
268: fetch c_ja_in_fa_mass_additions into ln_first_record;
269: close c_ja_in_fa_mass_additions;
270:
271: if nvl(ln_first_record, 0) > 1 then
272: /* Not the firstrecord to be inserted by the trigger for the batch
265: );
266:
267: open c_ja_in_fa_mass_additions(pr_new.create_batch_id);
268: fetch c_ja_in_fa_mass_additions into ln_first_record;
269: close c_ja_in_fa_mass_additions;
270:
271: if nvl(ln_first_record, 0) > 1 then
272: /* Not the firstrecord to be inserted by the trigger for the batch
273: No need to invoke the concurrent */
426: 1. 2002/06/07 RPK: For BUG#2391562
427:
428: 1.For updating the date format of the column attribute1 of the table
429: fa_mass_addtions_b for the assets added thru the ADI tool.The assets will
430: be interfaced from the legacy system to the fa_mass_additions table
431: thru ADI or any other data migration tool.The date format of the columns will
432: be maintained same as that of the valueset for the report
433: 'India Income fixed assets schedule' ie 'DD-MON-RRRR'.Now,the user will be
434: able to query the assets added through ADI.
434: able to query the assets added through ADI.
435:
436: 2. 30/03/2004 Aparajita for bug#3448803. Version#619.1
437: Removed the when condition for checking the context = 'India B Of Assets' as this
438: context is not used at the time of inserting records into FA_MASS_ADDITIONS. The process
439: here is mass additions create and the dff is not used at that point.
440:
441: There was no need to put extra condtion as the cursor dist_tax_cur would return null for
442: non localization record and the control would return from here.
454: Ramananda for bug#4428980. Removal of SQL LITERALs is done
455:
456: 6. 24-Jun-2005 rchandan for bug#4454657,File Version: 116.3
457: Modified the object as a part of AP LINES Impact Uptake
458: A column invoice_line_number ie added to jai_fa_mass_additions.
459: The ap_invoice_lines_all is used instead of ap_invoice_distributions_all while querying wherever applicable.
460:
461:
462: Future Dependencies For the release Of this Object:-