APPS.PER_US_EEO4_EXP_PKG dependencies on FND_FILE

Line 95: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query);

91: AND ppei.person_id=peo.person_id)
92: )
93: )';
94:
95: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query);
96:
97: qryCtx := dbms_xmlgen.newContext (l_query);
98:
99: l_xml_string := '';

Line 100: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

96:
97: qryCtx := dbms_xmlgen.newContext (l_query);
98:
99: l_xml_string := '';
100: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
102:
103: l_xml_string := '';
104: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

Line 101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

97: qryCtx := dbms_xmlgen.newContext (l_query);
98:
99: l_xml_string := '';
100: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
102:
103: l_xml_string := '';
104: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

Line 104: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

100: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
102:
103: l_xml_string := '';
104: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
106:
107: --Load 5 records at a time
108: DBMS_XMLGEN.setMaxRows(qryCtx, 5);

Line 105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
102:
103: l_xml_string := '';
104: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
106:
107: --Load 5 records at a time
108: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
109: LOOP

Line 115: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

111: l_result := DBMS_XMLGEN.getXML(qryCtx);
112: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
113: --insert into tab_clob values (to_char(l_xml_string));
114: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
115: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
116: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
117:
118: END LOOP;
119:

Line 116: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

112: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
113: --insert into tab_clob values (to_char(l_xml_string));
114: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
115: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
116: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
117:
118: END LOOP;
119:
120: -- Get Name of the business group.

Line 130: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

126: l_xml_string := ' '|| l_business_group_name ||'
127: ' || to_char(l_report_date, 'dd-Mon-yyyy') ||'
128: ' || p_reporting_year ||'
129: ';
130: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
131: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
132:
133: end generate_exception_report;
134:

Line 131: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

127: ' || to_char(l_report_date, 'dd-Mon-yyyy') ||'
128: ' || p_reporting_year ||'
129: ';
130: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
131: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
132:
133: end generate_exception_report;
134:
135: END PER_US_EEO4_EXP_PKG;