APPS.OKC_XPRT_CUSTOM_PACKAGE dependencies on PO_HEADERS_ALL

Line 199: l_price_update_tolerance PO_HEADERS_ALL.PRICE_UPDATE_TOLERANCE%TYPE;

195: IS
196:
197: l_api_name CONSTANT VARCHAR2(30) := 'GET_PRICE_UPDATE_TOLERANCE';
198:
199: l_price_update_tolerance PO_HEADERS_ALL.PRICE_UPDATE_TOLERANCE%TYPE;
200:
201:
202: Cursor l_price_update_csr Is
203: select PRICE_UPDATE_TOLERANCE from PO_HEADERS_ALL

Line 203: select PRICE_UPDATE_TOLERANCE from PO_HEADERS_ALL

199: l_price_update_tolerance PO_HEADERS_ALL.PRICE_UPDATE_TOLERANCE%TYPE;
200:
201:
202: Cursor l_price_update_csr Is
203: select PRICE_UPDATE_TOLERANCE from PO_HEADERS_ALL
204: WHERE po_header_id = P_DOC_ID ;
205:
206: --AND TYPE_LOOKUP_CODE = P_DOC_TYPE
207:

Line 781: FROM PO_HEADERS_ALL

777:
778:
779: Cursor l_release_ratio_csr Is
780: SELECT NVL(MIN_RELEASE_AMOUNT,0)/NVL(AMOUNT_LIMIT, 1)
781: FROM PO_HEADERS_ALL
782: WHERE PO_HEADER_ID = P_DOC_ID;
783:
784: BEGIN
785:

Line 976: l_attribute4_val PO_HEADERS_ALL.ATTRIBUTE4%TYPE;

972: IS
973:
974: l_api_name CONSTANT VARCHAR2(30) := 'GET_DFF_PO';
975:
976: l_attribute4_val PO_HEADERS_ALL.ATTRIBUTE4%TYPE;
977:
978:
979: Cursor l_attribute4_val_csr Is
980: SELECT ATTRIBUTE4

Line 981: FROM PO_HEADERS_ALL

977:
978:
979: Cursor l_attribute4_val_csr Is
980: SELECT ATTRIBUTE4
981: FROM PO_HEADERS_ALL
982: WHERE PO_HEADER_ID = P_DOC_ID;
983:
984: BEGIN
985: