DBA Data[Home] [Help]

APPS.PO_UDA_DEFAULTING_PKG dependencies on PO_HEADERS_ALL

Line 560: FROM PO_HEADERS_ALL_EXT_B

556: d_progress NUMBER := 0;
557:
558: CURSOR c_po_header_ext(p_header_id NUMBER, p_draft_id NUMBER) IS
559: SELECT DISTINCT ATTR_GROUP_ID
560: FROM PO_HEADERS_ALL_EXT_B
561: WHERE PO_HEADER_ID = p_header_id
562: AND DRAFT_ID = p_draft_id;
563:
564: CURSOR c_po_line_ext(p_line_id NUMBER, p_draft_id NUMBER) IS

Line 2200: FROM PO_HEADERS_ALL_EXT_B

2196: d_progress NUMBER := 0;
2197:
2198: CURSOR c_po_header_ext(p_header_id NUMBER) IS
2199: SELECT DISTINCT ATTR_GROUP_ID
2200: FROM PO_HEADERS_ALL_EXT_B
2201: WHERE PO_HEADER_ID = p_header_id;
2202:
2203: CURSOR c_po_line_ext(p_line_id NUMBER) IS
2204: SELECT DISTINCT ATTR_GROUP_ID

Line 2704: FROM po_headers_all

2700: x_return_status := FND_API.G_RET_STS_SUCCESS;
2701: BEGIN
2702: SELECT UDA_TEMPLATE_ID
2703: INTO l_template_id
2704: FROM po_headers_all
2705: WHERE PO_HEADER_ID = p_po_header_id;
2706:
2707: PO_UDA_DEFAULTING_PKG.DEBUG('l_template_id :' || l_template_id , d_progress);
2708: EXCEPTION