DBA Data[Home] [Help]

APPS.PAY_AU_SOE_PKG dependencies on HR_UTILITY

Line 1005: hr_utility.trace('Entering Function super_fund_name');

1001:
1002: begin
1003:
1004: if g_debug then
1005: hr_utility.trace('Entering Function super_fund_name');
1006: hr_utility.trace('Value of p_source_id is '||p_source_id);
1007: hr_utility.trace('Value of p_element_reporting_name is '||p_element_reporting_name);
1008: hr_utility.trace('Value of p_date_earned is '||p_date_earned);
1009: hr_utility.trace('Value of p_assignment_action_id is '||p_assignment_action_id);

Line 1006: hr_utility.trace('Value of p_source_id is '||p_source_id);

1002: begin
1003:
1004: if g_debug then
1005: hr_utility.trace('Entering Function super_fund_name');
1006: hr_utility.trace('Value of p_source_id is '||p_source_id);
1007: hr_utility.trace('Value of p_element_reporting_name is '||p_element_reporting_name);
1008: hr_utility.trace('Value of p_date_earned is '||p_date_earned);
1009: hr_utility.trace('Value of p_assignment_action_id is '||p_assignment_action_id);
1010: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);

Line 1007: hr_utility.trace('Value of p_element_reporting_name is '||p_element_reporting_name);

1003:
1004: if g_debug then
1005: hr_utility.trace('Entering Function super_fund_name');
1006: hr_utility.trace('Value of p_source_id is '||p_source_id);
1007: hr_utility.trace('Value of p_element_reporting_name is '||p_element_reporting_name);
1008: hr_utility.trace('Value of p_date_earned is '||p_date_earned);
1009: hr_utility.trace('Value of p_assignment_action_id is '||p_assignment_action_id);
1010: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);
1011: hr_utility.trace('Value of p_element_entry_id is '||p_element_entry_id);

Line 1008: hr_utility.trace('Value of p_date_earned is '||p_date_earned);

1004: if g_debug then
1005: hr_utility.trace('Entering Function super_fund_name');
1006: hr_utility.trace('Value of p_source_id is '||p_source_id);
1007: hr_utility.trace('Value of p_element_reporting_name is '||p_element_reporting_name);
1008: hr_utility.trace('Value of p_date_earned is '||p_date_earned);
1009: hr_utility.trace('Value of p_assignment_action_id is '||p_assignment_action_id);
1010: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);
1011: hr_utility.trace('Value of p_element_entry_id is '||p_element_entry_id);
1012: end if;

Line 1009: hr_utility.trace('Value of p_assignment_action_id is '||p_assignment_action_id);

1005: hr_utility.trace('Entering Function super_fund_name');
1006: hr_utility.trace('Value of p_source_id is '||p_source_id);
1007: hr_utility.trace('Value of p_element_reporting_name is '||p_element_reporting_name);
1008: hr_utility.trace('Value of p_date_earned is '||p_date_earned);
1009: hr_utility.trace('Value of p_assignment_action_id is '||p_assignment_action_id);
1010: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);
1011: hr_utility.trace('Value of p_element_entry_id is '||p_element_entry_id);
1012: end if;
1013:

Line 1010: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);

1006: hr_utility.trace('Value of p_source_id is '||p_source_id);
1007: hr_utility.trace('Value of p_element_reporting_name is '||p_element_reporting_name);
1008: hr_utility.trace('Value of p_date_earned is '||p_date_earned);
1009: hr_utility.trace('Value of p_assignment_action_id is '||p_assignment_action_id);
1010: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);
1011: hr_utility.trace('Value of p_element_entry_id is '||p_element_entry_id);
1012: end if;
1013:
1014: /* Get value of payee id attached to the element */

Line 1011: hr_utility.trace('Value of p_element_entry_id is '||p_element_entry_id);

1007: hr_utility.trace('Value of p_element_reporting_name is '||p_element_reporting_name);
1008: hr_utility.trace('Value of p_date_earned is '||p_date_earned);
1009: hr_utility.trace('Value of p_assignment_action_id is '||p_assignment_action_id);
1010: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);
1011: hr_utility.trace('Value of p_element_entry_id is '||p_element_entry_id);
1012: end if;
1013:
1014: /* Get value of payee id attached to the element */
1015:

Line 1022: hr_utility.trace(' l_payee_id is is '||l_payee_id);

1018: fetch c_get_third_party_payment_id into l_payee_id;
1019: close c_get_third_party_payment_id ;
1020:
1021: if g_debug then
1022: hr_utility.trace(' l_payee_id is is '||l_payee_id);
1023: end if;
1024:
1025: /* Get value of Superannuation Fund from Payee Organization Super Fund for the element
1026: This may either be the Seeded Superannuation Element or Employer Charge Element with

Line 1036: hr_utility.trace('Fund Name is '||l_fund_name);

1032: fetch c_get_third_party_fund_name into l_fund_name ;
1033: close c_get_third_party_fund_name ;
1034:
1035: if g_debug then
1036: hr_utility.trace('Fund Name is '||l_fund_name);
1037: end if;
1038:
1039: end if;
1040:

Line 1068: hr_utility.trace('Fund Name is '||l_fund_name);

1064: fetch c_get_super_fund_name into l_fund_name,l_element_entry_id;
1065: close c_get_super_fund_name;
1066: end if;
1067: if g_debug then
1068: hr_utility.trace('Fund Name is '||l_fund_name);
1069: end if;
1070:
1071: if l_element_entry_id is not null then
1072:

Line 1078: hr_utility.trace(' l_payee_id is is '||l_payee_id);

1074: fetch c_get_third_party_payment_id into l_payee_id;
1075: close c_get_third_party_payment_id ;
1076:
1077: if g_debug then
1078: hr_utility.trace(' l_payee_id is is '||l_payee_id);
1079: end if;
1080:
1081: /* Get value of Superannuation Fund from Payee Organization Super Fund
1082: for the Superannuation Information Element */

Line 1091: hr_utility.trace('Fund Name is '||l_fund_name);

1087: fetch c_get_third_party_fund_name into l_fund_name ;
1088: close c_get_third_party_fund_name ;
1089:
1090: if g_debug then
1091: hr_utility.trace('Fund Name is '||l_fund_name);
1092: end if;
1093:
1094: end if;
1095:

Line 1107: hr_utility.trace('Fund Name RETURNED is '||l_fund_name);

1103: l_fund_name := p_element_reporting_name ;
1104:
1105: end if;
1106: if g_debug then
1107: hr_utility.trace('Fund Name RETURNED is '||l_fund_name);
1108: end if;
1109:
1110: return l_fund_name;
1111:

Line 1190: g_debug := hr_utility.debug_enabled;

1186:
1187:
1188: BEGIN
1189:
1190: g_debug := hr_utility.debug_enabled;
1191:
1192: /* Bug 5967108 - Added Check for Multiple Hours Input
1193: If Input Name = "Hours", return run result for it
1194: else sum the run results for all "H_" UOM type.

Line 1279: g_debug := hr_utility.debug_enabled;

1275: AND prrv.input_value_id = c_input_value_id;
1276:
1277: BEGIN
1278:
1279: g_debug := hr_utility.debug_enabled;
1280:
1281: if g_debug then
1282: hr_utility.trace('Entering get_element_payment_rate');
1283: end if;

Line 1282: hr_utility.trace('Entering get_element_payment_rate');

1278:
1279: g_debug := hr_utility.debug_enabled;
1280:
1281: if g_debug then
1282: hr_utility.trace('Entering get_element_payment_rate');
1283: end if;
1284:
1285: OPEN get_rate_input_value(p_element_type_id,p_effective_date);
1286: FETCH get_rate_input_value INTO l_input_value_id;

Line 1303: hr_utility.trace('l_result is ' || l_result);

1299: l_result := NULL;
1300: END IF;
1301:
1302: if g_debug then
1303: hr_utility.trace('l_result is ' || l_result);
1304: end if;
1305:
1306: if g_debug then
1307: hr_utility.trace('Leaving get_element_payment_rate');

Line 1307: hr_utility.trace('Leaving get_element_payment_rate');

1303: hr_utility.trace('l_result is ' || l_result);
1304: end if;
1305:
1306: if g_debug then
1307: hr_utility.trace('Leaving get_element_payment_rate');
1308: end if;
1309:
1310: RETURN l_result;
1311: END get_element_payment_rate;

Line 1359: g_debug := hr_utility.debug_enabled;

1355: AND prrv.input_value_id = c_input_value_id;
1356:
1357: BEGIN
1358:
1359: g_debug := hr_utility.debug_enabled;
1360:
1361: OPEN get_hours_input_value(p_element_type_id,p_effective_date);
1362: FETCH get_hours_input_value INTO l_input_value_id;
1363: CLOSE get_hours_input_value;