APPS.GML_PO_RECV1_PKG dependencies on PO_ORDR_HDR

Line 50: FROM po_ordr_hdr

46: PROCEDURE get_no(v_po_no OUT NOCOPY VARCHAR2, v_line_no OUT NOCOPY NUMBER)
47: AS
48: CURSOR po_no_cur IS
49: SELECT po_no
50: FROM po_ordr_hdr
51: WHERE po_id = G_po_id;
52:
53: CURSOR line_no_cur IS
54: SELECT line_no

Line 148: v_po_no po_ordr_hdr.po_no%TYPE;

144: +========================================================================*/
145:
146:
147: PROCEDURE sum_recv AS
148: v_po_no po_ordr_hdr.po_no%TYPE;
149: v_line_no po_ordr_dtl.line_no%TYPE;
150: v_org_id gl_plcy_mst.org_id%TYPE;
151: v_orgn_code po_ordr_hdr.orgn_code%TYPE;
152: v_returned_qty po_rtrn_dtl.return_qty1%TYPE;

Line 151: v_orgn_code po_ordr_hdr.orgn_code%TYPE;

147: PROCEDURE sum_recv AS
148: v_po_no po_ordr_hdr.po_no%TYPE;
149: v_line_no po_ordr_dtl.line_no%TYPE;
150: v_org_id gl_plcy_mst.org_id%TYPE;
151: v_orgn_code po_ordr_hdr.orgn_code%TYPE;
152: v_returned_qty po_rtrn_dtl.return_qty1%TYPE;
153: v_received_qty po_recv_dtl.recv_qty1%TYPE;
154: v_status po_ordr_dtl.po_status%TYPE;
155: v_actual_received_qty NUMBER;

Line 180: FROM po_ordr_hdr

176: err_msg VARCHAR2(100);
177:
178: CURSOR po_org_cur(vc_po_id NUMBER) IS
179: SELECT po_no, orgn_code
180: FROM po_ordr_hdr
181: WHERE po_id = vc_po_id;
182:
183: CURSOR line_no_cur(vc_po_id NUMBER, vc_line_id NUMBER) IS
184: SELECT line_no,ORDER_UM1, item_id