APPS.JAI_ENCUM_PRC dependencies on PO_CONSTANTS_SV

Line 109: IF p_action <> PO_CONSTANTS_SV.RESERVE THEN

105: IF p_dist_type_tbl(i) IN ( 'STANDARD','PLANNED', 'SCHEDULED','BLANKET', 'AGREEMENT') THEN
106:
107: lv_doc_type := 'PO';
108:
109: IF p_action <> PO_CONSTANTS_SV.RESERVE THEN
110:
111: IF ln_line_location_id IS NULL THEN
112:
113: /*These values might be used to populate the IL table*/

Line 292: IF ((p_doc_type = PO_CONSTANTS_SV.PO)

288: ELSIF p_dist_type_tbl(i) IN ('REQUISITION') THEN
289:
290: lv_doc_type := 'REQ';
291:
292: IF ((p_doc_type = PO_CONSTANTS_SV.PO)
293: OR (p_action <> PO_CONSTANTS_SV.RESERVE AND p_doc_type = PO_CONSTANTS_SV.REQUISITION )) THEN
294:
295: ln_il_encum_used := 1;
296:

Line 293: OR (p_action <> PO_CONSTANTS_SV.RESERVE AND p_doc_type = PO_CONSTANTS_SV.REQUISITION )) THEN

289:
290: lv_doc_type := 'REQ';
291:
292: IF ((p_doc_type = PO_CONSTANTS_SV.PO)
293: OR (p_action <> PO_CONSTANTS_SV.RESERVE AND p_doc_type = PO_CONSTANTS_SV.REQUISITION )) THEN
294:
295: ln_il_encum_used := 1;
296:
297: IF ln_req_line_id IS NULL THEN /*If this is the first distribution in the requisition line*/

Line 479: IF p_action IN ( PO_CONSTANTS_SV.RESERVE, PO_CONSTANTS_SV.CANCEL, 'FINAL CLOSE' ) THEN

475: /*If the distribution_cnt is 1 and lv_last_record is TRUE then p_nr_tax_tbl(i) would be the one fetched from query only.*/
476: END IF;
477:
478: /*If the encumbrance action is any of the following then populate IL table*/
479: IF p_action IN ( PO_CONSTANTS_SV.RESERVE, PO_CONSTANTS_SV.CANCEL, 'FINAL CLOSE' ) THEN
480:
481: IF lv_doc_type = 'PO' THEN
482: /*fetch the document details*/
483: OPEN cur_po_hdr_dtls(ln_po_line_id);

Line 544: status = DECODE(p_action,PO_CONSTANTS_SV.RESERVE,'RESERVED',

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',
546: 'FINAL CLOSE' ,'CLOSED'),
547: last_update_date = sysdate,
548: last_updated_by = fnd_global.user_id,

Line 545: PO_CONSTANTS_SV.CANCEL ,'CANCELLED',

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',
546: 'FINAL CLOSE' ,'CLOSED'),
547: last_update_date = sysdate,
548: last_updated_by = fnd_global.user_id,
549: last_update_login = fnd_global.login_id

Line 582: DECODE(p_action,PO_CONSTANTS_SV.RESERVE,'RESERVED' ,

578: p_dist_id_tbl(i) ,
579: lv_doc_currency_code ,
580: ln_doc_curr_tax_amt ,
581: ln_func_curr_tax_amt ,
582: DECODE(p_action,PO_CONSTANTS_SV.RESERVE,'RESERVED' ,
583: PO_CONSTANTS_SV.CANCEL ,'CANCELLED',
584: 'FINAL CLOSE' ,'CLOSED') ,
585: sysdate ,
586: fnd_global.user_id ,

Line 583: PO_CONSTANTS_SV.CANCEL ,'CANCELLED',

579: lv_doc_currency_code ,
580: ln_doc_curr_tax_amt ,
581: ln_func_curr_tax_amt ,
582: DECODE(p_action,PO_CONSTANTS_SV.RESERVE,'RESERVED' ,
583: PO_CONSTANTS_SV.CANCEL ,'CANCELLED',
584: 'FINAL CLOSE' ,'CLOSED') ,
585: sysdate ,
586: fnd_global.user_id ,
587: sysdate ,