DBA Data[Home] [Help]

APPS.ARP_TRX_VALIDATE dependencies on ARP_GLOBAL

Line 1675: to_number(oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id))

1671: INTO l_temp
1672: FROM ORG_FREIGHT
1673: WHERE freight_code = p_ship_method_code
1674: AND organization_id =
1675: to_number(oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id))
1676: AND p_trx_date < NVL(TRUNC(DISABLE_DATE), p_trx_date + 1);
1677:
1678: EXCEPTION
1679: WHEN NO_DATA_FOUND THEN

Line 2019: -- AND aba.set_of_books_id = arp_global.set_of_books_id

2015: AND p_invoice_currency_code in
2016: (select currency_code from iby_fndcpt_payer_assgn_instr_v where
2017: party_id in (l_paying_customer_id,l_bill_to_customer_id))))))*/
2018: /* New Condition added Ends*/
2019: -- AND aba.set_of_books_id = arp_global.set_of_books_id
2020: AND arm.receipt_method_id = p_receipt_method_id
2021: AND p_trx_date < NVL(cba.end_date,
2022: TO_DATE('01/01/2200','DD/MM/YYYY') )
2023: AND p_trx_date BETWEEN NVL(arm.start_date,

Line 2745: pg_base_curr_code := arp_global.functional_currency;

2741:
2742: PROCEDURE init IS
2743: BEGIN
2744:
2745: pg_base_curr_code := arp_global.functional_currency;
2746: pg_salesrep_required_flag :=
2747: arp_trx_global.system_info.system_parameters.salesrep_required_flag;
2748: pg_set_of_books_id :=
2749: arp_trx_global.system_info.system_parameters.set_of_books_id;