DBA Data[Home] [Help]

APPS.OKL_ACCOUNTING_UTIL dependencies on AK_REGION_ITEMS

Line 1845: p_region_code IN ak_region_items.region_code%TYPE,

1841: ============================================================================*/
1842:
1843: FUNCTION Get_Message_Token
1844: (
1845: p_region_code IN ak_region_items.region_code%TYPE,
1846: p_attribute_code IN ak_region_items.attribute_code%TYPE,
1847: p_application_id IN fnd_application.application_id%TYPE DEFAULT 540
1848: )
1849: RETURN VARCHAR2

Line 1846: p_attribute_code IN ak_region_items.attribute_code%TYPE,

1842:
1843: FUNCTION Get_Message_Token
1844: (
1845: p_region_code IN ak_region_items.region_code%TYPE,
1846: p_attribute_code IN ak_region_items.attribute_code%TYPE,
1847: p_application_id IN fnd_application.application_id%TYPE DEFAULT 540
1848: )
1849: RETURN VARCHAR2
1850: IS

Line 1858: FROM ak_region_items ri, ak_region_items_tl rit

1854: -- Cursor which selects the label of an attribute belongs to a region.
1855:
1856: CURSOR label_cur IS
1857: SELECT rit.attribute_label_long
1858: FROM ak_region_items ri, ak_region_items_tl rit
1859: WHERE ri.region_code = p_region_code AND
1860: ri.attribute_code = p_attribute_code AND
1861: ri.region_application_id = p_application_id AND
1862: ri.attribute_application_id = p_application_id AND