APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on OKL_CNTRCT_LINE_FIN_EXTRACT_T

Line 27: | into table OKL_CNTRCT_LINE_FIN_EXTRACT_T

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

Line 144: -- select count(*), CONTRACT_LINE_ID from OKL_CNTRCT_LINE_FIN_EXTRACT_T group by CONTRACT_LINE_ID having count(*) > 1

140:
141:
142: --------------------------------------------------------------
143: -- debug section
144: -- select count(*), CONTRACT_LINE_ID from OKL_CNTRCT_LINE_FIN_EXTRACT_T group by CONTRACT_LINE_ID having count(*) > 1
145: ------------------------------------------------------------------
146: MO_GLOBAL.init('OKL');
147: MO_GLOBAL.set_policy_context('S',P_OPERATING_UNIT);
148:

Line 156: INSERT INTO OKL_CNTRCT_LINE_FIN_EXTRACT_T (

152:
153: write_to_log('Inserting ACTIVE contract lines P_FA_INFO_YN like Y');
154: x_row_count := NULL;
155:
156: INSERT INTO OKL_CNTRCT_LINE_FIN_EXTRACT_T (
157: REQUEST_ID,
158: CONTRACT_NUMBER,
159: CONTRACT_OPERATING_UNIT_ID,
160: CONTRACT_STATUS_CODE,

Line 2276: write_to_log(x_row_count||' rows extracted in OKL_CNTRCT_LINE_FIN_EXTRACT_T for ACTIVE contract lines.');

2272: );
2273:
2274: x_row_count := sql%rowcount;
2275: IF x_row_count IS NOT NULL THEN
2276: write_to_log(x_row_count||' rows extracted in OKL_CNTRCT_LINE_FIN_EXTRACT_T for ACTIVE contract lines.');
2277: END IF;
2278:
2279: l_row_count := l_row_count + to_number(x_row_count);
2280:

Line 2285: INSERT INTO OKL_CNTRCT_LINE_FIN_EXTRACT_T (

2281: write_to_log('Inserting INACTIVE contract lines P_FA_INFO_YN like Y');
2282:
2283: x_row_count := NULL;
2284:
2285: INSERT INTO OKL_CNTRCT_LINE_FIN_EXTRACT_T (
2286: REQUEST_ID,
2287: CONTRACT_NUMBER,
2288: CONTRACT_OPERATING_UNIT_ID,
2289: CONTRACT_STATUS_CODE,

Line 4335: write_to_log(x_row_count||' rows extracted in OKL_CNTRCT_LINE_FIN_EXTRACT_T for INACTIVE contract lines.');

4331: );
4332:
4333: x_row_count := sql%rowcount;
4334: IF x_row_count IS NOT NULL THEN
4335: write_to_log(x_row_count||' rows extracted in OKL_CNTRCT_LINE_FIN_EXTRACT_T for INACTIVE contract lines.');
4336: END IF;
4337: l_row_count := l_row_count + to_number(x_row_count);
4338:
4339: ELSE -- P_FA_INFO_YN like 'NO'

Line 4344: INSERT INTO OKL_CNTRCT_LINE_FIN_EXTRACT_T (

4340:
4341: write_to_log('Inserting contract lines P_FA_INFO_YN like N');
4342: x_row_count := NULL;
4343:
4344: INSERT INTO OKL_CNTRCT_LINE_FIN_EXTRACT_T (
4345: REQUEST_ID,
4346: CONTRACT_NUMBER,
4347: CONTRACT_OPERATING_UNIT_ID,
4348: CONTRACT_STATUS_CODE,

Line 6252: write_to_log(x_row_count||' rows extracted in OKL_CNTRCT_LINE_FIN_EXTRACT_T P_FA_INFO_YN is NO .');

6248: );
6249:
6250: x_row_count := sql%rowcount;
6251: IF x_row_count IS NOT NULL THEN
6252: write_to_log(x_row_count||' rows extracted in OKL_CNTRCT_LINE_FIN_EXTRACT_T P_FA_INFO_YN is NO .');
6253: END IF;
6254: l_row_count := l_row_count + to_number(x_row_count);
6255:
6256:

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

6513: IF l_row_count IS NULL OR l_row_count = 0 THEN
6514: write_to_log('There was no data extracted for Contract Line Financial Extract.');
6515:
6516: ELSE
6517: write_to_log( l_row_count||' rows extracted in OKL_CNTRCT_LINE_FIN_EXTRACT_T for Contract Line Financial Extract.');
6518:
6519: END IF;
6520:
6521:

Line 6564: DELETE FROM OKL_CNTRCT_LINE_FIN_EXTRACT_T

6560: fnd_file.put_line(fnd_file.log,'l_parent_request_id :'||l_parent_request_id);
6561:
6562: IF P_DELETE_DATA_YN = 'YES' THEN
6563:
6564: DELETE FROM OKL_CNTRCT_LINE_FIN_EXTRACT_T
6565: WHERE REQUEST_ID = l_parent_request_id;
6566:
6567: l_row_count := sql%rowcount;
6568:

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

6566:
6567: l_row_count := sql%rowcount;
6568:
6569: If l_row_count > 0 then
6570: write_to_log('Purged '||l_row_count||' rows from OKL_CNTRCT_LINE_FIN_EXTRACT_T after the report was rendered.');
6571: end if;
6572:
6573: COMMIT;
6574: