APPS.JAI_ENCUM_PRC dependencies on PO_CONSTANTS_SV

Line 103: IF p_action <> PO_CONSTANTS_SV.RESERVE THEN

99: IF p_dist_type_tbl(i) IN ( 'STANDARD','PLANNED', 'SCHEDULED','BLANKET', 'AGREEMENT') THEN
100:
101: lv_doc_type := 'PO';
102:
103: IF p_action <> PO_CONSTANTS_SV.RESERVE THEN
104:
105: IF ln_line_location_id IS NULL THEN
106:
107: /*Fetch the line_location_id of the distribution*/

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

244: Modified all the select statements which derive the non recoverable tax to fetch the amounts in document currency*/
245: ELSIF p_dist_type_tbl(i) IN ('REQUISITION') THEN
246:
247: lv_doc_type := 'REQ';
248: IF ((p_doc_type = PO_CONSTANTS_SV.PO) OR (p_action <> PO_CONSTANTS_SV.RESERVE AND p_doc_type = PO_CONSTANTS_SV.REQUISITION )) THEN
249:
250: ln_il_encum_used := 1;
251: IF ln_req_line_id IS NULL THEN /*If this is the first distribution in the requisition line*/
252:

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

384: /*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.*/
385: END IF;
386:
387: /*If the encumbrance action is any of the following then populate IL table*/
388: IF p_action IN ( PO_CONSTANTS_SV.RESERVE, PO_CONSTANTS_SV.CANCEL, 'FINAL CLOSE' ) THEN
389:
390: IF lv_doc_type = 'PO' THEN
391: /*fetch the document details*/
392: OPEN cur_po_hdr_dtls(ln_po_line_id);

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

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',
456: 'FINAL CLOSE' ,'CLOSED'),
457: last_update_date = sysdate,
458: last_updated_by = fnd_global.user_id,

Line 455: PO_CONSTANTS_SV.CANCEL ,'CANCELLED',

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',
456: 'FINAL CLOSE' ,'CLOSED'),
457: last_update_date = sysdate,
458: last_updated_by = fnd_global.user_id,
459: last_update_login = fnd_global.login_id

Line 492: DECODE(p_action,PO_CONSTANTS_SV.RESERVE,'RESERVED' ,PO_CONSTANTS_SV.CANCEL ,'CANCELLED','FINAL CLOSE' ,'CLOSED') ,

488: p_dist_id_tbl(i) ,
489: lv_doc_currency_code ,
490: ln_doc_curr_tax_amt ,
491: ln_func_curr_tax_amt ,
492: DECODE(p_action,PO_CONSTANTS_SV.RESERVE,'RESERVED' ,PO_CONSTANTS_SV.CANCEL ,'CANCELLED','FINAL CLOSE' ,'CLOSED') ,
493: sysdate ,
494: fnd_global.user_id ,
495: sysdate ,
496: fnd_global.user_id ,