eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_WPM_MASS_SCORE_CARD_TRNSF dependencies on HR_TRANSACTION_SWI

Line 262: txnXml := hr_transaction_swi.convertCLOBtoXMLElement(txnClob);

258: OPEN csr_clob(p_transaction_id);
259: FETCH csr_clob INTO txnClob;
260: CLOSE csr_clob;
261: IF txnClob IS NOT NULL THEN -- process only when there is a non null transaction document.
262: txnXml := hr_transaction_swi.convertCLOBtoXMLElement(txnClob);
263: -- Process the FndDocuments rows and populate the pl/sql table
264: nl := xmldom.getElementsByTagName(txnXml, 'FndDocumentsVlEORow');
265: len1 := xmldom.getLength(nl);
266: -- loop through elements

Line 271: gt_doc(j+1).Document_id := hr_transaction_swi.getNumberValue(n,'DocumentId',null);

267: FOR j in 0..len1-1 LOOP
268: n := xmldom.item(nl, j);
269: e := xmldom.makeElement(n);
270: gt_doc(j+1).post_State := xmldom.getAttribute(e, 'PS');
271: gt_doc(j+1).Document_id := hr_transaction_swi.getNumberValue(n,'DocumentId',null);
272: gt_doc(j+1).Created_By := hr_transaction_swi.getNumberValue(n,'CreatedBy',null);
273: gt_doc(j+1).creation_date := hr_transaction_swi.getDateValue(n,'CreationDate',null);
274: gt_doc(j+1).last_update_date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);
275: gt_doc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);

Line 272: gt_doc(j+1).Created_By := hr_transaction_swi.getNumberValue(n,'CreatedBy',null);

268: n := xmldom.item(nl, j);
269: e := xmldom.makeElement(n);
270: gt_doc(j+1).post_State := xmldom.getAttribute(e, 'PS');
271: gt_doc(j+1).Document_id := hr_transaction_swi.getNumberValue(n,'DocumentId',null);
272: gt_doc(j+1).Created_By := hr_transaction_swi.getNumberValue(n,'CreatedBy',null);
273: gt_doc(j+1).creation_date := hr_transaction_swi.getDateValue(n,'CreationDate',null);
274: gt_doc(j+1).last_update_date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);
275: gt_doc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);
276: gt_doc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);

Line 273: gt_doc(j+1).creation_date := hr_transaction_swi.getDateValue(n,'CreationDate',null);

269: e := xmldom.makeElement(n);
270: gt_doc(j+1).post_State := xmldom.getAttribute(e, 'PS');
271: gt_doc(j+1).Document_id := hr_transaction_swi.getNumberValue(n,'DocumentId',null);
272: gt_doc(j+1).Created_By := hr_transaction_swi.getNumberValue(n,'CreatedBy',null);
273: gt_doc(j+1).creation_date := hr_transaction_swi.getDateValue(n,'CreationDate',null);
274: gt_doc(j+1).last_update_date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);
275: gt_doc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);
276: gt_doc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);
277: gt_doc(j+1).Datatype_Id := hr_transaction_swi.getNumberValue(n,'DatatypeId',null);

Line 274: gt_doc(j+1).last_update_date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);

270: gt_doc(j+1).post_State := xmldom.getAttribute(e, 'PS');
271: gt_doc(j+1).Document_id := hr_transaction_swi.getNumberValue(n,'DocumentId',null);
272: gt_doc(j+1).Created_By := hr_transaction_swi.getNumberValue(n,'CreatedBy',null);
273: gt_doc(j+1).creation_date := hr_transaction_swi.getDateValue(n,'CreationDate',null);
274: gt_doc(j+1).last_update_date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);
275: gt_doc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);
276: gt_doc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);
277: gt_doc(j+1).Datatype_Id := hr_transaction_swi.getNumberValue(n,'DatatypeId',null);
278: gt_doc(j+1).Description := hr_transaction_swi.getVarchar2Value(n,'Description',null);

Line 275: gt_doc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);

271: gt_doc(j+1).Document_id := hr_transaction_swi.getNumberValue(n,'DocumentId',null);
272: gt_doc(j+1).Created_By := hr_transaction_swi.getNumberValue(n,'CreatedBy',null);
273: gt_doc(j+1).creation_date := hr_transaction_swi.getDateValue(n,'CreationDate',null);
274: gt_doc(j+1).last_update_date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);
275: gt_doc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);
276: gt_doc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);
277: gt_doc(j+1).Datatype_Id := hr_transaction_swi.getNumberValue(n,'DatatypeId',null);
278: gt_doc(j+1).Description := hr_transaction_swi.getVarchar2Value(n,'Description',null);
279: gt_doc(j+1).Media_Id := hr_transaction_swi.getNumberValue(n,'MediaId',null);

