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.JMF_GTA_ARTRX_PROC dependencies on JMF_GTA_SYSTEM_PARAMETERS_ALL

Line 458: FROM jmf_gta_system_parameters_all

454: END IF;
455:
456: SELECT GT_CURRENCY_CODE
457: INTO l_currency
458: FROM jmf_gta_system_parameters_all
459: WHERE org_id = p_org_id;
460:
461: --get rult name by rule id
462: BEGIN

Line 757: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;

753: l_procedure_name VARCHAR2(30) := 'retrive_valid_AR_TRXs';
754: l_trxtype_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
755: l_flex_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
756: l_other_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
757: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
758: l_gta_trx_tbl jmf_gta_trx_util.trx_tbl_type:= jmf_gta_trx_util.trx_tbl_type();
759: l_invoice_type_code VARCHAR2(1);
760: BEGIN
761:

Line 1771: l_gta_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;

1767: l_parameter_token VARCHAR2(10) := ':currency';
1768: l_ar_currency_code ra_customer_trx_all.Invoice_Currency_Code%TYPE;
1769:
1770: l_specific_currency_code jmf_gta_rule_headers_all.specific_currency_code%TYPE;
1771: l_gta_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1772:
1773: -- if currency_option = A then the rule is transfer all AR trx
1774: -- if currency_option = G
1775: -- then the rule is transfer AR trx which currency code is same as gta

Line 1834: FROM jmf_gta_system_parameters_all op

1830: -- get gta_currency code
1831: BEGIN
1832: SELECT op.gt_currency_code
1833: INTO l_gta_currency_code
1834: FROM jmf_gta_system_parameters_all op
1835: WHERE op.org_id = p_ORG_ID;
1836: EXCEPTION
1837: -- no data found , raise a data error
1838: WHEN no_data_found THEN

Line 1982: l_vat_tax_type jmf_gta_system_parameters_all.vat_tax_type_code%TYPE;

1978: l_ar_invoice_count number;
1979: --add end by Yao Zhang or bug 7629877
1980: l_max_amount NUMBER;
1981: l_max_num_of_line NUMBER;
1982: l_vat_tax_type jmf_gta_system_parameters_all.vat_tax_type_code%TYPE;
1983: l_trx_line_split_flag jmf_gta_system_parameters_all.trx_line_split_flag%TYPE;
1984: l_gt_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1985: l_item_name_source_flag jmf_gta_system_parameters_all.item_name_source_flag%TYPE;
1986: l_cross_reference_type jmf_gta_system_parameters_all.cross_reference_type%TYPE;

Line 1983: l_trx_line_split_flag jmf_gta_system_parameters_all.trx_line_split_flag%TYPE;

1979: --add end by Yao Zhang or bug 7629877
1980: l_max_amount NUMBER;
1981: l_max_num_of_line NUMBER;
1982: l_vat_tax_type jmf_gta_system_parameters_all.vat_tax_type_code%TYPE;
1983: l_trx_line_split_flag jmf_gta_system_parameters_all.trx_line_split_flag%TYPE;
1984: l_gt_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1985: l_item_name_source_flag jmf_gta_system_parameters_all.item_name_source_flag%TYPE;
1986: l_cross_reference_type jmf_gta_system_parameters_all.cross_reference_type%TYPE;
1987: l_master_item_default_flag jmf_gta_system_parameters_all.master_item_default_flag%TYPE;

Line 1984: l_gt_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;

1980: l_max_amount NUMBER;
1981: l_max_num_of_line NUMBER;
1982: l_vat_tax_type jmf_gta_system_parameters_all.vat_tax_type_code%TYPE;
1983: l_trx_line_split_flag jmf_gta_system_parameters_all.trx_line_split_flag%TYPE;
1984: l_gt_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1985: l_item_name_source_flag jmf_gta_system_parameters_all.item_name_source_flag%TYPE;
1986: l_cross_reference_type jmf_gta_system_parameters_all.cross_reference_type%TYPE;
1987: l_master_item_default_flag jmf_gta_system_parameters_all.master_item_default_flag%TYPE;
1988: l_latest_ref_default_flag jmf_gta_system_parameters_all.latest_ref_default_flag%TYPE;

Line 1985: l_item_name_source_flag jmf_gta_system_parameters_all.item_name_source_flag%TYPE;

1981: l_max_num_of_line NUMBER;
1982: l_vat_tax_type jmf_gta_system_parameters_all.vat_tax_type_code%TYPE;
1983: l_trx_line_split_flag jmf_gta_system_parameters_all.trx_line_split_flag%TYPE;
1984: l_gt_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1985: l_item_name_source_flag jmf_gta_system_parameters_all.item_name_source_flag%TYPE;
1986: l_cross_reference_type jmf_gta_system_parameters_all.cross_reference_type%TYPE;
1987: l_master_item_default_flag jmf_gta_system_parameters_all.master_item_default_flag%TYPE;
1988: l_latest_ref_default_flag jmf_gta_system_parameters_all.latest_ref_default_flag%TYPE;
1989: l_ra_line_context_code jmf_gta_system_parameters_all.ra_line_context_code%TYPE;

Line 1986: l_cross_reference_type jmf_gta_system_parameters_all.cross_reference_type%TYPE;

1982: l_vat_tax_type jmf_gta_system_parameters_all.vat_tax_type_code%TYPE;
1983: l_trx_line_split_flag jmf_gta_system_parameters_all.trx_line_split_flag%TYPE;
1984: l_gt_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1985: l_item_name_source_flag jmf_gta_system_parameters_all.item_name_source_flag%TYPE;
1986: l_cross_reference_type jmf_gta_system_parameters_all.cross_reference_type%TYPE;
1987: l_master_item_default_flag jmf_gta_system_parameters_all.master_item_default_flag%TYPE;
1988: l_latest_ref_default_flag jmf_gta_system_parameters_all.latest_ref_default_flag%TYPE;
1989: l_ra_line_context_code jmf_gta_system_parameters_all.ra_line_context_code%TYPE;
1990: l_ra_model_attribute_column jmf_gta_system_parameters_all.ra_model_attribute_column%TYPE;

Line 1987: l_master_item_default_flag jmf_gta_system_parameters_all.master_item_default_flag%TYPE;

1983: l_trx_line_split_flag jmf_gta_system_parameters_all.trx_line_split_flag%TYPE;
1984: l_gt_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1985: l_item_name_source_flag jmf_gta_system_parameters_all.item_name_source_flag%TYPE;
1986: l_cross_reference_type jmf_gta_system_parameters_all.cross_reference_type%TYPE;
1987: l_master_item_default_flag jmf_gta_system_parameters_all.master_item_default_flag%TYPE;
1988: l_latest_ref_default_flag jmf_gta_system_parameters_all.latest_ref_default_flag%TYPE;
1989: l_ra_line_context_code jmf_gta_system_parameters_all.ra_line_context_code%TYPE;
1990: l_ra_model_attribute_column jmf_gta_system_parameters_all.ra_model_attribute_column%TYPE;
1991: l_ra_tax_attribute_column jmf_gta_system_parameters_all.ra_tax_attribute_column%TYPE;

Line 1988: l_latest_ref_default_flag jmf_gta_system_parameters_all.latest_ref_default_flag%TYPE;

1984: l_gt_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1985: l_item_name_source_flag jmf_gta_system_parameters_all.item_name_source_flag%TYPE;
1986: l_cross_reference_type jmf_gta_system_parameters_all.cross_reference_type%TYPE;
1987: l_master_item_default_flag jmf_gta_system_parameters_all.master_item_default_flag%TYPE;
1988: l_latest_ref_default_flag jmf_gta_system_parameters_all.latest_ref_default_flag%TYPE;
1989: l_ra_line_context_code jmf_gta_system_parameters_all.ra_line_context_code%TYPE;
1990: l_ra_model_attribute_column jmf_gta_system_parameters_all.ra_model_attribute_column%TYPE;
1991: l_ra_tax_attribute_column jmf_gta_system_parameters_all.ra_tax_attribute_column%TYPE;
1992: l_inv_item_context_code jmf_gta_system_parameters_all.inv_item_context_code%TYPE;

Line 1989: l_ra_line_context_code jmf_gta_system_parameters_all.ra_line_context_code%TYPE;

1985: l_item_name_source_flag jmf_gta_system_parameters_all.item_name_source_flag%TYPE;
1986: l_cross_reference_type jmf_gta_system_parameters_all.cross_reference_type%TYPE;
1987: l_master_item_default_flag jmf_gta_system_parameters_all.master_item_default_flag%TYPE;
1988: l_latest_ref_default_flag jmf_gta_system_parameters_all.latest_ref_default_flag%TYPE;
1989: l_ra_line_context_code jmf_gta_system_parameters_all.ra_line_context_code%TYPE;
1990: l_ra_model_attribute_column jmf_gta_system_parameters_all.ra_model_attribute_column%TYPE;
1991: l_ra_tax_attribute_column jmf_gta_system_parameters_all.ra_tax_attribute_column%TYPE;
1992: l_inv_item_context_code jmf_gta_system_parameters_all.inv_item_context_code%TYPE;
1993: l_inv_model_attribute_column jmf_gta_system_parameters_all.inv_model_attribute_column%TYPE;

Line 1990: l_ra_model_attribute_column jmf_gta_system_parameters_all.ra_model_attribute_column%TYPE;

1986: l_cross_reference_type jmf_gta_system_parameters_all.cross_reference_type%TYPE;
1987: l_master_item_default_flag jmf_gta_system_parameters_all.master_item_default_flag%TYPE;
1988: l_latest_ref_default_flag jmf_gta_system_parameters_all.latest_ref_default_flag%TYPE;
1989: l_ra_line_context_code jmf_gta_system_parameters_all.ra_line_context_code%TYPE;
1990: l_ra_model_attribute_column jmf_gta_system_parameters_all.ra_model_attribute_column%TYPE;
1991: l_ra_tax_attribute_column jmf_gta_system_parameters_all.ra_tax_attribute_column%TYPE;
1992: l_inv_item_context_code jmf_gta_system_parameters_all.inv_item_context_code%TYPE;
1993: l_inv_model_attribute_column jmf_gta_system_parameters_all.inv_model_attribute_column%TYPE;
1994: l_inv_tax_attribute_column jmf_gta_system_parameters_all.Inv_Tax_Attribute_Column%TYPE;

Line 1991: l_ra_tax_attribute_column jmf_gta_system_parameters_all.ra_tax_attribute_column%TYPE;

1987: l_master_item_default_flag jmf_gta_system_parameters_all.master_item_default_flag%TYPE;
1988: l_latest_ref_default_flag jmf_gta_system_parameters_all.latest_ref_default_flag%TYPE;
1989: l_ra_line_context_code jmf_gta_system_parameters_all.ra_line_context_code%TYPE;
1990: l_ra_model_attribute_column jmf_gta_system_parameters_all.ra_model_attribute_column%TYPE;
1991: l_ra_tax_attribute_column jmf_gta_system_parameters_all.ra_tax_attribute_column%TYPE;
1992: l_inv_item_context_code jmf_gta_system_parameters_all.inv_item_context_code%TYPE;
1993: l_inv_model_attribute_column jmf_gta_system_parameters_all.inv_model_attribute_column%TYPE;
1994: l_inv_tax_attribute_column jmf_gta_system_parameters_all.Inv_Tax_Attribute_Column%TYPE;
1995: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;

Line 1992: l_inv_item_context_code jmf_gta_system_parameters_all.inv_item_context_code%TYPE;

1988: l_latest_ref_default_flag jmf_gta_system_parameters_all.latest_ref_default_flag%TYPE;
1989: l_ra_line_context_code jmf_gta_system_parameters_all.ra_line_context_code%TYPE;
1990: l_ra_model_attribute_column jmf_gta_system_parameters_all.ra_model_attribute_column%TYPE;
1991: l_ra_tax_attribute_column jmf_gta_system_parameters_all.ra_tax_attribute_column%TYPE;
1992: l_inv_item_context_code jmf_gta_system_parameters_all.inv_item_context_code%TYPE;
1993: l_inv_model_attribute_column jmf_gta_system_parameters_all.inv_model_attribute_column%TYPE;
1994: l_inv_tax_attribute_column jmf_gta_system_parameters_all.Inv_Tax_Attribute_Column%TYPE;
1995: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1996: l_cross_rows NUMBER;

Line 1993: l_inv_model_attribute_column jmf_gta_system_parameters_all.inv_model_attribute_column%TYPE;

1989: l_ra_line_context_code jmf_gta_system_parameters_all.ra_line_context_code%TYPE;
1990: l_ra_model_attribute_column jmf_gta_system_parameters_all.ra_model_attribute_column%TYPE;
1991: l_ra_tax_attribute_column jmf_gta_system_parameters_all.ra_tax_attribute_column%TYPE;
1992: l_inv_item_context_code jmf_gta_system_parameters_all.inv_item_context_code%TYPE;
1993: l_inv_model_attribute_column jmf_gta_system_parameters_all.inv_model_attribute_column%TYPE;
1994: l_inv_tax_attribute_column jmf_gta_system_parameters_all.Inv_Tax_Attribute_Column%TYPE;
1995: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1996: l_cross_rows NUMBER;
1997: --29-JUN-2006 Updated by shujuan

Line 1994: l_inv_tax_attribute_column jmf_gta_system_parameters_all.Inv_Tax_Attribute_Column%TYPE;

1990: l_ra_model_attribute_column jmf_gta_system_parameters_all.ra_model_attribute_column%TYPE;
1991: l_ra_tax_attribute_column jmf_gta_system_parameters_all.ra_tax_attribute_column%TYPE;
1992: l_inv_item_context_code jmf_gta_system_parameters_all.inv_item_context_code%TYPE;
1993: l_inv_model_attribute_column jmf_gta_system_parameters_all.inv_model_attribute_column%TYPE;
1994: l_inv_tax_attribute_column jmf_gta_system_parameters_all.Inv_Tax_Attribute_Column%TYPE;
1995: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1996: l_cross_rows NUMBER;
1997: --29-JUN-2006 Updated by shujuan
1998: l_cross_reference MTL_CROSS_REFERENCES_B.cross_reference%TYPE;

Line 1995: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;

1991: l_ra_tax_attribute_column jmf_gta_system_parameters_all.ra_tax_attribute_column%TYPE;
1992: l_inv_item_context_code jmf_gta_system_parameters_all.inv_item_context_code%TYPE;
1993: l_inv_model_attribute_column jmf_gta_system_parameters_all.inv_model_attribute_column%TYPE;
1994: l_inv_tax_attribute_column jmf_gta_system_parameters_all.Inv_Tax_Attribute_Column%TYPE;
1995: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1996: l_cross_rows NUMBER;
1997: --29-JUN-2006 Updated by shujuan
1998: l_cross_reference MTL_CROSS_REFERENCES_B.cross_reference%TYPE;
1999: l_sales_list_flag VARCHAR2(1);

Line 2139: --select parameters from JMF_GTA_SYSTEM_PARAMETERS_ALL dependence org_id

2135: 'Begin Retrieve_AR_TRXs......');
2136: END IF;
2137:
2138: -- begin select parameters
2139: --select parameters from JMF_GTA_SYSTEM_PARAMETERS_ALL dependence org_id
2140: BEGIN
2141: SELECT vat_tax_type_code,
2142: trx_line_split_flag,
2143: gt_currency_code,

Line 2169: FROM jmf_gta_system_parameters_all

2165: l_inv_item_context_code,
2166: l_inv_model_attribute_column,
2167: l_inv_tax_attribute_column,
2168: l_currency_code
2169: FROM jmf_gta_system_parameters_all
2170: WHERE org_id = p_org_id;
2171:
2172: EXCEPTION
2173: WHEN no_data_found THEN