APPS.PER_US_EEO5_EXP_PKG dependencies on FND_FILE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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