DBA Data[Home] [Help]

APPS.OKL_TRANSACTION_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 155: l_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

151: ) IS
152: l_proc_name VARCHAR2(35) := 'POPULATE_TRANSACTION_REC';
153: l_try_id NUMBER;
154: l_id NUMBER;
155: l_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
156: l_org_id OKL_K_HEADERS_FULL_V.AUTHORING_ORG_ID%TYPE;
157:
158: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
159: SELECT currency_code,

Line 156: l_org_id OKL_K_HEADERS_FULL_V.AUTHORING_ORG_ID%TYPE;

152: l_proc_name VARCHAR2(35) := 'POPULATE_TRANSACTION_REC';
153: l_try_id NUMBER;
154: l_id NUMBER;
155: l_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
156: l_org_id OKL_K_HEADERS_FULL_V.AUTHORING_ORG_ID%TYPE;
157:
158: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
159: SELECT currency_code,
160: authoring_org_id

Line 161: FROM okl_k_headers_full_v

157:
158: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
159: SELECT currency_code,
160: authoring_org_id
161: FROM okl_k_headers_full_v
162: WHERE id = p_chr_id;
163:
164: CURSOR try_csr(p_trx_type VARCHAR2) IS
165: SELECT id

Line 1219: FROM okl_k_headers_full_v

1215:
1216: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1217: SELECT currency_code,
1218: authoring_org_id
1219: FROM okl_k_headers_full_v
1220: WHERE id = p_chr_id;
1221:
1222: l_try_id NUMBER;
1223: service_txn_failed EXCEPTION;

Line 1424: FROM okl_k_headers_full_v

1420:
1421: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1422: SELECT currency_code,
1423: authoring_org_id
1424: FROM okl_k_headers_full_v
1425: WHERE id = p_chr_id;
1426:
1427: l_try_id NUMBER;
1428: ppd_txn_failed EXCEPTION;