APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on PAY_ACTION_INFORMATION

Line 5: TYPE char_tab IS TABLE OF pay_action_information.action_information1%type INDEX BY BINARY_INTEGER;

1: PACKAGE BODY pay_nl_nwr_xml_extract_pkg as
2: /* $Header: pynlwrep.pkb 120.26.12020000.6 2013/01/11 09:32:01 mkuppuch ship $ */
3: --
4:
5: TYPE char_tab IS TABLE OF pay_action_information.action_information1%type INDEX BY BINARY_INTEGER;
6: g_xml_nwr char_tab;
7: --
8: g_action_ctx_id NUMBER;
9: sqlstr DBMS_SQL.VARCHAR2S;

Line 118: l_tag pay_action_information.action_information1%TYPE;

114: ORDER BY active_date desc, lookup_code desc ;
115:
116: l_temp_data csr_get_tag_descr%ROWTYPE;
117: l_description VARCHAR2(500);
118: l_tag pay_action_information.action_information1%TYPE;
119:
120: BEGIN
121: IF p_tag IS NOT NULL THEN
122: IF g_year >= '2013' AND p_tag='WGHZVW' Then

Line 220: l_data pay_action_information.action_information1%TYPE;

216: PROCEDURE load_xml_internal (P_NODE_TYPE VARCHAR2
217: ,P_NODE VARCHAR2
218: ,P_DATA VARCHAR2) AS
219: l_proc_name VARCHAR2(100);
220: l_data pay_action_information.action_information1%TYPE;
221: --
222: BEGIN
223: --
224: IF p_node_type = 'CS' THEN

Line 289: l_data pay_action_information.action_information1%TYPE;

285: --
286:
287: l_proc_name VARCHAR2(100);
288: l_tag_name VARCHAR2(500);
289: l_data pay_action_information.action_information1%TYPE;
290: l_display VARCHAR2(1);
291: l_replace hr_lookups.description%TYPE;
292:
293: --