DBA Data[Home] [Help]

APPS.PAY_IP_STARTUP_UTIL dependencies on FND_FLEX_KEY_API

Line 1568: l_flexfield fnd_flex_key_api.flexfield_type;

1564: p_shorthand_enabled_flag IN VARCHAR2,
1565: p_shorthand_prompt IN VARCHAR2,
1566: p_shorthand_length IN NUMBER) RETURN NUMBER IS
1567:
1568: l_flexfield fnd_flex_key_api.flexfield_type;
1569: l_structure fnd_flex_key_api.structure_type;
1570: l_application_id NUMBER(15);
1571: l_exists varchar2(1);
1572:

Line 1569: l_structure fnd_flex_key_api.structure_type;

1565: p_shorthand_prompt IN VARCHAR2,
1566: p_shorthand_length IN NUMBER) RETURN NUMBER IS
1567:
1568: l_flexfield fnd_flex_key_api.flexfield_type;
1569: l_structure fnd_flex_key_api.structure_type;
1570: l_application_id NUMBER(15);
1571: l_exists varchar2(1);
1572:
1573:

Line 1593: fnd_flex_key_api.set_session_mode('seed_data');

1589: FROM FND_APPLICATION
1590: WHERE application_short_name = p_appl_Short_Name;
1591:
1592: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',10);
1593: fnd_flex_key_api.set_session_mode('seed_data');
1594:
1595: l_flexfield := fnd_flex_key_api.find_flexfield
1596: ( appl_short_name => p_appl_short_name,
1597: flex_code => p_flex_code );

Line 1595: l_flexfield := fnd_flex_key_api.find_flexfield

1591:
1592: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',10);
1593: fnd_flex_key_api.set_session_mode('seed_data');
1594:
1595: l_flexfield := fnd_flex_key_api.find_flexfield
1596: ( appl_short_name => p_appl_short_name,
1597: flex_code => p_flex_code );
1598:
1599: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',20);

Line 1602: l_structure := fnd_flex_key_api.find_structure

1598:
1599: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',20);
1600: BEGIN
1601:
1602: l_structure := fnd_flex_key_api.find_structure
1603: ( flexfield => l_flexfield,
1604: structure_code => p_structure_code );
1605:
1606: return l_structure.structure_number;

Line 1624: l_structure:=fnd_flex_key_api.new_structure

1620: END IF;
1621:
1622: CLOSE duplicate_structure_check;
1623:
1624: l_structure:=fnd_flex_key_api.new_structure
1625: (flexfield => l_flexfield,
1626: structure_code => p_structure_code,
1627: structure_title => p_structure_title,
1628: description => p_description,

Line 1652: fnd_flex_key_api.add_structure

1648: WHERE ifs.application_id = l_application_id
1649: AND ifs.id_flex_code = p_flex_code
1650: AND ifs.id_flex_num < 101;
1651:
1652: fnd_flex_key_api.add_structure
1653: ( flexfield => l_flexfield,
1654: structure => l_structure );
1655:
1656: RETURN l_structure.structure_number;

Line 1683: l_flexfield fnd_flex_key_api.flexfield_type;

1679: p_lov_prompt IN VARCHAR2,
1680: p_window_prompt IN VARCHAR2
1681: ) IS
1682:
1683: l_flexfield fnd_flex_key_api.flexfield_type;
1684: l_structure fnd_flex_key_api.structure_type;
1685: l_application_id NUMBER(15);
1686: l_flex_num NUMBER(15);
1687: l_segment fnd_flex_key_api.segment_type;

Line 1684: l_structure fnd_flex_key_api.structure_type;

1680: p_window_prompt IN VARCHAR2
1681: ) IS
1682:
1683: l_flexfield fnd_flex_key_api.flexfield_type;
1684: l_structure fnd_flex_key_api.structure_type;
1685: l_application_id NUMBER(15);
1686: l_flex_num NUMBER(15);
1687: l_segment fnd_flex_key_api.segment_type;
1688: BEGIN

Line 1687: l_segment fnd_flex_key_api.segment_type;

1683: l_flexfield fnd_flex_key_api.flexfield_type;
1684: l_structure fnd_flex_key_api.structure_type;
1685: l_application_id NUMBER(15);
1686: l_flex_num NUMBER(15);
1687: l_segment fnd_flex_key_api.segment_type;
1688: BEGIN
1689:
1690: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',10);
1691: fnd_flex_key_api.set_session_mode('seed_data');

Line 1691: fnd_flex_key_api.set_session_mode('seed_data');

1687: l_segment fnd_flex_key_api.segment_type;
1688: BEGIN
1689:
1690: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',10);
1691: fnd_flex_key_api.set_session_mode('seed_data');
1692: l_flexfield := fnd_flex_key_api.find_flexfield
1693: ( appl_short_name => p_appl_short_name,
1694: flex_code => p_flex_code );
1695:

Line 1692: l_flexfield := fnd_flex_key_api.find_flexfield

1688: BEGIN
1689:
1690: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',10);
1691: fnd_flex_key_api.set_session_mode('seed_data');
1692: l_flexfield := fnd_flex_key_api.find_flexfield
1693: ( appl_short_name => p_appl_short_name,
1694: flex_code => p_flex_code );
1695:
1696: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',11);

Line 1698: l_structure := fnd_flex_key_api.find_structure

1694: flex_code => p_flex_code );
1695:
1696: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',11);
1697:
1698: l_structure := fnd_flex_key_api.find_structure
1699: ( flexfield => l_flexfield,
1700: structure_code => p_structure_code );
1701:
1702: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',12);

Line 1706: l_segment := fnd_flex_key_api.find_segment

1702: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',12);
1703: begin
1704:
1705: hr_utility.trace(p_segment_name);
1706: l_segment := fnd_flex_key_api.find_segment
1707: (
1708: flexfield => l_flexfield
1709: ,structure => l_structure
1710: ,segment_name => p_segment_name

Line 1714: l_segment:= fnd_flex_key_api.new_segment

1710: ,segment_name => p_segment_name
1711: );
1712: exception
1713: when no_data_found then
1714: l_segment:= fnd_flex_key_api.new_segment
1715: (
1716: flexfield => l_flexfield
1717: ,structure => l_structure
1718: ,segment_name => p_segment_name

Line 1741: fnd_flex_key_api.add_segment

1737: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',13);
1738:
1739: hr_utility.trace(p_segment_name);
1740: begin
1741: fnd_flex_key_api.add_segment
1742: (
1743: flexfield => l_flexfield
1744: ,structure => l_structure
1745: ,segment => l_segment

Line 1749: hr_utility.trace(substr(fnd_flex_key_api.message,1,256));

1745: ,segment => l_segment
1746: );
1747: exception
1748: when others then
1749: hr_utility.trace(substr(fnd_flex_key_api.message,1,256));
1750: end;
1751: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',14);
1752: fnd_flex_key_api.assign_qualifier
1753: (

Line 1752: fnd_flex_key_api.assign_qualifier

1748: when others then
1749: hr_utility.trace(substr(fnd_flex_key_api.message,1,256));
1750: end;
1751: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',14);
1752: fnd_flex_key_api.assign_qualifier
1753: (
1754: flexfield => l_flexfield
1755: ,structure => l_structure
1756: ,segment => l_segment