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.AR_GTA_ARTRX_PROC dependencies on AR_GTA_SYSTEM_PARAMETERS_ALL

Line 486: FROM ar_gta_system_parameters_all

482: END IF;
483:
484: SELECT GT_CURRENCY_CODE
485: INTO l_currency
486: FROM ar_gta_system_parameters_all
487: WHERE org_id = p_org_id;
488:
489: --get rult name by rule id
490: BEGIN

Line 794: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;

790: l_procedure_name VARCHAR2(30) := 'retrive_valid_AR_TRXs';
791: l_trxtype_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type := AR_GTA_TRX_UTIL.Condition_para_tbl_type();
792: l_flex_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type := AR_GTA_TRX_UTIL.Condition_para_tbl_type();
793: l_other_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type := AR_GTA_TRX_UTIL.Condition_para_tbl_type();
794: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
795: l_gta_trx_tbl ar_gta_trx_util.trx_tbl_type := ar_gta_trx_util.trx_tbl_type();
796: l_invoice_type_code VARCHAR2(1);
797: BEGIN
798:

Line 1807: l_gta_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;

1803: l_parameter_token VARCHAR2(10) := ':currency';
1804: l_ar_currency_code ra_customer_trx_all.Invoice_Currency_Code%TYPE;
1805:
1806: l_specific_currency_code ar_gta_rule_headers_all.specific_currency_code%TYPE;
1807: l_gta_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
1808:
1809: -- if currency_option = A then the rule is transfer all AR trx
1810: -- if currency_option = G
1811: -- then the rule is transfer AR trx which currency code is same as gta

Line 1870: FROM ar_gta_system_parameters_all op

1866: -- get gta_currency code
1867: BEGIN
1868: SELECT op.gt_currency_code
1869: INTO l_gta_currency_code
1870: FROM ar_gta_system_parameters_all op
1871: WHERE op.org_id = p_ORG_ID;
1872: EXCEPTION
1873: -- no data found , raise a data error
1874: WHEN no_data_found THEN

Line 2037: l_unit_price_split_flag ar_gta_system_parameters_all.unit_price_split_flag%TYPE;

2033: --add end by Yao Zhang or bug 7629877
2034: l_cm_warn2 BOOLEAN; --Yao Zhang add for bug#8605196
2035: l_max_amount NUMBER;
2036: l_max_num_of_line NUMBER;
2037: l_unit_price_split_flag ar_gta_system_parameters_all.unit_price_split_flag%TYPE;
2038: l_vat_tax_type ar_gta_system_parameters_all.vat_tax_type_code%TYPE;
2039: l_trx_line_split_flag ar_gta_system_parameters_all.trx_line_split_flag%TYPE;
2040: l_gt_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2041: l_item_name_source_flag ar_gta_system_parameters_all.item_name_source_flag%TYPE;

Line 2038: l_vat_tax_type ar_gta_system_parameters_all.vat_tax_type_code%TYPE;

2034: l_cm_warn2 BOOLEAN; --Yao Zhang add for bug#8605196
2035: l_max_amount NUMBER;
2036: l_max_num_of_line NUMBER;
2037: l_unit_price_split_flag ar_gta_system_parameters_all.unit_price_split_flag%TYPE;
2038: l_vat_tax_type ar_gta_system_parameters_all.vat_tax_type_code%TYPE;
2039: l_trx_line_split_flag ar_gta_system_parameters_all.trx_line_split_flag%TYPE;
2040: l_gt_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2041: l_item_name_source_flag ar_gta_system_parameters_all.item_name_source_flag%TYPE;
2042: l_cross_reference_type ar_gta_system_parameters_all.cross_reference_type%TYPE;

Line 2039: l_trx_line_split_flag ar_gta_system_parameters_all.trx_line_split_flag%TYPE;

2035: l_max_amount NUMBER;
2036: l_max_num_of_line NUMBER;
2037: l_unit_price_split_flag ar_gta_system_parameters_all.unit_price_split_flag%TYPE;
2038: l_vat_tax_type ar_gta_system_parameters_all.vat_tax_type_code%TYPE;
2039: l_trx_line_split_flag ar_gta_system_parameters_all.trx_line_split_flag%TYPE;
2040: l_gt_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2041: l_item_name_source_flag ar_gta_system_parameters_all.item_name_source_flag%TYPE;
2042: l_cross_reference_type ar_gta_system_parameters_all.cross_reference_type%TYPE;
2043: l_master_item_default_flag ar_gta_system_parameters_all.master_item_default_flag%TYPE;

Line 2040: l_gt_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;

2036: l_max_num_of_line NUMBER;
2037: l_unit_price_split_flag ar_gta_system_parameters_all.unit_price_split_flag%TYPE;
2038: l_vat_tax_type ar_gta_system_parameters_all.vat_tax_type_code%TYPE;
2039: l_trx_line_split_flag ar_gta_system_parameters_all.trx_line_split_flag%TYPE;
2040: l_gt_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2041: l_item_name_source_flag ar_gta_system_parameters_all.item_name_source_flag%TYPE;
2042: l_cross_reference_type ar_gta_system_parameters_all.cross_reference_type%TYPE;
2043: l_master_item_default_flag ar_gta_system_parameters_all.master_item_default_flag%TYPE;
2044: l_latest_ref_default_flag ar_gta_system_parameters_all.latest_ref_default_flag%TYPE;

Line 2041: l_item_name_source_flag ar_gta_system_parameters_all.item_name_source_flag%TYPE;

2037: l_unit_price_split_flag ar_gta_system_parameters_all.unit_price_split_flag%TYPE;
2038: l_vat_tax_type ar_gta_system_parameters_all.vat_tax_type_code%TYPE;
2039: l_trx_line_split_flag ar_gta_system_parameters_all.trx_line_split_flag%TYPE;
2040: l_gt_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2041: l_item_name_source_flag ar_gta_system_parameters_all.item_name_source_flag%TYPE;
2042: l_cross_reference_type ar_gta_system_parameters_all.cross_reference_type%TYPE;
2043: l_master_item_default_flag ar_gta_system_parameters_all.master_item_default_flag%TYPE;
2044: l_latest_ref_default_flag ar_gta_system_parameters_all.latest_ref_default_flag%TYPE;
2045: l_ra_line_context_code ar_gta_system_parameters_all.ra_line_context_code%TYPE;

Line 2042: l_cross_reference_type ar_gta_system_parameters_all.cross_reference_type%TYPE;

2038: l_vat_tax_type ar_gta_system_parameters_all.vat_tax_type_code%TYPE;
2039: l_trx_line_split_flag ar_gta_system_parameters_all.trx_line_split_flag%TYPE;
2040: l_gt_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2041: l_item_name_source_flag ar_gta_system_parameters_all.item_name_source_flag%TYPE;
2042: l_cross_reference_type ar_gta_system_parameters_all.cross_reference_type%TYPE;
2043: l_master_item_default_flag ar_gta_system_parameters_all.master_item_default_flag%TYPE;
2044: l_latest_ref_default_flag ar_gta_system_parameters_all.latest_ref_default_flag%TYPE;
2045: l_ra_line_context_code ar_gta_system_parameters_all.ra_line_context_code%TYPE;
2046: l_ra_model_attribute_column ar_gta_system_parameters_all.ra_model_attribute_column%TYPE;

Line 2043: l_master_item_default_flag ar_gta_system_parameters_all.master_item_default_flag%TYPE;

2039: l_trx_line_split_flag ar_gta_system_parameters_all.trx_line_split_flag%TYPE;
2040: l_gt_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2041: l_item_name_source_flag ar_gta_system_parameters_all.item_name_source_flag%TYPE;
2042: l_cross_reference_type ar_gta_system_parameters_all.cross_reference_type%TYPE;
2043: l_master_item_default_flag ar_gta_system_parameters_all.master_item_default_flag%TYPE;
2044: l_latest_ref_default_flag ar_gta_system_parameters_all.latest_ref_default_flag%TYPE;
2045: l_ra_line_context_code ar_gta_system_parameters_all.ra_line_context_code%TYPE;
2046: l_ra_model_attribute_column ar_gta_system_parameters_all.ra_model_attribute_column%TYPE;
2047: l_ra_tax_attribute_column ar_gta_system_parameters_all.ra_tax_attribute_column%TYPE;

Line 2044: l_latest_ref_default_flag ar_gta_system_parameters_all.latest_ref_default_flag%TYPE;

2040: l_gt_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2041: l_item_name_source_flag ar_gta_system_parameters_all.item_name_source_flag%TYPE;
2042: l_cross_reference_type ar_gta_system_parameters_all.cross_reference_type%TYPE;
2043: l_master_item_default_flag ar_gta_system_parameters_all.master_item_default_flag%TYPE;
2044: l_latest_ref_default_flag ar_gta_system_parameters_all.latest_ref_default_flag%TYPE;
2045: l_ra_line_context_code ar_gta_system_parameters_all.ra_line_context_code%TYPE;
2046: l_ra_model_attribute_column ar_gta_system_parameters_all.ra_model_attribute_column%TYPE;
2047: l_ra_tax_attribute_column ar_gta_system_parameters_all.ra_tax_attribute_column%TYPE;
2048: l_inv_item_context_code ar_gta_system_parameters_all.inv_item_context_code%TYPE;

Line 2045: l_ra_line_context_code ar_gta_system_parameters_all.ra_line_context_code%TYPE;

2041: l_item_name_source_flag ar_gta_system_parameters_all.item_name_source_flag%TYPE;
2042: l_cross_reference_type ar_gta_system_parameters_all.cross_reference_type%TYPE;
2043: l_master_item_default_flag ar_gta_system_parameters_all.master_item_default_flag%TYPE;
2044: l_latest_ref_default_flag ar_gta_system_parameters_all.latest_ref_default_flag%TYPE;
2045: l_ra_line_context_code ar_gta_system_parameters_all.ra_line_context_code%TYPE;
2046: l_ra_model_attribute_column ar_gta_system_parameters_all.ra_model_attribute_column%TYPE;
2047: l_ra_tax_attribute_column ar_gta_system_parameters_all.ra_tax_attribute_column%TYPE;
2048: l_inv_item_context_code ar_gta_system_parameters_all.inv_item_context_code%TYPE;
2049: l_inv_model_attribute_column ar_gta_system_parameters_all.inv_model_attribute_column%TYPE;

Line 2046: l_ra_model_attribute_column ar_gta_system_parameters_all.ra_model_attribute_column%TYPE;

2042: l_cross_reference_type ar_gta_system_parameters_all.cross_reference_type%TYPE;
2043: l_master_item_default_flag ar_gta_system_parameters_all.master_item_default_flag%TYPE;
2044: l_latest_ref_default_flag ar_gta_system_parameters_all.latest_ref_default_flag%TYPE;
2045: l_ra_line_context_code ar_gta_system_parameters_all.ra_line_context_code%TYPE;
2046: l_ra_model_attribute_column ar_gta_system_parameters_all.ra_model_attribute_column%TYPE;
2047: l_ra_tax_attribute_column ar_gta_system_parameters_all.ra_tax_attribute_column%TYPE;
2048: l_inv_item_context_code ar_gta_system_parameters_all.inv_item_context_code%TYPE;
2049: l_inv_model_attribute_column ar_gta_system_parameters_all.inv_model_attribute_column%TYPE;
2050: l_inv_tax_attribute_column ar_gta_system_parameters_all.Inv_Tax_Attribute_Column%TYPE;

Line 2047: l_ra_tax_attribute_column ar_gta_system_parameters_all.ra_tax_attribute_column%TYPE;

2043: l_master_item_default_flag ar_gta_system_parameters_all.master_item_default_flag%TYPE;
2044: l_latest_ref_default_flag ar_gta_system_parameters_all.latest_ref_default_flag%TYPE;
2045: l_ra_line_context_code ar_gta_system_parameters_all.ra_line_context_code%TYPE;
2046: l_ra_model_attribute_column ar_gta_system_parameters_all.ra_model_attribute_column%TYPE;
2047: l_ra_tax_attribute_column ar_gta_system_parameters_all.ra_tax_attribute_column%TYPE;
2048: l_inv_item_context_code ar_gta_system_parameters_all.inv_item_context_code%TYPE;
2049: l_inv_model_attribute_column ar_gta_system_parameters_all.inv_model_attribute_column%TYPE;
2050: l_inv_tax_attribute_column ar_gta_system_parameters_all.Inv_Tax_Attribute_Column%TYPE;
2051: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;

Line 2048: l_inv_item_context_code ar_gta_system_parameters_all.inv_item_context_code%TYPE;

2044: l_latest_ref_default_flag ar_gta_system_parameters_all.latest_ref_default_flag%TYPE;
2045: l_ra_line_context_code ar_gta_system_parameters_all.ra_line_context_code%TYPE;
2046: l_ra_model_attribute_column ar_gta_system_parameters_all.ra_model_attribute_column%TYPE;
2047: l_ra_tax_attribute_column ar_gta_system_parameters_all.ra_tax_attribute_column%TYPE;
2048: l_inv_item_context_code ar_gta_system_parameters_all.inv_item_context_code%TYPE;
2049: l_inv_model_attribute_column ar_gta_system_parameters_all.inv_model_attribute_column%TYPE;
2050: l_inv_tax_attribute_column ar_gta_system_parameters_all.Inv_Tax_Attribute_Column%TYPE;
2051: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2052: l_cross_rows NUMBER;

Line 2049: l_inv_model_attribute_column ar_gta_system_parameters_all.inv_model_attribute_column%TYPE;

2045: l_ra_line_context_code ar_gta_system_parameters_all.ra_line_context_code%TYPE;
2046: l_ra_model_attribute_column ar_gta_system_parameters_all.ra_model_attribute_column%TYPE;
2047: l_ra_tax_attribute_column ar_gta_system_parameters_all.ra_tax_attribute_column%TYPE;
2048: l_inv_item_context_code ar_gta_system_parameters_all.inv_item_context_code%TYPE;
2049: l_inv_model_attribute_column ar_gta_system_parameters_all.inv_model_attribute_column%TYPE;
2050: l_inv_tax_attribute_column ar_gta_system_parameters_all.Inv_Tax_Attribute_Column%TYPE;
2051: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2052: l_cross_rows NUMBER;
2053: --29-JUN-2006 Updated by shujuan

Line 2050: l_inv_tax_attribute_column ar_gta_system_parameters_all.Inv_Tax_Attribute_Column%TYPE;

2046: l_ra_model_attribute_column ar_gta_system_parameters_all.ra_model_attribute_column%TYPE;
2047: l_ra_tax_attribute_column ar_gta_system_parameters_all.ra_tax_attribute_column%TYPE;
2048: l_inv_item_context_code ar_gta_system_parameters_all.inv_item_context_code%TYPE;
2049: l_inv_model_attribute_column ar_gta_system_parameters_all.inv_model_attribute_column%TYPE;
2050: l_inv_tax_attribute_column ar_gta_system_parameters_all.Inv_Tax_Attribute_Column%TYPE;
2051: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2052: l_cross_rows NUMBER;
2053: --29-JUN-2006 Updated by shujuan
2054: l_cross_reference MTL_CROSS_REFERENCES_B.cross_reference%TYPE;

Line 2051: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;

2047: l_ra_tax_attribute_column ar_gta_system_parameters_all.ra_tax_attribute_column%TYPE;
2048: l_inv_item_context_code ar_gta_system_parameters_all.inv_item_context_code%TYPE;
2049: l_inv_model_attribute_column ar_gta_system_parameters_all.inv_model_attribute_column%TYPE;
2050: l_inv_tax_attribute_column ar_gta_system_parameters_all.Inv_Tax_Attribute_Column%TYPE;
2051: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2052: l_cross_rows NUMBER;
2053: --29-JUN-2006 Updated by shujuan
2054: l_cross_reference MTL_CROSS_REFERENCES_B.cross_reference%TYPE;
2055: l_sales_list_flag VARCHAR2(1);

Line 2235: --select parameters from AR_GTA_SYSTEM_PARAMETERS_ALL dependence org_id

2231: 'Begin Retrieve_AR_TRXs......');
2232: END IF;
2233:
2234: -- begin select parameters
2235: --select parameters from AR_GTA_SYSTEM_PARAMETERS_ALL dependence org_id
2236: BEGIN
2237: SELECT vat_tax_type_code,
2238: trx_line_split_flag,
2239: gt_currency_code,

Line 2265: FROM ar_gta_system_parameters_all

2261: l_inv_item_context_code,
2262: l_inv_model_attribute_column,
2263: l_inv_tax_attribute_column,
2264: l_currency_code
2265: FROM ar_gta_system_parameters_all
2266: WHERE org_id = p_org_id;
2267:
2268: EXCEPTION
2269: WHEN no_data_found THEN

Line 3575: FROM AR_GTA_SYSTEM_PARAMETERS_all

3571:
3572: /* added by yoyo to handling different flag of unit_price_split */
3573: SELECT unit_price_split_flag
3574: INTO l_unit_price_split_flag
3575: FROM AR_GTA_SYSTEM_PARAMETERS_all
3576: WHERE org_id = p_org_id;
3577:
3578: -- default is not split for unit_price exceeded
3579: IF (l_unit_price_split_flag IS NULL) OR