Line 276: gt_doc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);

272: gt_doc(j+1).Created_By := hr_transaction_swi.getNumberValue(n,'CreatedBy',null);
273: gt_doc(j+1).creation_date := hr_transaction_swi.getDateValue(n,'CreationDate',null);
274: gt_doc(j+1).last_update_date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);
275: gt_doc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);
276: gt_doc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);
277: gt_doc(j+1).Datatype_Id := hr_transaction_swi.getNumberValue(n,'DatatypeId',null);
278: gt_doc(j+1).Description := hr_transaction_swi.getVarchar2Value(n,'Description',null);
279: gt_doc(j+1).Media_Id := hr_transaction_swi.getNumberValue(n,'MediaId',null);
280: gt_doc(j+1).Category_Id := hr_transaction_swi.getNumberValue(n,'CategoryId',null);

Line 277: gt_doc(j+1).Datatype_Id := hr_transaction_swi.getNumberValue(n,'DatatypeId',null);

273: gt_doc(j+1).creation_date := hr_transaction_swi.getDateValue(n,'CreationDate',null);
274: gt_doc(j+1).last_update_date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);
275: gt_doc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);
276: gt_doc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);
277: gt_doc(j+1).Datatype_Id := hr_transaction_swi.getNumberValue(n,'DatatypeId',null);
278: gt_doc(j+1).Description := hr_transaction_swi.getVarchar2Value(n,'Description',null);
279: gt_doc(j+1).Media_Id := hr_transaction_swi.getNumberValue(n,'MediaId',null);
280: gt_doc(j+1).Category_Id := hr_transaction_swi.getNumberValue(n,'CategoryId',null);
281: gt_doc(j+1).Security_Type := hr_transaction_swi.getNumberValue(n,'SecurityType',null);

Line 278: gt_doc(j+1).Description := hr_transaction_swi.getVarchar2Value(n,'Description',null);

274: gt_doc(j+1).last_update_date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);
275: gt_doc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);
276: gt_doc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);
277: gt_doc(j+1).Datatype_Id := hr_transaction_swi.getNumberValue(n,'DatatypeId',null);
278: gt_doc(j+1).Description := hr_transaction_swi.getVarchar2Value(n,'Description',null);
279: gt_doc(j+1).Media_Id := hr_transaction_swi.getNumberValue(n,'MediaId',null);
280: gt_doc(j+1).Category_Id := hr_transaction_swi.getNumberValue(n,'CategoryId',null);
281: gt_doc(j+1).Security_Type := hr_transaction_swi.getNumberValue(n,'SecurityType',null);
282: gt_doc(j+1).Publish_Flag := hr_transaction_swi.getVarchar2Value(n,'PublishFlag',null);

Line 279: gt_doc(j+1).Media_Id := hr_transaction_swi.getNumberValue(n,'MediaId',null);

275: gt_doc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);
276: gt_doc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);
277: gt_doc(j+1).Datatype_Id := hr_transaction_swi.getNumberValue(n,'DatatypeId',null);
278: gt_doc(j+1).Description := hr_transaction_swi.getVarchar2Value(n,'Description',null);
279: gt_doc(j+1).Media_Id := hr_transaction_swi.getNumberValue(n,'MediaId',null);
280: gt_doc(j+1).Category_Id := hr_transaction_swi.getNumberValue(n,'CategoryId',null);
281: gt_doc(j+1).Security_Type := hr_transaction_swi.getNumberValue(n,'SecurityType',null);
282: gt_doc(j+1).Publish_Flag := hr_transaction_swi.getVarchar2Value(n,'PublishFlag',null);
283: gt_doc(j+1).Usage_Type := hr_transaction_swi.getVarchar2Value(n,'UsageType',null);

Line 280: gt_doc(j+1).Category_Id := hr_transaction_swi.getNumberValue(n,'CategoryId',null);

276: gt_doc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);
277: gt_doc(j+1).Datatype_Id := hr_transaction_swi.getNumberValue(n,'DatatypeId',null);
278: gt_doc(j+1).Description := hr_transaction_swi.getVarchar2Value(n,'Description',null);
279: gt_doc(j+1).Media_Id := hr_transaction_swi.getNumberValue(n,'MediaId',null);
280: gt_doc(j+1).Category_Id := hr_transaction_swi.getNumberValue(n,'CategoryId',null);
281: gt_doc(j+1).Security_Type := hr_transaction_swi.getNumberValue(n,'SecurityType',null);
282: gt_doc(j+1).Publish_Flag := hr_transaction_swi.getVarchar2Value(n,'PublishFlag',null);
283: gt_doc(j+1).Usage_Type := hr_transaction_swi.getVarchar2Value(n,'UsageType',null);
284: gt_doc(j+1).Dm_Node := hr_transaction_swi.getNumberValue(n,'DmNode',null);

Line 281: gt_doc(j+1).Security_Type := hr_transaction_swi.getNumberValue(n,'SecurityType',null);

277: gt_doc(j+1).Datatype_Id := hr_transaction_swi.getNumberValue(n,'DatatypeId',null);
278: gt_doc(j+1).Description := hr_transaction_swi.getVarchar2Value(n,'Description',null);
279: gt_doc(j+1).Media_Id := hr_transaction_swi.getNumberValue(n,'MediaId',null);
280: gt_doc(j+1).Category_Id := hr_transaction_swi.getNumberValue(n,'CategoryId',null);
281: gt_doc(j+1).Security_Type := hr_transaction_swi.getNumberValue(n,'SecurityType',null);
282: gt_doc(j+1).Publish_Flag := hr_transaction_swi.getVarchar2Value(n,'PublishFlag',null);
283: gt_doc(j+1).Usage_Type := hr_transaction_swi.getVarchar2Value(n,'UsageType',null);
284: gt_doc(j+1).Dm_Node := hr_transaction_swi.getNumberValue(n,'DmNode',null);
285: gt_doc(j+1).File_Name := hr_transaction_swi.getVarchar2Value(n,'FileName',null);

Line 282: gt_doc(j+1).Publish_Flag := hr_transaction_swi.getVarchar2Value(n,'PublishFlag',null);

278: gt_doc(j+1).Description := hr_transaction_swi.getVarchar2Value(n,'Description',null);
279: gt_doc(j+1).Media_Id := hr_transaction_swi.getNumberValue(n,'MediaId',null);
280: gt_doc(j+1).Category_Id := hr_transaction_swi.getNumberValue(n,'CategoryId',null);
281: gt_doc(j+1).Security_Type := hr_transaction_swi.getNumberValue(n,'SecurityType',null);
282: gt_doc(j+1).Publish_Flag := hr_transaction_swi.getVarchar2Value(n,'PublishFlag',null);
283: gt_doc(j+1).Usage_Type := hr_transaction_swi.getVarchar2Value(n,'UsageType',null);
284: gt_doc(j+1).Dm_Node := hr_transaction_swi.getNumberValue(n,'DmNode',null);
285: gt_doc(j+1).File_Name := hr_transaction_swi.getVarchar2Value(n,'FileName',null);
286: gt_doc(j+1).Title := hr_transaction_swi.getVarchar2Value(n,'Title',null);

Line 283: gt_doc(j+1).Usage_Type := hr_transaction_swi.getVarchar2Value(n,'UsageType',null);

279: gt_doc(j+1).Media_Id := hr_transaction_swi.getNumberValue(n,'MediaId',null);
280: gt_doc(j+1).Category_Id := hr_transaction_swi.getNumberValue(n,'CategoryId',null);
281: gt_doc(j+1).Security_Type := hr_transaction_swi.getNumberValue(n,'SecurityType',null);
282: gt_doc(j+1).Publish_Flag := hr_transaction_swi.getVarchar2Value(n,'PublishFlag',null);
283: gt_doc(j+1).Usage_Type := hr_transaction_swi.getVarchar2Value(n,'UsageType',null);
284: gt_doc(j+1).Dm_Node := hr_transaction_swi.getNumberValue(n,'DmNode',null);
285: gt_doc(j+1).File_Name := hr_transaction_swi.getVarchar2Value(n,'FileName',null);
286: gt_doc(j+1).Title := hr_transaction_swi.getVarchar2Value(n,'Title',null);
287:

Line 284: gt_doc(j+1).Dm_Node := hr_transaction_swi.getNumberValue(n,'DmNode',null);

280: gt_doc(j+1).Category_Id := hr_transaction_swi.getNumberValue(n,'CategoryId',null);
281: gt_doc(j+1).Security_Type := hr_transaction_swi.getNumberValue(n,'SecurityType',null);
282: gt_doc(j+1).Publish_Flag := hr_transaction_swi.getVarchar2Value(n,'PublishFlag',null);
283: gt_doc(j+1).Usage_Type := hr_transaction_swi.getVarchar2Value(n,'UsageType',null);
284: gt_doc(j+1).Dm_Node := hr_transaction_swi.getNumberValue(n,'DmNode',null);
285: gt_doc(j+1).File_Name := hr_transaction_swi.getVarchar2Value(n,'FileName',null);
286: gt_doc(j+1).Title := hr_transaction_swi.getVarchar2Value(n,'Title',null);
287:
288: --dbms_output.put_line('DocumentId'||gt_doc(j+1).Document_id);

Line 285: gt_doc(j+1).File_Name := hr_transaction_swi.getVarchar2Value(n,'FileName',null);

281: gt_doc(j+1).Security_Type := hr_transaction_swi.getNumberValue(n,'SecurityType',null);
282: gt_doc(j+1).Publish_Flag := hr_transaction_swi.getVarchar2Value(n,'PublishFlag',null);
283: gt_doc(j+1).Usage_Type := hr_transaction_swi.getVarchar2Value(n,'UsageType',null);
284: gt_doc(j+1).Dm_Node := hr_transaction_swi.getNumberValue(n,'DmNode',null);
285: gt_doc(j+1).File_Name := hr_transaction_swi.getVarchar2Value(n,'FileName',null);
286: gt_doc(j+1).Title := hr_transaction_swi.getVarchar2Value(n,'Title',null);
287:
288: --dbms_output.put_line('DocumentId'||gt_doc(j+1).Document_id);
289: --dbms_output.put_line('PostState: '||gt_doc(j+1).post_State);

Line 286: gt_doc(j+1).Title := hr_transaction_swi.getVarchar2Value(n,'Title',null);

282: gt_doc(j+1).Publish_Flag := hr_transaction_swi.getVarchar2Value(n,'PublishFlag',null);
283: gt_doc(j+1).Usage_Type := hr_transaction_swi.getVarchar2Value(n,'UsageType',null);
284: gt_doc(j+1).Dm_Node := hr_transaction_swi.getNumberValue(n,'DmNode',null);
285: gt_doc(j+1).File_Name := hr_transaction_swi.getVarchar2Value(n,'FileName',null);
286: gt_doc(j+1).Title := hr_transaction_swi.getVarchar2Value(n,'Title',null);
287:
288: --dbms_output.put_line('DocumentId'||gt_doc(j+1).Document_id);
289: --dbms_output.put_line('PostState: '||gt_doc(j+1).post_State);
290: END LOOP;

Line 301: gt_attachdoc(j+1).attached_document_id := hr_transaction_swi.getNumberValue(n,'AttachedDocumentId',null);

297: n := xmldom.item(nl, j);
298: e := xmldom.makeElement(n);
299: gt_attachdoc(j+1).post_State := xmldom.getAttribute(e, 'PS');
300: --dbms_output.put_line('PostState: '||gt_attachdoc(j+1).post_State);
301: gt_attachdoc(j+1).attached_document_id := hr_transaction_swi.getNumberValue(n,'AttachedDocumentId',null);
302: gt_attachdoc(j+1).document_id := hr_transaction_swi.getNumberValue(n,'DocumentId',null);
303: gt_attachdoc(j+1).Creation_Date := hr_transaction_swi.getdateValue(n,'CreationDate',null);
304: gt_attachdoc(j+1).Created_by := hr_transaction_swi.getNumberValue(n,'CreatedBy',null);
305: gt_attachdoc(j+1).Last_Update_Date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);

Line 302: gt_attachdoc(j+1).document_id := hr_transaction_swi.getNumberValue(n,'DocumentId',null);

298: e := xmldom.makeElement(n);
299: gt_attachdoc(j+1).post_State := xmldom.getAttribute(e, 'PS');
300: --dbms_output.put_line('PostState: '||gt_attachdoc(j+1).post_State);
301: gt_attachdoc(j+1).attached_document_id := hr_transaction_swi.getNumberValue(n,'AttachedDocumentId',null);
302: gt_attachdoc(j+1).document_id := hr_transaction_swi.getNumberValue(n,'DocumentId',null);
303: gt_attachdoc(j+1).Creation_Date := hr_transaction_swi.getdateValue(n,'CreationDate',null);
304: gt_attachdoc(j+1).Created_by := hr_transaction_swi.getNumberValue(n,'CreatedBy',null);
305: gt_attachdoc(j+1).Last_Update_Date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);
306: gt_attachdoc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);

Line 303: gt_attachdoc(j+1).Creation_Date := hr_transaction_swi.getdateValue(n,'CreationDate',null);

299: gt_attachdoc(j+1).post_State := xmldom.getAttribute(e, 'PS');
300: --dbms_output.put_line('PostState: '||gt_attachdoc(j+1).post_State);
301: gt_attachdoc(j+1).attached_document_id := hr_transaction_swi.getNumberValue(n,'AttachedDocumentId',null);
302: gt_attachdoc(j+1).document_id := hr_transaction_swi.getNumberValue(n,'DocumentId',null);
303: gt_attachdoc(j+1).Creation_Date := hr_transaction_swi.getdateValue(n,'CreationDate',null);
304: gt_attachdoc(j+1).Created_by := hr_transaction_swi.getNumberValue(n,'CreatedBy',null);
305: gt_attachdoc(j+1).Last_Update_Date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);
306: gt_attachdoc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);
307: gt_attachdoc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);

Line 304: gt_attachdoc(j+1).Created_by := hr_transaction_swi.getNumberValue(n,'CreatedBy',null);

300: --dbms_output.put_line('PostState: '||gt_attachdoc(j+1).post_State);
301: gt_attachdoc(j+1).attached_document_id := hr_transaction_swi.getNumberValue(n,'AttachedDocumentId',null);
302: gt_attachdoc(j+1).document_id := hr_transaction_swi.getNumberValue(n,'DocumentId',null);
303: gt_attachdoc(j+1).Creation_Date := hr_transaction_swi.getdateValue(n,'CreationDate',null);
304: gt_attachdoc(j+1).Created_by := hr_transaction_swi.getNumberValue(n,'CreatedBy',null);
305: gt_attachdoc(j+1).Last_Update_Date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);
306: gt_attachdoc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);
307: gt_attachdoc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);
308: gt_attachdoc(j+1).Seq_Num := hr_transaction_swi.getNumberValue(n,'SeqNum',null);

Line 305: gt_attachdoc(j+1).Last_Update_Date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);

301: gt_attachdoc(j+1).attached_document_id := hr_transaction_swi.getNumberValue(n,'AttachedDocumentId',null);
302: gt_attachdoc(j+1).document_id := hr_transaction_swi.getNumberValue(n,'DocumentId',null);
303: gt_attachdoc(j+1).Creation_Date := hr_transaction_swi.getdateValue(n,'CreationDate',null);
304: gt_attachdoc(j+1).Created_by := hr_transaction_swi.getNumberValue(n,'CreatedBy',null);
305: gt_attachdoc(j+1).Last_Update_Date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);
306: gt_attachdoc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);
307: gt_attachdoc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);
308: gt_attachdoc(j+1).Seq_Num := hr_transaction_swi.getNumberValue(n,'SeqNum',null);
309: gt_attachdoc(j+1).Pk1_Value := hr_transaction_swi.getVarchar2Value(n,'Pk1Value',null);

Line 306: gt_attachdoc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);

302: gt_attachdoc(j+1).document_id := hr_transaction_swi.getNumberValue(n,'DocumentId',null);
303: gt_attachdoc(j+1).Creation_Date := hr_transaction_swi.getdateValue(n,'CreationDate',null);
304: gt_attachdoc(j+1).Created_by := hr_transaction_swi.getNumberValue(n,'CreatedBy',null);
305: gt_attachdoc(j+1).Last_Update_Date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);
306: gt_attachdoc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);
307: gt_attachdoc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);
308: gt_attachdoc(j+1).Seq_Num := hr_transaction_swi.getNumberValue(n,'SeqNum',null);
309: gt_attachdoc(j+1).Pk1_Value := hr_transaction_swi.getVarchar2Value(n,'Pk1Value',null);
310: gt_attachdoc(j+1).entity_name := hr_transaction_swi.getVarchar2Value(n,'EntityName',null); gt_attachdoc(j+1).Automatically_Added_Flag := hr_transaction_swi.getVarchar2Value(n,'AutomaticallyAddedFlag',null);

Line 307: gt_attachdoc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);

303: gt_attachdoc(j+1).Creation_Date := hr_transaction_swi.getdateValue(n,'CreationDate',null);
304: gt_attachdoc(j+1).Created_by := hr_transaction_swi.getNumberValue(n,'CreatedBy',null);
305: gt_attachdoc(j+1).Last_Update_Date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);
306: gt_attachdoc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);
307: gt_attachdoc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);
308: gt_attachdoc(j+1).Seq_Num := hr_transaction_swi.getNumberValue(n,'SeqNum',null);
309: gt_attachdoc(j+1).Pk1_Value := hr_transaction_swi.getVarchar2Value(n,'Pk1Value',null);
310: gt_attachdoc(j+1).entity_name := hr_transaction_swi.getVarchar2Value(n,'EntityName',null); gt_attachdoc(j+1).Automatically_Added_Flag := hr_transaction_swi.getVarchar2Value(n,'AutomaticallyAddedFlag',null);
311: gt_attachdoc(j+1).Attachment_Category_Id := hr_transaction_swi.getNumberValue(n,'AttachmentCategoryId',null);

Line 308: gt_attachdoc(j+1).Seq_Num := hr_transaction_swi.getNumberValue(n,'SeqNum',null);

304: gt_attachdoc(j+1).Created_by := hr_transaction_swi.getNumberValue(n,'CreatedBy',null);
305: gt_attachdoc(j+1).Last_Update_Date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);
306: gt_attachdoc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);
307: gt_attachdoc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);
308: gt_attachdoc(j+1).Seq_Num := hr_transaction_swi.getNumberValue(n,'SeqNum',null);
309: gt_attachdoc(j+1).Pk1_Value := hr_transaction_swi.getVarchar2Value(n,'Pk1Value',null);
310: gt_attachdoc(j+1).entity_name := hr_transaction_swi.getVarchar2Value(n,'EntityName',null); gt_attachdoc(j+1).Automatically_Added_Flag := hr_transaction_swi.getVarchar2Value(n,'AutomaticallyAddedFlag',null);
311: gt_attachdoc(j+1).Attachment_Category_Id := hr_transaction_swi.getNumberValue(n,'AttachmentCategoryId',null);
312: --dbms_output.put_line('DocumentId:'||gt_attachdoc(j+1).attached_document_id);

Line 309: gt_attachdoc(j+1).Pk1_Value := hr_transaction_swi.getVarchar2Value(n,'Pk1Value',null);

305: gt_attachdoc(j+1).Last_Update_Date := hr_transaction_swi.getDateValue(n,'LastUpdateDate',null);
306: gt_attachdoc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);
307: gt_attachdoc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);
308: gt_attachdoc(j+1).Seq_Num := hr_transaction_swi.getNumberValue(n,'SeqNum',null);
309: gt_attachdoc(j+1).Pk1_Value := hr_transaction_swi.getVarchar2Value(n,'Pk1Value',null);
310: gt_attachdoc(j+1).entity_name := hr_transaction_swi.getVarchar2Value(n,'EntityName',null); gt_attachdoc(j+1).Automatically_Added_Flag := hr_transaction_swi.getVarchar2Value(n,'AutomaticallyAddedFlag',null);
311: gt_attachdoc(j+1).Attachment_Category_Id := hr_transaction_swi.getNumberValue(n,'AttachmentCategoryId',null);
312: --dbms_output.put_line('DocumentId:'||gt_attachdoc(j+1).attached_document_id);
313: END LOOP;

Line 310: gt_attachdoc(j+1).entity_name := hr_transaction_swi.getVarchar2Value(n,'EntityName',null); gt_attachdoc(j+1).Automatically_Added_Flag := hr_transaction_swi.getVarchar2Value(n,'AutomaticallyAddedFlag',null);

306: gt_attachdoc(j+1).Last_Updated_By := hr_transaction_swi.getNumberValue(n,'LastUpdatedBy',null);
307: gt_attachdoc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);
308: gt_attachdoc(j+1).Seq_Num := hr_transaction_swi.getNumberValue(n,'SeqNum',null);
309: gt_attachdoc(j+1).Pk1_Value := hr_transaction_swi.getVarchar2Value(n,'Pk1Value',null);
310: gt_attachdoc(j+1).entity_name := hr_transaction_swi.getVarchar2Value(n,'EntityName',null); gt_attachdoc(j+1).Automatically_Added_Flag := hr_transaction_swi.getVarchar2Value(n,'AutomaticallyAddedFlag',null);
311: gt_attachdoc(j+1).Attachment_Category_Id := hr_transaction_swi.getNumberValue(n,'AttachmentCategoryId',null);
312: --dbms_output.put_line('DocumentId:'||gt_attachdoc(j+1).attached_document_id);
313: END LOOP;
314: --dbms_output.put_line('Number of attached doc entities:'||gt_attachdoc.count);

Line 311: gt_attachdoc(j+1).Attachment_Category_Id := hr_transaction_swi.getNumberValue(n,'AttachmentCategoryId',null);

307: gt_attachdoc(j+1).Last_Update_Login := hr_transaction_swi.getNumberValue(n,'LastUpdateLogin',null);
308: gt_attachdoc(j+1).Seq_Num := hr_transaction_swi.getNumberValue(n,'SeqNum',null);
309: gt_attachdoc(j+1).Pk1_Value := hr_transaction_swi.getVarchar2Value(n,'Pk1Value',null);
310: gt_attachdoc(j+1).entity_name := hr_transaction_swi.getVarchar2Value(n,'EntityName',null); gt_attachdoc(j+1).Automatically_Added_Flag := hr_transaction_swi.getVarchar2Value(n,'AutomaticallyAddedFlag',null);
311: gt_attachdoc(j+1).Attachment_Category_Id := hr_transaction_swi.getNumberValue(n,'AttachmentCategoryId',null);
312: --dbms_output.put_line('DocumentId:'||gt_attachdoc(j+1).attached_document_id);
313: END LOOP;
314: --dbms_output.put_line('Number of attached doc entities:'||gt_attachdoc.count);
315: -- Now process all FndDocumentsShortText rows and populate PL/SQL TABLE

Line 324: gt_shorttext(j+1).media_id := hr_transaction_swi.getNumberValue(n,'MediaId',null);

320: n := xmldom.item(nl, j);
321: e := xmldom.makeElement(n);
322: gt_shorttext(j+1).post_State := xmldom.getAttribute(e, 'PS');
323: --dbms_output.put_line('PostState: '||gt_shorttext(j+1).post_State);
324: gt_shorttext(j+1).media_id := hr_transaction_swi.getNumberValue(n,'MediaId',null);
325: gt_shorttext(j+1).short_text := hr_transaction_swi.getVarchar2Value(n,'ShortText',null);
326: gt_shorttext(j+1).app_source_version := hr_transaction_swi.getVarchar2Value(n,'AppSourceVersion',null);
327: --dbms_output.put_line('media_id:'||gt_shorttext(j+1).media_id);
328: END LOOP;

Line 325: gt_shorttext(j+1).short_text := hr_transaction_swi.getVarchar2Value(n,'ShortText',null);

321: e := xmldom.makeElement(n);
322: gt_shorttext(j+1).post_State := xmldom.getAttribute(e, 'PS');
323: --dbms_output.put_line('PostState: '||gt_shorttext(j+1).post_State);
324: gt_shorttext(j+1).media_id := hr_transaction_swi.getNumberValue(n,'MediaId',null);
325: gt_shorttext(j+1).short_text := hr_transaction_swi.getVarchar2Value(n,'ShortText',null);
326: gt_shorttext(j+1).app_source_version := hr_transaction_swi.getVarchar2Value(n,'AppSourceVersion',null);
327: --dbms_output.put_line('media_id:'||gt_shorttext(j+1).media_id);
328: END LOOP;
329: --dbms_output.put_line('Number of attached doc entities:'||gt_shorttext.count);

Line 326: gt_shorttext(j+1).app_source_version := hr_transaction_swi.getVarchar2Value(n,'AppSourceVersion',null);

322: gt_shorttext(j+1).post_State := xmldom.getAttribute(e, 'PS');
323: --dbms_output.put_line('PostState: '||gt_shorttext(j+1).post_State);
324: gt_shorttext(j+1).media_id := hr_transaction_swi.getNumberValue(n,'MediaId',null);
325: gt_shorttext(j+1).short_text := hr_transaction_swi.getVarchar2Value(n,'ShortText',null);
326: gt_shorttext(j+1).app_source_version := hr_transaction_swi.getVarchar2Value(n,'AppSourceVersion',null);
327: --dbms_output.put_line('media_id:'||gt_shorttext(j+1).media_id);
328: END LOOP;
329: --dbms_output.put_line('Number of attached doc entities:'||gt_shorttext.count);
330: -- Now process all the FndLOBs rows and populate the PL/SQL Table

Line 339: gt_lob(j+1).file_ID := hr_transaction_swi.getNumberValue(n,'FileId',null);

335: n := xmldom.item(nl, j);
336: e := xmldom.makeElement(n);
337: gt_lob(j+1).post_State := xmldom.getAttribute(e, 'PS');
338: --dbms_output.put_line('PostState: '||gt_lob(j+1).post_State);
339: gt_lob(j+1).file_ID := hr_transaction_swi.getNumberValue(n,'FileId',null);
340: gt_lob(j+1).file_Name := hr_transaction_swi.getVarchar2Value(n,'FileName',null);
341: gt_lob(j+1).file_content_type := hr_transaction_swi.getVarchar2Value(n,'FileContentType',null);
342: gt_lob(j+1).oracle_charset := hr_transaction_swi.getVarchar2Value(n,'OracleCharset',null);
343: --dbms_output.put_line('file name:'||gt_lob(j+1).file_Name );

Line 340: gt_lob(j+1).file_Name := hr_transaction_swi.getVarchar2Value(n,'FileName',null);

336: e := xmldom.makeElement(n);
337: gt_lob(j+1).post_State := xmldom.getAttribute(e, 'PS');
338: --dbms_output.put_line('PostState: '||gt_lob(j+1).post_State);
339: gt_lob(j+1).file_ID := hr_transaction_swi.getNumberValue(n,'FileId',null);
340: gt_lob(j+1).file_Name := hr_transaction_swi.getVarchar2Value(n,'FileName',null);
341: gt_lob(j+1).file_content_type := hr_transaction_swi.getVarchar2Value(n,'FileContentType',null);
342: gt_lob(j+1).oracle_charset := hr_transaction_swi.getVarchar2Value(n,'OracleCharset',null);
343: --dbms_output.put_line('file name:'||gt_lob(j+1).file_Name );
344: gt_lob(j+1).file_format := hr_transaction_swi.getVarchar2Value(n,'FileFormat',null);

Line 341: gt_lob(j+1).file_content_type := hr_transaction_swi.getVarchar2Value(n,'FileContentType',null);

337: gt_lob(j+1).post_State := xmldom.getAttribute(e, 'PS');
338: --dbms_output.put_line('PostState: '||gt_lob(j+1).post_State);
339: gt_lob(j+1).file_ID := hr_transaction_swi.getNumberValue(n,'FileId',null);
340: gt_lob(j+1).file_Name := hr_transaction_swi.getVarchar2Value(n,'FileName',null);
341: gt_lob(j+1).file_content_type := hr_transaction_swi.getVarchar2Value(n,'FileContentType',null);
342: gt_lob(j+1).oracle_charset := hr_transaction_swi.getVarchar2Value(n,'OracleCharset',null);
343: --dbms_output.put_line('file name:'||gt_lob(j+1).file_Name );
344: gt_lob(j+1).file_format := hr_transaction_swi.getVarchar2Value(n,'FileFormat',null);
345: dbms_lob.createtemporary(l_clob,true);

Line 342: gt_lob(j+1).oracle_charset := hr_transaction_swi.getVarchar2Value(n,'OracleCharset',null);

338: --dbms_output.put_line('PostState: '||gt_lob(j+1).post_State);
339: gt_lob(j+1).file_ID := hr_transaction_swi.getNumberValue(n,'FileId',null);
340: gt_lob(j+1).file_Name := hr_transaction_swi.getVarchar2Value(n,'FileName',null);
341: gt_lob(j+1).file_content_type := hr_transaction_swi.getVarchar2Value(n,'FileContentType',null);
342: gt_lob(j+1).oracle_charset := hr_transaction_swi.getVarchar2Value(n,'OracleCharset',null);
343: --dbms_output.put_line('file name:'||gt_lob(j+1).file_Name );
344: gt_lob(j+1).file_format := hr_transaction_swi.getVarchar2Value(n,'FileFormat',null);
345: dbms_lob.createtemporary(l_clob,true);
346: IF NOT xmldom.isnull(n) THEN

Line 344: gt_lob(j+1).file_format := hr_transaction_swi.getVarchar2Value(n,'FileFormat',null);

340: gt_lob(j+1).file_Name := hr_transaction_swi.getVarchar2Value(n,'FileName',null);
341: gt_lob(j+1).file_content_type := hr_transaction_swi.getVarchar2Value(n,'FileContentType',null);
342: gt_lob(j+1).oracle_charset := hr_transaction_swi.getVarchar2Value(n,'OracleCharset',null);
343: --dbms_output.put_line('file name:'||gt_lob(j+1).file_Name );
344: gt_lob(j+1).file_format := hr_transaction_swi.getVarchar2Value(n,'FileFormat',null);
345: dbms_lob.createtemporary(l_clob,true);
346: IF NOT xmldom.isnull(n) THEN
347: xmldom.writeToClob(n,l_clob);
348: END IF;

Line 829: api_return_status := hr_transaction_swi.commit_transaction_tree(

825: );
826: else
827:
828: /*
829: api_return_status := hr_transaction_swi.commit_transaction_tree(
830: p_transaction_id => score_card_txn_id,
831: p_validate => 0,
832: p_error_log => l_error_log);
833: */

Line 835: api_return_status := hr_transaction_swi.commit_transaction(

831: p_validate => 0,
832: p_error_log => l_error_log);
833: */
834:
835: api_return_status := hr_transaction_swi.commit_transaction(
836: p_transaction_id => score_card_txn_id,
837: p_validate => hr_Api.g_false_num);
838: end if;
839:

Line 946: hr_transaction_swi.delete_transaction(score_card_txn_id,hr_Api.g_false_num);

942: p_object_version_number => next_sc_ovn,
943: p_error_log => l_error_log,
944: p_duplicate_name_warning => l_duplsicate_name_warning);
945:
946: hr_transaction_swi.delete_transaction(score_card_txn_id,hr_Api.g_false_num);
947:
948: exception when others then
949:
950: for i in 1 .. fnd_msg_pub.count_msg Loop