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 786: OR NVL(p_delete_line_type,EGO_ITEM_PUB.G_INTF_DELETE_NONE) NOT IN

782: -- Validate the given parameters.
783: -- Perform the DELETE operation accordingly.
784: -------------------------------------------------------------------------------
785: IF (p_data_set_id IS NULL AND p_closed_date IS NULL)
786: OR NVL(p_delete_line_type,EGO_ITEM_PUB.G_INTF_DELETE_NONE) NOT IN
787: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
788: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
789: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
790: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE

Line 787: (EGO_ITEM_PUB.G_INTF_DELETE_ALL

783: -- Perform the DELETE operation accordingly.
784: -------------------------------------------------------------------------------
785: IF (p_data_set_id IS NULL AND p_closed_date IS NULL)
786: OR NVL(p_delete_line_type,EGO_ITEM_PUB.G_INTF_DELETE_NONE) NOT IN
787: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
788: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
789: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
790: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
791: ) THEN

Line 788: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR

784: -------------------------------------------------------------------------------
785: IF (p_data_set_id IS NULL AND p_closed_date IS NULL)
786: OR NVL(p_delete_line_type,EGO_ITEM_PUB.G_INTF_DELETE_NONE) NOT IN
787: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
788: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
789: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
790: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
791: ) THEN
792: -- invalid parameters

Line 789: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS

785: IF (p_data_set_id IS NULL AND p_closed_date IS NULL)
786: OR NVL(p_delete_line_type,EGO_ITEM_PUB.G_INTF_DELETE_NONE) NOT IN
787: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
788: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
789: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
790: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
791: ) THEN
792: -- invalid parameters
793: x_retcode := RETCODE_ERROR;

Line 790: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE

786: OR NVL(p_delete_line_type,EGO_ITEM_PUB.G_INTF_DELETE_NONE) NOT IN
787: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
788: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
789: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
790: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
791: ) THEN
792: -- invalid parameters
793: x_retcode := RETCODE_ERROR;
794: fnd_message.set_name('EGO','EGO_IPI_INSUFFICIENT_PARAMS');

Line 799: IF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_ALL THEN

795: fnd_message.set_token('PROG_NAME',l_program_name);
796: x_errbuff := fnd_message.get();
797: Conc_Output (p_msg => x_errbuff);
798: ELSE
799: IF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_ALL THEN
800: --
801: -- delete all lines
802: --
803: DELETE mtl_interface_errors

Line 815: ELSIF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_ERROR THEN

811: DELETE ego_item_people_intf
812: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
813: AND creation_date <= NVL(p_closed_date, creation_date);
814:
815: ELSIF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_ERROR THEN
816: --
817: -- delete all error lines
818: --
819: DELETE mtl_interface_errors

Line 832: ELSIF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS THEN

828: WHERE data_set_id = NVL(p_data_set_id, data_set_id)
829: AND creation_date <= NVL(p_closed_date, creation_date)
830: AND process_status = G_PS_ERROR;
831:
832: ELSIF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS THEN
833: --
834: -- delete all success lines
835: --
836: DELETE ego_item_people_intf

Line 842: (EGO_ITEM_PUB.G_INTF_DELETE_ALL

838: AND creation_date <= NVL(p_closed_date, creation_date)
839: AND process_status = G_PS_SUCCESS;
840: END IF;
841: IF p_delete_line_type IN
842: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
843: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
844: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
845: ) THEN
846: COMMIT WORK;

Line 843: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR

839: AND process_status = G_PS_SUCCESS;
840: END IF;
841: IF p_delete_line_type IN
842: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
843: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
844: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
845: ) THEN
846: COMMIT WORK;
847: END IF;

Line 844: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS

840: END IF;
841: IF p_delete_line_type IN
842: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
843: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
844: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
845: ) THEN
846: COMMIT WORK;
847: END IF;
848: x_retcode := RETCODE_SUCCESS;

Line 1674: p_delete_lines IN NUMBER DEFAULT EGO_ITEM_PUB.G_INTF_DELETE_NONE,

1670: x_errbuff OUT NOCOPY VARCHAR2,
1671: x_retcode OUT NOCOPY VARCHAR2,
1672: p_data_set_id IN NUMBER,
1673: p_bulk_batch_size IN NUMBER DEFAULT EGO_ITEM_PEOPLE_IMPORT_PKG.RECOMMENDED_BATCH_SIZE,
1674: p_delete_lines IN NUMBER DEFAULT EGO_ITEM_PUB.G_INTF_DELETE_NONE,
1675: p_debug_mode IN NUMBER DEFAULT EGO_ITEM_PEOPLE_IMPORT_PKG.DEBUG_MODE_ERROR,
1676: p_log_mode IN NUMBER DEFAULT EGO_ITEM_PEOPLE_IMPORT_PKG.LOG_INTO_TABLE_ONLY
1677: ) IS
1678:

Line 3049: (EGO_ITEM_PUB.G_INTF_DELETE_ALL

3045: --
3046: -- call purge_interface_lines if required
3047: --
3048: IF p_delete_lines IN
3049: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
3050: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
3051: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
3052: ) THEN
3053: purge_lines

Line 3050: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR

3046: -- call purge_interface_lines if required
3047: --
3048: IF p_delete_lines IN
3049: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
3050: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
3051: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
3052: ) THEN
3053: purge_lines
3054: (p_data_set_id => p_data_set_id

Line 3051: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS

3047: --
3048: IF p_delete_lines IN
3049: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
3050: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
3051: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
3052: ) THEN
3053: purge_lines
3054: (p_data_set_id => p_data_set_id
3055: ,p_closed_date => NULL

Line 3184: (EGO_ITEM_PUB.G_INTF_DELETE_ALL

3180: -- validate the given parameters
3181: G_DEBUG_MODE := DEBUG_MODE_DEBUG;
3182: IF (p_data_set_id IS NULL AND p_closed_date IS NULL)
3183: OR NVL(p_delete_line_type,-1) NOT IN
3184: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
3185: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
3186: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
3187: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
3188: ) THEN

Line 3185: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR

3181: G_DEBUG_MODE := DEBUG_MODE_DEBUG;
3182: IF (p_data_set_id IS NULL AND p_closed_date IS NULL)
3183: OR NVL(p_delete_line_type,-1) NOT IN
3184: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
3185: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
3186: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
3187: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
3188: ) THEN
3189: -- invalid parameters

Line 3186: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS

3182: IF (p_data_set_id IS NULL AND p_closed_date IS NULL)
3183: OR NVL(p_delete_line_type,-1) NOT IN
3184: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
3185: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
3186: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
3187: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
3188: ) THEN
3189: -- invalid parameters
3190: x_retcode := RETCODE_ERROR;

Line 3187: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE

3183: OR NVL(p_delete_line_type,-1) NOT IN
3184: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
3185: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
3186: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
3187: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
3188: ) THEN
3189: -- invalid parameters
3190: x_retcode := RETCODE_ERROR;
3191: fnd_message.set_name('EGO','EGO_IPI_INSUFFICIENT_PARAMS');