APPS.OKL_ACCOUNTING_PROCESS_PVT dependencies on OKL_TRNS_ACC_DSTRS

Line 89: FROM OKL_TRNS_ACC_DSTRS

85: IS
86:
87: CURSOR dist_csr(v_aet_id NUMBER) IS
88: SELECT ID
89: FROM OKL_TRNS_ACC_DSTRS
90: WHERE aet_id = v_aet_id;
91:
92: l_tabv_tbl TABV_TBL_TYPE;
93: x_tabv_tbl TABV_TBL_TYPE;

Line 124: Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs(p_api_version => l_api_version,

120: l_tabv_tbl(i).aet_id := NULL;
121:
122: END LOOP;
123:
124: Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs(p_api_version => l_api_version,
125: p_init_msg_list => l_init_msg_list,
126: x_return_status => l_return_status,
127: x_msg_count => l_msg_count,
128: x_msg_data => l_msg_data,

Line 161: FROM OKL_TRNS_ACC_DSTRS

157: CURSOR dists_csr IS
158: SELECT DISTINCT source_id,
159: source_table,
160: reverse_event_flag
161: FROM OKL_TRNS_ACC_DSTRS
162: WHERE posted_yn = 'S';
163:
164: CURSOR dist_csr(v_source_id NUMBER,
165: v_source_table VARCHAR2,

Line 170: FROM OKL_TRNS_ACC_DSTRS

166: v_rev_flag VARCHAR2) IS
167: SELECT ID,
168: template_id,
169: TRUNC(gl_date) gl_date
170: FROM OKL_TRNS_ACC_DSTRS
171: WHERE source_id = v_source_id
172: AND source_table = v_source_table
173: AND reverse_event_flag = v_rev_flag;
174:

Line 327: UPDATE OKL_TRNS_ACC_DSTRS

323:
324: -- Added by Santonyr Bug 3925719
325:
326: BEGIN
327: UPDATE OKL_TRNS_ACC_DSTRS
328: SET AET_ID =l_tabv_tbl(l_tab_count).AET_ID,
329: last_update_date = SYSDATE,
330: last_updated_by = Fnd_Global.user_id,
331: last_update_login = Fnd_Global.login_id,

Line 350: Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs(p_api_version => p_api_version,

346:
347: -- Commented by Santonyr Bug 3925719
348:
349: /*
350: Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs(p_api_version => p_api_version,
351: p_init_msg_list => p_init_msg_list,
352: x_return_status => l_return_status,
353: x_msg_count => x_msg_count,
354: x_msg_data => x_msg_data,

Line 631: FROM OKL_TRNS_ACC_DSTRS

627: ,GL_DATE
628: ,PERCENTAGE
629: ,CURRENCY_CONVERSION_DATE
630: ,CURRENCY_CONVERSION_RATE
631: FROM OKL_TRNS_ACC_DSTRS
632: WHERE aet_id = v_aet_id;
633:
634: CURSOR aeh_csr(v_aet_id NUMBER) IS
635: SELECT ae_header_id

Line 868: FROM OKL_TRNS_ACC_DSTRS

864: IS
865:
866: CURSOR dist_csr IS
867: SELECT ID
868: FROM OKL_TRNS_ACC_DSTRS
869: WHERE POSTED_YN = 'S';
870:
871: dist_rec dist_csr%ROWTYPE;
872:

Line 902: Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs(

898: END LOOP;
899:
900: IF (l_tabv_tbl.COUNT > 0) THEN
901:
902: Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs(
903: p_api_version => p_api_version,
904: p_init_msg_list => p_init_msg_list,
905: x_return_status => l_return_status,
906: x_msg_count => x_msg_count,