eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_REPORT_GENERATOR_PVT dependencies on OKL_G_REPORTS_GT

Line 503: INSERT INTO okl_g_reports_gt

499: -------------------------------------------------------------------------------------
500: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
501: 'Before Inserting the Lease Accounting Transactions GT Table Start Time:'
502: || TO_CHAR(l_trace_time, 'DD-MON-YYY HH:MM:SS') );
503: INSERT INTO okl_g_reports_gt
504: (
505: -- String Formatted Columns
506: value1_text
507: ,value2_text

Line 1128: INSERT INTO okl_g_reports_gt

1124: l_trace_time := SYSDATE;
1125: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
1126: 'Before Inserting the Receivables Invoice Transactions Data in GT Table Start Time:'
1127: || TO_CHAR(l_trace_time, 'DD-MON-YYY HH:MM:SS') );
1128: INSERT INTO okl_g_reports_gt
1129: (
1130: -- String Formatted Columns
1131: value1_text
1132: ,value2_text

Line 1776: INSERT INTO okl_g_reports_gt

1772: l_trace_time := SYSDATE;
1773: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
1774: 'Before Inserting the Receivables Adjustments Transactions Data in GT Table Start Time:'
1775: || TO_CHAR(l_trace_time, 'DD-MON-YYY HH:MM:SS') );
1776: INSERT INTO okl_g_reports_gt
1777: (
1778: -- String Formatted Columns
1779: value1_text
1780: ,value2_text

Line 2397: INSERT INTO okl_g_reports_gt

2393: l_trace_time := SYSDATE;
2394: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
2395: 'Before Inserting the Payables Invoice Transactions Data in GT Table Start Time:'
2396: || TO_CHAR(l_trace_time, 'DD-MON-YYY HH:MM:SS') );
2397: INSERT INTO okl_g_reports_gt
2398: (
2399: -- String Formatted Columns
2400: value1_text
2401: ,value2_text

Line 3061: -- As by now the okl_g_reports_gt table has all the TRX_POSTED [Posted Transactions]

3057: -- "Posted into Non Specified Accounts"
3058: -- (Or) "Posted into Non Specified Period"
3059: -- Note that "Posted into Non Specified Accounts" take precedence
3060: -- on the "Posted into Non Specified Period"
3061: -- As by now the okl_g_reports_gt table has all the TRX_POSTED [Posted Transactions]
3062: -- Update the entries which are not posted into the specified Accounts
3063: -- Logic:
3064: -- Step 1:
3065: -- For each record with detail type as TRX_POSTED in okl_g_reports_gt

Line 3065: -- For each record with detail type as TRX_POSTED in okl_g_reports_gt

3061: -- As by now the okl_g_reports_gt table has all the TRX_POSTED [Posted Transactions]
3062: -- Update the entries which are not posted into the specified Accounts
3063: -- Logic:
3064: -- Step 1:
3065: -- For each record with detail type as TRX_POSTED in okl_g_reports_gt
3066: -- check whether the Code Combination does not exists in the okl_code_cmbns_gt
3067: -- If it doesnot exist, update the detail type from TRX_POSTED to TRX_POST_NON_SPEC_ACCOUNTS
3068: UPDATE okl_g_reports_gt
3069: SET value1_text -- trx_detail_type_code

Line 3068: UPDATE okl_g_reports_gt

3064: -- Step 1:
3065: -- For each record with detail type as TRX_POSTED in okl_g_reports_gt
3066: -- check whether the Code Combination does not exists in the okl_code_cmbns_gt
3067: -- If it doesnot exist, update the detail type from TRX_POSTED to TRX_POST_NON_SPEC_ACCOUNTS
3068: UPDATE okl_g_reports_gt
3069: SET value1_text -- trx_detail_type_code
3070: = 'TRX_POST_NON_SPEC_ACCOUNTS'
3071: WHERE value1_text -- trx_detail_type_code
3072: = 'TRX_POSTED'

Line 3083: -- For each record with detail type as TRX_POSTED now in okl_g_reports_gt

3079: FROM okl_code_cmbns_gt
3080: );
3081: -- Step 2:
3082: -- And then, take rest of the records and,
3083: -- For each record with detail type as TRX_POSTED now in okl_g_reports_gt
3084: -- check whether the GL_DATE is not from the period_from_date and period_to_date
3085: -- If so, update the detail type from TRX_POSTED to TRX_POST_NON_SPEC_PERIOD
3086: UPDATE okl_g_reports_gt
3087: SET value1_text -- trx_detail_type_code

Line 3086: UPDATE okl_g_reports_gt

3082: -- And then, take rest of the records and,
3083: -- For each record with detail type as TRX_POSTED now in okl_g_reports_gt
3084: -- check whether the GL_DATE is not from the period_from_date and period_to_date
3085: -- If so, update the detail type from TRX_POSTED to TRX_POST_NON_SPEC_PERIOD
3086: UPDATE okl_g_reports_gt
3087: SET value1_text -- trx_detail_type_code
3088: = 'TRX_POST_NON_SPEC_PERIOD'
3089: WHERE value1_text -- trx_detail_type_code
3090: = 'TRX_POSTED'

Line 3407: INSERT INTO okl_g_reports_gt VALUES l_strm_bal_tbl(i);

3403: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
3404: 'Before Call to Bulk Insert ' || TO_CHAR(SYSDATE, 'DD-MON-YYY HH:MM:SS') );
3405: -- Finally insert the list of Products figured out
3406: FORALL i IN l_strm_bal_tbl.FIRST .. l_strm_bal_tbl.LAST
3407: INSERT INTO okl_g_reports_gt VALUES l_strm_bal_tbl(i);
3408: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
3409: 'After Call to Bulk Insert ' || TO_CHAR(SYSDATE, 'DD-MON-YYY HH:MM:SS') );
3410: END IF; -- IF l_strm_bal_tbl.COUNT > 0
3411:

Line 3535: INSERT INTO okl_g_reports_gt

