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.JAI_CREDIT_CHECK_PKG dependencies on OE_PRICE_ADJUSTMENTS

Line 554: delete from OE_PRICE_ADJUSTMENTS

550:
551: BEGIN
552: xv_return_code := jai_constants.successful ;
553: -- delete records
554: delete from OE_PRICE_ADJUSTMENTS
555: where HEADER_ID = pn_header_id
556: and line_id = pn_line_id
557: and LIST_LINE_TYPE_CODE = 'TAX';
558:

Line 559: fnd_file.put_line(FND_FILE.LOG,'Deleted records in oe_price_adjustments.'||'Header:'||pn_header_id||',line:'||pn_line_id);

555: where HEADER_ID = pn_header_id
556: and line_id = pn_line_id
557: and LIST_LINE_TYPE_CODE = 'TAX';
558:
559: fnd_file.put_line(FND_FILE.LOG,'Deleted records in oe_price_adjustments.'||'Header:'||pn_header_id||',line:'||pn_line_id);
560:
561: IF nvl(pv_line_type,'####') = 'ORDER' THEN
562: -- SO order process
563: ln_line_exclusive_tax_amt := 0;

Line 568: INSERT INTO OE_PRICE_ADJUSTMENTS

564:
565: FOR so_tax_rec IN get_so_tax_cur(pn_line_id)
566: LOOP
567: -- insert records
568: INSERT INTO OE_PRICE_ADJUSTMENTS
569: (PRICE_ADJUSTMENT_ID
570: ,CREATION_DATE
571: ,CREATED_BY
572: ,LAST_UPDATE_DATE

Line 585: (OE_PRICE_ADJUSTMENTS_S.NEXTVAL

581: ,OPERAND
582: ,ADJUSTED_AMOUNT
583: ,LOCK_CONTROL)
584: VALUES
585: (OE_PRICE_ADJUSTMENTS_S.NEXTVAL
586: ,SYSDATE
587: ,FND_GLOBAL.user_id
588: ,SYSDATE
589: ,fnd_global.user_id

Line 605: fnd_file.put_line(FND_FILE.LOG,'Inserted records of SO into oe_price_adjustments.'||'Header:'||pn_header_id||',line:'||pn_line_id||',tax amount:'||ln_line_exclusive_tax_amt);

601: -- accumulate amounts
602: ln_line_exclusive_tax_amt := ln_line_exclusive_tax_amt + NVL(so_tax_rec.TAX_AMOUNT,0);
603: END LOOP;
604:
605: fnd_file.put_line(FND_FILE.LOG,'Inserted records of SO into oe_price_adjustments.'||'Header:'||pn_header_id||',line:'||pn_line_id||',tax amount:'||ln_line_exclusive_tax_amt);
606:
607: ELSIF nvl(pv_line_type,'####') = 'RETURN' THEN
608: --The RMA order process
609: ln_line_exclusive_tax_amt := 0;

Line 614: INSERT INTO OE_PRICE_ADJUSTMENTS

610:
611: FOR so_tax_rec IN get_rma_tax_cur(pn_line_id)
612: LOOP
613: -- insert records
614: INSERT INTO OE_PRICE_ADJUSTMENTS
615: (PRICE_ADJUSTMENT_ID
616: ,CREATION_DATE
617: ,CREATED_BY
618: ,LAST_UPDATE_DATE

Line 631: (OE_PRICE_ADJUSTMENTS_S.NEXTVAL

627: ,OPERAND
628: ,ADJUSTED_AMOUNT
629: ,LOCK_CONTROL)
630: VALUES
631: (OE_PRICE_ADJUSTMENTS_S.NEXTVAL
632: ,SYSDATE
633: ,FND_GLOBAL.USER_ID
634: ,SYSDATE
635: ,FND_GLOBAL.USER_ID

Line 651: fnd_file.put_line(FND_FILE.LOG,'Inserted records of RMA into oe_price_adjustments.'||'Header:'||pn_header_id||',line:'||pn_line_id||',tax amount:'||ln_line_exclusive_tax_amt);

647: -- accumulate amounts
648: ln_line_exclusive_tax_amt := ln_line_exclusive_tax_amt + NVL(so_tax_rec.TAX_AMOUNT,0);
649: END LOOP;
650:
651: fnd_file.put_line(FND_FILE.LOG,'Inserted records of RMA into oe_price_adjustments.'||'Header:'||pn_header_id||',line:'||pn_line_id||',tax amount:'||ln_line_exclusive_tax_amt);
652:
653: END IF;
654:
655: --Update tax value with exclusive tax summary.