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.EGO_ITEM_PEOPLE_IMPORT_PKG dependencies on EGO_ITEM_PUB

Line 544: OR NVL(p_delete_line_type,EGO_ITEM_PUB.G_INTF_DELETE_NONE) NOT IN

540: -- Validate the given parameters.
541: -- Perform the DELETE operation accordingly.
542: -------------------------------------------------------------------------------
543: IF (p_data_set_id IS NULL AND p_closed_date IS NULL)
544: OR NVL(p_delete_line_type,EGO_ITEM_PUB.G_INTF_DELETE_NONE) NOT IN
545: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
546: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
547: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
548: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE

Line 545: (EGO_ITEM_PUB.G_INTF_DELETE_ALL

541: -- Perform the DELETE operation accordingly.
542: -------------------------------------------------------------------------------
543: IF (p_data_set_id IS NULL AND p_closed_date IS NULL)
544: OR NVL(p_delete_line_type,EGO_ITEM_PUB.G_INTF_DELETE_NONE) NOT IN
545: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
546: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
547: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
548: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
549: ) THEN

Line 546: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR

542: -------------------------------------------------------------------------------
543: IF (p_data_set_id IS NULL AND p_closed_date IS NULL)
544: OR NVL(p_delete_line_type,EGO_ITEM_PUB.G_INTF_DELETE_NONE) NOT IN
545: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
546: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
547: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
548: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
549: ) THEN
550: -- invalid parameters

Line 547: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS

543: IF (p_data_set_id IS NULL AND p_closed_date IS NULL)
544: OR NVL(p_delete_line_type,EGO_ITEM_PUB.G_INTF_DELETE_NONE) NOT IN
545: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
546: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
547: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
548: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
549: ) THEN
550: -- invalid parameters
551: x_retcode := RETCODE_ERROR;

Line 548: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE

544: OR NVL(p_delete_line_type,EGO_ITEM_PUB.G_INTF_DELETE_NONE) NOT IN
545: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
546: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
547: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
548: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
549: ) THEN
550: -- invalid parameters
551: x_retcode := RETCODE_ERROR;
552: fnd_message.set_name('EGO','EGO_IPI_INSUFFICIENT_PARAMS');

Line 557: IF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_ALL THEN

553: fnd_message.set_token('PROG_NAME',l_program_name);
554: x_errbuff := fnd_message.get();
555: Conc_Output (p_msg => x_errbuff);
556: ELSE
557: IF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_ALL THEN
558: --
559: -- delete all lines
560: --
561: DELETE mtl_interface_errors

Line 573: ELSIF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_ERROR THEN

569: DELETE ego_item_people_intf
570: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
571: AND creation_date <= NVL(p_closed_date, creation_date);
572:
573: ELSIF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_ERROR THEN
574: --
575: -- delete all error lines
576: --
577: DELETE mtl_interface_errors

Line 590: ELSIF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS THEN

586: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
587: AND creation_date <= NVL(p_closed_date, creation_date)
588: AND process_status = G_PS_ERROR;
589:
590: ELSIF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS THEN
591: --
592: -- delete all success lines
593: --
594: DELETE ego_item_people_intf

Line 600: (EGO_ITEM_PUB.G_INTF_DELETE_ALL

596: AND creation_date <= NVL(p_closed_date, creation_date)
597: AND process_status = G_PS_SUCCESS;
598: END IF;
599: IF p_delete_line_type IN
600: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
601: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
602: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
603: ) THEN
604: COMMIT WORK;

Line 601: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR

597: AND process_status = G_PS_SUCCESS;
598: END IF;
599: IF p_delete_line_type IN
600: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
601: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
602: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
603: ) THEN
604: COMMIT WORK;
605: END IF;

Line 602: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS

598: END IF;
599: IF p_delete_line_type IN
600: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
601: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
602: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
603: ) THEN
604: COMMIT WORK;
605: END IF;
606: x_retcode := RETCODE_SUCCESS;

Line 1428: p_delete_lines IN NUMBER DEFAULT EGO_ITEM_PUB.G_INTF_DELETE_NONE,

1424: x_errbuff OUT NOCOPY VARCHAR2,
1425: x_retcode OUT NOCOPY VARCHAR2,
1426: p_data_set_id IN NUMBER,
1427: p_bulk_batch_size IN NUMBER DEFAULT EGO_ITEM_PEOPLE_IMPORT_PKG.RECOMMENDED_BATCH_SIZE,
1428: p_delete_lines IN NUMBER DEFAULT EGO_ITEM_PUB.G_INTF_DELETE_NONE,
1429: p_debug_mode IN NUMBER DEFAULT EGO_ITEM_PEOPLE_IMPORT_PKG.DEBUG_MODE_ERROR,
1430: p_log_mode IN NUMBER DEFAULT EGO_ITEM_PEOPLE_IMPORT_PKG.LOG_INTO_TABLE_ONLY
1431: ) IS
1432:

Line 2680: (EGO_ITEM_PUB.G_INTF_DELETE_ALL

2676: --
2677: -- call purge_interface_lines if required
2678: --
2679: IF p_delete_lines IN
2680: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
2681: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
2682: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
2683: ) THEN
2684: purge_lines

Line 2681: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR

2677: -- call purge_interface_lines if required
2678: --
2679: IF p_delete_lines IN
2680: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
2681: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
2682: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
2683: ) THEN
2684: purge_lines
2685: (p_data_set_id => p_data_set_id

Line 2682: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS

2678: --
2679: IF p_delete_lines IN
2680: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
2681: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
2682: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
2683: ) THEN
2684: purge_lines
2685: (p_data_set_id => p_data_set_id
2686: ,p_closed_date => NULL

Line 2809: (EGO_ITEM_PUB.G_INTF_DELETE_ALL

2805: -- validate the given parameters
2806: G_DEBUG_MODE := DEBUG_MODE_DEBUG;
2807: IF (p_data_set_id IS NULL AND p_closed_date IS NULL)
2808: OR NVL(p_delete_line_type,-1) NOT IN
2809: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
2810: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
2811: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
2812: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
2813: ) THEN

Line 2810: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR

2806: G_DEBUG_MODE := DEBUG_MODE_DEBUG;
2807: IF (p_data_set_id IS NULL AND p_closed_date IS NULL)
2808: OR NVL(p_delete_line_type,-1) NOT IN
2809: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
2810: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
2811: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
2812: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
2813: ) THEN
2814: -- invalid parameters

Line 2811: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS

2807: IF (p_data_set_id IS NULL AND p_closed_date IS NULL)
2808: OR NVL(p_delete_line_type,-1) NOT IN
2809: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
2810: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
2811: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
2812: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
2813: ) THEN
2814: -- invalid parameters
2815: x_retcode := RETCODE_ERROR;

Line 2812: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE

2808: OR NVL(p_delete_line_type,-1) NOT IN
2809: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
2810: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
2811: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
2812: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
2813: ) THEN
2814: -- invalid parameters
2815: x_retcode := RETCODE_ERROR;
2816: fnd_message.set_name('EGO','EGO_IPI_INSUFFICIENT_PARAMS');