3531:
3532: -- Start the stop watch
3533: l_trace_time := SYSDATE;
3534: -- Actual Insert Statement
3535: INSERT INTO okl_g_reports_gt
3536: (
3537: -- String Formatted Columns
3538: value1_text
3539: ,value2_text

Line 3694: INSERT INTO okl_g_reports_gt

3690:
3691: -- Start the stop watch
3692: l_trace_time := SYSDATE;
3693: -- Actual Insert Statement
3694: INSERT INTO okl_g_reports_gt
3695: (
3696: -- String Formatted Columns
3697: value1_text
3698: ,value2_text

Line 3882: INSERT INTO okl_g_reports_gt

3878:
3879: -- Start the stop watch
3880: l_trace_time := SYSDATE;
3881: -- Actual Insert Statement
3882: INSERT INTO okl_g_reports_gt
3883: (
3884: -- String Formatted Columns
3885: value1_text
3886: ,value2_text

Line 4096: INSERT INTO okl_g_reports_gt

4092:
4093: -- Start the stop watch
4094: l_trace_time := SYSDATE;
4095: -- Actual Insert Statement
4096: INSERT INTO okl_g_reports_gt
4097: (
4098: -- String Formatted Columns
4099: value1_text
4100: ,value2_text

Line 4325: INSERT INTO okl_g_reports_gt

4321:
4322: -- Start the stop watch
4323: l_trace_time := SYSDATE;
4324: -- Actual Insert Statement
4325: INSERT INTO okl_g_reports_gt
4326: (
4327: -- String Formatted Columns
4328: value1_text
4329: ,value2_text

Line 4546: INSERT INTO okl_g_reports_gt

4542:
4543: -- Start the stop watch
4544: l_trace_time := SYSDATE;
4545: -- Actual Insert Statement
4546: INSERT INTO okl_g_reports_gt
4547: (
4548: -- String Formatted Columns
4549: value1_text
4550: ,value2_text

Line 4775: UPDATE okl_g_reports_gt gt

4771: -- Otherwsie also, change this Journal Type to GL_ACC_NON_SPEC_CRITERIA
4772: -- c. If the Journal is for a Contract whose product is not present in
4773: -- okl_g_products_gt, change this Journal Type to GL_ACC_NON_SPEC_CRITERIA
4774: -- Step 1:
4775: UPDATE okl_g_reports_gt gt
4776: SET value1_text = 'GL_ACC_NON_SPEC_CRITERIA'
4777: WHERE value1_text = 'GL_ACC_OLM_ENTRIES'
4778: -- Need to Cover Two Cases:
4779: -- Case 1: When Only the Transaction Type is mentioned

Line 4810: UPDATE okl_g_reports_gt gt

4806: -- is in the specified Criteria, check the Transaction Date
4807: -- If ithe Transaction Date is not lying in between the start and End Date
4808: -- change this Journal Type to GL_ACC_NON_SPEC_PERIOD
4809: -- Step 2:
4810: UPDATE okl_g_reports_gt gt
4811: SET value1_text = 'GL_ACC_NON_SPEC_PERIOD'
4812: ,value12_text -- trx_period_name
4813: = (
4814: SELECT per.period_name

Line 4843: INSERT INTO okl_g_reports_gt

4839: || TO_CHAR(l_trace_time, 'DD-MON-YYY HH:MM:SS') );
4840: -- Start the stop watch
4841: l_trace_time := SYSDATE;
4842: -- Actual Insert Statement
4843: INSERT INTO okl_g_reports_gt
4844: (
4845: -- String Formatted Columns
4846: value1_text
4847: ,value2_text

Line 5012: FROM okl_g_reports_gt gt

5008: AND xe.event_id
5009: NOT IN
5010: (
5011: SELECT DISTINCT gt.value15_num -- trx_xla_event_id
5012: FROM okl_g_reports_gt gt
5013: WHERE gt.value1_text IN
5014: (
5015: 'GL_ACC_OLM_ENTRIES'
5016: ,'GL_ACC_NON_SPEC_CRITERIA'

Line 5124: INSERT INTO okl_g_reports_gt

5120:
5121: -- Start the stop watch
5122: l_trace_time := SYSDATE;
5123: -- Actual Insert Statement
5124: INSERT INTO okl_g_reports_gt
5125: (
5126: -- String Formatted Columns
5127: value1_text
5128: ,value11_text

Line 5214: UPDATE okl_g_reports_gt lc

5210: -- But the Ledger Currency Balances in GL is sum of Balances in all the
5211: -- Transactional Currencies too. Hence, need to deduct the Sum of
5212: -- Opening Balances for all non Ledger Currencies from the Ledger Currencies
5213: -- if exists.
5214: UPDATE okl_g_reports_gt lc
5215: SET value1_num =
5216: value1_num -
5217: NVL(
5218: (

Line 5220: FROM okl_g_reports_gt nlc

5216: value1_num -
5217: NVL(
5218: (
5219: SELECT SUM(value2_num) -- Sum of Balance in Ledger Currency
5220: FROM okl_g_reports_gt nlc
5221: WHERE nlc.value1_text = 'GL_OPENING_BALANCE'
5222: AND nlc.value12_text = lc.value12_text -- Period Name
5223: AND nlc.value13_text = lc.value13_text -- Account Number
5224: AND nlc.value11_text <> lc.value11_text

Line 5231: FROM okl_g_reports_gt nlc

5227: value2_num -
5228: NVL(
5229: (
5230: SELECT SUM(value2_num) -- Sum of Balance in Ledger Currency
5231: FROM okl_g_reports_gt nlc
5232: WHERE nlc.value1_text = 'GL_OPENING_BALANCE'
5233: AND nlc.value12_text = lc.value12_text -- Period Name
5234: AND nlc.value13_text = lc.value13_text -- Account Number
5235: AND nlc.value11_text <> lc.value11_text

Line 5249: INSERT INTO okl_g_reports_gt

5245:
5246: --Bug:7535993 by nikshah
5247: --If no records found for OPENING BALANCE in GL
5248: --for natural account, enter 0 amount with ledger currency
5249: INSERT INTO okl_g_reports_gt
5250: (
5251: -- String Formatted Columns
5252: value1_text
5253: ,value11_text

Line 5272: from okl_g_reports_gt

5268: ,0 --value2_num
5269: FROM (select distinct account_number
5270: from okl_code_cmbns_gt) cgt
5271: WHERE cgt.account_number not in (select value13_text
5272: from okl_g_reports_gt
5273: where value1_text = 'GL_OPENING_BALANCE'
5274: );
5275:
5276: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',

Line 5296: INSERT INTO okl_g_reports_gt

5292: -- Start the stop watch
5293: l_trace_time := SYSDATE;
5294: -- Actual Insert Statement
5295:
5296: INSERT INTO okl_g_reports_gt
5297: (
5298: -- String Formatted Columns
5299: value1_text
5300: ,value11_text

Line 5417: UPDATE okl_g_reports_gt lc

5413: -- But the Ledger Currency Balances in GL is sum of Balances in all the
5414: -- Transactional Currencies too. Hence, need to deduct the Sum of
5415: -- Period Activity for all non Ledger Currencies from the Ledger Currencies
5416: -- if exists.
5417: UPDATE okl_g_reports_gt lc
5418: SET value1_num =
5419: value1_num -
5420: NVL(
5421: (

Line 5423: FROM okl_g_reports_gt nlc

5419: value1_num -
5420: NVL(
5421: (
5422: SELECT SUM(value2_num) -- Sum of Balance in Ledger Currency
5423: FROM okl_g_reports_gt nlc
5424: WHERE nlc.value1_text = 'GL_PERIOD_ACTIVITY'
5425: AND nlc.value12_text = lc.value12_text -- Period Name
5426: AND nlc.value13_text = lc.value13_text -- Account Number
5427: AND nlc.value11_text <> lc.value11_text

Line 5434: FROM okl_g_reports_gt nlc

5430: value2_num -
5431: NVL(
5432: (
5433: SELECT SUM(value2_num) -- Sum of Balance in Ledger Currency
5434: FROM okl_g_reports_gt nlc
5435: WHERE nlc.value1_text = 'GL_PERIOD_ACTIVITY'
5436: AND nlc.value12_text = lc.value12_text -- Period Name
5437: AND nlc.value13_text = lc.value13_text -- Account Number
5438: AND nlc.value11_text <> lc.value11_text

Line 5452: INSERT INTO okl_g_reports_gt

5448:
5449: --Bug:7535993 by nikshah
5450: --If no records found for Period Activity in GL
5451: --for natural account, enter 0 amount with ledger currency
5452: INSERT INTO okl_g_reports_gt
5453: (
5454: -- String Formatted Columns
5455: value1_text
5456: ,value11_text

Line 5476: from okl_g_reports_gt

5472: ,0 --value2_num
5473: FROM (select distinct account_number
5474: from okl_code_cmbns_gt) cgt
5475: WHERE cgt.account_number not in (select value13_text
5476: from okl_g_reports_gt
5477: where value1_text = 'GL_PERIOD_ACTIVITY'
5478: );
5479:
5480: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',

Line 5498: INSERT INTO okl_g_reports_gt

5494:
5495: -- Start the stop watch
5496: l_trace_time := SYSDATE;
5497: -- Actual Insert Statement
5498: INSERT INTO okl_g_reports_gt
5499: (
5500: -- String Formatted Columns
5501: value1_text
5502: ,value11_text

Line 5613: UPDATE okl_g_reports_gt lc

5609: -- But the Ledger Currency Balances in GL is sum of Balances in all the
5610: -- Transactional Currencies too. Hence, need to deduct the Sum of
5611: -- Opening Balances for all non Ledger Currencies from the Ledger Currencies
5612: -- if exists.
5613: UPDATE okl_g_reports_gt lc
5614: SET value1_num =
5615: value1_num -
5616: NVL(
5617: (

Line 5619: FROM okl_g_reports_gt nlc

5615: value1_num -
5616: NVL(
5617: (
5618: SELECT SUM(value2_num) -- Sum of Balance in Ledger Currency
5619: FROM okl_g_reports_gt nlc
5620: WHERE nlc.value1_text = 'GL_CLOSING_BALANCE'
5621: AND nlc.value12_text = lc.value12_text -- Period Name
5622: AND nlc.value13_text = lc.value13_text -- Account Number
5623: AND nlc.value11_text <> lc.value11_text

Line 5630: FROM okl_g_reports_gt nlc

5626: value2_num -
5627: NVL(
5628: (
5629: SELECT SUM(value2_num) -- Sum of Balance in Ledger Currency
5630: FROM okl_g_reports_gt nlc
5631: WHERE nlc.value1_text = 'GL_CLOSING_BALANCE'
5632: AND nlc.value12_text = lc.value12_text -- Period Name
5633: AND nlc.value13_text = lc.value13_text -- Account Number
5634: AND nlc.value11_text <> lc.value11_text

Line 5648: INSERT INTO okl_g_reports_gt

5644:
5645: --Bug:7535993 by nikshah
5646: --If no records found for CLOSING BALANCE in GL
5647: --for natural account, enter 0 amount with ledger currency
5648: INSERT INTO okl_g_reports_gt
5649: (
5650: -- String Formatted Columns
5651: value1_text
5652: ,value11_text

Line 5672: from okl_g_reports_gt

5668: ,0 --value2_num
5669: FROM (select distinct account_number
5670: from okl_code_cmbns_gt) cgt
5671: WHERE cgt.account_number not in (select value13_text
5672: from okl_g_reports_gt
5673: where value1_text = 'GL_CLOSING_BALANCE'
5674: );
5675:
5676: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',

Line 5688: INSERT INTO okl_g_reports_gt

5684: -- Always need to show the GL Closing and Opening Balances, when there are entries
5685: -- in the Streams Closing and Opening Balances. So that the Report generated fillay
5686: -- shows the GL and Stream Balance headers.
5687: -- Case 1: Insert GL Closing Balance record for which we have Streams Closing Balance
5688: INSERT INTO okl_g_reports_gt
5689: (
5690: -- String Formatted Columns
5691: value1_text
5692: ,value11_text

Line 5706: FROM okl_g_reports_gt

5702: ,NULL --value12_text
5703: ,NULL --value13_text
5704: ,0 --value1_num
5705: ,0 --value2_num
5706: FROM okl_g_reports_gt
5707: WHERE value1_text IN ( 'OKL_STR_CLOSE' )
5708: AND value11_text
5709: NOT IN
5710: (

Line 5712: FROM okl_g_reports_gt

5708: AND value11_text
5709: NOT IN
5710: (
5711: SELECT DISTINCT value11_text
5712: FROM okl_g_reports_gt
5713: WHERE value1_text = 'GL_CLOSING_BALANCE'
5714: )
5715: GROUP BY 'GL_CLOSING_BALANCE'
5716: ,value11_text;

Line 5720: INSERT INTO okl_g_reports_gt

5716: ,value11_text;
5717:
5718:
5719: -- Case 2: Insert GL Opening Balance record for which we have Streams Opening Balance
5720: INSERT INTO okl_g_reports_gt
5721: (
5722: -- String Formatted Columns
5723: value1_text
5724: ,value11_text

Line 5738: FROM okl_g_reports_gt

5734: ,NULL --value12_text
5735: ,NULL --value13_text
5736: ,0 --value1_num
5737: ,0 --value2_num
5738: FROM okl_g_reports_gt
5739: WHERE value1_text IN ( 'OKL_STR_OPEN' )
5740: AND value11_text
5741: NOT IN
5742: (

Line 5744: FROM okl_g_reports_gt

5740: AND value11_text
5741: NOT IN
5742: (
5743: SELECT DISTINCT value11_text
5744: FROM okl_g_reports_gt
5745: WHERE value1_text = 'GL_OPENING_BALANCE'
5746: )
5747: GROUP BY 'GL_OPENING_BALANCE'
5748: ,value11_text;

Line 5750: INSERT INTO okl_g_reports_gt

5746: )
5747: GROUP BY 'GL_OPENING_BALANCE'
5748: ,value11_text;
5749: -- Case 3: Insert Stream Closing Balance record for which we have GL Closing Balance
5750: INSERT INTO okl_g_reports_gt
5751: (
5752: -- String Formatted Columns
5753: value1_text
5754: ,value11_text

Line 5766: FROM okl_g_reports_gt

5762: ,value11_text --value11_text -- Currency Code
5763: ,NULL --value5_text
5764: ,NULL --value14_text
5765: ,0 --value3_num
5766: FROM okl_g_reports_gt
5767: WHERE value1_text IN ( 'GL_CLOSING_BALANCE' )
5768: AND value11_text
5769: NOT IN
5770: (

Line 5772: FROM okl_g_reports_gt

5768: AND value11_text
5769: NOT IN
5770: (
5771: SELECT DISTINCT value11_text
5772: FROM okl_g_reports_gt
5773: WHERE value1_text = 'OKL_STR_CLOSE'
5774: )
5775: GROUP BY 'OKL_STR_CLOSE'
5776: ,value11_text;

Line 5779: INSERT INTO okl_g_reports_gt

5775: GROUP BY 'OKL_STR_CLOSE'
5776: ,value11_text;
5777:
5778: -- Case 4: Insert Stream Opening Balance record for which we have GL Opening Balance
5779: INSERT INTO okl_g_reports_gt
5780: (
5781: -- String Formatted Columns
5782: value1_text
5783: ,value11_text

Line 5795: FROM okl_g_reports_gt

5791: ,value11_text --value11_text -- Currency Code
5792: ,NULL --value5_text
5793: ,NULL --value14_text
5794: ,0 --value3_num
5795: FROM okl_g_reports_gt
5796: WHERE value1_text IN ( 'GL_OPENING_BALANCE' )
5797: AND value11_text
5798: NOT IN
5799: (

Line 5801: FROM okl_g_reports_gt

5797: AND value11_text
5798: NOT IN
5799: (
5800: SELECT DISTINCT value11_text
5801: FROM okl_g_reports_gt
5802: WHERE value1_text = 'OKL_STR_OPEN'
5803: )
5804: GROUP BY 'OKL_STR_OPEN'
5805: ,value11_text;

Line 5860: TYPE rep_gt_tbl_type IS TABLE OF okl_g_reports_gt%ROWTYPE

5856: -- Local Variable Declarations
5857: l_error_out VARCHAR2(1);
5858: l_check_access VARCHAR2(1);
5859:
5860: TYPE rep_gt_tbl_type IS TABLE OF okl_g_reports_gt%ROWTYPE
5861: INDEX BY BINARY_INTEGER;
5862: l_invalid_orgs_tbl rep_gt_tbl_type;
5863: i NUMBER;
5864: BEGIN

Line 5907: INSERT INTO okl_g_reports_gt VALUES l_invalid_orgs_tbl(i);

5903: IF l_error_out = 'Y'
5904: THEN
5905: -- Finally insert the list of Invalid Org Names to print it on the Report
5906: FORALL i IN l_invalid_orgs_tbl.FIRST .. l_invalid_orgs_tbl.LAST
5907: INSERT INTO okl_g_reports_gt VALUES l_invalid_orgs_tbl(i);
5908:
5909: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
5910: 'Returning FALSE. End API OKL_REPORT_GENERATOR_PVT.' || l_api_name );
5911: RETURN FALSE;

Line 7058: ' Inserting records in okl_g_reports_gt table for expected sum of stream elements amount');

7054: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
7055: END IF;
7056:
7057: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7058: ' Inserting records in okl_g_reports_gt table for expected sum of stream elements amount');
7059:
7060: FORALL i IN l_exp_streams_tbl.FIRST..l_exp_streams_tbl.LAST
7061: INSERT INTO okl_g_reports_gt VALUES l_exp_streams_tbl(i);
7062:

Line 7061: INSERT INTO okl_g_reports_gt VALUES l_exp_streams_tbl(i);

7057: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7058: ' Inserting records in okl_g_reports_gt table for expected sum of stream elements amount');
7059:
7060: FORALL i IN l_exp_streams_tbl.FIRST..l_exp_streams_tbl.LAST
7061: INSERT INTO okl_g_reports_gt VALUES l_exp_streams_tbl(i);
7062:
7063: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7064: ' Inserting all records into okl_g_reports_gt');
7065:

Line 7064: ' Inserting all records into okl_g_reports_gt');

7060: FORALL i IN l_exp_streams_tbl.FIRST..l_exp_streams_tbl.LAST
7061: INSERT INTO okl_g_reports_gt VALUES l_exp_streams_tbl(i);
7062:
7063: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7064: ' Inserting all records into okl_g_reports_gt');
7065:
7066: --At this point of time we will have details of all buckets, so just bulk insert into GT table
7067: FORALL i IN l_reports_tbl.FIRST..l_reports_tbl.LAST
7068: INSERT INTO okl_g_reports_gt VALUES l_reports_tbl(i);

Line 7068: INSERT INTO okl_g_reports_gt VALUES l_reports_tbl(i);

7064: ' Inserting all records into okl_g_reports_gt');
7065:
7066: --At this point of time we will have details of all buckets, so just bulk insert into GT table
7067: FORALL i IN l_reports_tbl.FIRST..l_reports_tbl.LAST
7068: INSERT INTO okl_g_reports_gt VALUES l_reports_tbl(i);
7069:
7070: --Now whatever allotted in NON_SPEC_STRMS_ASE bucket,
7071: --we want to populate same in NON_SPEC_PERIOD_TRX_SPEC_PERIOD bucket
7072: --if it was accounted and posted

Line 7075: INSERT INTO okl_g_reports_gt

7071: --we want to populate same in NON_SPEC_PERIOD_TRX_SPEC_PERIOD bucket
7072: --if it was accounted and posted
7073: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7074: ' Populating NON_SPEC_PERIOD_TRX_SPEC_PERIOD bucket based on NON_SPEC_STRMS_ASE bucket');
7075: INSERT INTO okl_g_reports_gt
7076: ( value1_text --Bucket name
7077: ,value2_text --trx number
7078: ,value3_text --trx_type name
7079: ,value4_text --application name

Line 7417: INSERT INTO OKL_G_REPORTS_GT ( VALUE1_TEXT )

7413: IF l_proceed_flag = FALSE
7414: THEN
7415: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7416: 'Validation Failed !!! Erroring Out !!!!');
7417: INSERT INTO OKL_G_REPORTS_GT ( VALUE1_TEXT )
7418: VALUES ('OKL_RECON_REP_NO_ACCESS' );
7419: RETURN TRUE; -- Always return TRUE
7420: END IF;
7421: -- Fetch the Operating Unit