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 143: -- select count(*), CONTRACT_LINE_ID from OKL_CNTRCT_LINE_FIN_EXTRACT_T group by CONTRACT_LINE_ID having count(*) > 1

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

Line 155: INSERT INTO OKL_CNTRCT_LINE_FIN_EXTRACT_T (

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

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

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

Line 2284: INSERT INTO OKL_CNTRCT_LINE_FIN_EXTRACT_T (

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

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

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

Line 4343: INSERT INTO OKL_CNTRCT_LINE_FIN_EXTRACT_T (

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

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

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

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

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

Line 6563: DELETE FROM OKL_CNTRCT_LINE_FIN_EXTRACT_T

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

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

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