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.PO_GEN_DIFF_PKG dependencies on PO_ENTITY_GT

Line 245: l_temp := 'INSERT INTO PO_ENTITY_GT ( PK1_VALUE, PK2_VALUE, PK3_VALUE, PK4_VALUE, PK5_VALUE, COL_NAME, COL_VALUE, COL_DESC )

241:
242:
243:
244: --inserting base document records into gt
245: l_temp := 'INSERT INTO PO_ENTITY_GT ( PK1_VALUE, PK2_VALUE, PK3_VALUE, PK4_VALUE, PK5_VALUE, COL_NAME, COL_VALUE, COL_DESC )
246: select PK1_VALUE, PK2_VALUE, PK3_VALUE, PK4_VALUE, PK5_VALUE, COL_NAME, COL_VALUE, COL_DESC from '|| base_doc_source;
247: execute immediate l_temp;
248:
249: l_progress := '0040';

Line 257: l_temp := 'INSERT INTO PO_ENTITY_GT ( PK1_VALUE, PK2_VALUE, PK3_VALUE, PK4_VALUE, PK5_VALUE, COL_NAME, COL_VALUE, COL_DESC )

253:
254:
255:
256: --inserting mod document records into gt.
257: l_temp := 'INSERT INTO PO_ENTITY_GT ( PK1_VALUE, PK2_VALUE, PK3_VALUE, PK4_VALUE, PK5_VALUE, COL_NAME, COL_VALUE, COL_DESC )
258: select PK1_VALUE, PK2_VALUE, PK3_VALUE, PK4_VALUE, PK5_VALUE, COL_NAME, COL_VALUE, COL_DESC from '|| mod_doc_source;
259: execute immediate l_temp;
260:
261: l_progress := '0050';

Line 300: ' FROM PO_ENTITY_GT ' || base_source_alias || ', PO_ENTITY_GT ' || mod_source_alias ||

296: base_source_alias || '.col_value old_value, ' ||
297: mod_source_alias || '.col_value new_value, ' ||
298: base_source_alias || '.col_desc old_desc, ' ||
299: mod_source_alias || '.col_desc new_desc '||
300: ' FROM PO_ENTITY_GT ' || base_source_alias || ', PO_ENTITY_GT ' || mod_source_alias ||
301: ' WHERE '|| l_sql_where;
302:
303:
304: --looping and inserting values into the destination table

Line 344: delete from PO_ENTITY_GT;

340: END IF;
341:
342:
343: --deleting mod and base records from gt
344: delete from PO_ENTITY_GT;
345:
346: l_progress := '0070';
347: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
348: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' deleted records from gt');

Line 698: --populate po_entity_gt with header level archive draft records

694: mod_pk4 := mod_pk4_value;
695: mod_pk5 := mod_pk5_value;
696:
697: l_progress := '0020';
698: --populate po_entity_gt with header level archive draft records
699: populate_par_header;
700:
701: l_progress := '0030';
702: --populate po_entity_gt with line level archive draft records

Line 702: --populate po_entity_gt with line level archive draft records

698: --populate po_entity_gt with header level archive draft records
699: populate_par_header;
700:
701: l_progress := '0030';
702: --populate po_entity_gt with line level archive draft records
703: populate_par_lines;
704:
705: l_progress := '0040';
706: --populate po_entity_gt with shipment level archive draft records

Line 706: --populate po_entity_gt with shipment level archive draft records

702: --populate po_entity_gt with line level archive draft records
703: populate_par_lines;
704:
705: l_progress := '0040';
706: --populate po_entity_gt with shipment level archive draft records
707: populate_par_line_locs;
708:
709: l_progress := '0050';
710: --populate po_entity_gt with distribution level archive draft records

Line 710: --populate po_entity_gt with distribution level archive draft records

706: --populate po_entity_gt with shipment level archive draft records
707: populate_par_line_locs;
708:
709: l_progress := '0050';
710: --populate po_entity_gt with distribution level archive draft records
711: populate_par_distributions;
712:
713: l_progress := '0055';
714: --populate po_entity_gt with distribution level archive draft records

Line 714: --populate po_entity_gt with distribution level archive draft records

710: --populate po_entity_gt with distribution level archive draft records
711: populate_par_distributions;
712:
713: l_progress := '0055';
714: --populate po_entity_gt with distribution level archive draft records
715: populate_par_elins;
716:
717: --Comparison SQL
718:

