DBA Data[Home] [Help]

APPS.JTF_TERRITORY_TYPE_PVT dependencies on JTF_TERR_TYPES_PKG

Line 910: --dbms_ourtput.put_line('De-Activate_Terrtype PVT: Before Calling JTF_TERR_TYPES_PKG.Update_Row');

906: RAISE fnd_api.g_exc_error;
907: END IF;
908:
909: CLOSE c_getterrtype;
910: --dbms_ourtput.put_line('De-Activate_Terrtype PVT: Before Calling JTF_TERR_TYPES_PKG.Update_Row');
911: jtf_terr_types_pkg.update_row (
912: x_rowid => l_rowid,
913: x_terr_type_id => l_ref_terrtype_rec.terr_type_id,
914: x_last_updated_by => l_ref_terrtype_rec.last_updated_by,

Line 911: jtf_terr_types_pkg.update_row (

907: END IF;
908:
909: CLOSE c_getterrtype;
910: --dbms_ourtput.put_line('De-Activate_Terrtype PVT: Before Calling JTF_TERR_TYPES_PKG.Update_Row');
911: jtf_terr_types_pkg.update_row (
912: x_rowid => l_rowid,
913: x_terr_type_id => l_ref_terrtype_rec.terr_type_id,
914: x_last_updated_by => l_ref_terrtype_rec.last_updated_by,
915: x_last_update_date => l_ref_terrtype_rec.last_update_date,

Line 1732: --dbms_ourtput.put_line('Create_TerrType_Record PVT: Before calling JTF_TERR_TYPES_PKG.Insert_Row');

1728:
1729: --dbms_output.put_line('Value of l_terrtype_id='||TO_CHAR(l_terrtype_id));
1730:
1731: -- Call insert terr_all table handler
1732: --dbms_ourtput.put_line('Create_TerrType_Record PVT: Before calling JTF_TERR_TYPES_PKG.Insert_Row');
1733: jtf_terr_types_pkg.insert_row (
1734: x_rowid => l_rowid,
1735: x_terr_type_id => l_terrtype_id,
1736: x_last_updated_by => p_terrtype_rec.last_updated_by,

Line 1733: jtf_terr_types_pkg.insert_row (

1729: --dbms_output.put_line('Value of l_terrtype_id='||TO_CHAR(l_terrtype_id));
1730:
1731: -- Call insert terr_all table handler
1732: --dbms_ourtput.put_line('Create_TerrType_Record PVT: Before calling JTF_TERR_TYPES_PKG.Insert_Row');
1733: jtf_terr_types_pkg.insert_row (
1734: x_rowid => l_rowid,
1735: x_terr_type_id => l_terrtype_id,
1736: x_last_updated_by => p_terrtype_rec.last_updated_by,
1737: x_last_update_date => p_terrtype_rec.last_update_date,

Line 2967: --dbms_ourtput.put_line('Update_TerrType_Record PVT: Before Calling JTF_TERR_TYPES_PKG.Update_Row');

2963: END IF;
2964: END IF;
2965:
2966: --
2967: --dbms_ourtput.put_line('Update_TerrType_Record PVT: Before Calling JTF_TERR_TYPES_PKG.Update_Row');
2968: jtf_terr_types_pkg.update_row (
2969: x_rowid => l_rowid,
2970: x_terr_type_id => p_terrtype_rec.terr_type_id,
2971: x_last_updated_by => p_terrtype_rec.last_updated_by,

Line 2968: jtf_terr_types_pkg.update_row (

2964: END IF;
2965:
2966: --
2967: --dbms_ourtput.put_line('Update_TerrType_Record PVT: Before Calling JTF_TERR_TYPES_PKG.Update_Row');
2968: jtf_terr_types_pkg.update_row (
2969: x_rowid => l_rowid,
2970: x_terr_type_id => p_terrtype_rec.terr_type_id,
2971: x_last_updated_by => p_terrtype_rec.last_updated_by,
2972: x_last_update_date => p_terrtype_rec.last_update_date,

Line 4169: --dbms_ourtput.put_line('Delete_TerrType_Record PVT: Before Calling JTF_TERR_TYPES_PKG.Delete_Row');

4165:
4166: --Initialize the return status to success
4167: x_return_status := fnd_api.g_ret_sts_success;
4168: --
4169: --dbms_ourtput.put_line('Delete_TerrType_Record PVT: Before Calling JTF_TERR_TYPES_PKG.Delete_Row');
4170: jtf_terr_types_pkg.delete_row (x_terr_type_id => p_terrtype_id);
4171: --
4172: --Prepare message name
4173: fnd_message.set_name ('JTF', 'TERRTYPE_RECORDS_DELETED');

Line 4170: jtf_terr_types_pkg.delete_row (x_terr_type_id => p_terrtype_id);

4166: --Initialize the return status to success
4167: x_return_status := fnd_api.g_ret_sts_success;
4168: --
4169: --dbms_ourtput.put_line('Delete_TerrType_Record PVT: Before Calling JTF_TERR_TYPES_PKG.Delete_Row');
4170: jtf_terr_types_pkg.delete_row (x_terr_type_id => p_terrtype_id);
4171: --
4172: --Prepare message name
4173: fnd_message.set_name ('JTF', 'TERRTYPE_RECORDS_DELETED');
4174: