[Home] [Help]
1606: p_chart_of_accounts_id OUT NOCOPY gl_sets_of_books.chart_of_accounts_id%TYPE,
1607: p_acct_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,
1608: p_acct_value_set_id OUT NOCOPY fnd_id_flex_segments.flex_value_set_id%TYPE,
1609: p_bal_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,
1610: p_accomplish_attribute OUT NOCOPY fv_system_parameters.sf224_accomplish_date%TYPE,
1611: p_error_code OUT NOCOPY NUMBER,
1612: p_error_desc OUT NOCOPY VARCHAR2
1613: )
1614: IS
1739: IF (p_error_code = g_SUCCESS) THEN
1740: BEGIN
1741: SELECT sf224_accomplish_date
1742: INTO p_accomplish_attribute
1743: FROM fv_system_parameters;
1744: EXCEPTION
1745: WHEN OTHERS THEN
1746: p_error_code := g_FAILURE;
1747: p_error_desc := SQLERRM;
1744: EXCEPTION
1745: WHEN OTHERS THEN
1746: p_error_code := g_FAILURE;
1747: p_error_desc := SQLERRM;
1748: l_location := l_module_name||'select_fv_system_parameters';
1749: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1750: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1751: END;
1752: END IF;
2852: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
2853: l_INVOICE_ID AP_INVOICES.invoice_ID%TYPE;
2854: l_inv_amount NUMBER;
2855: l_check_date DATE;
2856: l_payables_ia_paygroup FV_system_parameters_v.payables_ia_paygroup%type;
2857:
2858: -- References invoice_id populated by treasury confirmation procedure
2859: L_REFERENCE_4 FV_SF224_TEMP.REFERENCE_4%TYPE ;
2860: L_REFERENCE_5 FV_SF224_TEMP.REFERENCE_5%TYPE ;
3008: --Determine the attribute column used in AR Reclass Receipt DFF
3009: BEGIN
3010: SELECT AR_RECLASS_ATTRIBUTE
3011: INTO l_ar_reclass_attribute
3012: FROM fv_system_parameters;
3013: EXCEPTION
3014: WHEN NO_DATA_FOUND THEN
3015: l_ar_reclass_attribute:=NULL;
3016: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3294: RETURN;
3295: END;
3296: END IF;
3297: END IF;
3298: ELSE -- accomplish date attribute in fv_system_parameters is null.
3299: l_accomplish_date := l_txn_end_date;
3300: END IF;
3301: l_record_type := 'Disbursement';
3302: ELSIF (l_je_source = 'Payables' AND l_je_category <> 'Treasury Confirmation') Then -- source1