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.FV_SLA_PROCESSING_PKG dependencies on FV_EXTRACT_DETAIL_GT

Line 34: TYPE fv_ref_detail IS TABLE OF FV_EXTRACT_DETAIL_GT%ROWTYPE

30: CRLF CONSTANT VARCHAR2(1) := FND_GLOBAL.newline;
31:
32:
33:
34: TYPE fv_ref_detail IS TABLE OF FV_EXTRACT_DETAIL_GT%ROWTYPE
35: INDEX BY BINARY_INTEGER;
36:
37: TYPE fv_extract_rec IS RECORD
38: (

Line 41: fund_value fv_extract_detail_gt.fund_value%TYPE := 'X',

37: TYPE fv_extract_rec IS RECORD
38: (
39: event_id NUMBER,
40: line_number NUMBER,
41: fund_value fv_extract_detail_gt.fund_value%TYPE := 'X',
42: fund_category fv_extract_detail_gt.fund_category%TYPE DEFAULT 'N',
43: fund_expired_status fv_extract_detail_gt.fund_expired_status%TYPE DEFAULT 'NONE',
44: fund_time_frame fv_extract_detail_gt.fund_time_frame%TYPE DEFAULT 'NONE',
45: prior_year_flag fv_extract_detail_gt.prior_year_flag%TYPE DEFAULT 'N',

Line 42: fund_category fv_extract_detail_gt.fund_category%TYPE DEFAULT 'N',

38: (
39: event_id NUMBER,
40: line_number NUMBER,
41: fund_value fv_extract_detail_gt.fund_value%TYPE := 'X',
42: fund_category fv_extract_detail_gt.fund_category%TYPE DEFAULT 'N',
43: fund_expired_status fv_extract_detail_gt.fund_expired_status%TYPE DEFAULT 'NONE',
44: fund_time_frame fv_extract_detail_gt.fund_time_frame%TYPE DEFAULT 'NONE',
45: prior_year_flag fv_extract_detail_gt.prior_year_flag%TYPE DEFAULT 'N',
46: account_rule fv_extract_detail_gt.account_rule%TYPE DEFAULT 'DEFAULT',

Line 43: fund_expired_status fv_extract_detail_gt.fund_expired_status%TYPE DEFAULT 'NONE',

39: event_id NUMBER,
40: line_number NUMBER,
41: fund_value fv_extract_detail_gt.fund_value%TYPE := 'X',
42: fund_category fv_extract_detail_gt.fund_category%TYPE DEFAULT 'N',
43: fund_expired_status fv_extract_detail_gt.fund_expired_status%TYPE DEFAULT 'NONE',
44: fund_time_frame fv_extract_detail_gt.fund_time_frame%TYPE DEFAULT 'NONE',
45: prior_year_flag fv_extract_detail_gt.prior_year_flag%TYPE DEFAULT 'N',
46: account_rule fv_extract_detail_gt.account_rule%TYPE DEFAULT 'DEFAULT',
47: receivable_with_advance fv_extract_detail_gt.receivable_with_advance%TYPE DEFAULT 'N'

Line 44: fund_time_frame fv_extract_detail_gt.fund_time_frame%TYPE DEFAULT 'NONE',

40: line_number NUMBER,
41: fund_value fv_extract_detail_gt.fund_value%TYPE := 'X',
42: fund_category fv_extract_detail_gt.fund_category%TYPE DEFAULT 'N',
43: fund_expired_status fv_extract_detail_gt.fund_expired_status%TYPE DEFAULT 'NONE',
44: fund_time_frame fv_extract_detail_gt.fund_time_frame%TYPE DEFAULT 'NONE',
45: prior_year_flag fv_extract_detail_gt.prior_year_flag%TYPE DEFAULT 'N',
46: account_rule fv_extract_detail_gt.account_rule%TYPE DEFAULT 'DEFAULT',
47: receivable_with_advance fv_extract_detail_gt.receivable_with_advance%TYPE DEFAULT 'N'
48: );

Line 45: prior_year_flag fv_extract_detail_gt.prior_year_flag%TYPE DEFAULT 'N',

41: fund_value fv_extract_detail_gt.fund_value%TYPE := 'X',
42: fund_category fv_extract_detail_gt.fund_category%TYPE DEFAULT 'N',
43: fund_expired_status fv_extract_detail_gt.fund_expired_status%TYPE DEFAULT 'NONE',
44: fund_time_frame fv_extract_detail_gt.fund_time_frame%TYPE DEFAULT 'NONE',
45: prior_year_flag fv_extract_detail_gt.prior_year_flag%TYPE DEFAULT 'N',
46: account_rule fv_extract_detail_gt.account_rule%TYPE DEFAULT 'DEFAULT',
47: receivable_with_advance fv_extract_detail_gt.receivable_with_advance%TYPE DEFAULT 'N'
48: );
49:

Line 46: account_rule fv_extract_detail_gt.account_rule%TYPE DEFAULT 'DEFAULT',

42: fund_category fv_extract_detail_gt.fund_category%TYPE DEFAULT 'N',
43: fund_expired_status fv_extract_detail_gt.fund_expired_status%TYPE DEFAULT 'NONE',
44: fund_time_frame fv_extract_detail_gt.fund_time_frame%TYPE DEFAULT 'NONE',
45: prior_year_flag fv_extract_detail_gt.prior_year_flag%TYPE DEFAULT 'N',
46: account_rule fv_extract_detail_gt.account_rule%TYPE DEFAULT 'DEFAULT',
47: receivable_with_advance fv_extract_detail_gt.receivable_with_advance%TYPE DEFAULT 'N'
48: );
49:
50:

Line 47: receivable_with_advance fv_extract_detail_gt.receivable_with_advance%TYPE DEFAULT 'N'

43: fund_expired_status fv_extract_detail_gt.fund_expired_status%TYPE DEFAULT 'NONE',
44: fund_time_frame fv_extract_detail_gt.fund_time_frame%TYPE DEFAULT 'NONE',
45: prior_year_flag fv_extract_detail_gt.prior_year_flag%TYPE DEFAULT 'N',
46: account_rule fv_extract_detail_gt.account_rule%TYPE DEFAULT 'DEFAULT',
47: receivable_with_advance fv_extract_detail_gt.receivable_with_advance%TYPE DEFAULT 'N'
48: );
49:
50:
51: /*PROCEDURE DEBUG(p_debug IN VARCHAR2);

Line 2105: INSERT INTO FV_EXTRACT_DETAIL_GT VALUES l_fv_extract_detail(l_index);

2101:
2102:
2103: -- check if any req transactions are to be included
2104: FORALL l_Index IN l_fv_extract_detail.first..l_fv_extract_detail.last
2105: INSERT INTO FV_EXTRACT_DETAIL_GT VALUES l_fv_extract_detail(l_index);
2106:
2107: -- ================================== FND_LOG ==================================
2108: l_debug_info := 'No of rows inserted into FV_EXTRACT_DETAIL_GT: '|| SQL%ROWCOUNT;
2109: trace(C_STATE_LEVEL, l_procedure_name, l_debug_info );

Line 2108: l_debug_info := 'No of rows inserted into FV_EXTRACT_DETAIL_GT: '|| SQL%ROWCOUNT;

2104: FORALL l_Index IN l_fv_extract_detail.first..l_fv_extract_detail.last
2105: INSERT INTO FV_EXTRACT_DETAIL_GT VALUES l_fv_extract_detail(l_index);
2106:
2107: -- ================================== FND_LOG ==================================
2108: l_debug_info := 'No of rows inserted into FV_EXTRACT_DETAIL_GT: '|| SQL%ROWCOUNT;
2109: trace(C_STATE_LEVEL, l_procedure_name, l_debug_info );
2110: -- ================================== FND_LOG ==================================
2111:
2112: l_index := 0;

Line 2420: INSERT INTO FV_EXTRACT_DETAIL_GT VALUES l_fv_extract_detail(l_index);

2416: END IF;
2417: END LOOP;
2418:
2419: FORALL l_index IN l_fv_extract_detail .first..l_fv_extract_detail.last
2420: INSERT INTO FV_EXTRACT_DETAIL_GT VALUES l_fv_extract_detail(l_index);
2421: l_index := 0;
2422: -------------------------------------------------------------------------
2423: l_debug_info := 'End of procedure'||l_procedure_name;
2424: trace(C_PROC_LEVEL, l_procedure_name, l_debug_info);

Line 2898: INSERT INTO FV_EXTRACT_DETAIL_GT VALUES l_fv_extract_detail(l_index);

2894: --- end
2895: -- Handled separtely in treasury confirmation
2896:
2897: FORALL l_Index IN l_fv_extract_detail.first..l_fv_extract_detail.last
2898: INSERT INTO FV_EXTRACT_DETAIL_GT VALUES l_fv_extract_detail(l_index);
2899:
2900: l_debug_info := 'Number of Rows inserted into FV_EXTRACT_DETAIL_GT: '|| SQL%ROWCOUNT;
2901: trace(C_STATE_LEVEL, l_procedure_name, l_debug_info );
2902:

Line 2900: l_debug_info := 'Number of Rows inserted into FV_EXTRACT_DETAIL_GT: '|| SQL%ROWCOUNT;

2896:
2897: FORALL l_Index IN l_fv_extract_detail.first..l_fv_extract_detail.last
2898: INSERT INTO FV_EXTRACT_DETAIL_GT VALUES l_fv_extract_detail(l_index);
2899:
2900: l_debug_info := 'Number of Rows inserted into FV_EXTRACT_DETAIL_GT: '|| SQL%ROWCOUNT;
2901: trace(C_STATE_LEVEL, l_procedure_name, l_debug_info );
2902:
2903: l_index := 0;
2904:

Line 3050: l_fund_value fv_extract_detail_gt.fund_value%TYPE;

3046: l_ar_event_type xla_events_gt.event_type_code%TYPE;
3047: l_ar_inv_extract_details cur_ar_inv_extract_details%ROWTYPE;
3048: l_ar_rct_extract_details cur_ar_rct_extract_details%ROWTYPE;
3049: l_misc_rct_extract_details cur_misc_rct_extract_details%ROWTYPE;
3050: l_fund_value fv_extract_detail_gt.fund_value%TYPE;
3051: l_head_fund_value fv_extract_detail_gt.fund_value%TYPE;
3052: l_head_fund_category fv_extract_detail_gt.fund_category%TYPE;
3053: l_fund_expired_status fv_extract_detail_gt.fund_expired_status%TYPE;
3054: l_fund_category fv_extract_detail_gt.fund_category%TYPE;

Line 3051: l_head_fund_value fv_extract_detail_gt.fund_value%TYPE;

3047: l_ar_inv_extract_details cur_ar_inv_extract_details%ROWTYPE;
3048: l_ar_rct_extract_details cur_ar_rct_extract_details%ROWTYPE;
3049: l_misc_rct_extract_details cur_misc_rct_extract_details%ROWTYPE;
3050: l_fund_value fv_extract_detail_gt.fund_value%TYPE;
3051: l_head_fund_value fv_extract_detail_gt.fund_value%TYPE;
3052: l_head_fund_category fv_extract_detail_gt.fund_category%TYPE;
3053: l_fund_expired_status fv_extract_detail_gt.fund_expired_status%TYPE;
3054: l_fund_category fv_extract_detail_gt.fund_category%TYPE;
3055: l_fund_time_frame fv_extract_detail_gt.fund_time_frame%TYPE;

Line 3052: l_head_fund_category fv_extract_detail_gt.fund_category%TYPE;

3048: l_ar_rct_extract_details cur_ar_rct_extract_details%ROWTYPE;
3049: l_misc_rct_extract_details cur_misc_rct_extract_details%ROWTYPE;
3050: l_fund_value fv_extract_detail_gt.fund_value%TYPE;
3051: l_head_fund_value fv_extract_detail_gt.fund_value%TYPE;
3052: l_head_fund_category fv_extract_detail_gt.fund_category%TYPE;
3053: l_fund_expired_status fv_extract_detail_gt.fund_expired_status%TYPE;
3054: l_fund_category fv_extract_detail_gt.fund_category%TYPE;
3055: l_fund_time_frame fv_extract_detail_gt.fund_time_frame%TYPE;
3056: l_prior_year_flag fv_extract_detail_gt.prior_year_flag%TYPE;

Line 3053: l_fund_expired_status fv_extract_detail_gt.fund_expired_status%TYPE;

3049: l_misc_rct_extract_details cur_misc_rct_extract_details%ROWTYPE;
3050: l_fund_value fv_extract_detail_gt.fund_value%TYPE;
3051: l_head_fund_value fv_extract_detail_gt.fund_value%TYPE;
3052: l_head_fund_category fv_extract_detail_gt.fund_category%TYPE;
3053: l_fund_expired_status fv_extract_detail_gt.fund_expired_status%TYPE;
3054: l_fund_category fv_extract_detail_gt.fund_category%TYPE;
3055: l_fund_time_frame fv_extract_detail_gt.fund_time_frame%TYPE;
3056: l_prior_year_flag fv_extract_detail_gt.prior_year_flag%TYPE;
3057: l_account_valid_flag fv_extract_detail_gt.account_valid_flag%TYPE;

Line 3054: l_fund_category fv_extract_detail_gt.fund_category%TYPE;

3050: l_fund_value fv_extract_detail_gt.fund_value%TYPE;
3051: l_head_fund_value fv_extract_detail_gt.fund_value%TYPE;
3052: l_head_fund_category fv_extract_detail_gt.fund_category%TYPE;
3053: l_fund_expired_status fv_extract_detail_gt.fund_expired_status%TYPE;
3054: l_fund_category fv_extract_detail_gt.fund_category%TYPE;
3055: l_fund_time_frame fv_extract_detail_gt.fund_time_frame%TYPE;
3056: l_prior_year_flag fv_extract_detail_gt.prior_year_flag%TYPE;
3057: l_account_valid_flag fv_extract_detail_gt.account_valid_flag%TYPE;
3058: l_ledger_info cur_ledger_info%ROWTYPE;

Line 3055: l_fund_time_frame fv_extract_detail_gt.fund_time_frame%TYPE;

3051: l_head_fund_value fv_extract_detail_gt.fund_value%TYPE;
3052: l_head_fund_category fv_extract_detail_gt.fund_category%TYPE;
3053: l_fund_expired_status fv_extract_detail_gt.fund_expired_status%TYPE;
3054: l_fund_category fv_extract_detail_gt.fund_category%TYPE;
3055: l_fund_time_frame fv_extract_detail_gt.fund_time_frame%TYPE;
3056: l_prior_year_flag fv_extract_detail_gt.prior_year_flag%TYPE;
3057: l_account_valid_flag fv_extract_detail_gt.account_valid_flag%TYPE;
3058: l_ledger_info cur_ledger_info%ROWTYPE;
3059: l_fv_extract_rec fv_extract_rec;

Line 3056: l_prior_year_flag fv_extract_detail_gt.prior_year_flag%TYPE;

3052: l_head_fund_category fv_extract_detail_gt.fund_category%TYPE;
3053: l_fund_expired_status fv_extract_detail_gt.fund_expired_status%TYPE;
3054: l_fund_category fv_extract_detail_gt.fund_category%TYPE;
3055: l_fund_time_frame fv_extract_detail_gt.fund_time_frame%TYPE;
3056: l_prior_year_flag fv_extract_detail_gt.prior_year_flag%TYPE;
3057: l_account_valid_flag fv_extract_detail_gt.account_valid_flag%TYPE;
3058: l_ledger_info cur_ledger_info%ROWTYPE;
3059: l_fv_extract_rec fv_extract_rec;
3060: l_ar_event_info cur_ar_event_info%ROWTYPE;

Line 3057: l_account_valid_flag fv_extract_detail_gt.account_valid_flag%TYPE;

3053: l_fund_expired_status fv_extract_detail_gt.fund_expired_status%TYPE;
3054: l_fund_category fv_extract_detail_gt.fund_category%TYPE;
3055: l_fund_time_frame fv_extract_detail_gt.fund_time_frame%TYPE;
3056: l_prior_year_flag fv_extract_detail_gt.prior_year_flag%TYPE;
3057: l_account_valid_flag fv_extract_detail_gt.account_valid_flag%TYPE;
3058: l_ledger_info cur_ledger_info%ROWTYPE;
3059: l_fv_extract_rec fv_extract_rec;
3060: l_ar_event_info cur_ar_event_info%ROWTYPE;
3061: l_header_natseg_value NUMBER;

Line 3071: l_account_rule fv_extract_detail_gt.account_rule%TYPE;

3067: l_index NUMBER;
3068: l_trx_type_reim BOOLEAN := FALSE;
3069: l_trx_type_over BOOLEAN := FALSE;
3070: l_trx_type_adv BOOLEAN := FALSE;
3071: l_account_rule fv_extract_detail_gt.account_rule%TYPE;
3072: l_receivable_with_advance VARCHAR2(1) := 'N';
3073:
3074: BEGIN
3075:

Line 3500: So directly jump to the condition that insert the records to fv_extract_detail_gt table */

3496: CLOSE cur_get_natacct;
3497: -- Check the Natural Account Segment of the line
3498: IF (l_natseg_value BETWEEN 101001 AND 101099) THEN
3499: /* Now we are sure that this particular receipt is for the 'Refunds of Advances or Prepayment'.
3500: So directly jump to the condition that insert the records to fv_extract_detail_gt table */
3501: l_overall_acct_valid := TRUE;
3502: -- ================================== FND_LOG ==================================
3503: l_debug_info := 'CASH line validated: Y' || ' for Refund of Advance or Prepayment';
3504: trace(C_STATE_LEVEL, l_procedure_name, l_debug_info );

Line 3835: INSERT INTO fv_extract_detail_gt VALUES l_fv_extract_detail(l_index);

3831: END LOOP;
3832: END IF;
3833: /* Insert data into FV_EXTRACT_DETAILS_GT table */
3834: FORALL l_index IN l_fv_extract_detail.first..l_fv_extract_detail.last
3835: INSERT INTO fv_extract_detail_gt VALUES l_fv_extract_detail(l_index);
3836: -- ================================== FND_LOG ==================================
3837: l_debug_info := 'No of rows inserted into FV_EXTRACT_DETAIL_GT: '|| SQL%ROWCOUNT;
3838: trace(C_STATE_LEVEL, l_procedure_name, l_debug_info );
3839: -- ================================== FND_LOG ==================================

Line 3837: l_debug_info := 'No of rows inserted into FV_EXTRACT_DETAIL_GT: '|| SQL%ROWCOUNT;

3833: /* Insert data into FV_EXTRACT_DETAILS_GT table */
3834: FORALL l_index IN l_fv_extract_detail.first..l_fv_extract_detail.last
3835: INSERT INTO fv_extract_detail_gt VALUES l_fv_extract_detail(l_index);
3836: -- ================================== FND_LOG ==================================
3837: l_debug_info := 'No of rows inserted into FV_EXTRACT_DETAIL_GT: '|| SQL%ROWCOUNT;
3838: trace(C_STATE_LEVEL, l_procedure_name, l_debug_info );
3839: -- ================================== FND_LOG ==================================
3840: ELSIF l_fv_extract_detail.COUNT = 0 THEN
3841: -- ================================== FND_LOG ==================================