[Home] [Help]
40: WHERE change_request_group_id = p_change_request_grp_id_csr;
41:
42: CURSOR getDocSubType(p_po_header_id_csr IN NUMBER) IS
43: SELECT type_lookup_code
44: FROM po_headers_all poha
45: WHERE poha.po_header_id = p_po_header_id_csr;
46:
47: CURSOR getDocSubTypeRel(p_po_header_id_csr IN NUMBER, p_po_release_id_csr IN NUMBER) IS
48: SELECT distinct(release_type)
51: AND pora.po_release_id = p_po_release_id_csr;
52:
53: CURSOR getOrgId(p_po_header_id_csr IN NUMBER) IS
54: SELECT org_id
55: FROM po_headers_all
56: WHERE po_header_id = p_po_header_id_csr;
57:
58: l_chg_req_grp_id po_change_requests.change_request_group_id%TYPE;
59: l_po_header_id po_headers_all.po_header_id%TYPE;
55: FROM po_headers_all
56: WHERE po_header_id = p_po_header_id_csr;
57:
58: l_chg_req_grp_id po_change_requests.change_request_group_id%TYPE;
59: l_po_header_id po_headers_all.po_header_id%TYPE;
60: l_po_release_id po_releases_all.po_release_id%TYPE;
61: l_doc_type po_change_requests.document_type%TYPE;
62: l_po_style varchar2(10);
63: l_doc_subtype varchar2(10);
504: AND ( (pcr.new_promised_date <> old_promised_date) OR
505: (nvl(pcr.old_promised_date,nvl(pcr.old_need_by_date,pcr.new_promised_date - 1))<>pcr.new_promised_date)
506: );
507:
508: l_po_header_id po_headers_all.po_header_id%type;
509: l_change_group_id po_change_requests.change_request_group_id%type;
510: l_prom_date_dec NUMBER;
511: l_prom_date_incr NUMBER;
512: l_old_promise_date po_change_requests.old_promised_date%type;
671:
672: -- cursor to check for the Complex Work( Actuals Case)
673:
674:
675: l_po_header_id po_headers_all.po_header_id%TYPE;
676: l_po_release_id po_releases_all.po_release_id%TYPE;
677: l_change_group_id po_change_requests.change_request_group_id%type;
678: l_unitprice_lower_tol number;
679: l_unitprice_upper_tol number;
846: l_shipq_ty_max_dec_per NUMBER;
847: l_ship_qty_max_incr_val NUMBER;
848: l_ship_qty_max_dec_val NUMBER;
849: x_progress VARCHAR2(1000);
850: l_po_header_id po_headers_all.po_header_id%TYPE;
851: l_change_group_id po_change_requests.change_request_group_id%type;
852: l_po_style_type VARCHAR2(10);
853: l_doc_type VARCHAR2(10);
854:
2503: resultout OUT NOCOPY VARCHAR2)
2504:
2505: IS
2506: l_return_val VARCHAR2(1) ;
2507: l_po_header_id po_headers_all.po_header_id%TYPE;
2508: l_change_group_id po_change_requests.change_request_group_id%type;
2509: x_progress VARCHAR2(1000);
2510: l_po_style_type VARCHAR2(10);
2511: l_doc_type VARCHAR2(10);
2754: cursor c_getReqHdrId(p_po_header_id_csr IN NUMBER) is
2755: select distinct porh.requisition_header_id
2756: from po_requisition_headers_all porh,
2757: po_requisition_lines_all porl,
2758: po_headers_all poh,
2759: po_line_locations_all poll
2760: where porh.requisition_header_id = porl.requisition_header_id AND
2761: porl.line_location_id = poll.line_location_id AND
2762: poh.po_header_id = poll.po_header_id AND
2765: cursor c_getReqHdrId_r(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) is
2766: select distinct porh.requisition_header_id
2767: from po_requisition_headers_all porh,
2768: po_requisition_lines_all porl,
2769: po_headers_all poh,
2770: po_line_locations_all poll
2771: where porh.requisition_header_id = porl.requisition_header_id AND
2772: porl.line_location_id = poll.line_location_id AND
2773: poh.po_header_id = poll.po_header_id AND
2773: poh.po_header_id = poll.po_header_id AND
2774: poh.po_header_id = p_po_header_id_csr AND
2775: poll.po_release_id = p_po_release_id_csr;
2776:
2777: l_po_header_id po_headers_all.po_header_id%TYPE;
2778: l_po_release_id po_releases_all.po_release_id%TYPE;
2779: l_doc_type VARCHAR2(10);
2780: l_return_val VARCHAR2(1);
2781: l_change_group_id po_change_requests.change_request_group_id%TYPE;
2895: resultout OUT NOCOPY VARCHAR2)
2896:
2897: IS
2898:
2899: l_po_header_id po_headers_all.po_header_id%TYPE;
2900: l_po_release_id po_releases_all.po_release_id%TYPE;
2901: l_return_val VARCHAR2(1);
2902: x_progress VARCHAR2(1000);
2903: l_po_style_type VARCHAR2(10);
3083: cursor c_req_locks(p_po_header_id_csr IN NUMBER) is
3084: select count(1)
3085: from po_requisition_headers_all porh,
3086: po_requisition_lines_all porl,
3087: po_headers_all poh,
3088: po_line_locations_all poll
3089: where porh.requisition_header_id = porl.requisition_header_id AND
3090: porl.line_location_id = poll.line_location_id AND
3091: poh.po_header_id = poll.po_header_id AND
3098: cursor c_req_locks_rel(p_po_header_id_csr IN NUMBER, p_po_release_id_csr IN NUMBER) is
3099: select count(1)
3100: from po_requisition_headers_all porh,
3101: po_requisition_lines_all porl,
3102: po_headers_all poh,
3103: po_line_locations_all poll
3104: where porh.requisition_header_id = porl.requisition_header_id AND
3105: porl.line_location_id = poll.line_location_id AND
3106: poh.po_header_id = poll.po_header_id AND
3364: -- SCO created during Acknowledgement AND the supplier has rejected at least one shipment
3365: -- Cursor for checking whether sco is created during Acknowledgement or not.
3366: cursor c_sco_ack_ship(p_po_header_id_csr IN NUMBER) is
3367: SELECT acceptance_required_flag,revision_num
3368: FROM po_headers_all
3369: WHERE po_header_id = p_po_header_id_csr;
3370:
3371: -- Cursor for checking the acknowledgement status of the shipment
3372: cursor c_sco_ack_rej_ship(p_po_header_id_csr IN NUMBER, c_revision_num IN NUMBER) is
3414: -- Cursor for checking whether the signature is required or not
3415: /* 5550515
3416: cursor c_sgn_req_flag(p_po_header_id_csr IN NUMBER) IS
3417: SELECT acceptance_required_flag
3418: FROM po_headers_all
3419: WHERE po_header_id = p_po_header_id_csr;
3420: */
3421: cursor c_sgn_req_flag_po(p_po_header_id_csr IN NUMBER,c_revision_num IN NUMBER ) IS
3422: SELECT count(1)
3447: l_additional_change_requests number;
3448: l_ack_reject_cnt number;
3449: l_supp_item_chg_cnt number;
3450: l_temp number;
3451: l_accpt_req_flag po_headers_all.acceptance_required_flag%type;
3452: l_revision_num number;
3453: l_signature_required number :=0;
3454: l_ack_status_flag_count number;
3455: l_api_name varchar2(50) := 'AUTO_APP_BIZ_RULES';
3654: funcmode IN VARCHAR2,
3655: resultout OUT NOCOPY VARCHAR2)
3656: IS
3657:
3658: l_po_header_id po_headers_all.po_header_id%TYPE;
3659: x_progress VARCHAR2(1000);
3660: l_change_group_id po_change_requests.change_request_group_id%TYPE;
3661:
3662: BEGIN
3831: funcmode IN VARCHAR2,
3832: resultout OUT NOCOPY VARCHAR2)
3833: IS
3834: l_change_group_id PO_CHANGE_REQUESTS.CHANGE_REQUEST_GROUP_ID%type;
3835: l_po_header_id po_headers_all.po_header_id%type;
3836: l_po_release_id po_releases_all.po_release_id%type;
3837: x_progress VARCHAR2(1000);
3838:
3839: BEGIN
4347: IS
4348: select porh.PREPARER_ID
4349: from po_requisition_headers_all porh,
4350: po_requisition_lines_all porl,
4351: po_headers_all poh,
4352: po_line_locations_all poll
4353: where porh.requisition_header_id = porl.requisition_header_id AND
4354: porl.line_location_id = poll.line_location_id AND
4355: poh.po_header_id = poll.po_header_id AND
4380: l_requester_username fnd_user.user_name%type;
4381: l_requester_disp_name VARCHAR2(2000);
4382: l_requester_id number;
4383: l_planner_id number;
4384: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
4385: BEGIN
4386:
4387: x_progress :='MARK_SCO_FOR_REQ:000';
4388: