APPS.JAI_BOE_MIGRATION_PKG dependencies on JAI_BOE_DETAILS

Line 403: l_boe_detail_type_rec JAI_BOE_DETAILS%ROWTYPE;

399: ln_boe_detail_line_num NUMBER := 1;
400: ln_boe_detail_id NUMBER;
401: consolidate_boe_detail_rec consolidate_boe_detail_cur%ROWTYPE;
402: detail_line_rec detail_line_cur%ROWTYPE;
403: l_boe_detail_type_rec JAI_BOE_DETAILS%ROWTYPE;
404: dedicate_dtls_rec dedicate_dtls_summary_type;
405: BEGIN
406: Fnd_File.put_line(Fnd_File.LOG,'**Start merge_consolidate_boe_details for boe_id:'||pn_boe_id || ' with applied percentage:'||pn_percentage || '--- **');
407:

Line 415: SELECT jai_boe_details_s.NEXTVAL INTO ln_boe_detail_id FROM dual;

411:
412: OPEN detail_line_cur(pn_boe_id);
413: FETCH detail_line_cur INTO detail_line_rec;
414: CLOSE detail_line_cur;
415: SELECT jai_boe_details_s.NEXTVAL INTO ln_boe_detail_id FROM dual;
416:
417: l_boe_detail_type_rec.boe_detail_id := ln_boe_detail_id;
418: l_boe_detail_type_rec.boe_id := pn_boe_id;
419: l_boe_detail_type_rec.detail_line_num := ln_boe_detail_line_num;

Line 522: l_boe_detail_type_rec JAI_BOE_DETAILS%ROWTYPE;

518: ln_boe_detail_line_num NUMBER := 0;
519: ln_boe_detail_id NUMBER;
520: detail_line_rec detail_line_cur%ROWTYPE;
521: item_boe_detail_rec item_boe_detail_cur%ROWTYPE;
522: l_boe_detail_type_rec JAI_BOE_DETAILS%ROWTYPE;
523: dedicate_dtls_rec dedicate_dtls_summary_type;
524: BEGIN
525: Fnd_File.put_line(Fnd_File.LOG,' **Start merge_item_boe_details for boe_id:' ||pn_boe_id || ' with applied percentage:' ||pn_percentage || '--- **');
526:

Line 533: SELECT jai_boe_details_s.NEXTVAL INTO ln_boe_detail_id FROM dual;

529: OPEN detail_line_cur(pn_boe_id,item_boe_detail_rec.item_number);
530: FETCH detail_line_cur INTO detail_line_rec;
531: CLOSE detail_line_cur;
532:
533: SELECT jai_boe_details_s.NEXTVAL INTO ln_boe_detail_id FROM dual;
534: ln_boe_detail_line_num := ln_boe_detail_line_num + 1;
535:
536: l_boe_detail_type_rec.boe_detail_id := ln_boe_detail_id;
537: l_boe_detail_type_rec.boe_id := pn_boe_id;

Line 586: -- This procedure will insert a record into jai_boe_details table.

582:
583: -- DESCRIPTION:
584: --
585:
586: -- This procedure will insert a record into jai_boe_details table.
587:
588: -- PARAMETERS:
589:
590: -- In: p_boe_detail_rec The BOE Detail line that need to be inserted.

Line 602: PROCEDURE insert_boe_detail(p_boe_detail_rec IN JAI_BOE_DETAILS%ROWTYPE) IS

598:
599: --
600:
601: --=========================================================================
602: PROCEDURE insert_boe_detail(p_boe_detail_rec IN JAI_BOE_DETAILS%ROWTYPE) IS
603: BEGIN
604: Fnd_File.put_line(Fnd_File.LOG,' **Start insert_boe_detail for boe_detail_id:' ||p_boe_detail_rec.BOE_DETAIL_ID || '--- **');
605:
606: INSERT INTO JAI_BOE_DETAILS

Line 606: INSERT INTO JAI_BOE_DETAILS

602: PROCEDURE insert_boe_detail(p_boe_detail_rec IN JAI_BOE_DETAILS%ROWTYPE) IS
603: BEGIN
604: Fnd_File.put_line(Fnd_File.LOG,' **Start insert_boe_detail for boe_detail_id:' ||p_boe_detail_rec.BOE_DETAIL_ID || '--- **');
605:
606: INSERT INTO JAI_BOE_DETAILS
607: (BOE_DETAIL_ID,
608: DETAIL_LINE_NUM,
609: BOE_ID, QUANTITY,
610: UOM_CODE,

Line 747: FROM jai_boe_details jbd,

743: CURSOR boe_dtl_tax_cur(pn_boe_id NUMBER) IS
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'

Line 1439: FROM jai_boe_details jbd,

1435: SELECT jbt.tax_type,
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;