Line 748: FROM PO_ENTITY_GT base, PO_ENTITY_GT par

744: l_colname_tbl,
745: l_oldvalue_tbl,
746: l_newvalue_tbl,
747: l_entity_tbl
748: FROM PO_ENTITY_GT base, PO_ENTITY_GT par
749: WHERE base.pk1_value (+) = base_pk1
750: AND base.pk2_value (+) = -1
751: AND par.pk1_value = mod_pk1
752: AND par.pk2_value = mod_pk2

Line 826: delete from PO_ENTITY_GT;

822: l_current_user_id,
823: sysdate,
824: l_current_user_id);
825:
826: delete from PO_ENTITY_GT;
827:
828: EXCEPTION
829: WHEN OTHERS THEN
830: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 833: delete from PO_ENTITY_GT;

829: WHEN OTHERS THEN
830: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
831: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||'0080'||' Unexpected error occured ' || SQLERRM );
832: END IF;
833: delete from PO_ENTITY_GT;
834: END generate_par_differences;
835:
836:
837:

Line 841: DESC: populates po_entity_gt with header level archive data and draft data

837:
838:
839: /* ============================================================================
840: NAME: populate_par_header
841: DESC: populates po_entity_gt with header level archive data and draft data
842: ===============================================================================*/
843:
844: PROCEDURE populate_par_header
845: IS

Line 858: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

854: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_header');
855: END IF;
856:
857: --Insert archive data for a given revision
858: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
859: PK2_VALUE,
860: PK3_VALUE,
861: PK4_VALUE,
862: PK5_VALUE,

Line 890: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

886: END IF;
887:
888: l_progress := '0025';
889: --Insert uda archive data for a given revision
890: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
891: PK2_VALUE,
892: PK3_VALUE,
893: PK4_VALUE,
894: PK5_VALUE,

Line 921: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

917: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda archive : ' || SQL%ROWCOUNT);
918: END IF;
919:
920: --Insert addresses uda archive data for a given revision
921: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
922: PK2_VALUE,
923: PK3_VALUE,
924: PK4_VALUE,
925: PK5_VALUE,

Line 952: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

948: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from addresses uda archive : ' || SQL%ROWCOUNT);
949: END IF;
950:
951: --Insert current PAR data i.e. draft data
952: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
953: PK2_VALUE,
954: PK3_VALUE,
955: PK4_VALUE,
956: PK5_VALUE,

Line 979: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

975: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
976: END IF;
977:
978: --Insert current PAR uda data i.e. ext data
979: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
980: PK2_VALUE,
981: PK3_VALUE,
982: PK4_VALUE,
983: PK5_VALUE,

Line 1006: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

1002: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
1003: END IF;
1004:
1005: --Insert current PAR uda addresses data i.e. ext data
1006: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
1007: PK2_VALUE,
1008: PK3_VALUE,
1009: PK4_VALUE,
1010: PK5_VALUE,

Line 1039: DELETE FROM PO_ENTITY_GT;

1035: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1036: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);
1037: END IF;
1038:
1039: DELETE FROM PO_ENTITY_GT;
1040: RAISE;
1041: END populate_par_header;
1042:
1043:

Line 1047: DESC: populates po_entity_gt with line level archive data and draft data

1043:
1044:
1045: /* ============================================================================
1046: NAME: populate_par_lines
1047: DESC: populates po_entity_gt with line level archive data and draft data
1048: ===============================================================================*/
1049:
1050: PROCEDURE populate_par_lines
1051: IS

Line 1064: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

1060: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_lines');
1061: END IF;
1062:
1063: --Insert archive data for a given revision
1064: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
1065: PK2_VALUE,
1066: PK3_VALUE,
1067: PK4_VALUE,
1068: PK5_VALUE,

Line 1096: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

1092: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);
1093: END IF;
1094:
1095: --Insert uda archive data for a given revision
1096: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
1097: PK2_VALUE,
1098: PK3_VALUE,
1099: PK4_VALUE,
1100: PK5_VALUE,

Line 1128: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

1124: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda archive : ' || SQL%ROWCOUNT);
1125: END IF;
1126:
1127: --Insert current PAR data i.e. draft data
1128: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
1129: PK2_VALUE,
1130: PK3_VALUE,
1131: PK4_VALUE,
1132: PK5_VALUE,

Line 1155: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

1151: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
1152: END IF;
1153:
1154: --Insert current PAR uda data i.e. ext data
1155: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
1156: PK2_VALUE,
1157: PK3_VALUE,
1158: PK4_VALUE,
1159: PK5_VALUE,

Line 1188: DELETE FROM PO_ENTITY_GT;

1184: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1185: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);
1186: END IF;
1187:
1188: DELETE FROM PO_ENTITY_GT;
1189: RAISE;
1190: END populate_par_lines;
1191:
1192:

Line 1196: DESC: populates po_entity_gt with shipment level archive data and draft data

1192:
1193:
1194: /* ============================================================================
1195: NAME: populate_par_line_locs
1196: DESC: populates po_entity_gt with shipment level archive data and draft data
1197: ===============================================================================*/
1198:
1199: PROCEDURE populate_par_line_locs
1200: IS

Line 1213: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

1209: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_line_locs');
1210: END IF;
1211:
1212: --Insert archive data for a given revision
1213: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
1214: PK2_VALUE,
1215: PK3_VALUE,
1216: PK4_VALUE,
1217: PK5_VALUE,

Line 1245: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

1241: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);
1242: END IF;
1243:
1244: --Insert archive uda data for a given revision
1245: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
1246: PK2_VALUE,
1247: PK3_VALUE,
1248: PK4_VALUE,
1249: PK5_VALUE,

Line 1277: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

1273: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda archive : ' || SQL%ROWCOUNT);
1274: END IF;
1275:
1276: --Insert current PAR data i.e. draft data
1277: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
1278: PK2_VALUE,
1279: PK3_VALUE,
1280: PK4_VALUE,
1281: PK5_VALUE,

Line 1304: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

1300: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
1301: END IF;
1302:
1303: --Insert current PAR uda data i.e. ext data
1304: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
1305: PK2_VALUE,
1306: PK3_VALUE,
1307: PK4_VALUE,
1308: PK5_VALUE,

Line 1338: DELETE FROM PO_ENTITY_GT;

1334: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1335: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);
1336: END IF;
1337:
1338: DELETE FROM PO_ENTITY_GT;
1339: RAISE;
1340: END populate_par_line_locs;
1341:
1342:

Line 1346: DESC: populates po_entity_gt with distribution level archive data and draft data

1342:
1343:
1344: /* ============================================================================
1345: NAME: populate_par_distributions
1346: DESC: populates po_entity_gt with distribution level archive data and draft data
1347: ===============================================================================*/
1348:
1349: PROCEDURE populate_par_distributions
1350: IS

Line 1363: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

1359: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_distributions');
1360: END IF;
1361:
1362: --Insert archive data for a given revision
1363: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
1364: PK2_VALUE,
1365: PK3_VALUE,
1366: PK4_VALUE,
1367: PK5_VALUE,

Line 1395: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

1391: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);
1392: END IF;
1393:
1394: --Insert current PAR data i.e. draft data
1395: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
1396: PK2_VALUE,
1397: PK3_VALUE,
1398: PK4_VALUE,
1399: PK5_VALUE,

Line 1428: DELETE FROM PO_ENTITY_GT;

1424: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1425: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);
1426: END IF;
1427:
1428: DELETE FROM PO_ENTITY_GT;
1429: RAISE;
1430: END populate_par_distributions;
1431:
1432:

Line 1483: DESC: populates po_entity_gt with elins archive data and draft data

1479:
1480:
1481: /* ============================================================================
1482: NAME: populate_par_elins
1483: DESC: populates po_entity_gt with elins archive data and draft data
1484: ===============================================================================*/
1485: PROCEDURE populate_par_elins
1486: IS
1487:

Line 1499: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

1495: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_elins');
1496: END IF;
1497:
1498: --Insert archive data for a given revision
1499: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
1500: PK2_VALUE,
1501: PK3_VALUE,
1502: PK4_VALUE,
1503: PK5_VALUE,

Line 1531: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

1527: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);
1528: END IF;
1529:
1530: --Insert current PAR data i.e. draft data
1531: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
1532: PK2_VALUE,
1533: PK3_VALUE,
1534: PK4_VALUE,
1535: PK5_VALUE,

Line 1564: DELETE FROM PO_ENTITY_GT;

1560: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1561: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);
1562: END IF;
1563:
1564: DELETE FROM PO_ENTITY_GT;
1565: RAISE;
1566: END populate_par_elins;
1567:
1568: