DBA Data[Home] [Help]

APPS.PER_US_VETS_100A_CONS_PKG dependencies on WRITE_AUDIT

Line 1227: write_audit.put(l_buffer);

1223: p_job_category_name || g_delimiter ||
1224: per.assignment_id || g_delimiter ||
1225: p_state ||
1226: g_eol;
1227: write_audit.put(l_buffer);
1228: end loop;
1229: end if;
1230: if P_AUDIT_REPORT = 'Y' and P_SHOW_NEW_HIRES = 'Y' then
1231: for per in c_audit_report_nh(l_est_node_id)

Line 1243: write_audit.put(l_buffer);

1239: p_job_category_name || g_delimiter ||
1240: per.assignment_id || g_delimiter ||
1241: p_state ||
1242: g_eol;
1243: write_audit.put(l_buffer);
1244: end loop;
1245: end if;
1246:
1247: for per in c_nonreported(l_est_node_id)

Line 1339: write_audit.open('PERRPVTC_100A');

1335: write_to_concurrent_out(l_xml_string);
1336: l_xml_string :='';
1337:
1338: if P_AUDIT_REPORT = 'Y' then
1339: write_audit.open('PERRPVTC_100A');
1340: l_buffer := 'Person Id' || g_delimiter ||
1341: 'Last Name' || g_delimiter ||
1342: 'First Name' || g_delimiter ||
1343: 'Employee Number' || g_delimiter ||

Line 1350: write_audit.put(l_buffer);

1346: 'Job Category' || g_delimiter ||
1347: 'Assignment Id' || g_delimiter ||
1348: 'State' ||
1349: g_eol;
1350: write_audit.put(l_buffer);
1351: end if;
1352:
1353: write_to_concurrent_log('Please find the Employee details who are not counted under Recently Seperated Veteran Category.Please Correct them');
1354:

Line 1532: write_audit.close;

1528: write_to_concurrent_out(l_xml_string);
1529: l_xml_string :='';
1530:
1531: if P_AUDIT_REPORT = 'Y' then
1532: write_audit.close;
1533: end if;
1534:
1535: End GET_VETS100A_DATA;
1536: