DBA Data[Home] [Help]

APPS.ARP_TRX_VALIDATE dependencies on ARP_GLOBAL

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

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

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

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

Line 2748: pg_base_curr_code := arp_global.functional_currency;

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