DBA Data[Home] [Help]

APPS.PQH_REFRESH_DATA dependencies on PQH_REFRESH_DATA

Line 1: Package Body pqh_refresh_data AS

1: Package Body pqh_refresh_data AS
2: /* $Header: pqrefdat.pkb 120.0 2005/05/29 02:26:24 appldev noship $ */
3: -- ----------------------------------------------------------------------------
4: -- | Private Global Definitions |
5: -- ----------------------------------------------------------------------------

Line 7: g_package varchar2(33) := ' pqh_refresh_data.'; -- Global package name

3: -- ----------------------------------------------------------------------------
4: -- | Private Global Definitions |
5: -- ----------------------------------------------------------------------------
6: --
7: g_package varchar2(33) := ' pqh_refresh_data.'; -- Global package name
8: --
9: -- ----------------------------------------------------------------------------
10: -- | Private Variables and functions for string parsing
11: -- ----------------------------------------------------------------------------

Line 829: return pqh_refresh_data.g_refresh_tab_all(p_index).txn_val;

825: BEGIN
826: --
827: hr_utility.set_location('Entering:'||l_proc, 5);
828: --
829: return pqh_refresh_data.g_refresh_tab_all(p_index).txn_val;
830: --
831: hr_utility.set_location('Entering:'||l_proc, 5);
832: --
833: exception when others then

Line 867: l_col_val := 'pqh_refresh_data.ret_value_from_glb_table('

863: LOOP
864: hr_utility.set_location('Searching g_refresh_tab_all:'|| UPPER(g_refresh_tab_all(i).column_name)||','|| UPPER(p_column_name),7);
865: IF UPPER(g_refresh_tab_all(i).column_name) = UPPER(p_column_name) THEN
866: hr_utility.set_location('Found match in g_refresh_tab_all',8);
867: l_col_val := 'pqh_refresh_data.ret_value_from_glb_table('
868: || to_char(i)
869: || ')';
870: l_col_type := g_refresh_tab_all(i).column_type;
871: EXIT; -- exit the loop as the column is found

Line 1621: OPEN c1(pqh_refresh_data.g_refresh_bak(i).column_name);

1617:
1618: IF g_refresh_bak(i).updt_flag = 'C' THEN
1619: -- get the form_column_name for the column_name and populate the prvcalc table
1620:
1621: OPEN c1(pqh_refresh_data.g_refresh_bak(i).column_name);
1622: FETCH c1 INTO l_form_column_name;
1623: CLOSE c1;
1624:
1625: -- populate the global prv_tab

Line 1775: END; -- Package Body PQH_REFRESH_DATA

1771: END LOOP;
1772: END IF;
1773: END parse_string;
1774:
1775: END; -- Package Body PQH_REFRESH_DATA