[Home] [Help]
37: select REQUISITION_HEADER_ID,DESCRIPTION,AUTHORIZATION_STATUS,
38: TYPE_LOOKUP_CODE,PREPARER_ID,SEGMENT1,CLOSED_CODE,EMERGENCY_PO_NUM,
39: NVL(CONTRACTOR_REQUISITION_FLAG, 'N'),
40: NVL(CONTRACTOR_STATUS, 'NULL'), NOTE_TO_AUTHORIZER
41: from po_requisition_headers_all
42: where REQUISITION_HEADER_ID = p_requisition_header_id;
43:
44: /*****************************************************************************
45: * The following are local/Private procedure that support the workflow APIs: *
488: -- Indicates the caller of this procedure. If 'CANCEL', then the approval will
489: -- not insert into the action history.
490: --DocumentID
491: -- This value for this parameter depends on the DocumentType:
492: -- 'REQUISITION': PO_REQUISITION_HEADERS_ALL.requisition_header_id
493: -- 'PO' or 'PA': PO_HEADERS_ALL.po_header_id
494: -- 'RELEASE': PO_RELEASES_ALL.po_release_id
495: --DocumentNumber
496: -- (Obsolete) This parameter is ignored. This procedure will derive the
501: --DocumentType
502: -- 'REQUISITION', 'PO', 'PA', 'RELEASE'
503: --DocumentSubType
504: -- The value for this parameter depends on the DocumentType:
505: -- 'REQUISITION': PO_REQUISITION_HEADERS_ALL.type_lookup_code
506: -- 'PO' or 'PA': PO_HEADERS_ALL.type_lookup_code
507: -- 'RELEASE': PO_RELEASES_ALL.release_type
508: --SubmitterAction
509: -- (Unused) This parameter is not currently used.
1095: ELSIF (DocumentTypeCode = 'REQUISITION') THEN
1096:
1097: SELECT PRH.segment1
1098: INTO l_document_number
1099: FROM po_requisition_headers PRH
1100: WHERE PRH.requisition_header_id = DocumentID;
1101:
1102: END IF; -- DocumentTypeCode
1103: -- Bug 3284628 END
2244: IF l_document_type='REQUISITION' THEN
2245:
2246: select AUTHORIZATION_STATUS
2247: into l_authorization_status
2248: from po_requisition_headers_all
2249: where REQUISITION_HEADER_ID = l_document_id;
2250:
2251: /* Bug#1810322: kagarwal
2252: ** Desc: If the original authorization status is IN PROCESS or PRE-APPROVED
2814: */
2815: IF l_doc_type = 'REQUISITION' THEN
2816:
2817: select NVL(authorization_status, 'INCOMPLETE') into l_auth_stat
2818: from PO_REQUISITION_HEADERS
2819: where requisition_header_id = l_doc_id;
2820:
2821: IF l_auth_stat <> 'APPROVED' THEN
2822: SetReqAuthStat(l_doc_id, itemtype,itemkey,NULL, l_orig_auth_stat);
3137:
3138: IF l_doc_type = 'REQUISITION' THEN
3139:
3140: select NVL(authorization_status, 'INCOMPLETE') into l_auth_stat
3141: from PO_REQUISITION_HEADERS
3142: where requisition_header_id = l_doc_id;
3143:
3144: ELSIF l_doc_type IN ('PO', 'PA') THEN
3145:
3256: ** Desc:Initially the Workflow sets the preparer_id, approver_empid
3257: ** as the value passed to it by the POXAPAPC.pld file. As it always
3258: ** assumed that an Incomplete Requisition would get approved by
3259: ** preparer only. Then when it calls the GetReqAttributes()
3260: ** it would reget the preparer_id from the po_requisition_headers_all
3261: ** table hence if the preparer_id and approver_empid are different
3262: ** then the action history would be wrongly updated.
3263: **
3264: ** Modifying the parameter l_employee_id to be passed to
3679: where po_header_id= p_header_id;
3680:
3681: cursor req_cursor(p_header_id number) is
3682: select wf_item_key
3683: from po_requisition_headers
3684: where requisition_header_id= p_header_id;
3685:
3686: cursor rel_cursor(p_header_id number) is
3687: select wf_item_key
5009:
5010: x_progress := '002';
5011:
5012: select NVL(authorization_status, 'INCOMPLETE') into l_auth_stat
5013: from PO_REQUISITION_HEADERS
5014: where requisition_header_id = l_doc_id;
5015:
5016:
5017: ELSIF l_doc_type IN ('PO','PA') THEN
5896: */
5897:
5898: IF (note = 'UPGRADE_TO_R11' and p_auth_status = 'IN PROCESS') THEN
5899:
5900: update po_requisition_headers set
5901: WF_ITEM_TYPE = itemtype,
5902: WF_ITEM_KEY = itemkey,
5903: active_shopping_cart_flag = NULL,
5904: last_updated_by = fnd_global.user_id,
5907: where requisition_header_id = l_requisition_header_id;
5908:
5909: ELSE
5910:
5911: update po_requisition_headers set
5912: AUTHORIZATION_STATUS = p_auth_status,
5913: WF_ITEM_TYPE = itemtype,
5914: WF_ITEM_KEY = itemkey,
5915: active_shopping_cart_flag = NULL,
6043: BEGIN
6044:
6045: x_progress := '001';
6046:
6047: update po_requisition_headers set
6048: WF_ITEM_TYPE = itemtype,
6049: WF_ITEM_KEY = itemkey,
6050: last_updated_by = fnd_global.user_id,
6051: last_update_login = fnd_global.login_id,
6166: x_orgid IN OUT NOCOPY number) is
6167:
6168: cursor get_req_orgid is
6169: select org_id
6170: from po_requisition_headers_all
6171: where requisition_header_id = document_id;
6172:
6173: cursor get_po_orgid is
6174: select org_id
6329:
6330: x_progress := '002';
6331:
6332: select NVL(authorization_status, 'INCOMPLETE') into l_auth_stat
6333: from PO_REQUISITION_HEADERS
6334: where requisition_header_id = p_doc_id;
6335:
6336:
6337: ELSIF p_doc_type IN ('PO','PA') THEN
7504: IF l_document_id IS NOT NULL THEN
7505:
7506: select nvl(apps_source_code, 'PO')
7507: into l_apps_source_code
7508: from po_requisition_headers_all
7509: where requisition_header_id=l_document_id;
7510:
7511: END IF;
7512:
7716: select st.DISPLAYED_FIELD || ' ' ||
7717: ty.DISPLAYED_FIELD || ' ' ||
7718: hd.SEGMENT1
7719: into l_doc_string
7720: from po_requisition_headers hd,
7721: po_lookup_codes ty,
7722: po_lookup_codes st
7723: where hd.requisition_header_id = l_document_id
7724: and ty.lookup_type = 'DOCUMENT TYPE'