DBA Data[Home] [Help]

APPS.ARP_TRX_VALIDATE dependencies on OE_PROFILE

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

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

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