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 1180: FROM okl_k_headers_full_v

1176:
1177: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1178: SELECT currency_code,
1179: authoring_org_id
1180: FROM okl_k_headers_full_v
1181: WHERE id = p_chr_id;
1182:
1183: l_try_id NUMBER;
1184: service_txn_failed EXCEPTION;

Line 1385: FROM okl_k_headers_full_v

1381:
1382: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1383: SELECT currency_code,
1384: authoring_org_id
1385: FROM okl_k_headers_full_v
1386: WHERE id = p_chr_id;
1387:
1388: l_try_id NUMBER;
1389: ppd_txn_failed EXCEPTION;