APPS.JAI_ENCUM_PRC dependencies on JAI_ENCUM_TAX_DETAILS

Line 42: FROM jai_encum_tax_details

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

Line 88: FROM jai_encum_tax_details

84:
85: CURSOR cur_il_encumbrance(cp_document_type VARCHAR2, cp_distribution_id NUMBER )
86: IS
87: SELECT *
88: FROM jai_encum_tax_details
89: WHERE document_type = cp_document_type
90: AND distribution_id = cp_distribution_id;
91:
92: il_encumbrance_rec cur_il_encumbrance%ROWTYPE;

Line 541: UPDATE jai_encum_tax_details

537: IF lv_encum_exists = 'Encumbrance Exists' THEN
538:
539: /*If record exists then update it with the tax amount and status*/
540:
541: UPDATE jai_encum_tax_details
542: SET nr_tax_amount = ln_doc_curr_tax_amt,
543: func_nr_tax_amount = p_nr_tax_tbl(i),
544: status = DECODE(p_action,PO_CONSTANTS_SV.RESERVE,'RESERVED',
545: PO_CONSTANTS_SV.CANCEL ,'CANCELLED',

Line 558: jai_encum_tax_details( DOCUMENT_TYPE ,

554:
555: /*If the record does not exist create a new record*/
556:
557: INSERT INTO
558: jai_encum_tax_details( DOCUMENT_TYPE ,
559: DOC_HEADER_ID ,
560: DOC_LINE_ID ,
561: LINE_LOCATION_ID ,
562: DISTRIBUTION_ID ,

Line 644: FROM jai_encum_tax_details

640: /*Cursor fetches the non-recoverable tax amount of PO stored in IL encumbrance table*/
641: CURSOR cur_po_nr_tax_amt
642: IS
643: SELECT nr_tax_amount
644: FROM jai_encum_tax_details
645: WHERE document_type = p_source_doc_type
646: AND distribution_id = p_source_doc_id;
647:
648: /*Cursor fetches the non-recoverable tax amount of REQUISITION stored in IL encumbrance table*/

Line 652: FROM jai_encum_tax_details

648: /*Cursor fetches the non-recoverable tax amount of REQUISITION stored in IL encumbrance table*/
649: CURSOR cur_req_nr_tax_amt
650: IS
651: SELECT nvl(sum(nr_tax_amount),0)
652: FROM jai_encum_tax_details
653: WHERE document_type = p_source_doc_type
654: AND doc_line_id = p_source_doc_id;
655:
656: