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 173: -- select khr_CONTRACT_ID, count(*) from okl_cntrct_fin_extract_t group by contract_id having count(*) > 1

169: Okl_Execute_Formula_Pub.g_additional_parameters(5).value := 'PRIMARY';
170:
171: --------------------------------------------------------------
172: -- debug section
173: -- select khr_CONTRACT_ID, count(*) from okl_cntrct_fin_extract_t group by contract_id having count(*) > 1
174: -- query to pull NON-OKL contracts
175: -- select * from okl_cntrct_fin_extract_t where scs_code in (select code from okc_subclasses_b where cls_code <> 'OKL')
176: ------------------------------------------------------------------
177: MO_GLOBAL.init('OKL');

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

171: --------------------------------------------------------------
172: -- debug section
173: -- select khr_CONTRACT_ID, count(*) from okl_cntrct_fin_extract_t group by contract_id having count(*) > 1
174: -- query to pull NON-OKL contracts
175: -- select * from okl_cntrct_fin_extract_t where scs_code in (select code from okc_subclasses_b where cls_code <> 'OKL')
176: ------------------------------------------------------------------
177: MO_GLOBAL.init('OKL');
178: MO_GLOBAL.set_policy_context('S',P_OPERATING_UNIT);
179:

Line 183: INSERT INTO OKL_CNTRCT_FIN_EXTRACT_T

179:
180:
181: IF P_AR_INFO_YN like 'YES' THEN
182:
183: INSERT INTO OKL_CNTRCT_FIN_EXTRACT_T
184: (
185: REQUEST_ID,
186: CONTRACT_DOCUMENT_ID,
187: CONTRACT_NUMBER,

Line 1216: INSERT INTO OKL_CNTRCT_FIN_EXTRACT_T

1212:
1213: ELSE -- IF P_AR_INFO_YN like 'NO'
1214:
1215:
1216: INSERT INTO OKL_CNTRCT_FIN_EXTRACT_T
1217: (
1218: REQUEST_ID,
1219: CONTRACT_DOCUMENT_ID,
1220: CONTRACT_NUMBER,

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

2251: x_row_count := sql%rowcount;
2252: commit;
2253:
2254: IF x_row_count IS NOT NULL THEN
2255: write_to_log(x_row_count||' rows extracted in OKL_CNTRCT_FIN_EXTRACT_T .');
2256: END IF;
2257:
2258:
2259: Okl_Api.END_ACTIVITY (

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

2525: IF l_row_count IS NULL OR l_row_count = 0 THEN
2526: write_to_log('There was no data extracted for Contract Financial Extract.');
2527:
2528: ELSE
2529: write_to_log( l_row_count||' rows extracted in OKL_CNTRCT_FIN_EXTRACT_T for Contract Financial Extract.');
2530:
2531: END IF;
2532:
2533:

Line 2802: DELETE FROM OKL_CNTRCT_FIN_EXTRACT_T

2798: fnd_file.put_line(fnd_file.log,'l_parent_request_id :'||l_parent_request_id);
2799:
2800: IF P_DELETE_DATA_YN = 'YES' THEN
2801:
2802: DELETE FROM OKL_CNTRCT_FIN_EXTRACT_T
2803: WHERE REQUEST_ID = l_parent_request_id;
2804:
2805: l_row_count := sql%rowcount;
2806:

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

2804:
2805: l_row_count := sql%rowcount;
2806:
2807: If l_row_count > 0 then
2808: write_to_log('Purged '||l_row_count||' rows from OKL_CNTRCT_FIN_EXTRACT_T after the report was rendered.');
2809: end if;
2810:
2811: COMMIT;
2812: