APPS.JAI_ENCUM_PRC dependencies on JAI_ENCUM_TAX_DETAILS

Line 36: FROM jai_encum_tax_details

32: /*The cursor is used to see if a record already exists for the distribution in the IL table*/
33: CURSOR cur_encum_exists( cp_document_type VARCHAR2, cp_distribution_id NUMBER )
34: IS
35: SELECT 'Encumbrance Exists'
36: FROM jai_encum_tax_details
37: WHERE document_type = cp_document_type
38: AND distribution_id = cp_distribution_id;
39:
40: /*Cursor used to fetch the line_location_id using distribution_id*/

Line 82: FROM jai_encum_tax_details

78:
79: CURSOR cur_il_encumbrance(cp_document_type VARCHAR2, cp_distribution_id NUMBER )
80: IS
81: SELECT *
82: FROM jai_encum_tax_details
83: WHERE document_type = cp_document_type
84: AND distribution_id = cp_distribution_id;
85:
86: il_encumbrance_rec cur_il_encumbrance%ROWTYPE;

Line 451: UPDATE jai_encum_tax_details

447: IF lv_encum_exists = 'Encumbrance Exists' THEN
448:
449: /*If record exists then update it with the tax amount and status*/
450:
451: UPDATE jai_encum_tax_details
452: SET nr_tax_amount = ln_doc_curr_tax_amt,
453: func_nr_tax_amount = ln_func_curr_tax_amt, /*10421803 - Replaced p_nr_tax_tbl with ln_func_curr_tax_amt*/
454: status = DECODE(p_action,PO_CONSTANTS_SV.RESERVE,'RESERVED',
455: PO_CONSTANTS_SV.CANCEL ,'CANCELLED',

Line 468: jai_encum_tax_details( DOCUMENT_TYPE ,

464:
465: /*If the record does not exist create a new record*/
466:
467: INSERT INTO
468: jai_encum_tax_details( DOCUMENT_TYPE ,
469: DOC_HEADER_ID ,
470: DOC_LINE_ID ,
471: LINE_LOCATION_ID ,
472: DISTRIBUTION_ID ,

Line 552: FROM jai_encum_tax_details

548: /*Cursor fetches the non-recoverable tax amount of PO stored in IL encumbrance table*/
549: CURSOR cur_po_nr_tax_amt
550: IS
551: SELECT nr_tax_amount
552: FROM jai_encum_tax_details
553: WHERE document_type = p_source_doc_type
554: AND distribution_id = p_source_doc_id;
555:
556: /*Cursor fetches the non-recoverable tax amount of REQUISITION stored in IL encumbrance table*/

Line 560: FROM jai_encum_tax_details

556: /*Cursor fetches the non-recoverable tax amount of REQUISITION stored in IL encumbrance table*/
557: CURSOR cur_req_nr_tax_amt
558: IS
559: SELECT nvl(sum(nr_tax_amount),0)
560: FROM jai_encum_tax_details
561: WHERE document_type = p_source_doc_type
562: AND doc_line_id = p_source_doc_id;
563:
564: