DBA Data[Home] [Help]

APPS.ARP_TRX_VALIDATE dependencies on OE_PROFILE

Line 1423: oe_profile.get( 'SO_SOURCE_CODE', l_so_source_code );

1419: get the commitment balance at that moment. If it is
1420: exhausted, we will flag an error. */
1421:
1422: BEGIN
1423: oe_profile.get( 'SO_SOURCE_CODE', l_so_source_code );
1424:
1425: SELECT 'invoice date is ok',
1426: arp_bal_util.get_commitment_balance(
1427: p_initial_customer_trx_id,

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