APPS.FV_SF224_TRANSACTIONS dependencies on FV_SYSTEM_PARAMETERS

Line 1589: p_accomplish_attribute OUT NOCOPY fv_system_parameters.sf224_accomplish_date%TYPE,

1585: p_chart_of_accounts_id OUT NOCOPY gl_sets_of_books.chart_of_accounts_id%TYPE,
1586: p_acct_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,
1587: p_acct_value_set_id OUT NOCOPY fnd_id_flex_segments.flex_value_set_id%TYPE,
1588: p_bal_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,
1589: p_accomplish_attribute OUT NOCOPY fv_system_parameters.sf224_accomplish_date%TYPE,
1590: p_error_code OUT NOCOPY NUMBER,
1591: p_error_desc OUT NOCOPY VARCHAR2
1592: )
1593: IS

Line 1722: FROM fv_system_parameters;

1718: IF (p_error_code = g_SUCCESS) THEN
1719: BEGIN
1720: SELECT sf224_accomplish_date
1721: INTO p_accomplish_attribute
1722: FROM fv_system_parameters;
1723: EXCEPTION
1724: WHEN OTHERS THEN
1725: p_error_code := g_FAILURE;
1726: p_error_desc := SQLERRM;

Line 1727: l_location := l_module_name||'select_fv_system_parameters';

1723: EXCEPTION
1724: WHEN OTHERS THEN
1725: p_error_code := g_FAILURE;
1726: p_error_desc := SQLERRM;
1727: l_location := l_module_name||'select_fv_system_parameters';
1728: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1729: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1730: END;
1731: END IF;

Line 2728: l_payables_ia_paygroup FV_system_parameters_v.payables_ia_paygroup%type;

2724: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
2725: l_INVOICE_ID AP_INVOICES.invoice_ID%TYPE;
2726: l_inv_amount NUMBER;
2727: l_check_date DATE;
2728: l_payables_ia_paygroup FV_system_parameters_v.payables_ia_paygroup%type;
2729:
2730: -- References invoice_id populated by treasury confirmation procedure
2731: L_REFERENCE_4 FV_SF224_TEMP.REFERENCE_4%TYPE ;
2732: L_REFERENCE_5 FV_SF224_TEMP.REFERENCE_5%TYPE ;

Line 2884: FROM fv_system_parameters;

2880: --Determine the attribute column used in AR Reclass Receipt DFF
2881: BEGIN
2882: SELECT AR_RECLASS_ATTRIBUTE
2883: INTO l_ar_reclass_attribute
2884: FROM fv_system_parameters;
2885: EXCEPTION
2886: WHEN NO_DATA_FOUND THEN
2887: l_ar_reclass_attribute:=NULL;
2888: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3163: ELSE -- accomplish date attribute in fv_system_parameters is null.

3159: RETURN;
3160: END;
3161: END IF;
3162: END IF;
3163: ELSE -- accomplish date attribute in fv_system_parameters is null.
3164: l_accomplish_date := l_txn_end_date;
3165: END IF;
3166: l_record_type := 'Disbursement';
3167: ELSIF (l_je_source = 'Payables' AND l_je_category <> 'Treasury Confirmation') Then -- source1