APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on OKL_CNTRCT_FIN_EXTRACT_T

Line 26: | into okl_cntrct_fin_extract_t

22: | PUBLIC PROCEDURE Pull_extract_data
23: |
24: | DESCRIPTION
25: | This procedure fetches data for Contract Financial Report and inserts
26: | into okl_cntrct_fin_extract_t
27: |
28: | CALLED FROM
29: | Concurrent Program "Child Program -- Contract Financial Report"
30: |

Line 159: -- select khr_CONTRACT_ID, count(*) from okl_cntrct_fin_extract_t group by contract_id having count(*) > 1

155: Okl_Execute_Formula_Pub.g_additional_parameters(4).value := P_REPORT_DATE ;
156:
157: --------------------------------------------------------------
158: -- debug section
159: -- select khr_CONTRACT_ID, count(*) from okl_cntrct_fin_extract_t group by contract_id having count(*) > 1
160: -- query to pull NON-OKL contracts
161: -- select * from okl_cntrct_fin_extract_t where scs_code in (select code from okc_subclasses_b where cls_code <> 'OKL')
162: ------------------------------------------------------------------
163: MO_GLOBAL.init('OKL');

Line 161: -- select * from okl_cntrct_fin_extract_t where scs_code in (select code from okc_subclasses_b where cls_code <> 'OKL')

157: --------------------------------------------------------------
158: -- debug section
159: -- select khr_CONTRACT_ID, count(*) from okl_cntrct_fin_extract_t group by contract_id having count(*) > 1
160: -- query to pull NON-OKL contracts
161: -- select * from okl_cntrct_fin_extract_t where scs_code in (select code from okc_subclasses_b where cls_code <> 'OKL')
162: ------------------------------------------------------------------
163: MO_GLOBAL.init('OKL');
164: MO_GLOBAL.set_policy_context('S',P_OPERATING_UNIT);
165:

Line 169: INSERT INTO OKL_CNTRCT_FIN_EXTRACT_T

165:
166:
167: IF P_AR_INFO_YN like 'YES' THEN
168:
169: INSERT INTO OKL_CNTRCT_FIN_EXTRACT_T
170: (
171: REQUEST_ID,
172: CONTRACT_DOCUMENT_ID,
173: CONTRACT_NUMBER,

Line 1202: INSERT INTO OKL_CNTRCT_FIN_EXTRACT_T

1198:
1199: ELSE -- IF P_AR_INFO_YN like 'NO'
1200:
1201:
1202: INSERT INTO OKL_CNTRCT_FIN_EXTRACT_T
1203: (
1204: REQUEST_ID,
1205: CONTRACT_DOCUMENT_ID,
1206: CONTRACT_NUMBER,

Line 2241: write_to_log(x_row_count||' rows extracted in OKL_CNTRCT_FIN_EXTRACT_T .');

2237: x_row_count := sql%rowcount;
2238: commit;
2239:
2240: IF x_row_count IS NOT NULL THEN
2241: write_to_log(x_row_count||' rows extracted in OKL_CNTRCT_FIN_EXTRACT_T .');
2242: END IF;
2243:
2244:
2245: Okl_Api.END_ACTIVITY (

Line 2515: write_to_log( l_row_count||' rows extracted in OKL_CNTRCT_FIN_EXTRACT_T for Contract Financial Extract.');

2511: IF l_row_count IS NULL OR l_row_count = 0 THEN
2512: write_to_log('There was no data extracted for Contract Financial Extract.');
2513:
2514: ELSE
2515: write_to_log( l_row_count||' rows extracted in OKL_CNTRCT_FIN_EXTRACT_T for Contract Financial Extract.');
2516:
2517: END IF;
2518:
2519:

Line 2788: DELETE FROM OKL_CNTRCT_FIN_EXTRACT_T

2784: fnd_file.put_line(fnd_file.log,'l_parent_request_id :'||l_parent_request_id);
2785:
2786: IF P_DELETE_DATA_YN = 'YES' THEN
2787:
2788: DELETE FROM OKL_CNTRCT_FIN_EXTRACT_T
2789: WHERE REQUEST_ID = l_parent_request_id;
2790:
2791: l_row_count := sql%rowcount;
2792:

Line 2794: write_to_log('Purged '||l_row_count||' rows from OKL_CNTRCT_FIN_EXTRACT_T after the report was rendered.');

2790:
2791: l_row_count := sql%rowcount;
2792:
2793: If l_row_count > 0 then
2794: write_to_log('Purged '||l_row_count||' rows from OKL_CNTRCT_FIN_EXTRACT_T after the report was rendered.');
2795: end if;
2796:
2797: COMMIT;
2798: