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.AP_IMPORT_VALIDATION_PKG dependencies on FND_PLSQL_CACHE

Line 16665: l_valueOut fnd_plsql_cache.generic_cache_value_type;

16661: l_period_name VARCHAR2(15);
16662: l_dummy VARCHAR2(100);
16663: l_key VARCHAR2(1000);
16664: l_numof_values NUMBER;
16665: l_valueOut fnd_plsql_cache.generic_cache_value_type;
16666: l_values fnd_plsql_cache.generic_cache_values_type;
16667: l_ret_code VARCHAR2(1);
16668: l_exception VARCHAR2(10);
16669: l_current_invoice_status VARCHAR2(1) := 'Y';

Line 16666: l_values fnd_plsql_cache.generic_cache_values_type;

16662: l_dummy VARCHAR2(100);
16663: l_key VARCHAR2(1000);
16664: l_numof_values NUMBER;
16665: l_valueOut fnd_plsql_cache.generic_cache_value_type;
16666: l_values fnd_plsql_cache.generic_cache_values_type;
16667: l_ret_code VARCHAR2(1);
16668: l_exception VARCHAR2(10);
16669: l_current_invoice_status VARCHAR2(1) := 'Y';
16670: l_accounting_date DATE := p_invoice_lines_rec.accounting_date;

Line 16761: fnd_plsql_cache.generic_1tom_get_values(

16757: l_key := TO_CHAR(p_set_of_books_id)||' '||
16758: TO_CHAR(NVL(l_accounting_date,
16759: AP_IMPORT_INVOICES_PKG.g_inv_sysdate),'dd-mm-yyyy');
16760:
16761: fnd_plsql_cache.generic_1tom_get_values(
16762: AP_IMPORT_INVOICES_PKG.lg_many_controller,
16763: AP_IMPORT_INVOICES_PKG.lg_generic_storage,
16764: l_key,
16765: l_numof_values,

Line 16809: fnd_plsql_cache.generic_1tom_put_values(

16805: l_valueOut.varchar2_2 := l_exception;
16806: l_values(1) := l_valueOut;
16807: l_numof_values := 1;
16808:
16809: fnd_plsql_cache.generic_1tom_put_values(
16810: AP_IMPORT_INVOICES_PKG.lg_many_controller,
16811: AP_IMPORT_INVOICES_PKG.lg_generic_storage,
16812: l_key,
16813: l_numof_values,

Line 16842: fnd_plsql_cache.generic_1tom_put_values(

16838: l_valueOut.varchar2_2 := l_exception;
16839: l_values(1) := l_valueOut;
16840: l_numof_values := 1;
16841:
16842: fnd_plsql_cache.generic_1tom_put_values(
16843: AP_IMPORT_INVOICES_PKG.lg_many_controller,
16844: AP_IMPORT_INVOICES_PKG.lg_generic_storage,
16845: l_key,
16846: l_numof_values,

Line 16975: l_valueOut fnd_plsql_cache.generic_cache_value_type;

16971: current_calling_sequence VARCHAR2(2000);
16972: debug_info VARCHAR2(500);
16973: l_key VARCHAR2(1000);
16974: l_numof_values NUMBER;
16975: l_valueOut fnd_plsql_cache.generic_cache_value_type;
16976: l_values fnd_plsql_cache.generic_cache_values_type;
16977: l_ret_code VARCHAR2(1);
16978: l_validate_res VARCHAR2(10);
16979:

Line 16976: l_values fnd_plsql_cache.generic_cache_values_type;

16972: debug_info VARCHAR2(500);
16973: l_key VARCHAR2(1000);
16974: l_numof_values NUMBER;
16975: l_valueOut fnd_plsql_cache.generic_cache_value_type;
16976: l_values fnd_plsql_cache.generic_cache_values_type;
16977: l_ret_code VARCHAR2(1);
16978: l_validate_res VARCHAR2(10);
16979:
16980: BEGIN

Line 17392: fnd_plsql_cache.generic_1tom_get_values(

17388:
17389: l_key := to_char(nvl(p_chart_of_accounts_id,0))||' '
17390: ||l_pa_concatenated_segments||' '
17391: ||to_char(AP_IMPORT_INVOICES_PKG.g_inv_sysdate,'dd-mm-yyyy');
17392: fnd_plsql_cache.generic_1tom_get_values(
17393: AP_IMPORT_INVOICES_PKG.lg_many_controller1,
17394: AP_IMPORT_INVOICES_PKG.lg_generic_storage1,
17395: l_key,
17396: l_numof_values,

Line 17442: fnd_plsql_cache.generic_1tom_put_values(

17438: l_valueOut.varchar2_3 := l_reason_unbuilt_flex;
17439: l_values(1) := l_valueOut;
17440: l_numof_values := 1;
17441:
17442: fnd_plsql_cache.generic_1tom_put_values(
17443: AP_IMPORT_INVOICES_PKG.lg_many_controller1,
17444: AP_IMPORT_INVOICES_PKG.lg_generic_storage1,
17445: l_key,
17446: l_numof_values,

Line 17585: l_valueOut fnd_plsql_cache.generic_cache_value_type;

17581: l_unbuilt_flex VARCHAR2(240):='';
17582: l_reason_unbuilt_flex VARCHAR2(2000):='';
17583: l_key VARCHAR2(1000);
17584: l_numof_values NUMBER;
17585: l_valueOut fnd_plsql_cache.generic_cache_value_type;
17586: l_values fnd_plsql_cache.generic_cache_values_type;
17587: l_ret_code VARCHAR2(1);
17588: l_validate_res VARCHAR2(10);
17589: current_calling_sequence VARCHAR2(2000);

Line 17586: l_values fnd_plsql_cache.generic_cache_values_type;

17582: l_reason_unbuilt_flex VARCHAR2(2000):='';
17583: l_key VARCHAR2(1000);
17584: l_numof_values NUMBER;
17585: l_valueOut fnd_plsql_cache.generic_cache_value_type;
17586: l_values fnd_plsql_cache.generic_cache_values_type;
17587: l_ret_code VARCHAR2(1);
17588: l_validate_res VARCHAR2(10);
17589: current_calling_sequence VARCHAR2(2000);
17590: debug_info VARCHAR2(500);

Line 17932: fnd_plsql_cache.generic_1tom_get_values(

17928: l_key := TO_CHAR(NVL(p_chart_of_accounts_id,0))||' '||
17929: p_invoice_lines_rec.dist_code_concatenated||' '||
17930: to_char(p_accounting_date,'dd-mm-yyyy');
17931:
17932: fnd_plsql_cache.generic_1tom_get_values(
17933: AP_IMPORT_INVOICES_PKG.lg_many_controller1,
17934: AP_IMPORT_INVOICES_PKG.lg_generic_storage1,
17935: l_key,
17936: l_numof_values,

Line 17976: fnd_plsql_cache.generic_1tom_put_values(

17972: l_valueOut.varchar2_2 := l_validate_res;
17973: l_values(1) := l_valueOut;
17974: l_numof_values := 1;
17975:
17976: fnd_plsql_cache.generic_1tom_put_values(
17977: AP_IMPORT_INVOICES_PKG.lg_many_controller1,
17978: AP_IMPORT_INVOICES_PKG.lg_generic_storage1,
17979: l_key,
17980: l_numof_values,

Line 20620: l_valueOut fnd_plsql_cache.generic_cache_value_type;

20616: debug_info VARCHAR2(500);
20617: -- Bug 5572876. Caching Income Tax Type and Income Tax Region
20618: l_key VARCHAR2(1000);
20619: l_numof_values NUMBER;
20620: l_valueOut fnd_plsql_cache.generic_cache_value_type;
20621: l_values fnd_plsql_cache.generic_cache_values_type;
20622: l_ret_code VARCHAR2(1);
20623: l_exception VARCHAR2(10);
20624: l_key1 VARCHAR2(1000);

Line 20621: l_values fnd_plsql_cache.generic_cache_values_type;

20617: -- Bug 5572876. Caching Income Tax Type and Income Tax Region
20618: l_key VARCHAR2(1000);
20619: l_numof_values NUMBER;
20620: l_valueOut fnd_plsql_cache.generic_cache_value_type;
20621: l_values fnd_plsql_cache.generic_cache_values_type;
20622: l_ret_code VARCHAR2(1);
20623: l_exception VARCHAR2(10);
20624: l_key1 VARCHAR2(1000);
20625: l_numof_values1 NUMBER;

Line 20626: l_valueOut1 fnd_plsql_cache.generic_cache_value_type;

20622: l_ret_code VARCHAR2(1);
20623: l_exception VARCHAR2(10);
20624: l_key1 VARCHAR2(1000);
20625: l_numof_values1 NUMBER;
20626: l_valueOut1 fnd_plsql_cache.generic_cache_value_type;
20627: l_values1 fnd_plsql_cache.generic_cache_values_type;
20628: l_ret_code1 VARCHAR2(1);
20629: l_exception1 VARCHAR2(10);
20630: l_income_tax_type ap_income_tax_types.income_tax_type%TYPE;

Line 20627: l_values1 fnd_plsql_cache.generic_cache_values_type;

20623: l_exception VARCHAR2(10);
20624: l_key1 VARCHAR2(1000);
20625: l_numof_values1 NUMBER;
20626: l_valueOut1 fnd_plsql_cache.generic_cache_value_type;
20627: l_values1 fnd_plsql_cache.generic_cache_values_type;
20628: l_ret_code1 VARCHAR2(1);
20629: l_exception1 VARCHAR2(10);
20630: l_income_tax_type ap_income_tax_types.income_tax_type%TYPE;
20631: l_income_tax_region ap_income_tax_regions.region_short_name%TYPE;

Line 20761: fnd_plsql_cache.generic_1tom_get_values(

20757: -- Invalid Info
20758:
20759: l_key := p_invoice_lines_rec.type_1099;
20760:
20761: fnd_plsql_cache.generic_1tom_get_values(
20762: AP_IMPORT_INVOICES_PKG.lg_incometax_controller,
20763: AP_IMPORT_INVOICES_PKG.lg_incometax_storage,
20764: l_key,
20765: l_numof_values,

Line 20812: fnd_plsql_cache.generic_1tom_put_values(

20808: l_valueOut.varchar2_2 := l_exception;
20809: l_values(1) := l_valueOut;
20810: l_numof_values := 1;
20811:
20812: fnd_plsql_cache.generic_1tom_put_values(
20813: AP_IMPORT_INVOICES_PKG.lg_incometax_controller,
20814: AP_IMPORT_INVOICES_PKG.lg_incometax_storage,
20815: l_key,
20816: l_numof_values,

Line 20849: fnd_plsql_cache.generic_1tom_put_values(

20845: l_valueOut.varchar2_2 := l_exception;
20846: l_values(1) := l_valueOut;
20847: l_numof_values := 1;
20848:
20849: fnd_plsql_cache.generic_1tom_put_values(
20850: AP_IMPORT_INVOICES_PKG.lg_incometax_controller,
20851: AP_IMPORT_INVOICES_PKG.lg_incometax_storage,
20852: l_key,
20853: l_numof_values,

Line 20913: fnd_plsql_cache.generic_1tom_get_values(

20909:
20910: -- Invalid Info
20911: l_key1 := p_invoice_lines_rec.income_tax_region;
20912:
20913: fnd_plsql_cache.generic_1tom_get_values(
20914: AP_IMPORT_INVOICES_PKG.lg_incometaxr_controller,
20915: AP_IMPORT_INVOICES_PKG.lg_incometaxr_storage,
20916: l_key1,
20917: l_numof_values1,

Line 20965: fnd_plsql_cache.generic_1tom_put_values(

20961: l_valueOut1.varchar2_2 := l_exception1;
20962: l_values1(1) := l_valueOut1;
20963: l_numof_values1 := 1;
20964:
20965: fnd_plsql_cache.generic_1tom_put_values(
20966: AP_IMPORT_INVOICES_PKG.lg_incometaxr_controller,
20967: AP_IMPORT_INVOICES_PKG.lg_incometaxr_storage,
20968: l_key1,
20969: l_numof_values1,

Line 20999: fnd_plsql_cache.generic_1tom_put_values(

20995: l_valueOut1.varchar2_2 := l_exception1;
20996: l_values1(1) := l_valueOut1;
20997: l_numof_values1 := 1;
20998:
20999: fnd_plsql_cache.generic_1tom_put_values(
21000: AP_IMPORT_INVOICES_PKG.lg_incometaxr_controller,
21001: AP_IMPORT_INVOICES_PKG.lg_incometaxr_storage,
21002: l_key1,
21003: l_numof_values1,