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.FII_AP_INV_SUM_INIT dependencies on FII_AP_PAY_SCHED_B

Line 1523: INSERT INTO FII_AP_PAY_SCHED_B b

1519: action date for a voided payment would be the same as the payment creation
1520: and the report would show wrong results for past periods. */
1521:
1522:
1523: INSERT INTO FII_AP_PAY_SCHED_B b
1524: (Time_ID,
1525: Period_Type_ID,
1526: Action_Date,
1527: Action,

Line 1918: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Payment records into FII_AP_PAY_SCHED_B');

1914: AND RATES.Trx_Date = PSUM.Invoice_Date;
1915:
1916:
1917: if g_debug_flag = 'Y' then
1918: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Payment records into FII_AP_PAY_SCHED_B');
1919: FII_UTIL.put_timestamp('End Timestamp');
1920: FII_UTIL.stop_timer;
1921: FII_UTIL.print_timer('Duration');
1922: FII_UTIL.put_line('');

Line 2070: FROM FII_AP_Pay_Sched_B PSUM,

2066: PS.Payment_Num Payment_Num,
2067: SUM(Discount_Available) Discount_Available,
2068: SUM(Discount_Lost) Discount_Lost,
2069: SUM(Discount_Taken) Discount_Taken
2070: FROM FII_AP_Pay_Sched_B PSUM,
2071: AP_Payment_Schedules_All PS
2072: WHERE PS.Invoice_ID BETWEEN g_start_range and g_end_range
2073: AND PS.Invoice_ID = PSUM.Invoice_ID (+)
2074: AND PS.Payment_Num = PSUM.Payment_Num (+)

Line 2196: INSERT INTO FII_AP_PAY_SCHED_B b

2192: FII_UTIL.start_timer;
2193: FII_UTIL.put_line('');
2194: end if;
2195:
2196: INSERT INTO FII_AP_PAY_SCHED_B b
2197: (Time_ID,
2198: Period_Type_ID,
2199: Action_Date,
2200: Action,

Line 2431: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Payment records into FII_AP_PAY_SCHED_B from Temp table');

2427: AND RATES.Trx_Date = TEMP.Trx_Date;
2428:
2429:
2430: if g_debug_flag = 'Y' then
2431: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Payment records into FII_AP_PAY_SCHED_B from Temp table');
2432: FII_UTIL.put_timestamp('End Timestamp');
2433: FII_UTIL.stop_timer;
2434: FII_UTIL.print_timer('Duration');
2435: FII_UTIL.put_line('');

Line 2457: INSERT INTO FII_AP_PAY_SCHED_B b

2453: will populate the On_Time_Payment_Amt column with the payment amount */
2454:
2455:
2456:
2457: INSERT INTO FII_AP_PAY_SCHED_B b
2458: (Time_ID,
2459: Period_Type_ID,
2460: Action_Date,
2461: Action,

Line 2855: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Withholding records into FII_AP_PAY_SCHED_B');

2851:
2852:
2853:
2854: if g_debug_flag = 'Y' then
2855: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Withholding records into FII_AP_PAY_SCHED_B');
2856: FII_UTIL.put_timestamp('End Timestamp');
2857: FII_UTIL.stop_timer;
2858: FII_UTIL.print_timer('Duration');
2859: FII_UTIL.put_line('');

Line 2872: INSERT INTO FII_AP_PAY_SCHED_B b

2868: FII_UTIL.start_timer;
2869: FII_UTIL.put_line('');
2870: end if;
2871:
2872: INSERT INTO FII_AP_PAY_SCHED_B b
2873: (Time_ID,
2874: Period_Type_ID,
2875: Action_Date,
2876: Action,

Line 3312: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Prepayment records into FII_AP_PAY_SCHED_B ');

3308: AND RATES.Trx_Date = AI.Invoice_Date
3309: AND AI.Payment_Currency_Code = FC.Currency_Code;
3310:
3311: if g_debug_flag = 'Y' then
3312: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Prepayment records into FII_AP_PAY_SCHED_B ');
3313: FII_UTIL.put_timestamp('End Timestamp');
3314: FII_UTIL.stop_timer;
3315: FII_UTIL.print_timer('Duration');
3316: FII_UTIL.put_line('');

Line 3371: INSERT INTO FII_AP_PAY_SCHED_B b

3367: We will insert only those payment schedules which have not been paid
3368: fully before the first discount date. This check is done by comparing
3369: the gross amount with the payment, prepayment and withheld amount */
3370:
3371: INSERT INTO FII_AP_PAY_SCHED_B b
3372: (Time_ID,
3373: Period_Type_ID,
3374: Action_Date,
3375: Action,

Line 3610: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');

3606: + NVL(PP.Prepay_Amount,0)) < ABS(PS.Gross_Amount);
3607:
3608:
3609: if g_debug_flag = 'Y' then
3610: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');
3611: FII_UTIL.put_timestamp('End Timestamp');
3612: FII_UTIL.stop_timer;
3613: FII_UTIL.print_timer('Duration');
3614: FII_UTIL.put_line('');

Line 3634: INSERT INTO FII_AP_PAY_SCHED_B b

3630: We will insert only those payment schedules which have not be paid
3631: fully before the second discount date. This check is done by comparing
3632: the gross amount with the payment, prepayment and withheld amount */
3633:
3634: INSERT INTO FII_AP_PAY_SCHED_B b
3635: (Time_ID,
3636: Period_Type_ID,
3637: Action_Date,
3638: Action,

Line 3884: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');

3880: + NVL(PP.Prepay_Amount,0)) < ABS(PS.Gross_Amount);
3881:
3882:
3883: if g_debug_flag = 'Y' then
3884: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');
3885: FII_UTIL.put_timestamp('End Timestamp');
3886: FII_UTIL.stop_timer;
3887: FII_UTIL.print_timer('Duration');
3888: FII_UTIL.put_line('');

Line 3908: INSERT INTO FII_AP_PAY_SCHED_B b

3904: We will insert only those payment schedules which have not be paid
3905: fully before the third discount date. This check is done by comparing
3906: the gross amount with the payment, prepayment and withheld amount */
3907:
3908: INSERT INTO FII_AP_PAY_SCHED_B b
3909: (Time_ID,
3910: Period_Type_ID,
3911: Action_Date,
3912: Action,

Line 4149: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');

4145: + NVL(PP.Prepay_Amount,0)) < ABS(PS.Gross_Amount);
4146:
4147:
4148: if g_debug_flag = 'Y' then
4149: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');
4150: FII_UTIL.put_timestamp('End Timestamp');
4151: FII_UTIL.stop_timer;
4152: FII_UTIL.print_timer('Duration');
4153: FII_UTIL.put_line('');

Line 4202: INSERT INTO FII_AP_PAY_SCHED_B b

4198: We will insert only those payment schedules which have not been paid
4199: fully before the due date. This check is done by comparing
4200: the gross amount with the payment, prepayment and withheld amount */
4201:
4202: INSERT INTO FII_AP_PAY_SCHED_B b
4203: (Time_ID,
4204: Period_Type_ID,
4205: Action_Date,
4206: Action,

Line 4474: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due records into FII_AP_PAY_SCHED_B');

4470: + NVL(PP.Prepay_Amount,0)) < ABS(PS.Gross_Amount);
4471:
4472:
4473: if g_debug_flag = 'Y' then
4474: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due records into FII_AP_PAY_SCHED_B');
4475: FII_UTIL.put_timestamp('End Timestamp');
4476: FII_UTIL.stop_timer;
4477: FII_UTIL.print_timer('Duration');
4478: FII_UTIL.put_line('');

Line 4526: INSERT INTO FII_AP_PAY_SCHED_B b

4522: We will insert only those payment schedules which have not been paid
4523: fully before the due bucket2. This check is done by comparing
4524: the gross amount with the payment, prepayment and withheld amount */
4525:
4526: INSERT INTO FII_AP_PAY_SCHED_B b
4527: (Time_ID,
4528: Period_Type_ID,
4529: Action_Date,
4530: Action,

Line 4776: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due Bucket2 records into FII_AP_PAY_SCHED_B');

4772: + NVL(PP.Prepay_Amount,0)) < ABS(PS.Gross_Amount);
4773:
4774:
4775: if g_debug_flag = 'Y' then
4776: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due Bucket2 records into FII_AP_PAY_SCHED_B');
4777: FII_UTIL.put_timestamp('End Timestamp');
4778: FII_UTIL.stop_timer;
4779: FII_UTIL.print_timer('Duration');
4780: FII_UTIL.put_line('');

Line 4801: INSERT INTO FII_AP_PAY_SCHED_B b

4797: We will insert only those payment schedules which have not been paid
4798: fully before the due bucket3. This check is done by comparing
4799: the gross amount with the payment, prepayment and withheld amount */
4800:
4801: INSERT INTO FII_AP_PAY_SCHED_B b
4802: (Time_ID,
4803: Period_Type_ID,
4804: Action_Date,
4805: Action,

Line 5051: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due Bucket3 records into FII_AP_PAY_SCHED_B');

5047: + NVL(PP.Prepay_Amount,0)) < ABS(PS.Gross_Amount);
5048:
5049:
5050: if g_debug_flag = 'Y' then
5051: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due Bucket3 records into FII_AP_PAY_SCHED_B');
5052: FII_UTIL.put_timestamp('End Timestamp');
5053: FII_UTIL.stop_timer;
5054: FII_UTIL.print_timer('Duration');
5055: FII_UTIL.put_line('');

Line 5103: INSERT INTO FII_AP_PAY_SCHED_B b

5099: We will insert only those payment schedules which have not been paid
5100: fully before the past due bucket2. This check is done by comparing
5101: the gross amount with the payment, prepayment and withheld amount */
5102:
5103: INSERT INTO FII_AP_PAY_SCHED_B b
5104: (Time_ID,
5105: Period_Type_ID,
5106: Action_Date,
5107: Action,

Line 5353: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Past Due Bucket2 records into FII_AP_PAY_SCHED_B');

5349: + NVL(PP.Prepay_Amount,0)) < ABS(PS.Gross_Amount);
5350:
5351:
5352: if g_debug_flag = 'Y' then
5353: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Past Due Bucket2 records into FII_AP_PAY_SCHED_B');
5354: FII_UTIL.put_timestamp('End Timestamp');
5355: FII_UTIL.stop_timer;
5356: FII_UTIL.print_timer('Duration');
5357: end if;

Line 5376: INSERT INTO FII_AP_PAY_SCHED_B b

5372: We will insert only those payment schedules which have not been paid
5373: fully before the past due bucket2. This check is done by comparing
5374: the gross amount with the payment, prepayment and withheld amount */
5375:
5376: INSERT INTO FII_AP_PAY_SCHED_B b
5377: (Time_ID,
5378: Period_Type_ID,
5379: Action_Date,
5380: Action,

Line 5626: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Past Due Bucket1 records into FII_AP_PAY_SCHED_B');

5622: + NVL(PP.Prepay_Amount,0)) < ABS(PS.Gross_Amount);
5623:
5624:
5625: if g_debug_flag = 'Y' then
5626: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Past Due Bucket1 records into FII_AP_PAY_SCHED_B');
5627: FII_UTIL.put_timestamp('End Timestamp');
5628: FII_UTIL.stop_timer;
5629: FII_UTIL.print_timer('Duration');
5630: FII_UTIL.put_line('');

Line 5676: SELECT fii_ap_pay_sched_b_s.nextval

5672: FII_UTIL.put_line('g_start_range is '|| g_start_range);
5673: FII_UTIL.put_line('g_end_range is '|| g_end_range);
5674: end if;
5675:
5676: SELECT fii_ap_pay_sched_b_s.nextval
5677: INTO g_seq_id
5678: FROM dual;
5679:
5680: g_state := 'Populating FII_AP_PAY_SCHED_B FROM AP_PAYMENT_SCHEDULES_ALL table';

Line 5680: g_state := 'Populating FII_AP_PAY_SCHED_B FROM AP_PAYMENT_SCHEDULES_ALL table';

5676: SELECT fii_ap_pay_sched_b_s.nextval
5677: INTO g_seq_id
5678: FROM dual;
5679:
5680: g_state := 'Populating FII_AP_PAY_SCHED_B FROM AP_PAYMENT_SCHEDULES_ALL table';
5681: if g_debug_flag = 'Y' then
5682: FII_UTIL.put_line(g_state);
5683: end if;
5684:

Line 5693: INSERT INTO FII_AP_PAY_SCHED_B b

5689: FII_UTIL.start_timer;
5690: FII_UTIL.put_line('');
5691: end if;
5692:
5693: INSERT INTO FII_AP_PAY_SCHED_B b
5694: (Time_ID,
5695: Period_Type_ID,
5696: Action_Date,
5697: Action,

Line 5977: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Creation records into FII_AP_PAY_SCHED_B');

5973: AND RATES.Trx_Date = PSUM.Invoice_Date;
5974:
5975:
5976: if g_debug_flag = 'Y' then
5977: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Creation records into FII_AP_PAY_SCHED_B');
5978: FII_UTIL.put_timestamp('End Timestamp');
5979: FII_UTIL.stop_timer;
5980: FII_UTIL.print_timer('Duration');
5981: FII_UTIL.put_line('');

Line 6701: -- Payment Schedule Summarization and populating FII_AP_PAY_SCHED_B

6697:
6698: --------------------------------------------------
6699: -- PROCEDURE WORKER
6700: -- This Worker routine Handles all functions involved in the
6701: -- Payment Schedule Summarization and populating FII_AP_PAY_SCHED_B
6702: -- summary table.
6703:
6704: ---------------------------------------------------
6705: PROCEDURE WORKER(Errbuf IN OUT NOCOPY VARCHAR2,

Line 7104: g_state := 'Deleting records from FII_AP_PAY_SCHED_B that are already existing';

7100:
7101: REGISTER_JOBS;
7102: COMMIT;
7103:
7104: g_state := 'Deleting records from FII_AP_PAY_SCHED_B that are already existing';
7105: /* For Initial Load we will truncate the data in the pay sched summary table
7106: and re-populate this table */
7107: TRUNCATE_TABLE('MLOG$_FII_AP_PAY_SCHED_B');
7108: TRUNCATE_TABLE('FII_AP_PAY_SCHED_B');

Line 7107: TRUNCATE_TABLE('MLOG$_FII_AP_PAY_SCHED_B');

7103:
7104: g_state := 'Deleting records from FII_AP_PAY_SCHED_B that are already existing';
7105: /* For Initial Load we will truncate the data in the pay sched summary table
7106: and re-populate this table */
7107: TRUNCATE_TABLE('MLOG$_FII_AP_PAY_SCHED_B');
7108: TRUNCATE_TABLE('FII_AP_PAY_SCHED_B');
7109:
7110: FND_PROFILE.PUT('CONC_SINGLE_THREAD','N');
7111:

Line 7108: TRUNCATE_TABLE('FII_AP_PAY_SCHED_B');

7104: g_state := 'Deleting records from FII_AP_PAY_SCHED_B that are already existing';
7105: /* For Initial Load we will truncate the data in the pay sched summary table
7106: and re-populate this table */
7107: TRUNCATE_TABLE('MLOG$_FII_AP_PAY_SCHED_B');
7108: TRUNCATE_TABLE('FII_AP_PAY_SCHED_B');
7109:
7110: FND_PROFILE.PUT('CONC_SINGLE_THREAD','N');
7111:
7112: --------------------------------------------------------