200: max_seqno number;
201: l_item_type wf_items.item_type%TYPE;
202: l_item_key wf_items.item_key%TYPE;
203:
204: l_document_id po_requisition_headers.requisition_header_id%TYPE;
205: l_org_id po_requisition_headers.org_id%TYPE;
206: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
207: l_document_type po_lookup_codes.displayed_field%TYPE;
208: l_document_number po_requisition_headers.segment1%TYPE;
201: l_item_type wf_items.item_type%TYPE;
202: l_item_key wf_items.item_key%TYPE;
203:
204: l_document_id po_requisition_headers.requisition_header_id%TYPE;
205: l_org_id po_requisition_headers.org_id%TYPE;
206: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
207: l_document_type po_lookup_codes.displayed_field%TYPE;
208: l_document_number po_requisition_headers.segment1%TYPE;
209: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
204: l_document_id po_requisition_headers.requisition_header_id%TYPE;
205: l_org_id po_requisition_headers.org_id%TYPE;
206: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
207: l_document_type po_lookup_codes.displayed_field%TYPE;
208: l_document_number po_requisition_headers.segment1%TYPE;
209: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
210: l_total_amount VARCHAR2(30);
211: l_header_msg VARCHAR2(2225);
212: l_req_amount VARCHAR2(30);
210: l_total_amount VARCHAR2(30);
211: l_header_msg VARCHAR2(2225);
212: l_req_amount VARCHAR2(30);
213: l_tax_amount VARCHAR2(30);
214: l_description po_requisition_headers.description%TYPE;
215: l_forwarded_from per_people_f.full_name%TYPE;
216: l_preparer per_people_f.full_name%TYPE;
217: --
218: -- l_note VARCHAR2(480);
445: max_seqno number;
446: l_item_type wf_items.item_type%TYPE;
447: l_item_key wf_items.item_key%TYPE;
448:
449: l_document_id po_requisition_headers.requisition_header_id%TYPE;
450: l_org_id po_requisition_headers.org_id%TYPE;
451: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
452: l_document_type po_lookup_codes.displayed_field%TYPE;
453: l_document_number po_requisition_headers.segment1%TYPE;
446: l_item_type wf_items.item_type%TYPE;
447: l_item_key wf_items.item_key%TYPE;
448:
449: l_document_id po_requisition_headers.requisition_header_id%TYPE;
450: l_org_id po_requisition_headers.org_id%TYPE;
451: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
452: l_document_type po_lookup_codes.displayed_field%TYPE;
453: l_document_number po_requisition_headers.segment1%TYPE;
454: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
449: l_document_id po_requisition_headers.requisition_header_id%TYPE;
450: l_org_id po_requisition_headers.org_id%TYPE;
451: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
452: l_document_type po_lookup_codes.displayed_field%TYPE;
453: l_document_number po_requisition_headers.segment1%TYPE;
454: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
455: l_total_amount VARCHAR2(30);
456: l_header_msg VARCHAR2(200);
457: l_req_amount VARCHAR2(30);
455: l_total_amount VARCHAR2(30);
456: l_header_msg VARCHAR2(200);
457: l_req_amount VARCHAR2(30);
458: l_tax_amount VARCHAR2(30);
459: l_description po_requisition_headers.description%TYPE;
460: l_approver per_people_f.full_name%TYPE;
461: l_preparer per_people_f.full_name%TYPE;
462: --
463: -- l_note VARCHAR2(480);
715: max_seqno number;
716: l_item_type wf_items.item_type%TYPE;
717: l_item_key wf_items.item_key%TYPE;
718:
719: l_document_id po_requisition_headers.requisition_header_id%TYPE;
720: l_org_id po_requisition_headers.org_id%TYPE;
721: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
722: l_document_type po_lookup_codes.displayed_field%TYPE;
723: l_document_number po_requisition_headers.segment1%TYPE;
716: l_item_type wf_items.item_type%TYPE;
717: l_item_key wf_items.item_key%TYPE;
718:
719: l_document_id po_requisition_headers.requisition_header_id%TYPE;
720: l_org_id po_requisition_headers.org_id%TYPE;
721: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
722: l_document_type po_lookup_codes.displayed_field%TYPE;
723: l_document_number po_requisition_headers.segment1%TYPE;
724: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
719: l_document_id po_requisition_headers.requisition_header_id%TYPE;
720: l_org_id po_requisition_headers.org_id%TYPE;
721: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
722: l_document_type po_lookup_codes.displayed_field%TYPE;
723: l_document_number po_requisition_headers.segment1%TYPE;
724: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
725: l_total_amount VARCHAR2(30);
726: l_header_msg VARCHAR2(200);
727: l_req_amount VARCHAR2(30);
725: l_total_amount VARCHAR2(30);
726: l_header_msg VARCHAR2(200);
727: l_req_amount VARCHAR2(30);
728: l_tax_amount VARCHAR2(30);
729: l_description po_requisition_headers.description%TYPE;
730: l_approver per_people_f.full_name%TYPE;
731: l_preparer per_people_f.full_name%TYPE;
732: --
733: -- l_note VARCHAR2(480);
940: max_seqno number;
941: l_item_type wf_items.item_type%TYPE;
942: l_item_key wf_items.item_key%TYPE;
943:
944: l_document_id po_requisition_headers.requisition_header_id%TYPE;
945: l_org_id po_requisition_headers.org_id%TYPE;
946: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
947: l_document_type po_lookup_codes.displayed_field%TYPE;
948: l_document_number po_requisition_headers.segment1%TYPE;
941: l_item_type wf_items.item_type%TYPE;
942: l_item_key wf_items.item_key%TYPE;
943:
944: l_document_id po_requisition_headers.requisition_header_id%TYPE;
945: l_org_id po_requisition_headers.org_id%TYPE;
946: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
947: l_document_type po_lookup_codes.displayed_field%TYPE;
948: l_document_number po_requisition_headers.segment1%TYPE;
949: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
944: l_document_id po_requisition_headers.requisition_header_id%TYPE;
945: l_org_id po_requisition_headers.org_id%TYPE;
946: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
947: l_document_type po_lookup_codes.displayed_field%TYPE;
948: l_document_number po_requisition_headers.segment1%TYPE;
949: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
950: l_total_amount VARCHAR2(30);
951: l_header_msg VARCHAR2(200);
952: l_req_amount VARCHAR2(30);
950: l_total_amount VARCHAR2(30);
951: l_header_msg VARCHAR2(200);
952: l_req_amount VARCHAR2(30);
953: l_tax_amount VARCHAR2(30);
954: l_description po_requisition_headers.description%TYPE;
955: l_rejected_by per_people_f.full_name%TYPE;
956: l_preparer per_people_f.full_name%TYPE;
957: --
958: -- l_note VARCHAR2(480);
1408: l_max_lines NUMBER := 0;
1409:
1410: l_document VARCHAR2(32000) := '';
1411:
1412: l_req_status po_requisition_headers.authorization_status%TYPE;
1413:
1414: l_req_details_url VARCHAR2(2000) := '';
1415: l_req_line_msg VARCHAR2(2000) := '';
1416: l_req_updates_url VARCHAR2(2000) := '';
2650: l_nid number;
2651: l_forwardTo varchar2(240);
2652: l_result varchar2(100);
2653: l_forward_to_username_response varchar2(240) :='';
2654: l_req_header_id po_requisition_headers.requisition_header_id%TYPE;
2655: l_action po_action_history.action_code%TYPE;
2656: l_new_recipient_id wf_roles.orig_system_id%TYPE;
2657: l_current_recipient_id wf_roles.orig_system_id%TYPE;
2658: l_origsys wf_roles.orig_system%TYPE;
2685:
2686: -- MIPR Changes
2687: CURSOR mipr_csr(p_doc_id NUMBER) IS
2688: SELECT flv.MEANING
2689: FROM po_requisition_headers_all prh, FND_LOOKUP_VALUES FLV
2690: WHERE prh.requisition_header_id = p_doc_id
2691: AND prh.clm_mipr_type = flv.LOOKUP_CODE
2692: AND NVL(prh.cancel_flag,'N') = 'N'
2693: AND FLV.LOOKUP_TYPE='MIPR_TYPE'
3324:
3325: -- MIPR Changes
3326: CURSOR mipr_csr(p_doc_id NUMBER, p_language varchar2) IS
3327: SELECT flv.MEANING
3328: FROM po_requisition_headers_all prh, FND_LOOKUP_VALUES FLV, FND_LANGUAGES FL
3329: WHERE prh.requisition_header_id = p_doc_id
3330: AND prh.clm_mipr_type = flv.LOOKUP_CODE
3331: AND NVL(cancel_flag,'N') = 'N'
3332: AND FL.NLS_LANGUAGE = p_language