APPS.JAI_BOE_MIGRATION_PKG dependencies on JAI_BOE_DETAIL_TAXES

Line 659: -- This procedure will insert a record into JAI_BOE_DETAIL_TAXES table.

655:
656: -- DESCRIPTION:
657: --
658:
659: -- This procedure will insert a record into JAI_BOE_DETAIL_TAXES table.
660:
661: -- PARAMETERS:
662:
663: -- In: p_boe_detail_tax_rec The BOE Detail Tax that need to be inserted.

Line 675: PROCEDURE insert_boe_detail_tax(p_boe_detail_tax_rec IN JAI_BOE_DETAIL_TAXES%ROWTYPE) IS

671:
672: --
673:
674: --=========================================================================
675: PROCEDURE insert_boe_detail_tax(p_boe_detail_tax_rec IN JAI_BOE_DETAIL_TAXES%ROWTYPE) IS
676: BEGIN
677: Fnd_File.put_line(Fnd_File.LOG,'**Start insert_boe_detail_tax for BOE_DETAIL_TAX_ID:'||p_boe_detail_tax_rec.BOE_DETAIL_TAX_ID || '--- **');
678: INSERT INTO JAI_BOE_DETAIL_TAXES
679: (BOE_DETAIL_TAX_ID,

Line 678: INSERT INTO JAI_BOE_DETAIL_TAXES

674: --=========================================================================
675: PROCEDURE insert_boe_detail_tax(p_boe_detail_tax_rec IN JAI_BOE_DETAIL_TAXES%ROWTYPE) IS
676: BEGIN
677: Fnd_File.put_line(Fnd_File.LOG,'**Start insert_boe_detail_tax for BOE_DETAIL_TAX_ID:'||p_boe_detail_tax_rec.BOE_DETAIL_TAX_ID || '--- **');
678: INSERT INTO JAI_BOE_DETAIL_TAXES
679: (BOE_DETAIL_TAX_ID,
680: BOE_DETAIL_ID,
681: TAX_LINE_NO,
682: TAX_ID,

Line 748: jai_boe_detail_taxes jbt

744: SELECT
745: jbt.tax_id,
746: SUM(jbt.tax_amount) tax_amount
747: FROM jai_boe_details jbd,
748: jai_boe_detail_taxes jbt
749: WHERE jbd.boe_detail_id = jbt.boe_detail_id
750: AND jbd.boe_id = pn_boe_id
751: AND jbt.boe_flag = 'Y'
752: GROUP BY jbt.tax_id;

Line 923: l_boe_tax_type_rec JAI_BOE_DETAIL_TAXES%ROWTYPE;

919: ) IS
920:
921: ln_tax_id NUMBER;
922: ln_boe_tax_id NUMBER;
923: l_boe_tax_type_rec JAI_BOE_DETAIL_TAXES%ROWTYPE;
924:
925: BEGIN
926: Fnd_File.put_line(Fnd_File.LOG,' **Start insert_tax_wise_data for boe_detail_id:' ||pn_boe_detail_id || '--- **');
927: get_tax_id(pn_tax_category_id => pn_tax_category_id

Line 932: SELECT jai_boe_detail_taxes_s.NEXTVAL INTO ln_boe_tax_id FROM dual;

928: ,pv_tax_type => pv_tax_type
929: --OUT--
930: ,xn_tax_id => ln_tax_id);
931:
932: SELECT jai_boe_detail_taxes_s.NEXTVAL INTO ln_boe_tax_id FROM dual;
933:
934: l_boe_tax_type_rec.BOE_DETAIL_TAX_ID := ln_boe_tax_id;
935: l_boe_tax_type_rec.TAX_ID := ln_tax_id;
936: l_boe_tax_type_rec.BOE_DETAIL_ID := pn_boe_detail_id;

Line 1440: jai_boe_detail_taxes jbt

1436: SUM(jbt.tax_amount) tax_amt,
1437: SUM(jbt.applied_amount) applied_amt,
1438: (SUM(jbt.tax_amount) - SUM(jbt.applied_amount)) available_amt
1439: FROM jai_boe_details jbd,
1440: jai_boe_detail_taxes jbt
1441: WHERE jbd.boe_id = v_boe_id
1442: AND jbd.boe_detail_id = jbt.boe_detail_id
1443: GROUP BY jbt.tax_type;
1444: